ABAP Spreadsheet Importer
A server-side ABAP component that parses an uploaded XLSX or CSV file and creates instances of a named RAP business object through dynamic EML, so its validations and authorizations run on every row.
You name a RAP business object and it parses the file in the backend and creates the rows, building the payload at runtime through RTTC, so a flat active create needs no code per business object. The inserts go through EML rather than a direct database write, which is what makes the business object's own determinations, validations and authorizations run on every row; the facade returns created keys and per-row messages rather than raising. XLSX is read through XCO and CSV through an RFC 4180 state machine, with DDIC-aware coercion for dates, EU and US decimals, NUMC padding, ALPHA conversion, amounts with currency symbols, and booleans. It runs on S/4HANA 2023 (SAP_BASIS 758) or higher, SAP BTP ABAP Environment or S/4HANA Cloud, and installs through abapGit under the ZSSI_ prefix. Its own documentation calls it early and experimental at 0.x with the ZCL_SSI_ and ZIF_SSI_ public API still liable to change between releases, and says the component is commercial and its source repositories private.
Facts
Where it sits
What it declares
Every artifact
- Type
- Package
- Origin
- By a community org
As a package
- Where it runs
- does not say
- Distributed through
- does not say
Connections
Getting files into tables and table content back out as files
Download
Others providing
Compare all 9 on the Importing and exporting table data page →- abap2UI5 for Excelabap2UI5 for ExcelAn Office add-in that runs an abap2UI5 app in Excel's task pane, where the app reads and writes the workbook through the z2ui5.cc.ExcelBridge control.community org, abapOffice add-in running an abap2UI5 app in Excel's task panefrom ABAP
- abap2UI5-addons/table-content-loaderabap2UI5-addons/table-content-loaderAn abap2UI5 developer tool that moves the content of an ABAP table in and out of JSON, CSV or XLSX files, with a preview before download or saving to the database.independent, abapUpload, edit and download ABAP table content as JSON, CSV or XLSXfrom ABAP
- boy0korea/abap2jsonboy0korea/abap2jsonA report that exports ABAP table content to a JSON zip file, per table or per package, imports it back into its table, and compares or copies table content across servers.independent, abapExports and imports ABAP table content as zipped JSONfrom ABAP
- boy0korea/ABAP2XLSX_HELPERboy0korea/ABAP2XLSX_HELPERHelper methods over abap2xlsx to download, email or upload a table as Excel, and to convert between Excel, JSON and an ABAP table.independent, abapHelper methods over abap2xlsx for Excel, JSON and tablesfrom ABAP
- abapDataToTableImportabapDataToTableImportAn ABAP framework that declares a target structure in code and maps data a user supplies from a clipboard, an Excel file, a text file or an internal table onto it, with drag-and-drop column mapping.independent, abapMaps clipboard, Excel or text data onto a declared ABAP structurefrom ABAP
- mkysoft/xlsxreadermkysoft/xlsxreaderAn ABAP library that reads the content of Excel spreadsheets in the OpenXML format; its documentation states only that scope, with no detail on the class it exposes or on writing a file back.independent, abapReader for Excel spreadsheets in OpenXML format from ABAPfrom ABAP
- cds-spreadsheetimporter-plugincds-spreadsheetimporter-pluginA CAP plugin that adds an ImporterService accepting an uploaded Excel file, parses it on the server and writes its rows into the CDS entity named in the URL.community org, capSpreadsheet upload into a CDS entity, parsed on the serverfrom CAP
- ui5-cc-spreadsheetimporterui5-cc-spreadsheetimporterA UI5 component that adds a spreadsheet upload dialog to a Fiori elements or freestyle app and submits the rows it reads through the app's own OData model.community org, ui5UI5 component adding a spreadsheet upload dialog to Fiori appsfrom UI5
Details
Sources
Sources are graph entities: the same page may back several entries, and an unreachable source flags every row that rests on it.
Compatibility and provenance
Flavors
“Developed in the **ABAP for Cloud Development** language version (clean core), so one codebase runs on on-prem and Cloud.” — Spreadsheet Importer documentation — ABAP Spreadsheet Importer (backend)
History in the atlas
- First seen.
For your agent
- Ref
artifact:spreadsheetimporter-abap-importer- JSON
- /artifacts/spreadsheetimporter-abap-importer.json
- MCP
- Connecting an agent