SAP PP Table Relationships

An interactive reference showing how SAP Production Planning tables connect across production orders, MRP, bills of material, routings, work centres and material movements in both SAP ECC and SAP S/4HANA.

The SAP Production Planning (PP) module stores manufacturing data across dozens of related tables covering planned and production orders, BOMs, routings, work centres and shop-floor confirmations. Understanding how these tables join together is essential for building accurate manufacturing analytics, WIP reporting, capacity dashboards and variance analyses.

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 (including the S/4HANA MATDOC change for material documents).

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.

PP Transaction

Master Data

S/4HANA

Configuration

Quick-Reference Guide

All SAP PP tables shown above with their primary join keys and SAP system compatibility.

Table	Description	Primary Join Keys	System
Production Order - Transactional
AUFK	Order Master Data (shared with PM, PS, CO)	AUFNR	ECC + S/4HANA
AFKO	Production Order Header	AUFNR	ECC + S/4HANA
AFPO	Production Order Item	AUFNR, POSNR	ECC + S/4HANA
AFVC	Operation within Order	AUFPL, APLZL	ECC + S/4HANA
AFVV	Quantities/Dates/Values in Operation	AUFPL, APLZL	ECC + S/4HANA
AFRU	Order Confirmations	RUECK, RMZHL	ECC + S/4HANA
RESB	Reservations / Dependent Requirements	RSNUM, RSPOS	ECC + S/4HANA
MRP / Planning
PLAF	Planned Orders (output of MRP run)	PLNUM, MATNR, WERKS	ECC + S/4HANA
MDKP	MRP Document Header	DBLNR, MATNR, WERKS	ECC + S/4HANA
MDTB	MRP Table (Items)	DBLNR, DTNUM	ECC + S/4HANA
Bill of Materials
MAST	Material to BOM Link	MATNR, WERKS, STLAN, STLNR, STLAL	ECC + S/4HANA
STKO	BOM Header	STLNR, STLAL, STLTY	ECC + S/4HANA
STPO	BOM Item (components)	STLNR, STLKN	ECC + S/4HANA
Routing / Task List
MAPL	Assignment of Task Lists to Material	MATNR, PLNTY, PLNNR, PLNAL	ECC + S/4HANA
PLKO	Task List Header (Routing)	PLNTY, PLNNR, PLNAL	ECC + S/4HANA
PLPO	Task List Operation	PLNTY, PLNNR, PLNKN	ECC + S/4HANA
Work Centre
CRHD	Work Centre Header	OBJTY, OBJID	ECC + S/4HANA
CRTX	Work Centre Text	OBJTY, OBJID, SPRAS	ECC + S/4HANA
Material Master
MARA	Material Master - General	MATNR	ECC + S/4HANA
MARC	Material - Plant Data (incl. MRP)	MATNR, WERKS	ECC + S/4HANA
MBEW	Material Valuation	MATNR, BWKEY	ECC + S/4HANA
Material Documents (Goods Movements)
MKPF	Material Document Header	MBLNR, MJAHR	ECC
MSEG	Material Document Items	MBLNR, MJAHR, ZEILE	ECC
MATDOC	Universal Material Document (replaces MKPF+MSEG)	MBLNR, MJAHR, ZEILE	S/4HANA
Configuration
T024D	MRP Controllers	WERKS, DISPO	ECC + S/4HANA
T399X	Order Type Master (per plant)	WERKS, AUART	ECC + S/4HANA
T001W	Plants	WERKS	ECC + S/4HANA

Related Resources

Explore more SAP content from DVW Analytics.

SAP PP Tables Blog Post

Detailed descriptions of every table shown in this diagram, with practical tips for building manufacturing analytics workflows.

DVW Help Centre

Guides and documentation for the DVW Connector for SAP, DVW Flow Tool and other DVW products. Available to free trial and paid users.

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