onedevatlasBeta
Browse the atlas
AllABAPCAPUI5BTP
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 →

sql-console

A 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.

Type a query, press Run, and the result comes up as a table with search, a range filter, spreadsheet export and a per-user query history that loads a query and its result again. It ships two apps: the Open SQL console (src/abap), which the README calls ABAP-Cloud-clean, and the native console (src/native), which runs the statement through ADBC and needs Standard ABAP. Both install with abapGit on top of abap2UI5, after the addon repositories popups and custom-controls, and start like any abap2UI5 app 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.

GitHub14 ★
abaplint5,427 lines

Facts

Last pushLicenceMIT

Where it sits

Lives in
ABAP
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.
Add-on to
abap2UI5abap2UI5artifactOne 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.
Flavors
ABAP CloudStandard ABAP
Requires
abap2UI5abap2UI5artifactThe framework the console runs on: the README lists abap2UI5 under its requirements and as the first install step, and both consoles are started like any abap2UI5 app with ?app_start= and the app class.abapGitabapGitartifactHow the code gets into the system: the README's install steps pull abap2UI5, popups, custom-controls and then this repository with abapGit.

Who is behind it

abap2UI5-addonsabap2UI5-addonsOrganisationMaintains this
In the atlas: maintains 21@abap2UI5-addonsmaintainerchoper725PersonContributes to this
In the atlas: contributes to 3@choper725feng1976PersonContributes to this
In the atlas: contributes to 2@feng1976Lars HvamPersonContributes to this
In the atlas: maintains 13, contributes to 92, wrote 1@larshpoblomov-devPersonContributes to this
In the atlas: maintains 4, contributes to 44@oblomov-devFrancisco AlcarazPersonContributes to this
In the atlas: contributes to 3@whothefluff5 contributors

Before choosing this

Conditions

PracticalFunctional boundary

It runs whatever SQL a user types without an authorisation check of its own, and the native path additionally uses ADBC, which bypasses ABAP authorisations and client separation; the README asks anyone running it beyond a development system to add authorisation checks and restrict who may start the app. The native console needs Standard ABAP, so on ABAP Cloud only the Open SQL console is available.

What it declares

Every artifact

Type
App
Origin
Independently maintained

As an app

Where it runs
does not say
Distributed through
abapGit

Connections3

Download
sql-console connectionssql-consolePROVIDES→ provides1provides stated Runs ad-hoc SQL queries against the database from a browser UI, with search, filter, spreadsheet export and a per-user query history, in place of opening Eclipse or SAP GUI. abap2UI5-addons/sql-console — README: https://github.com/abap2UI5-addons/sql-console abap2UI5-addons/sql-console — README: https://github.com/abap2UI5-addons/sql-console abap2UI5-addons/sql-console — README: https://github.com/abap2UI5-addons/sql-consoleBrowsing table dataNEEDS→ needs2needs stated The framework the console runs on: the README lists abap2UI5 under its requirements and as the first install step, and both consoles are started like any abap2UI5 app with `?app_start=` and the app class. abap2UI5-addons/sql-console — README: https://github.com/abap2UI5-addons/sql-console abap2UI5-addons/sql-console — README: https://github.com/abap2UI5-addons/sql-consoleabap2UI5needs stated How the code gets into the system: the README's install steps pull abap2UI5, popups, custom-controls and then this repository with abapGit. abap2UI5-addons/sql-console — README: https://github.com/abap2UI5-addons/sql-consoleabapGit

README

quoted from abap2UI5-addons/sql-console under MIT, read
abap2UI5-addons/sql-console/README.mdOn GitHub

sql-console

abap2UI5-addons ABAP abap2UI5 popups custom-controls License
ABAP Cloud ABAP Standard rename check-abap2UI5 abap2UI5

An SQL console in your browser - no Eclipse or SAP GUI installation needed. Type a query, run it and look at the result as a table, with search, filter, export and a per-user query history. Built with abap2UI5, for ABAP developers who want a quick look at the data of a system, on ABAP Cloud as well as on Standard ABAP.

Part of abap2UI5-addons - addons and apps for abap2UI5, installed with abapGit.

image

Why

A quick query should not need a development environment. The SQL console of ADT needs Eclipse, the classic tools need SAP GUI - and on ABAP Cloud there is no SAP GUI at all. sql-console runs the query in any browser that can reach the system, as an abap2UI5 app.

Good for:

  • ABAP developers who want to check data without starting Eclipse or SAP GUI.
  • ABAP Cloud systems - the Open SQL console (src/abap) is ABAP-Cloud-clean.
  • Native SQL on Standard ABAP - the native console (src/native) runs the statement through ADBC.

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. The native SQL console (src/native, ADBC) needs Standard ABAP; on ABAP Cloud, use the Open SQL console (src/abap).
  • abap2UI5
  • abap2UI5-addons/popups
  • abap2UI5-addons/custom-controls - the spreadsheet export (z2ui5_cl_cci_spreadsheet)

Steps - with abapGit, in this order:

  1. abap2UI5
  2. abap2UI5-addons/popups
  3. abap2UI5-addons/custom-controls
  4. this repository (branch main)

Start - like any abap2UI5 app:

AppClassStart
ABAP SQL Console (Open SQL)z2ui5_sql_cl_app_01?app_start=z2ui5_sql_cl_app_01
Native SQL Console (ADBC, Standard ABAP only)zcl_2ui5_native_sql_console?app_start=zcl_2ui5_native_sql_console

Usage

ABAP SQL Console (z2ui5_sql_cl_app_01, package src/abap)

  1. Type an ABAP SQL query into the editor - it starts with Select * from T100.
  2. Set Max Rows (default 500) and press Run.
  3. The result comes up as a table: search it, filter it with a range popup and export it with the spreadsheet button.
  4. Every query goes into your history. Select an entry to load the query and its result again, or clear the history.

Native SQL Console (zcl_2ui5_native_sql_console, package src/native)

The same idea for native SQL: the statement runs through ADBC, with a Fallback Limit (default 100) added when the statement has no limit of its own, a data preview and a query history (table Z2UI5_NSQL_C_HST) whose entries you load again or delete. Association path expressions in the statement are mapped to joins (zcl_association_processor).

Features

  • Execute SQL commands
  • Save query history
  • Data preview

Security

This is a developer tool. It runs the SQL the user enters, without an authorization check of its own; the native path additionally uses ADBC and therefore bypasses ABAP authorizations and client separation. Before using it beyond a development system, add your own authorization checks and restrict who may run the app (see the Todo below).

Todo

  • Extend the input-to-SQL translation
  • Add authorization checks
  • XLSX Export
  • Fix ABAP Cloud Readiness

Development

npm ci
npm run check   # abaplint Standard + ABAP Cloud, abap2UI5-linter, rename check

npm 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.

Credits: logic for query to ABAP SQL translation used from ZTOAD, integrated by choper725.

MIT, read

History

Latest

v1.134.0

Others providing12

Compare all 13 on the Browsing table data page →
Browsing table data
  1. sapguiThirty classic transactions rebuilt as abap2UI5 apps
  2. se16nTable content browser in abap2UI5, for ABAP Cloud and on premise
  3. HammerNative macOS code editor for ABAP and CDS
  4. abap-db-browserSAP GUI browser for tables, views, CDS views and joins
  5. ABAP_DATABASE_MANAGERABAP report running custom SQL queries into an ALV grid
  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
GitHub APIdiscovered herechecked
github.com/abap2UI5-addons/sql-consoletree, 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 viaGitHub API
first seen in the atlas
ecosystem and domainabap, developer-experience
abaplint
issues under its own abaplint configuration0
lines5,427
statements2,562
objects9
files19
analysed, main
abaplint version2.120.84
read fromabaplint.app,
Flavors2
ABAP Cloud
“the Open SQL console (`src/abap`) is ABAP-Cloud-clean” — abap2UI5-addons/sql-console — READMEchecked
Standard ABAP
“Native SQL Console (ADBC, Standard ABAP only)” — abap2UI5-addons/sql-console — READMEchecked
Contributors5
choper725feng1976Lars Hvamoblomov-devFrancisco Alcaraz

From the repository’s contributor list, .

History in the atlas1
  1. First seen.
For your agent
Ref
artifact:abap2ui5-addons-sql-console
JSON
/artifacts/abap2ui5-addons-sql-console.json
MCP
Connecting an agent