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 Post

Interactive Data Model

Hover over any table to see its description, key fields and system compatibility. Dashed red borders indicate S/4HANA-specific tables.

Transaction

Master Data

Info Records

Configuration

S/4HANA

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	Both
EBKN	Requisition Account Assignment	BANFN, BNFPO, SAKOS	Both
Purchase Orders
EKKO	Purchase Order Header	EBELN, BSART, EKORG, LIFNR	Both
EKPO	Purchase Order Item	EBELN, EBELP, MATNR, NETPR	Both
EKET	PO Schedule Lines	EBELN, EBELP, ETENR, EINDT	Both
EKBE	PO History/Item Changes	EBELN, EBELP, BELNR, GRNUMR	Both
EKKN	PO Account Assignment	EBELN, EBELP, SAKOS	Both
Goods Receipt
MKPF	Material Document Header	MBLNR, MJAHR, BLDAT, BUDAT	Both
MSEG	Material Document Item	MBLNR, MJAHR, ZEILE, MATNR	Both
Invoice Verification
RBKP	Invoice Header	BELNR, GJAHR, BLDAT, LIFNR	Both
RSEG	Invoice Item	BELNR, GJAHR, BUZEI, EBELN, EBELP	Both
Info Records
EINA	Source List Info Rec General	INFNR, MATNR, LIFNR, EKORG	Both
EINE	Info Rec by Purchasing Org	INFNR, EKORG, VKORG	Both
Vendor Master Tables (ECC)
LFA1	Vendor Master General Data	LIFNR, NAME1, LAND1, ADRNR	ECC
LFB1	Vendor Master Company Code	LIFNR, BUKRS, AKONT, ZTERM	ECC
LFM1	Vendor Master Purchasing Org	LIFNR, EKORG, LFABC, WAERS	ECC
LFBK	Vendor Master Bank Data	LIFNR, BANKS, BANKL, BANKN	ECC
ADRC	Address Data	ADDRNUMBER, NAME1, CITY1, COUNTRY	Both
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	Both
T024E	Purchasing Organizations	EKORG, BUKRS, EKOTX	Both
T161	Document Types	BSART, BSTYP	Both
T161T	Document Type Texts	BSART, SPRAS, BSTEXT	Both
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.

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