runQuery
Run Open SQL SELECT queries on ABAP systems to fetch rows, supporting joins, aggregates, and GROUP BY. Read-only data retrieval for reporting and analysis.
Instructions
Run an Open SQL SELECT and get the rows back - joins, aggregates, GROUP BY, whatever the ABAP SQL console accepts. Reading only, and only SELECT: the endpoint refuses anything that writes, and for logic around the data (call a function module, compute, loop) use runSnippet. Row limits are the ones the backend applies, so ask for what you need with UP TO n ROWS.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| decode | No | Whether to decode the data. | |
| offset | No | Skip this many leading rows. ADT has no offset, so the server fetches offset+rowNumber rows and returns the tail - add an ORDER BY to make the window stable. | |
| sqlQuery | Yes | The SQL query to execute. | |
| rowNumber | No | The maximum number of rows to retrieve. |