abap2UI5-addons/table-content-loader
An abap2UI5abap2UI5One ABAP class implementing z2ui5_if_app is the whole app: the browser loads a generic UI5 shell once, and every interaction after that is an HTTP roundtrip back into ABAP.community org, abap 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.
Getting data in and out of an arbitrary ABAP table for inspection or a one-off fix usually means writing a report for that one table. Table Content Loader is a start page of tiles, one per format and direction, leading into small step-by-step abap2UI5abap2UI5One ABAP class implementing z2ui5_if_app is the whole app: the browser loads a generic UI5 shell once, and every interaction after that is an HTTP roundtrip back into ABAP.community org, abap apps: pick a table, convert its content to or from a JSON, CSV or XLSX file, preview it, and download it or save it to the database. It installs with abapGitabapGitA Git client written in ABAP that runs inside the system, so objects are cloned, pulled and pushed without leaving it; with no package manager in ABAP, a cloned repository is how code is distributed.community org, abap on top of abap2UI5, the addons' popups repository and abap2xlsxabap2xlsxA library that reads and generates .xlsx Excel workbooks directly from ABAP data, without exporting through a list viewer, installed through abapGit and tested from SAP_ABA 731.independent, abap, and runs on ABAP Cloud (S/4 Public Cloud, BTP ABAP Environment, S/4 Private Cloud or on-premise with ABAP for Cloud) or on Standard ABAP from SAP NetWeaver AS ABAP 7.50. It is a developer tool for moving test data or Z table content between systems in the browser, without SAP GUI or Eclipse.
Facts
Where it sits
Who is behind it
In the atlas: maintains 21@abap2UI5-addonsmaintaineroblomov-devContributes to this
In the atlas: maintains 4, contributes to 44@oblomov-dev1 contributor
Before choosing this
Conditions
PracticalFunctional boundary
Not an end-user app: it reads from any table the user names and writes into tables of the Z/Y namespace, with no authorisation check of its own, so the README asks a project to add its own checks on S_TABU_DIS/S_TABU_NAM and to restrict who may run it before it is used beyond a development system. XLSX upload and download are not ready for ABAP Cloud yet, and of the upload apps only the JSON one writes the file's rows back to the database.
What it declares
Every artifact
- Type
- App
- Origin
- Independently maintained
As an app
- Where it runs
- does not say
- Distributed through
- abapGit
Connections
Getting files into tables and table content back out as files
UI5 apps written as one ABAP class, rendered by a generic shell
Library that reads and generates Excel spreadsheets from ABAP
Git client written in ABAP that runs inside the system
Download
README
quoted from abap2UI5-addons/table-content-loader under MIT, readtable-content-loader
Upload, edit and download the content of database tables as JSON, CSV or XLSX - in the browser. A start page with one tile per format and direction leads into small step-by-step abap2UI5 apps: pick a table, convert its content to or from a file, preview it and download it or save it to the database. For developers who move test data or Z table content between systems, on ABAP Cloud as well as on Standard ABAP.
Part of abap2UI5-addons - addons and apps for abap2UI5, installed with abapGit.
Why
Getting the content of a table into a file and back is a frequent chore - test data for another system, a Z table filled from a spreadsheet, a quick export for a colleague. table-content-loader does it in the browser, with the table chosen at runtime, and without SAP GUI or Eclipse.
It is a developer tool, not an end-user app - read Security before you use it beyond a development system.
Installation
Requirements
- ABAP Cloud (S/4 Public Cloud, BTP ABAP Environment, S/4 Private Cloud or On-Premise with ABAP for Cloud) or Standard ABAP on SAP NetWeaver AS ABAP 7.50 or higher. XLSX upload and download are not ready for ABAP Cloud yet (see Limitations & Todo).
- abap2UI5
- abap2UI5-addons/popups - file upload, input and confirmation popups
- abap2xlsx - reads and writes the
XLSX files (
z2ui5_cl_tcl_xlsx_api)
Steps - with abapGit, in this order:
- abap2UI5
- abap2UI5-addons/popups
- abap2xlsx
- this repository (branch
main)
Start - open the start page like any abap2UI5 app:
?app_start=z2ui5_cl_tcl_app_00
Usage
The start page z2ui5_cl_tcl_app_00 shows one tile per format and direction.
Tiles whose app is not finished yet are shown disabled; every app can also be
started directly with ?app_start=<class>.
| Tile | Class | What you do |
|---|---|---|
| JSON - Upload DB Content | z2ui5_cl_tcl_app_01 | (1) upload a JSON file, (2) check the target table, (3) convert the JSON into the table's rows, (4) preview the first rows, (5) save - after a confirmation the file's rows are written to the table: a row whose key exists is overwritten, a new key is inserted, rows that are not in the file stay (MODIFY) |
| JSON - Download DB Content | z2ui5_cl_tcl_app_03 | (1) set the table, (2) convert its content to JSON, (3) preview the JSON, (4) download it |
| CSV - Upload / Download DB Content | z2ui5_cl_tcl_app_04 | upload a CSV file, view or edit its content as a table, download it as CSV (no database write yet) |
| XLSX - Upload DB Content | z2ui5_cl_tcl_app_05 | upload an XLSX file, view or edit its content as a table, download it as XLSX (no database write yet) |
| XLSX - Download DB Content | z2ui5_cl_tcl_app_06 | create a draft for a table, then (1) preview the data, (2) configure the sheet head, (3) configure the columns, (4) preview the XLSX, (5) download it; Load reads the table's rows again (the draft itself is not stored - Save Draft does nothing yet, see Limitations & Todo) |
z2ui5_cl_tcl_app_02 (view/edit/download) is not on the start page: it
shows the import - edit - export round trip on a demo table of flight
connections.
Features
- Upload & Download Data
- Table Content Editor
- Data Preview
Security
This is a developer tool. It reads from any table the user names and writes into tables of the Z/Y namespace only, without an authorization check of its own. Before using it beyond a development system, add your own authorization checks (e.g. AUTHORITY-CHECK on S_TABU_DIS/S_TABU_NAM) and restrict who may run the app.
Limitations & Todo
- CSV Upload & Download
- JSON Download
- XLSX Upload/Download for ABAP Cloud
- Saving and reloading an XLSX draft - the Save Draft button of the XLSX download stores nothing yet
Development
npm ci
npm run check # abaplint Standard + ABAP Cloud, abap2UI5-linter, rename checknpm run check runs the same steps as CI. The manual build-rename workflow
pushes a namespace-renamed copy to a branch rename_<name> for a parallel
installation.
Contributing
Issues and pull requests are welcome - whether you're fixing bugs, adding new functionality, or improving documentation. See CONTRIBUTING.md.
License
MIT - see LICENSE.
History
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
- 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
- ABAP Spreadsheet ImporterABAP Spreadsheet ImporterA 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.community org, abapABAP component importing XLSX or CSV files into RAP business objectsfrom 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
abaplint
Flavors
“ABAP Cloud (S/4 Public Cloud, BTP ABAP Environment, S/4 Private Cloud or” — abap2UI5-addons/table-content-loader — README
“Standard ABAP on SAP NetWeaver AS ABAP” — abap2UI5-addons/table-content-loader — README
Contributors
History in the atlas
- First seen.
For your agent
- Ref
artifact:abap2ui5-addons-table-content-loader- JSON
- /artifacts/abap2ui5-addons-table-content-loader.json
- MCP
- Connecting an agent