abap-sql-query

name	abap-sql-query
description	Execute ABAP SQL (OpenSQL) queries against a connected SAP system using the sapcli datapreview osql command.

What I do

I run ABAP SQL (OpenSQL) SELECT queries against a connected SAP system and display the results. I use the sapcli datapreview osql command under the hood.

When to use me

Use me when you need to query SAP database tables directly — for example to inspect table contents, check configuration entries, or retrieve data for analysis or debugging.

Basic usage

sapcli datapreview osql "SELECT * FROM <TABLE>"

Limiting rows returned

Use --rows to cap the number of result rows (default is determined by the system):

sapcli datapreview osql --rows 20 "SELECT MANDT, CARRID, CONNID FROM SPFLI"

Output formats

Results can be displayed in human-readable form (default) or as JSON:

# Human-readable table (default)
sapcli datapreview osql "SELECT * FROM T000"

# JSON output — useful for scripting or piping to jq
sapcli datapreview osql -o json "SELECT * FROM T000"

Suppress headings

Use -n / --noheadings to omit column headers from the output:

sapcli datapreview osql -n "SELECT MANDT FROM T000"

Disable aging check

Use --noaging to skip the data aging check:

sapcli datapreview osql --noaging "SELECT * FROM SFLIGHT UP TO 5 ROWS"

Notes

• The statement argument must be valid ABAP SQL syntax without a trailing period.
• Only SELECT statements (no JOINS) are supported via datapreview osql.