SAP Schema Expert

Quick start

1. Search assets/TABLE_INDEX.yaml for the table by name or description keyword.
2. Read assets/schemas/<TABLENAME>.yaml for full field definitions.
3. If the schema file is absent, look up the URL in assets/TABLE_INDEX.yaml and use fetch_webpage.

Workflows

Write a HANA SQL query

1. Find the header table in assets/TABLE_INDEX.yaml (e.g. OINV = A/R Invoice).
2. Lines table = strip leading O + append 1 → OINV → INV1.
3. Read field names from assets/schemas/OINV.yaml and assets/schemas/INV1.yaml.
4. Build query — double-quote all identifiers (HANA is case-sensitive):