SAP Reference
Interactive Tool
SAP Reference Database
A searchable reference for SAP tables, transaction codes, fields, and relationships. Built for supply chain business analysts and data engineers modeling SAP sources in Databricks, Snowflake, or any downstream analytics platform.
148
Tables
50
T-Codes
11
Modules
How this is scoped
- Scope: core supply chain and financial modules — MM, PP, SD, WM/EWM, QM, FI/CO, APO, LE, plus cross-module org tables. Not a complete SAP Data Dictionary (yet).
- S/4HANA awareness: every table and t-code carries an S/4HANA status tag — active, compatibility view, replaced, deprecated, or migrating to IBP. Module-level tags flag broader shifts: APO moving toward IBP and embedded PP/DS depending on planning capability, and classic WM moving toward embedded or decentralized EWM.
- Field data: key fields are populated for every table; secondary fields for the highest-traffic tables. Table and field metadata is cross-checked against SAP-Tables, SAP Datasheet, and SAP Help. Per-field provenance is still being expanded; see the full sources list below. Last verified May 2026.
- Built for analytics: relationships are focused on the joins you'll actually write — header/item pairs, foreign keys, and the cross-module keys (MATNR, EBELN, VBELN, BUKRS) that stitch SAP data together.
Frequently Referenced Tables
The workhorses of SAP analytics — material master, sales orders, purchase orders, accounting.
- MARAGeneral Material Data
- MARCPlant Data for Material
- MARDStorage Location Data for Material
- EKKOPurchasing Document Header
- EKPOPurchasing Document Item
- MSEGDocument Segment: Material
- MATDOCMaterial Document (S/4HANA)
- VBAKSales Document: Header Data
- VBAPSales Document: Item Data
- LIKPSD Document: Delivery Header Data
- LIPSSD Document: Delivery Item Data
- BKPFAccounting Document Header
- BSEGAccounting Document Segment
- ACDOCAUniversal Journal Entry Line Items (S/4HANA)
Frequently Used T-Codes
Display and reporting t-codes analysts use to validate SAP data, reverse-engineer schemas, and reconcile reports against the source system.
- MM03Display Material
- MMBEStock Overview
- MB51Material Document List
- MIGOGoods Movement
- ME23NDisplay Purchase Order
- MD04Display Stock/Requirements List
- COOISProduction Order Information System
- VA03Display Sales Order
- VL03NDisplay Outbound Delivery
- FB03Display Document
- FBL1NVendor Line Item Display
- KSB1Cost Centers: Actual Line Items
Browse by Module
Organized by SAP functional area. Click a module to see its tables and transaction codes.
- APOAdvanced Planning & OptimizationDemand planning, supply network planning, PP/DS, and global ATP10 tables · 0 t-codes→ IBP
- COControllingCost center accounting, profit center accounting, internal orders, and profitability analysis7 tables · 3 t-codes
- EWMExtended Warehouse ManagementAdvanced warehouse management with wave management, labor management, and yard management15 tables · 0 t-codes
- FIFinancial AccountingGeneral ledger, accounts payable/receivable, asset accounting, and bank accounting9 tables · 4 t-codes
- LELogistics ExecutionShipping, transportation, and handling unit management5 tables · 0 t-codes
- MMMaterials ManagementCovers procurement, inventory management, invoice verification, and material master data27 tables · 15 t-codes
- ORGOrganizational StructureCompany codes, plants, storage locations, sales orgs, purchasing orgs9 tables · 0 t-codes
- PPProduction PlanningCovers demand management, MRP, production orders, capacity planning, and shop floor control20 tables · 12 t-codes
- QMQuality ManagementCovers quality planning, inspection, control, certificates, and notifications19 tables · 7 t-codes
- SDSales & DistributionCovers sales orders, deliveries, billing, pricing, and customer master data18 tables · 9 t-codes
- WMWarehouse Management (Classic)Classic warehouse management for storage bin management, transfer orders, and physical inventory9 tables · 0 t-codesDeprecated in S/4
Sources & further reading
S/4HANA status, simplification semantics, and Fiori mappings are authoritative only at source. Use these references to verify before building on any claim in this reference.
- SAP Help Portal — authoritative S/4HANA simplification, Universal Journal, NSDM, Business Partner/CVI, and CDS documentation.
- SAP Business Accelerator Hub — central catalog for S/4HANA Cloud CDS views, APIs, events, and integrations with release status. The first stop when replacing classic-table reads with released CDS views.
- sap-tables.org — community SAP table and field reference, useful for spot-checking classic DDIC objects.
- sapdatasheet.org — deep-linkable SAP object repository (tables, data elements, search helps, T-codes) for ECC-era schemas.
- sap-tcodes.org — transaction code descriptions and module/component analytics.
- SAP Fiori Apps Reference Library — classic-to-Fiori transaction mapping and S/4HANA release availability.
- SAP Databricks documentation — Business Data Cloud integration, SAP data products, and Delta Sharing with SAP.
- SAP Samples (GitHub) — official sample repos for ABAP CDS, CAP/RAP, S/4HANA extensions, Fiori Elements, and clean-core patterns.