MPLA SAP (Maintenance plan) Table details
Dictionary Type: Table
Description: Maintenance plan
Description: Maintenance plan
Table field list including key, data, relationships and ABAP select examples
MPLA is a standard SAP Table which is used to store Maintenance plan data and is available within R/3 SAP systems depending on the version and release level.
The MPLA table consists of various fields, each holding specific information or linking keys about Maintenance plan data available in SAP. These include WARPL (Maintenance Plan), ERKNZ (Creation indicator), AEKNZ (Change indicator), ERSDT (Date of creation).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MPLA table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| WARPL | Maintenance Plan | WARPL | CHAR | 12 | ALPHA | WARPL | MPL | MPLAL | |
| ERKNZ | Creation indicator | ERKNZ | CHAR | 1 | FLAG | ||||
| AEKNZ | Change indicator | AEKNZ | CHAR | 1 | FLAG | ||||
| ERSDT | Date of creation | EDATUM | DATS | 8 | DATUM | ||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
| WPTXT | Maintenance Plan Text | WPTXT | CHAR | 40 | TEXT40 | ||||
| STRAT | Maintenance strategy | STRAT | CHAR | 6 | T351 | WSTRA | STR | STRAA | |
| ABRHO | Scheduling Period | ABRHO | NUMC | 3 | ANZTA | ||||
| EQUNR | Equipment Number | EQUNR | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | EQN | EQUI |
| TPLNR | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
| KUNUM | Customer Number | KUNUM | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | |
| LTKNZ | Long Text Indicator | MPLTX | CHAR | 1 | XFELD | ||||
| LVORM | Indicator: maintenance plan locked against calls | ABSTOP | CHAR | 1 | XFELD | ||||
| ANZPS | Number of maintenance items in the maintenance plan | ANZMPOS | NUMC | 4 | WPPOS | ||||
| ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | ABNUM | ||||
| LANGU | Language key of the long text | MPLANGU | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
| VSPOS | Shift Factor for Late Completion | VERSCHPLUS | NUMC | 3 | NUM3 | ||||
| VSNEG | Shift Factor for Early Completion | VERSCHNEG | NUMC | 3 | NUM3 | ||||
| TOPOS | Tolerance for Late Completion (%) | TOLERPLUS | NUMC | 3 | NUM3 | ||||
| TONEG | Tolerance for Early Completion (%) | TOLERNEG | NUMC | 3 | NUM3 | ||||
| SFAKT | Cycle modification factor | SFAKT | DEC | 3(2) | SFAKT | ||||
| STICH | Scheduling indicator | TERMKNZ | CHAR | 1 | TERMKNZ | ||||
| TGOON | Scheduling to reoccur when lead float reached | TGON | NUMC | 3 | NUM3 | ||||
| HORIZ | Call horizon for maintenance plan calls | HORIZONT | NUMC | 3 | NUM3 | ||||
| HORIZ_DAYS | Call horizon for maintenance plan calls | HORIZONT | NUMC | 3 | NUM3 | ||||
| HORIZ_QUALIFIER | Calculation Type of Call Horizon | EAM_CC_CALLHORIZON_QUALIFIER | CHAR | 1 | EAMQF | EAM_CC_CALLHORIZON_QUALIFIER | |||
| ANDOR | Indicator for OR or AND link | ANDOR | CHAR | 1 | RADIO | ||||
| KNAUT | Reserved | KNZABR | CHAR | 1 | FLAG | ||||
| BEGRU | Technical object authorization group | IAUTG | CHAR | 4 | T370B | IAUTG | |||
| OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
| MPTYP | Maintenance plan category | MPTYP | CHAR | 2 | T399W | MPTYP | WAT | ||
| HUNIT | Unit in scheduling interval | HUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| STADT | Start date | STADT | DATS | 8 | DATUM | ||||
| SZAEH | Start counter reading | SZAEHC | CHAR | 22 | WZYKL | ||||
| CALL_CONFIRM | Only Create New Call Object After Completing Predecessor | CALL_CONFIRM | CHAR | 1 | CHAR1 | ||||
| PLAN_SORT | Sort field for maintenance plans | PLAN_SORT | CHAR | 20 | T399G | CHAR20 | |||
| FABKL | Factory calendar key | FABKL | CHAR | 2 | TFACD | WFCID | |||
| PUFFP | Lead Float in Days | PUFF_VORL | NUMC | 3 | NUM3 | ||||
| PUFFN | Follow-up float in days | PUFF_NACHL | NUMC | 3 | NUM3 | ||||
| .INCLU--AP | 0 | ||||||||
| START_DATE | Start Date for Scheduling | DATE_START | DATS | 8 | DATUM | ||||
| START_TIME | Start Time for Scheduling | TIME_START | TIMS | 6 | TIME | ||||
| CALL_UPDATE_IND | Indicator for Adapting Basic Dates of Call Object | IND_CALL_UPDATE | CHAR | 1 | XFELD | ||||
| IND_MPLA_API | Maintenance Plan Was Created/Changed by API | IND_MPLA_API | CHAR | 2 | IND_API | ||||
| MCP_SF | Shift Factor for Multiple Counter Plan | MCP_SF | CHAR | 1 | MCP_SF |
| Key field | Non-key field |
How do I retrieve data from SAP table MPLA using ABAP code
The following ABAP code Example will allow you to do a basic selection on MPLA to SELECT all data from the tableDATA: WA_MPLA TYPE MPLA.
SELECT SINGLE *
FROM MPLA
INTO CORRESPONDING FIELDS OF WA_MPLA
WHERE...
How to access SAP table MPLA
Within an ECC or HANA version of SAP you can also view further information about MPLA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects