SAP Data Models|Plant Maintenance
SAP PM table relationships in one interactive diagram
How SAP Plant Maintenance tables connect across maintenance orders, notifications, equipment, functional locations and maintenance plans, in both SAP ECC and SAP S/4HANA.
Trusted by 500+ enterprises. Read and write SAP data from any analytics or data platform.
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 PostInteractive Data Model
Hover over any table to see its description, key fields and system compatibility.
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 | |||
| IMPTT | 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 |
| T370K | Technical Object Types | EQART | ECC + S/4HANA |
| T399W | Maintenance Plan Categories | MPTYP | ECC + S/4HANA |
Related Resources
Explore more SAP content from DVW Analytics.
Try it free for 30 days
Free 30-day trial. Full functionality. No commitment.
Start Your Free Trial