SAP MPLA Table in S/4 HANA - Maintenance plan
MPLA is a standard SAP Table which is used to store Maintenance plan data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MPLA table(ECC)
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: MPLA
MPLA table structure field list
Below is the full MPLA field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| WARPL | Maintenance Plan | WARPL | CHAR | 12(0) | ALPHA | WARPL | MPL | MPLAL | WARPL | |
| ERKNZ | Creation Indicator | ERKNZ | CHAR | 1(0) | FLAG | |||||
| AEKNZ | Change indicator | AEKNZ | CHAR | 1(0) | FLAG | |||||
| ERSDT | Date of creation | EDATUM | DATS | 8(0) | DATUM | |||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
| AEDAT | Date of Last Change | AEDAT | DATS | 8(0) | DATUM | |||||
| AENAM | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
| WPTXT | Maintenance Plan Text | WPTXT | CHAR | 40(0) | TEXT40 | |||||
| STRAT | Maintenance Strategy | STRAT | CHAR | 6(0) | T351 | WSTRA | STR | STRAA | STRAT | |
| ABRHO | Scheduling Period | ABRHO | NUMC | 3(0) | ANZTA | |||||
| EQUNR | Equipment Number | EQUNR | CHAR | 18(0) | ALPHA | EQUNR | EQN | EQUI | EQUNR | |
| TPLNR | Functional Location | TPLNR | CHAR | 30(0) | TPLNR | TPLNR | IFL | IFLM | TPLNR | |
| KUNUM | Customer Number | KUNUM | CHAR | 10(0) | ALPHA | KUNNR | KUN | |||
| LTKNZ | Long Text Indicator | MPLTX | CHAR | 1(0) | XFELD | |||||
| LVORM | Indicator: maintenance plan locked against calls | ABSTOP | CHAR | 1(0) | XFELD | |||||
| ANZPS | Number of maintenance items in the maintenance plan | ANZMPOS | NUMC | 4(0) | WPPOS | |||||
| ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10(0) | ABNUM | |||||
| LANGU | Language key of the long text | MPLANGU | LANG | 1(0) | ISOLA | SPRAS | ||||
| VSPOS | Shift Factor for Late Completion | VERSCHPLUS | NUMC | 3(0) | NUM3 | |||||
| VSNEG | Shift Factor for Early Completion | VERSCHNEG | NUMC | 3(0) | NUM3 | |||||
| TOPOS | Tolerance for Late Completion (%) | TOLERPLUS | NUMC | 3(0) | NUM3 | |||||
| TONEG | Tolerance for Early Completion (%) | TOLERNEG | NUMC | 3(0) | NUM3 | |||||
| SFAKT | Cycle modification factor | SFAKT | DEC | 3(2) | SFAKT | |||||
| STICH | Scheduling indicator | TERMKNZ | CHAR | 1(0) | TERMKNZ | |||||
| TGOON | Scheduling to reoccur when lead float reached | TGON | NUMC | 3(0) | NUM3 | |||||
| HORIZ | Call horizon for maintenance plan calls | HORIZONT | NUMC | 3(0) | NUM3 | |||||
| HORIZ_DAYS | Call horizon for maintenance plan calls | HORIZONT | NUMC | 3(0) | NUM3 | |||||
| HORIZ_QUALIFIER | Calculation Type of Call Horizon | EAM_CC_CALLHORIZON_QUALIFIER | CHAR | 1(0) | EAMQF | EAM_CC_CALLHORIZON_QUALIFIER | ||||
| ANDOR | Indicator for OR or AND link | ANDOR | CHAR | 1(0) | RADIO | |||||
| KNAUT | Reserved | KNZABR | CHAR | 1(0) | FLAG | |||||
| BEGRU | Technical object authorization group | IAUTG | CHAR | 4(0) | T370B | IAUTG | ||||
| OBJNR | Object number | J_OBJNR | CHAR | 22(0) | J_OBJNR | ONR | ||||
| MPTYP | Maintenance plan category | MPTYP | CHAR | 2(0) | T399W | MPTYP | WAT | |||
| HUNIT | Unit for Scheduling Period | HUNIT | UNIT | 3(0) | CUNIT | MEINS | ||||
| STADT | Start date | STADT | DATS | 8(0) | DATUM | |||||
| SZAEH | Start counter reading | SZAEHC | CHAR | 22(0) | WZYKL | |||||
| CALL_CONFIRM | Only Create New Call Object After Completing Predecessor | CALL_CONFIRM | CHAR | 1(0) | CHAR1 | |||||
| PLAN_SORT | Sort field for maintenance plans | PLAN_SORT | CHAR | 20(0) | T399G | CHAR20 | ||||
| FABKL | Factory calendar key | FABKL | CHAR | 2(0) | TFACD | WFCID | ||||
| PUFFP | Lead Float in Days | PUFF_VORL | NUMC | 3(0) | NUM3 | |||||
| PUFFN | Follow-up float in days | PUFF_NACHL | NUMC | 3(0) | NUM3 | |||||
| .INCLU--AP | 0(0) | |||||||||
| START_DATE | Start Date for Scheduling | DATE_START | DATS | 8(0) | DATUM | |||||
| START_TIME | Start Time for Scheduling | TIME_START | TIMS | 6(0) | TIME | |||||
| CALL_UPDATE_IND | Indicator for Adapting Basic Dates of Call Object | IND_CALL_UPDATE | CHAR | 1(0) | XFELD | |||||
| IND_MPLA_API | Maintenance Plan Was Created/Changed by API | IND_MPLA_API | CHAR | 2(0) | IND_API | |||||
| MCP_SF | Shift Factor for Multiple Counter Plan | MCP_SF | CHAR | 1(0) | MCP_SF | |||||
| .INCLU--AP | 0(0) | |||||||||
| ENDDT_FOR_SCHED | End Date for Scheduling | EAM_ENDDT_FOR_SCHED | DATS | 8(0) | DATUM | |||||
| END_COUNTER | End Counter for Scheduling | EAM_END_COUNTER | CHAR | 22(0) | WZYKL | |||||
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15(0) | TZNTSTMPS |
Search for further information about these or an SAP related objects