sap_read_table_data
Retrieve SAP table rows with optional ABAP WHERE filters. Supports operators like EQ, GT, IN, and date/number formats for precise data extraction.
Instructions
Query rows from an SAP table with optional WHERE filtering. Use sap_search_tables / sap_read_table_structure first if unsure of the table or field names. WHERE uses ABAP operators: EQ NE GE LE GT LT LIKE IN, values in single quotes. Dates are YYYYMMDD. Numeric keys carry leading zeros (vendor 1000 = LIFNR EQ '0000001000', material = 18 digits). Example: "MTART EQ 'FERT' AND ERSDA GE '20260101'"
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| max_rows | No | Maximum rows to return (default 100) | |
| table_name | Yes | SAP table name, e.g. LFA1, EKKO, MARA | |
| where_clause | No | ABAP-style WHERE condition (see tool description) |