SAP Data Models|Purchasing
SAP Purchasing table relationships in one interactive diagram
How 27 SAP Purchasing tables connect across purchase requisitions, purchase orders, goods receipts, invoice verification, vendor master data and configuration, in both SAP ECC and SAP S/4HANA.
Trusted by 500+ enterprises. Read and write SAP data from any analytics or data platform.
SAP Purchasing Table Relationships
An interactive reference showing how 27 SAP Purchasing tables connect across purchase requisitions, purchase orders, goods receipts, invoice verification, vendor master data and configuration - in both SAP ECC and SAP S/4HANA.
The SAP Purchasing (MM) module stores procurement data across dozens of related tables. Understanding how these tables join together is essential for building accurate purchase order, goods receipt and invoice verification reporting workflows. This page provides an interactive diagram and a quick-reference table covering the full procure-to-pay data model, including the Business Partner and Material Document changes introduced in SAP S/4HANA.
Use the diagram below to explore table relationships visually, or scroll to the quick-reference guide for a complete list of tables, join keys and system compatibility.
Read the Full Blog PostInteractive Data Model
Hover over any table to see its description, key fields and system compatibility. Dashed red borders indicate S/4HANA-specific tables.
See the Data Model in Action
The same tables, read from SAP in one flow and reconciled two ways: ordered, received, invoiced, line by line in Power BI, and again in an app built with AI.
Requisition, purchase order, order history, material documents and invoice documents joined in one pass, then filtered to the quantity and value discrepancies worth chasing. The demo ends on the same reconciliation in a second front end off the same flow, a web app built with Claude from the flow configuration alone. Also available on YouTube.
Quick-Reference Guide
All 27 SAP Purchasing tables with their primary join keys and SAP system compatibility.
| Table | Description | Primary Join Keys | System |
|---|---|---|---|
| Purchase Requisitions | |||
| EBAN | Purchase Requisition Item | BANFN, BNFPO, MATNR | ECC + S/4HANA |
| EBKN | Requisition Account Assignment | BANFN, BNFPO, ZEBKN | ECC + S/4HANA |
| Purchase Orders | |||
| EKKO | Purchase Order Header | EBELN, BSART, EKORG, LIFNR | ECC + S/4HANA |
| EKPO | Purchase Order Item | EBELN, EBELP, MATNR, NETPR | ECC + S/4HANA |
| EKET | PO Schedule Lines | EBELN, EBELP, ETENR, EINDT | ECC + S/4HANA |
| EKBE | PO History/Item Changes | EBELN, EBELP, VGABE, GJAHR, BELNR | ECC + S/4HANA |
| EKKN | PO Account Assignment | EBELN, EBELP, ZEKKN | ECC + S/4HANA |
| Goods Receipt | |||
| MKPF | Material Document Header | MBLNR, MJAHR, BLDAT, BUDAT | ECC + S/4HANA |
| MSEG | Material Document Item | MBLNR, MJAHR, ZEILE, MATNR | ECC + S/4HANA |
| Invoice Verification | |||
| RBKP | Invoice Header | BELNR, GJAHR, BLDAT, LIFNR | ECC + S/4HANA |
| RSEG | Invoice Item | BELNR, GJAHR, BUZEI, EBELN, EBELP | ECC + S/4HANA |
| Info Records | |||
| EINA | Purchasing Info Record - General Data | INFNR, MATNR, LIFNR | ECC + S/4HANA |
| EINE | Purchasing Info Record - Purch Org Data | INFNR, EKORG, ESOKZ, WERKS | ECC + S/4HANA |
| Vendor Master Tables (ECC + S/4HANA) | |||
| LFA1 | Vendor Master General Data | LIFNR, NAME1, LAND1, ADRNR | ECC + S/4HANA |
| LFB1 | Vendor Master Company Code | LIFNR, BUKRS, AKONT, ZTERM | ECC + S/4HANA |
| LFM1 | Vendor Master Purchasing Org | LIFNR, EKORG, LFABC, WAERS | ECC + S/4HANA |
| LFBK | Vendor Master Bank Data | LIFNR, BANKS, BANKL, BANKN | ECC + S/4HANA |
| ADRC | Address Data | ADDRNUMBER, NAME1, CITY1, COUNTRY | ECC + S/4HANA |
| Business Partner Tables (S/4HANA) | |||
| CVI_VEND_LINK | Vendor to BP Number Mapping | PARTNER, VENDOR (LIFNR) | S/4HANA |
| BUT000 | Business Partner General Data | PARTNER, NAME_ORG1, COUNTRY, BU_TYPE | S/4HANA |
| BUT020 | Business Partner Address Data | PARTNER, ADDRNUMBER | S/4HANA |
| Configuration Tables | |||
| T024 | Purchasing Groups | EKGRP, EKNAM | ECC + S/4HANA |
| T024E | Purchasing Organizations | EKORG, BUKRS, EKOTX | ECC + S/4HANA |
| T161 | Document Types | BSART, BSTYP | ECC + S/4HANA |
| T161T | Document Type Texts | BSART, SPRAS, BSTEXT | ECC + S/4HANA |
| S/4HANA Material Documents | |||
| MATDOC | Material Document (replaces MKPF + MSEG) | MBLNR, MJAHR, ZEILE, MATNR, WERKS, BWART | S/4HANA |
| NSDM_V_MSEG | Compatibility View for MSEG | MBLNR, MJAHR, ZEILE | S/4HANA |
Related Resources
Explore more SAP content from DVW Analytics.
SAP SD Table Relationships
Interactive diagram of Sales and Distribution tables: orders, deliveries, billing and customer master data across ECC and S/4HANA.
SAP IM Table Relationships
Inventory Management table relationships: material documents, stock levels, physical inventory, master data and configuration tables.
SAP FI/CO Table Relationships
Financial Accounting and Controlling table relationships: general ledger, subledgers, cost centers and profit centers across ECC and S/4HANA.