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)

26 tables across orders, deliveries, billing, customer master and configuration

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.

View Diagram Read blog

SAP Finance and Controlling (FI/CO)

33 tables across general ledger, accounts payable/receivable, cost centres and profit centres

The financial data model: accounting documents, general ledger, subledger line items, cost centre and profit centre postings, master data and configuration. Includes the S/4HANA Universal Journal (ACDOCA).

View Diagram Read blog

SAP Inventory Management (IM)

26 tables across material documents, stock levels, physical inventory, material master and configuration

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.

View Diagram Read blog

SAP Purchasing (MM-PUR)

27 tables across requisitions, purchase orders, goods receipts, invoice verification, vendor master and configuration

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.

View Diagram Read blog

SAP Production Planning (PP)

27 tables across production orders, MRP, BOMs, routings, work centres, material master and goods movements

The plan-to-produce data model: production orders, planned orders, bill of materials, routings, work centres, order confirmations and material master data.

View Diagram Read blog

SAP Quality Management (QM)

26 tables across inspection lots, results recording, quality notifications, inspection plans and master data

The quality data model: inspection lots, results recording, usage decisions, quality notifications, inspection plans, master inspection characteristics and catalog data.

View Diagram Read blog

SAP Plant Maintenance (PM)

27 tables across maintenance orders, notifications, equipment, functional locations, task lists, maintenance plans and measuring points

The maintain-to-settle data model: maintenance orders, notifications, equipment master, functional locations, task lists, maintenance plans and measuring points.

View Diagram Read blog

SAP Warehouse Management (WM/EWM)

25 tables across transfer orders, warehouse stock, storage bins and Extended Warehouse Management

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.

View Diagram Read blog

SAP Human Capital Management (HCM)

22 tables across personnel administration, organisational management, time management and payroll

The HR data model: employee infotypes, organisational structure, time management, payroll results and personnel configuration tables.

View Diagram Read blog

SAP Project System (PS)

22 tables across project definitions, WBS elements, networks, budgets, actual costs and object status

The project data model: project definitions, WBS elements, network activities, milestones, budgets, cost postings and settlement rules.

View Diagram Read blog

Try it free for 30 days

Free 30-day trial. Full functionality. No commitment.

Start Your Free Trial

Watch demos View pricing Talk to our team