SAP Reference
Interactive Tool
SAP Reference Database
A searchable reference for SAP tables, transaction codes, fields, relationships, and released CDS views. Built for supply chain business analysts and data engineers modeling SAP sources in Databricks, Snowflake, or any downstream analytics platform.
/
148
Tables
82
T-Codes
11
Modules
23
CDS Views
How this is scoped
- Scope: core supply chain and financial modules — MM, PP, SD, EWM plus classic WM, 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 lifecycle tag — active, deprecated, replaced, or migrating to IBP — and tables whose classic name still answers reads carry a second tag for the mechanism (compatibility view or NSDM proxy view). 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. Released CDS views are cataloged alongside the classic tables they read over.
- 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. Every field record carries its provenance, shown beneath each table's field listing; see the full sources list below. Last verified July 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 · 5 t-codesUniversal Journal (ACDOCA)
- 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 · 7 t-codesUniversal Journal (ACDOCA)
- LELogistics ExecutionShipping, transportation, and handling unit management7 tables · 0 t-codes
- MMMaterials ManagementCovers procurement, inventory management, invoice verification, and material master data27 tables · 26 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 · 17 t-codes
- QMQuality ManagementCovers quality planning, inspection, control, certificates, and notifications19 tables · 9 t-codes
- SDSales & DistributionCovers sales orders, deliveries, billing, pricing, and customer master data16 tables · 13 t-codes
- WMWarehouse Management (Classic)Classic warehouse management for storage bin management, transfer orders, and physical inventory9 tables · 5 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 View Browser — released CDS views (S/4HANA Cloud) — the canonical lookup for which CDS views are released in a given S/4HANA Cloud release. Only Released-status views are safe to build on.
- 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 Cloudification Repository — SAP-official, machine-readable JSON/CSV lists of released and classic APIs with successor objects for Cloud ERP — the bulk-export counterpart to the View Browser.
- 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 Architecture Center — BDC ↔ Databricks integration — SAP-authored reference architecture for Business Data Cloud with Databricks via Delta Sharing and data-product activation. The SAP-side view of the Databricks docs above.
- SAP Business Data Cloud Catalog — official index of concrete BDC data packages and products. Pairs the integration pattern and mechanics above with what is actually available to activate.
- SAP Samples (GitHub) — official sample repos for ABAP CDS, CAP/RAP, S/4HANA extensions, Fiori Elements, and clean-core patterns.