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
12
Modules
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
- BCBasis ComponentsSystem administration, data dictionary, transport management0 tables · 0 t-codes
- 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
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 is tagged with its S/4HANA status — active, compatibility view, deprecated, or migrating to IBP.
- Field data: key fields are populated for every table; secondary fields for the highest-traffic tables. Field names verified against sap-tables.org and se80.co.uk.
- 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.