AppApptypeAn application you deploy and use, installed into a system or loaded into an application as a component, rather than a library whose functions you call.See every one →What this type is →independently maintainedindependently maintainedoriginPublished by one person or a small company outside SAP. Says nothing about quality; the readings say that.See every one →

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

Last pushLicenceMIT

Where it sits

Lives in
Provides
Browsing table dataABAPBrowsing table datacapabilityLooking at what a system holds while developing or supporting it: the rows behind a key, the reference data a field points at, the tables that carry data for one object. Editing configuration records through maintenance screens is a different job, even where the same transaction does both.

Who is behind it

Furkan COSGUNFurkan COSGUNPersonMaintains this
In the atlas: maintains 6, contributes to 8
@furkancosgun
maintainerMarc BernardPersonContributes to this
In the atlas: contributes to 26
@mbtools
1 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

Connections1

README

quoted from furkancosgun/ABAP_DATABASE_MANAGER under MIT, read
furkancosgun/ABAP_DATABASE_MANAGER/README.mdOn GitHub

ABAP 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

  1. Setup: Transfer the project files into your local ABAP development environment.
  2. Run the Application: Execute the report zabap_p_database_manager and specify either the default SAP database or an external connection name.
  3. 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.

MIT, read
Browsing table data
  1. sapguiThirty classic transactions rebuilt as abap2UI5 apps
  2. se16nTable content browser in abap2UI5, for ABAP Cloud and on premise
  3. sql-consoleBrowser-based SQL console built on abap2UI5
  4. HammerNative macOS code editor for ABAP and CDS
  5. abap-db-browserSAP GUI browser for tables, views, CDS views and joins
  6. urbani-saplinkSE16 clone shipped as SAPlink files
  7. ABAP remote filesystemVS Code extension editing ABAP systems over ADT as a filesystem
  8. ztoadOpen SQL editor for ABAP with ALV output
  9. ABAP Development Tools for EclipseSAP's Eclipse plugins for ABAP development over ADT
  10. HR_DMERead-only SAP GUI report listing where HCM object data is stored
  11. Simple Data ExplorerMulti-window SAP GUI explorer for tables, views and CDS SQL views
  12. VERTEXADT extension for Eclipse and VS Code showing three SAP GUI tools

Details

Sources3
Added by handdiscovered herechecked
github.com/furkancosgun/ABAP_DATABASE_MANAGERtree, pushes, contributors, CIchecked
README.mdquoted, and what the entry declareschecked

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
discovered viaAdded by hand
first seen in the atlas
ecosystem and domainabap, developer-experience
abaplint
issues under its own abaplint configuration116
lines320
statements206
objects2
files2
analysed, main
abaplint version2.120.84
Contributors1

From the repository’s contributor list, .

History in the atlas1
  1. First seen.
For your agent
Ref
artifact:furkancosgun-abap-database-manager
JSON
/artifacts/furkancosgun-abap-database-manager.json
MCP
Connecting an agent