MPLA SAP table for – Maintenance plan

Here we would like to draw your attention to MPLA 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). MPLA is a SAP standard transparent table used for storing Maintenance plan related data in SAP. It comes under the package IPRM.

SAP MPLA table

Table MPLA technical data

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

SAP MPLA 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 MPLA table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • ABRHO
    Its data type is N (Character String with Digits Only) with field length 3
  • TPLNR : Flight Scheduling: Actual Aircraft Registration
    Its data type is C (Character String) with field length 30
  • LTKNZ
    Its data type is C (Character String) with field length 1
  • ANZPS
    Its data type is N (Character String with Digits Only) with field length 4
  • LANGU : Language ID
    Its data type is C (Character String) with field length 1
  • VSNEG
    Its data type is N (Character String with Digits Only) with field length 3
  • TONEG
    Its data type is N (Character String with Digits Only) with field length 3
  • STICH
    Its data type is C (Character String) with field length 1
  • HORIZ
    Its data type is N (Character String with Digits Only) with field length 3
  • HORIZ_QUALIFIER
    Its data type is C (Character String) with field length 1
  • ERKNZ
    Its data type is C (Character String) with field length 1
  • KNAUT
    Its data type is C (Character String) with field length 1
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • HUNIT
    Its data type is C (Character String) with field length 3
  • SZAEH
    Its data type is C (Character String) with field length 22
  • PLAN_SORT
    Its data type is C (Character String) with field length 20
  • PUFFP : Free float (from forecast)
    Its data type is N (Character String with Digits Only) with field length 3
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is MPLA_AS1
  • START_TIME : Time of Entry in Difference Tables for Quarterly Adjustment
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • IND_MPLA_API
    Its data type is C (Character String) with field length 2
  • ERSDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • WPTXT
    Its data type is C (Character String) with field length 40