GetTableContents
Retrieve ABAP table contents with filtering, pagination, sorting, and batch queries to inspect SAP data in one call.
Instructions
Retrieve contents of an ABAP table with advanced filtering, pagination, and batch query support. Either provide table_name for a single query, or provide queries array for batch mode.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| offset | No | Optional: Number of rows to skip for pagination (default: 0) | |
| columns | No | Optional: Specific columns to retrieve (default: all columns). Column names are validated against table metadata. | |
| queries | No | Optional: Batch mode - execute multiple queries in one call (max: 10, omit when using table_name). Each query supports all single-query parameters. | |
| max_rows | No | Optional: Maximum number of rows to retrieve (default: 100, max: 500) | |
| order_by | No | Optional: Column names for sorting results. Column names are validated against table metadata. | |
| table_name | No | Name of the ABAP table (required for single query mode, omit when using queries array) | |
| where_conditions | No | Optional: WHERE conditions for filtering. Simple: {"MATNR": "ABC123", "MTART": "FERT"}. Advanced: {"MATNR": {"eq": "ABC123"}}. Note: ADT Data Preview API only supports equality (=) operator. | |
| include_column_metadata | No | Optional: Include column type and description in response (default: false) |