Resources|SAP Data Models
How SAP tables connect, module by module
Interactive table-relationship diagrams for ten SAP modules, with join keys and ECC and S/4HANA compatibility for every table. Platform-agnostic reference for anyone building SAP extracts in Alteryx, KNIME, Dataiku, Power BI or the DVW Flow Tool.
Trusted by 500+ enterprises. Read and write SAP data from any analytics or data platform.
SAP data models
Interactive table relationship diagrams for key SAP modules, covering both SAP ECC and SAP S/4HANA.
Each data model page provides an interactive diagram showing how SAP tables connect to each other, a quick-reference guide with join keys and system compatibility, and links to the companion blog post with detailed table descriptions. Use these pages to plan your SAP analytics workflows, understand foreign key relationships and identify the right tables for your reporting requirements.
SAP Sales and Distribution (SD)
The order-to-cash data model: sales orders, deliveries, billing documents, document flow, customer master data and configuration tables. Includes S/4HANA Business Partner changes.
SAP Finance and Controlling (FI/CO)
The financial data model: accounting documents, general ledger, subledger line items, cost center and profit center postings, master data and configuration. Includes the S/4HANA Universal Journal (ACDOCA).
SAP Inventory Management (IM)
The inventory data model: material documents, stock overview tables, physical inventory, material valuation, material master data and batch management. Includes the S/4HANA MATDOC consolidation.
SAP Purchasing (MM-PUR)
The procure-to-pay data model: purchase requisitions, purchase orders, goods receipts, invoice verification, vendor master data, purchasing info records and configuration. Includes S/4HANA Business Partner changes.
SAP Production Planning (PP)
The plan-to-produce data model: production orders, planned orders, bill of materials, routings, work centers, order confirmations and material master data.
SAP Quality Management (QM)
The quality data model: inspection lots, results recording, usage decisions, quality notifications, inspection plans, master inspection characteristics and catalog data.
SAP Plant Maintenance (PM)
The maintain-to-settle data model: maintenance orders, notifications, equipment master, functional locations, task lists, maintenance plans and measuring points.
SAP Warehouse Management (WM/EWM)
The warehouse data model: transfer orders, quants, storage bins, warehouse structures in classic WM, plus warehouse tasks, orders and deliveries in S/4HANA Extended Warehouse Management.
SAP Human Capital Management (HCM)
The HR data model: employee infotypes, organizational structure, time management, payroll results and personnel configuration tables.
SAP Project System (PS)
The project data model: project definitions, WBS elements, network activities, milestones, budgets, cost postings and settlement rules.