SAP PM Tables

Today we are going to explain the core concepts of the SAP PM (plant maintenance) module as we promised. In the SAP PM tables article, you will get a complete idea of the types of PM tables being used while performing maintenance tasks and the purpose of using them in the organization. Before heading towards the actual concept, we would like to give a quick introduction to the SAP PM module;

Introduction to the SAP PM module:

SAP PM (plant maintenance) is also an important functional module that helps the organization to maintain its business activities. With the help of the SAP PM module, ERP-based organizations can manage the equipment and also enable them to manage the production planning effectively.

If you want to enrich your career and become a professional in SAP PM, then enroll in "SAP PM Training"

SAP PM table types:

In general, tables are nothing but a structure where we can store, and retrieve the data.

SAP PM (plant maintenance) tables can be classified according to the business objects.

SAP PM Tables:

The list of SAP PM tables are as follows;

  • Equipment tables
  • Functional locations
  • Tables for serial numbers
  • Measurement documents
  • Tables for maintenance notification
  • Service notification PM tables
  • Tables for maintenance
  • Service orders tables in PM
  • Task lists tables
  • Maintenance plans tables

Let me explain them one by one ;

Equipment tables:

The equipment is an individual business object that should be maintained independently using tables.

Note: Equipment tables can be installed in a technical system as a part of the technical object in the PM module.

Tables lists and their description:

EQUI -> This table describes the equipment master data.
EQKT -> this table describes the multilingual equipment, short texts, and internal remarks.
EQUZ -> it defines the equipment time segments
ILOA -> Location and account assignment details for the maintenance objects.
IHSG -> it defines the table of permits for the plant maintenance along with long texts.
IHPA -> it defines the partner details.
FLEET -> Fleet object-specific data for technical objects.

Service order tables in PM:

To manage various service order tables in the PM module, follow the below table lists;

AFIH -> it defines order header
AFAB -> It defines network relationship
AFPO -> order details
AFFH -> this table defines the PRT assignment data for the work order.
AFFT -> order process instructions
AFFV -> order process instruction values
AFKO -> order header data pp orders
IHPA -> this table defines the partners
PMCO -> it defines the cost structures and overview of the order.
MCIPMIS -> order data for PMIS .
PMCOQT -> this table defines quantity structures for the maintenance order.
PMPL -> print data for the order.
PMSDO -> PM organizational data for the sales and distribution documents.

Check out SAP PM Tutorial

SAP PM Training

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning

SAP PM functional location tables:

As we know, functional locations are also known as “organizational units” within data logistics and also structure the business maintenance objects of the organizations based on the functional, process-related, or special criteria.

Note: A functional location represents the place where the maintenance tasks can be performed.

The following are the lists of functional locations:

  • IFLOT -> this table defines the functional location master data.
  • IFLOS -> it defines the functional location labeling
  • IFLOTX -> it defines the multilingual short texts and long texts for the functional location.
  • ILOA -> location and account assignments for the maintenance objects.
  • IHPA -> it defines the partner details
  • IHSG -> table of permits for plant maintenance with long texts.

SAP PM Tables for serial numbers:

The serial number in the PM table defines how to generate the ID for the different PM functional objects.

The list of tables and their description:

  • OBJK -> it defines the object lists for plant maintenance.
  • SER01 -> document headers serial number for the delivery.
  • SER02 -> document headers for serial numbers for contact maintenance.
  • SER03 -> header document for the serial numbers for the delivery.
  • SER04 -> this table defines the document header for the serial numbers for the inspection lot.
  • SER05 -> document header for the serial numbers for the PP order.
  • SER06 -> this table defines the number document for the serial numbers for handling the unit contents.
  • SER07 -> document header for the serial number in physical inventory.

[Related Article: SAP PM Module]

SAP PM measurement documents:

The data has to be transferred to the system once the measurement has to be taken at a measuring point or a counter in the SAP R/3 system.
This type of data transfer can be done automatically or manually. You can also consider measuring documents or counter-reading documents being readable in the system.

The following table lists;

  • CDHDR -> this table defines the change document header.
  • CDPOS -> Change the document item.
  • IMRG -> this table describes the measurement documents.
  • THEAD -> it defines the long text.

Maintenance notification tables in SAP PM:

The purpose of the maintenance notification table is to process the events or malfunction situations in the system.

Mainly there are three activities taking place;

  • Describes the exceptional/error conditions of technical objects.
  • Request the maintenance department to perform necessary tasks.
  • Document work that needs to be performed.

The following are the important table lists;

  • QMEL -> this table defines the notification header data.
  • QMFE -> it describes the item lists.
  • QMMA -> it defines the activities.
  • QMSM -> task objects
  • QMUR -> causes.
  • QMIH -> this table defines the maintenance data.

IHPA -> partners
PMLP -> print log
KSSK -> classification
JEST -> status
JESTO -> object status
SWW_ CONTOB -> workflow/ worklog
THEAD -> this table defines the long text.

Read these Latest SAP PM Interview Questions Experienced that helps you grab the high-paying job

Subscribe to our youtube channel to get new updates..!

SAP PM tables for the maintenance notification:

The commonly used SAP PM maintenance notification tables are as follows;
QMEL -> this table defines the notification header data.
QMFE -> it defines the items
QMMA -> this table defines the activities.
QMSM -> it defines tasks.
QMUR -> causes
QMIH -> it describes the maintenance data.
ILOA -> it defines the location data
IHPA -> this table defines the partner functions.
PMLP -> print logs details.

SAP PM task lists table:

The commonly used SAP PM tasks lists are as follows;
PLKO -> this table defines the task list header.
PLKZ -> it defines time-independent header data.
MAPL -> this table defines material task list assignments.
KALC -> formulas for material quantity calculations.
KALT -> text for the formulas.
EAPL -> it defines the equipment assignments.
TAPL -> Assignment of functional locations.

SAP PM task list sequence tables:

The following are the major tables list;
PLPO -> operations
PLAS -> Assignment of operations to the sequences.
PLMZ -> material component assignment.
PLWP -> maintenance of package management.
PLFH -> production resources / tools assignments
PLMK -> Inspection plan characteristics.
PLMW -> inspection plan characteristic values.
PLAB -> Task list relationships.
PLTX -> PMS texts.
PLPH -> phases and partial operations for CAP.
PLFT -> process instructions.
PLFV -> process instructions characteristics and partial operation parameters.
MLST ->: milestones
EINA -> Purchasing info record of general data.
EINE -> Purchasing info order details.
ESLL -’> this table describes the lines for the service package.
ESLH -> service package header data.

[Related Article: SAP PM Certification]

SAP PM Training

Weekday / Weekend Batches

SAP PM maintenance plan tables:

The below is the list of SAP PM maintenance plan tables;

MPLA -> Maintenance plan
MMPT -> Cycle definition and maintenance points for the PM.
MHIS -> Maintenance plan calls.
MHIO -> Call objects and call object history.
ONR00 -> object number.
MPOS -> Maintenance objects.
ILOA -> location and accounts assigned to the objects.
OBJK -> Object list for the plant maintenance.

Final words:

This SAP PM tables article is the best example for the core concepts terminologies. When it comes to professional growth, it is important to have hands-on project implementation experience, for that it requires a lot of reading, and concepts understanding. We hope that our articles fulfill our readers' dreams and requirements. Stay tuned to our website for more tech-related articles.

Related Articles:

Find our upcoming SAP PM Training Online Classes

  • Batch starts on 2nd Jun 2023, Fast Track batch

  • Batch starts on 6th Jun 2023, Weekday batch

  • Batch starts on 10th Jun 2023, Weekend batch

Global Promotional Image


Request for more information

Kavya Gowda
Kavya Gowda
Research Analyst
Kavya works for HKR Trainings institute as a technical writer with diverse experience in many kinds of technology-related content development. She holds a graduate education in the Computer science and Engineering stream. She has cultivated strong technical skills from reading tech blogs and also doing a lot of research related to content. She manages to write great content in many fields like Programming & Frameworks, Enterprise Integration, Web Development, SAP, and Business Process Management (BPM). Connect her on LinkedIn and Twitter.