Products
Solutions
Pricing
Free Trial
Resources
Contact Us

DVW Analytics
  • Products
    • DVW Connectors for SAP >
      • Alteryx Connector
      • KNIME Connector
      • Dataiku Connector
    • DVW Flow Tool >
      • Flow Tool
      • DVW Flow Tool SAP Migration Landing
    • DVW RPA Tools for SAP >
      • Alteryx RPA Tools
      • KNIME RPA Tools
      • Flow Tool RPA Tools
  • Solutions
    • SAP Analytics
    • SAP Data Migration
    • SAP Process Automation
    • SAP Data for AI and Machine Learning
    • SAP Audit and Compliance
  • Pricing
    • DVW Connectors for SAP >
      • Alteryx Connector
      • KNIME Connector
      • Dataiku Connector
    • DVW Flow Tool >
      • Flow Tool
    • DVW RPA Tools for SAP >
      • RPA Tools
  • Free Trial
  • Resources
    • Blog
    • SAP Data Models >
      • Finance and Controlling
      • Sales and Distribution
      • Inventory Management
      • Purchasing
      • Production Planning
      • Quality Management
      • Plant Maintenance
      • Warehouse Management
      • Human Capital Management
      • Project System
    • Webinars
    • Events
    • Demos and Recordings >
      • DVW Connectors for SAP >
        • Alteryx Connector
        • KNIME Connector
        • Dataiku Connector
      • DVW Flow Tool >
        • Flow Tool
      • DVW RPA Tools for SAP >
        • RPA Tools
    • About Us
    • Customers >
      • Johnson & Johnson
      • AGC
      • Brightstar
      • Vector Logistics
      • International Bank
      • KPMG
    • Partners
    • Resellers
    • Services
    • Help Centre
    • Sample Workflows >
      • Alteryx
      • KNIME
      • Flow Tool
    • License
    • FAQ
  • Contact Us

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.

Start Your Free Trial All SAP Data Models

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 Post

Interactive Data Model

Hover over any table to see its description, key fields and system compatibility.

PM Transaction
Master Data
Configuration
Maintenance Order AUFK Order Master AFIH PM Order Header AFKO Order Header AFPO Order Item AUFNR AUFNR AUFNR AFVC Order Operation AFVV Op Qty/Dates AUFPL, APLZL AUFPL AFRU Confirmations RESB Reservations AUFPL AUFNR Notifications QMEL Notif Header QMIH Notif Item (PM) QMFE Damage/Cause QMNUM QMNUM QMNUM (order linked to notif) Equipment EQUI Equipment Master EQKT Equipment Text EQUZ Equipment Time EQUNR EQUNR EQUNR EQUNR Functional Location IFLOT Func Location IFLOTX FuncLoc Text ILOA Loc/Account Assn TPLNR ILOAN ILOAN TPLNR TPLNR Task Lists / Plans MPLA Maint Plan MPOS Maint Item PLKO Task List Header PLPO Task List Op WARPL PLNNR EQUNR TPLNR PLNNR Measuring Points / Documents IMPTT Measuring Points IMRG Measurement Docs POINT OBJID (EQUI) OBJID (IFLOT) Configuration T001W Plants T352R Priorities T370K Technical Object Types T399W Maint Plan Categories config: WERKS config: PRIOK config: MPTYP config: MPTYP

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.

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
Products​
​SAP Connectors
DVW Alteryx Connector for SAP
DVW KNIME Connector for SAP
​DVW Dataiku Connector for SAP

DVW Flow Tool
DVW Flow Tool
S/4HANA Migration with Flow Tool

RPA Tools for SAP
DVW Alteryx RPA Tools for SAP
DVW KNIME RPA Tools for SAP
DVW Flow Tool RPA Tools for SAP
Resources
Blog
Watch Demos
Webinars
​
​Events
​Customers
Services
Solutions
SAP Analytics
SAP Data Migration
SAP Process Automation
SAP Data for AI and ML
​SAP Audit and Compliance
Company
About Us
Contact Us
Pricing
Free Trial

[email protected]
Get started
​Start Free Trial
View Pricing
Book a Demo
​DVW Analytics gives business users and technical teams direct access to SAP data from Alteryx, KNIME, Dataiku, Power BI, Databricks, Snowflake, and more. Trusted by 500+ enterprises worldwide.
© COPYRIGHT 2003 - 2026 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.
Privacy Policy
Cookie Policy
De Villiers Walton Limited. Registered in England and Wales. Company No. 04638006. VAT No. GB 807714429. Registered Office:  Ground Floor Marlborough House, 298 Regents Park Road, London, N3 2SZ, United Kingdom

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Alteryx is a registered trademark of Alteryx, Inc. KNIME is a registered trademark of KNIME AG. Dataiku is a registered trademark of Dataiku SAS. All other product, company, and brand names mentioned herein are the trademarks or registered trademarks of their respective owners and are used for identification purposes only.
  • Products
    • DVW Connectors for SAP >
      • Alteryx Connector
      • KNIME Connector
      • Dataiku Connector
    • DVW Flow Tool >
      • Flow Tool
      • DVW Flow Tool SAP Migration Landing
    • DVW RPA Tools for SAP >
      • Alteryx RPA Tools
      • KNIME RPA Tools
      • Flow Tool RPA Tools
  • Solutions
    • SAP Analytics
    • SAP Data Migration
    • SAP Process Automation
    • SAP Data for AI and Machine Learning
    • SAP Audit and Compliance
  • Pricing
    • DVW Connectors for SAP >
      • Alteryx Connector
      • KNIME Connector
      • Dataiku Connector
    • DVW Flow Tool >
      • Flow Tool
    • DVW RPA Tools for SAP >
      • RPA Tools
  • Free Trial
  • Resources
    • Blog
    • SAP Data Models >
      • Finance and Controlling
      • Sales and Distribution
      • Inventory Management
      • Purchasing
      • Production Planning
      • Quality Management
      • Plant Maintenance
      • Warehouse Management
      • Human Capital Management
      • Project System
    • Webinars
    • Events
    • Demos and Recordings >
      • DVW Connectors for SAP >
        • Alteryx Connector
        • KNIME Connector
        • Dataiku Connector
      • DVW Flow Tool >
        • Flow Tool
      • DVW RPA Tools for SAP >
        • RPA Tools
    • About Us
    • Customers >
      • Johnson & Johnson
      • AGC
      • Brightstar
      • Vector Logistics
      • International Bank
      • KPMG
    • Partners
    • Resellers
    • Services
    • Help Centre
    • Sample Workflows >
      • Alteryx
      • KNIME
      • Flow Tool
    • License
    • FAQ
  • Contact Us