Run ABAP-SQL Query
sap_sql_queryExecute read-only ABAP SQL SELECT statements, including joins, against SAP S/4HANA and retrieve results in markdown or JSON. Designed for queries beyond standard table reads.
Instructions
Run a freestyle, read-only ABAP-SQL SELECT (including joins) via the ADT Data Preview. Use this when sap_read_table is not expressive enough.
Args:
sql (string): a SELECT statement. Only SELECT is permitted.
max_rows (number): 1-1000 (default 100).
response_format ('markdown' | 'json').
Returns (json): same shape as sap_read_table.
Examples:
"Join BKPF and BSEG for company 1000" -> sql="SELECT k
belnr, kgjahr, bhkont, bdmbtr FROM bkpf AS k INNER JOIN bseg AS b ON kbukrs = bbukrs AND kbelnr = bbelnr AND kgjahr = bgjahr WHERE k~bukrs = '1000'". Error Handling:Rejects anything that is not a SELECT.
SAP syntax errors are returned with the server message.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | A read-only ABAP-SQL SELECT statement (no trailing period needed). Joins are supported. | |
| max_rows | No | Maximum rows to return (1-1000, default 100). | |
| response_format | No | Output format: 'markdown' (human-readable, default) or 'json' (structured). | markdown |