ABAP_DATABASE_MANAGER
A report that runs custom SQL queries against the SAP database or an external connection, shows the results in an ALV grid, and inserts, updates and deletes data in the connected database.
zabap_p_database_manager is a report you execute in an ABAP system, naming either the default SAP database or an external connection, and then hand a SQL query to at runtime. Results come back in an ALV (ABAP List Viewer) format, and the same report inserts, updates and deletes data in the connected database. Missing queries, connection issues and query results are reported as messages. Its setup step is to transfer the project files into a local ABAP development environment, and the only requirement it states is an SAP environment with permissions for executing SQL queries on both internal and external databases.
Facts
Where it sits
Who is behind it
In the atlas: maintains 6, contributes to 8@furkancosgunmaintainerMarc BernardContributes to this
In the atlas: contributes to 26@mbtools1 contributor
What it declares
Every artifact
- Type
- App
- Origin
- Independently maintained
As an app
- Where it runs
- Inside the system it serves
- Distributed through
- Copied into the project
Connections
Looking at the data a system holds while developing or supporting it
Download
README
quoted from furkancosgun/ABAP_DATABASE_MANAGER under MIT, readABAP DATABASE MANAGER
A custom SQL query application for SAP ABAP, enabling management of both internal and external databases.
Project Overview
zabap_p_database_manager is an SQL query application written in SAP ABAP that allows users to connect to and interact with databases within SAP or external databases. This flexibility provides a seamless interface for database management, similar to SQL Server Management Studio, directly from the ABAP environment.
Purpose
The project facilitates database management by allowing users to:
- Run SQL queries on both the default SAP database and external databases.
- Retrieve, add, update, and delete data across connected databases.
Functionalities
- Flexible Database Connection: Connect to either the SAP system's default database or an external database using the provided connection interface.
- Executing SQL Queries: Run custom SQL queries on the connected database.
- Data Retrieval: Display query results in an ALV (ABAP List Viewer) format for easy analysis.
- Data Modification: Insert, update, or delete data within the connected database.
- Error Handling: User-friendly messages for missing queries, connection issues, and query results.
Usage
- Setup: Transfer the project files into your local ABAP development environment.
- Run the Application: Execute the report
zabap_p_database_managerand specify either the default SAP database or an external connection name. - Execute SQL Commands: Use the interface to connect and run SQL queries on the chosen database.
Requirements
- SAP ABAP System: Access to an SAP environment, with permissions for executing SQL queries on both internal and external databases.
Contributing
We welcome contributions to enhance the project! Feel free to submit a pull request or add issues for suggestions, bug reports, or new features.
Others providing
Compare all 13 on the Browsing table data page →- sapguisapguiThirty classic transactions, SE80 and SE16N among them, rebuilt as abap2UI5 apps and installed with abapGit into a standard ABAP system.independent, abapThirty classic transactions rebuilt as abap2UI5 apps
- se16nse16nAn abap2UI5 app that browses and filters the content of a table in the browser, on ABAP Cloud systems that have no SE16N as well as on premise.independent, abapTable content browser in abap2UI5, for ABAP Cloud and on premise
- sql-consolesql-consoleA browser-based SQL console built on abap2UI5, in an Open SQL and a native ADBC variant, that shows a query's result as a filterable table without Eclipse or SAP GUI.independent, abapBrowser-based SQL console built on abap2UI5
- HammerHammerA native macOS code editor for ABAP and CDS, with an Object Navigator, Transport Organizer, Data Browser and Gateway Client in the same app as the editor.independent, abapNative macOS code editor for ABAP and CDS
- abap-db-browserabap-db-browserAn SAP GUI program for browsing tables, views, CDS views, custom queries and joins, installed with abapGit together with two other repositories from the same maintainer and needing ABAP 7.50.independent, abapSAP GUI browser for tables, views, CDS views and joins
- urbani-saplinkurbani-saplinkAn SE16 clone shipped as SAPlink files: an ABAP report that reads a table named at runtime with up to 190 select-options, and a Web Dynpro application beside it.independent, abapSE16 clone shipped as SAPlink files
- ABAP remote filesystemABAP remote filesystemA Visual Studio Code extension that opens an ABAP system over ADT as an editable filesystem and exposes system tools to GitHub Copilot and external MCP clients.independent, abapVS Code extension editing ABAP systems over ADT as a filesystem
- ztoadztoadAn Open SQL editor for ABAP that runs a query written in the editor pane on the server and shows the rows in an ALV window, with a pane of saved queries to reuse and share.independent, abapOpen SQL editor for ABAP with ALV output
- ABAP Development Tools for EclipseABAP Development Tools for EclipseSAP's Eclipse plugins for ABAP: source, dictionary and CDS editors, Project Explorer, Outline and ABAP Unit, calling ADT resources on the connected system.sap official, abapSAP's Eclipse plugins for ABAP development over ADT
- HR_DMEHR_DMEA read-only SAP GUI report that lists every infotype, payroll cluster and assignment table holding data for one SAP HCM person or organisational object.independent, abapRead-only SAP GUI report listing where HCM object data is stored
- Simple Data ExplorerSimple Data ExplorerA multi-window SAP GUI explorer for tables, views and CDS SQL views, with filters that re-read as they change, foreign-key navigation, a join builder and pivot tables.independent, abapMulti-window SAP GUI explorer for tables, views and CDS SQL views
- VERTEXVERTEXAn extension for ABAP Development Tools for Eclipse and VS Code that shows Simple Data Explorer, AVE and ACE in the editor over the developer's ADT connection.independent, abapADT extension for Eclipse and VS Code showing three SAP GUI tools
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
Contributors
History in the atlas
- First seen.
For your agent
- Ref
artifact:furkancosgun-abap-database-manager- JSON
- /artifacts/furkancosgun-abap-database-manager.json
- MCP
- Connecting an agent