MPOS SAP table for – Maintenance item

Here we would like to draw your attention to MPOS table in SAP. As we know it is being mainly used with the SAP PM-PRM (Preventive Maintenance in PM) component which is coming under PM module (Plant Maintenance). MPOS is a SAP standard transparent table used for storing Maintenance item related data in SAP. It comes under the package IPRM.

SAP MPOS table

Table MPOS technical data

TableMPOS
Data storingMaintenance item
ModulePM
ComponentPM-PRM
SAP PackageIPRM
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MPOS Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in MPOS table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PLNTY : Task List Type
    Its data type is C (Character String) with field length 1
  • PLNAL : Group Counter
    Its data type is C (Character String) with field length 2
  • LTKNZ
    Its data type is C (Character String) with field length 1
  • OBJTY : Object types of the CIM resource
    Its data type is C (Character String) with field length 2
  • IWERK : Maintenance Planning Plant
    Its data type is C (Character String) with field length 4
  • ILOAN : Location and account assignment for technical object
    Its data type is C (Character String) with field length 12
  • LAUFN : Order number
    Its data type is C (Character String) with field length 12
  • WARPL : Maintenance Plan
    Its data type is C (Character String) with field length 12
  • AUART : Order Type
    Its data type is C (Character String) with field length 4
  • ILART : Maintenance activity type
    Its data type is C (Character String) with field length 3
  • IND_ABRVO
    Its data type is C (Character String) with field length 1
  • STD_NETZ
    Its data type is C (Character String) with field length 8
  • KDAUF : Sales Order Number
    Its data type is C (Character String) with field length 10
  • MITYP
    Its data type is C (Character String) with field length 2
  • BSTPO
    Its data type is N (Character String with Digits Only) with field length 5
  • PACKNO : Package number
    Its data type is N (Character String with Digits Only) with field length 10
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • WPPOS
    Its data type is N (Character String with Digits Only) with field length 4
  • SCRRENTY
    Its data type is C (Character String) with field length 4
  • SERMAT : Material Number
    Its data type is C (Character String) with field length 18
  • QMNUM : Message Number
    Its data type is C (Character String) with field length 12
  • LBLNI
    Its data type is C (Character String) with field length 10
  • PRIOK : Priority
    Its data type is C (Character String) with field length 1
  • QMGRP
    Its data type is C (Character String) with field length 8
  • QMCOD
    Its data type is C (Character String) with field length 4
  • ART
    Its data type is C (Character String) with field length 8
  • TSTMP_BW
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is /CUM/APP_MPOS
  • EQUNR : Equipment Number
    Its data type is C (Character String) with field length 18
  • ADPSP : Reference Element PM/PS
    Its data type is C (Character String) with field length 40
  • ERKNZ
    Its data type is C (Character String) with field length 1