SAP PM Table Relationships

An interactive reference showing how SAP Plant Maintenance tables connect across maintenance orders, notifications, equipment, functional locations and maintenance plans in both SAP ECC and SAP S/4HANA.

The SAP Plant Maintenance (PM) module stores asset and maintenance execution data across related tables covering orders, notifications, equipment, functional locations, task lists, maintenance plans and measurement documents. Understanding how these tables join together is essential for building MTTR/MTBF dashboards, work-order backlog reporting, PM compliance analytics and asset cost roll-ups.

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. PM tables are consistent between ECC and S/4HANA - the key cross-module dependencies are shared order tables (AUFK, AFKO, AFVC, AFVV, AFRU, RESB) with PP/PS and shared notification tables (QMEL/QMIH/QMFE) with QM.

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.

PM Transaction

Master Data

S/4HANA

Configuration

Quick-Reference Guide

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

Table	Description	Primary Join Keys	System
Maintenance Orders - Transactional
AUFK	Order Master Data (shared with PP, PS, CO)	AUFNR	ECC + S/4HANA
AFIH	Maintenance Order Header (PM-specific; links to equipment, functional location, notification)	AUFNR	ECC + S/4HANA
AFKO	Order Header (shared with PP)	AUFNR	ECC + S/4HANA
AFPO	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 / Components (spares)	RSNUM, RSPOS	ECC + S/4HANA
Notifications - Transactional
QMEL	Quality/PM Notification Header (shared with QM)	QMNUM	ECC + S/4HANA
QMIH	Notification Item (PM maintenance data)	QMNUM	ECC + S/4HANA
QMFE	Notification Cause/Damage Items	QMNUM, FENUM	ECC + S/4HANA
Equipment - Master Data
EQUI	Equipment Master	EQUNR	ECC + S/4HANA
EQKT	Equipment Text (language-dependent)	SPRAS, EQUNR	ECC + S/4HANA
EQUZ	Equipment Time Segments	EQUNR, DATBI	ECC + S/4HANA
Functional Locations - Master Data
IFLOT	Functional Location	TPLNR	ECC + S/4HANA
IFLOTX	Functional Location Text (language-dependent)	SPRAS, TPLNR	ECC + S/4HANA
ILOA	Location/Account Assignment (shared by EQUI and IFLOT)	ILOAN	ECC + S/4HANA
Maintenance Plans / Task Lists - Master Data
MPLA	Maintenance Plan	WARPL	ECC + S/4HANA
MPOS	Maintenance Item	WAPOS	ECC + S/4HANA
PLKO	Task List Header (shared with PP)	PLNTY, PLNNR, PLNAL	ECC + S/4HANA
PLPO	Task List Operation (shared with PP)	PLNTY, PLNNR, PLNKN	ECC + S/4HANA
Measuring Points / Documents - Master Data
IMPT	Measuring Points (on EQUI or IFLOT)	POINT	ECC + S/4HANA
IMRG	Measurement Documents (readings)	POINT, MDOCM	ECC + S/4HANA
Configuration
T001W	Plants	WERKS	ECC + S/4HANA
T352R	Priorities (for notifications/orders)	QUALF, ARTPR, PRIOK	ECC + S/4HANA
T370	Measurement Types	MPTYP	ECC + S/4HANA
TPMY	Maintenance Plan Types	MPTYP	ECC + S/4HANA

Related Resources

Explore more SAP content from DVW Analytics.

SAP PM Tables Blog Post

Detailed descriptions of every table shown in this diagram, with practical tips for building maintenance 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