bw_table_get_data
Retrieve SAP BW DDIC table data using OpenSQL SELECT via ADT data-preview. Use outputPath to write large result sets to a file.
Instructions
Query DDIC table data via the ADT data-preview service (OpenSQL SELECT). maxRows defaults to a small value and is capped to avoid huge inline payloads; for large reads set outputPath to dump the full result to a file.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | DDIC table name. | |
| columns | No | Optional column allowlist. If omitted, all columns are read. | |
| maxRows | No | Max rows to fetch (default 50). | |
| orderBy | No | OpenSQL ORDER BY clause, without the ORDER BY keyword. | |
| outputPath | No | If provided, the full result is written to this path (under the workdir) and the tool returns only a small summary envelope { ok, outputPath, bytes, summary }. Objects/arrays are written as JSON; ONLY the bw_*_get_xml family writes the raw XML string as plain text (that file is directly reusable as xmlPath in a later save call). Other *_get tools (e.g. bw_dtp_get, bw_trfn_get) write the PARSED XML-to-JSON tree, not raw XML — use the matching bw_*_get_xml tool when you need the raw XML string. Use outputPath for large responses (XML, table data, logs, dataflow graphs). When set, tools skip inline pagination/projection so the file contains the complete payload. | |
| whereClause | No | OpenSQL WHERE clause, without the WHERE keyword. ⚠️ Executed with the configured BW credentials — avoid untrusted input. |