cancel
Showing results for 
Search instead for 
Did you mean: 

Mastering SAP Tables

0 Kudos

am new in SAP and  would like to simply master SAP tables?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi David,

Please find the list of some useful SAP PM Tables:-


Equipments Tables

  • EQUI: Equipment master data
  • EQKT: Multilingual equipment short texts, long texts, and internal remarks
  • EQUZ: Equipment time segments
  • ILOA: Location and account assignment data for the maintenance object
  • IHSG: Table of permits for Plant Maintenance with long texts
  • IHPA: Partners
  • FLEET: Fleet object-specific data for technical objects

Functional Locations

  • IFLOT: Functional location master data
  • IFLOS: Functional location labeling
  • IFLOTX: Multilingual short texts and long texts for the functional location
  • ILOA: Location and account assignment data for the maintenance object
  • IHPA: Partner
  • IHSG: Table of permits for Plant Maintenance with long texts.

Tables for Serial Numbers

  • OBJK: Object list for Plant Maintenance
  • SER01: Document header for serial numbers for delivery
  • SER02: Document header for serial numbers for maintenance contract (SD order)
  • SER03: Document header for serial numbers for delivery
  • SER04: Document header for serial numbers for inspection lot
  • SER05: Document header for serial numbers for PP order
  • SER06: Document number for serial numbers for handling unit – contents
  • SER07: Document header for serial numbers in physical inventory

Measurement Document

  • CDHDR: Change document header
  • CDPOS: Change document item
  • IMRG: Measurement document
  • THEAD: Long text

Tables for Maintenance Notification

  • QMEL: Notification header data
  • QMFE: Items
  • QMMA: Activities
  • QMSM: Tasks
  • QMUR: Causes
  • QMIH: Maintenance data
  • ILOA: Location data
  • IHPA: Partners
  • PMLP: Print log
  • KSSK: Classification
  • JEST, JESTO: Status
  • SWW_CONTOB: Workflow, work item
  • THEAD: Long text

Tables for Service Notification

  • QMEL: Notification header data
  • QMFE: Items
  • QMMA: Activities
  • QMSM: Tasks
  • QMUR: Causes
  • QMIH: Maintenance data
  • ILOA: Location data
  • IHPA: Partner
  • PMLP: Print log

Tables for Maintenance and Service Orders

  • AFIH: Order header
  • AFAB: Network – Relationships
  • AFPO: Order Item
  • AFFH: PRT assignment data for the work order
  • AFFL:  Work order sequence
  • AFFT:  Order – Process Instructions
  • AFFV: Order – Process Instruction Values
  • AFKO: Order header data PP orders
  • IHPA: Partners
  • PMCO: Cost structure and overview of the order
  • MCIPMIS: Order data for PMIS
  • PMCOQT: Quantity structure for the maintenance order
  • PMPL: Print data for the order
  • PMSDO: PM organizational data for SD documents

Task Lists Tables

  • PLKO: Task list header
  • PLKZ: Time-independent header data (for example, administrative data)
  • MAPL: Material-task list assignments
  • KALC: Formulas for material quantity calculation
  • KALT: Texts for the formulas
  • EAPL: Equipment assignments
  • TAPL: Assignments of functional locations
  • PLFL: Task list sequences
  • PLPO: Operations
  • PLAS: Assignments of operations to sequences
  • PLMZ: Material component assignments
  • PLWP: Maintenance package assignments
  • PLFH: Production resources/tool 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 instruction characteristics and partial operation parameters
  • MLST: Milestones
  • EINA: Purchasing info record (general data)
  • EINE: Purchasing info record (data for purchasing organization)
  • ESLL: Lines for service package
  • ESLH: Service package header data

Maintenance Plans tables

  • MPLA: Maintenance plan
  • MMPT: Cycle definitions and measuring points for the maintenance plan
  • MHIS: Maintenance plan calls
  • MHIO: Call objects, call object history
  • ONR00: Object number
  • MPOS: Maintenance item
  • ILOA: Location and account assignment for maintenance object (PM object)
  • OBJK: Object list for Plant Maintenance

For more visit on

Useful Tables - PM Module - ERP Operations - SCN Wiki

BR

Former Member
0 Kudos

What exactly do you mean by this?