Skip to main content

adt datapreview

ABAP data preview (Open SQL console) operations. Runs arbitrary SELECT statements through the Eclipse ADT "Data Preview" / Freestyle endpoint.

Subcommands

CommandDescription
adt datapreview osql <statement>Execute an ABAP Open SQL SELECT statement.

Options — osql

Argument / FlagDescription
<statement>ABAP SQL SELECT statement (quote it).
-o, --output <format>Output format: human (default) or json.
-r, --rows <n>Maximum number of rows to return (default: 100).
--noheadingsSuppress column headings.
--noagingDisable SAP aging (bypass browser cache flag).

Examples

# Simple select, default human table
adt datapreview osql 'SELECT * FROM t000 UP TO 5 ROWS'

# JSON output for further processing
adt datapreview osql 'SELECT mandt, mtext FROM t000' -o json -r 50

# Suppress headers for `cut`/`awk` piping
adt datapreview osql 'SELECT bname FROM usr01' --noheadings -r 1000

See also