SAP Table
MPLA Maintenance plan
SAP table MPLA has 2 primary key fields being MANDT,WARPL.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
MPLA columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||
| KeyWARPL | Maintenance Plan | CHAR | 12 | 0 | WARPL | ||||||||||||
| ERKNZ | Creation Indicator | CHAR | 1 | 0 | ERKNZ | ||||||||||||
| AEKNZ | Change indicator | CHAR | 1 | 0 | AEKNZ | ||||||||||||
| ERSDT | Date of creation | DATS | 8 | 0 | EDATUM | ||||||||||||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||||||||||||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||||||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||||||||||||
| WPTXT | Maintenance Plan Text | CHAR | 40 | 0 | WPTXT | ||||||||||||
| STRAT | Maintenance Strategy | CHAR | 6 | 0 | T351 | STRAT | |||||||||||
| ABRHO | Scheduling Period | NUMC | 3 | 0 | ABRHO | ||||||||||||
| EQUNR | Equipment Number | CHAR | 18 | 0 | EQUNR | ||||||||||||
| TPLNR | Functional Location | CHAR | 30 | 0 | TPLNR | ||||||||||||
| KUNUM | Customer Number | CHAR | 10 | 0 | KUNUM | ||||||||||||
| LTKNZ | Long Text Indicator | CHAR | 1 | 0 | MPLTX | ||||||||||||
| LVORM | Indicator: maintenance plan locked against calls | CHAR | 1 | 0 | ABSTOP | ||||||||||||
| ANZPS | Number of maintenance items in the maintenance plan | NUMC | 4 | 0 | ANZMPOS | ||||||||||||
| ABNUM | Maintenance Plan Call Number | INT4 | 10 | 0 | ABNUM | ||||||||||||
| LANGU | Language key of the long text | LANG | 1 | 0 | MPLANGU | ||||||||||||
| VSPOS | Shift Factor for Late Completion | NUMC | 3 | 0 | VERSCHPLUS | ||||||||||||
| VSNEG | Shift Factor for Early Completion | NUMC | 3 | 0 | VERSCHNEG | ||||||||||||
| TOPOS | Tolerance for Late Completion (%) | NUMC | 3 | 0 | TOLERPLUS | ||||||||||||
| TONEG | Tolerance for Early Completion (%) | NUMC | 3 | 0 | TOLERNEG | ||||||||||||
| SFAKT | Cycle modification factor | DEC | 3 | 2 | SFAKT | ||||||||||||
| STICH | Scheduling indicator | CHAR | 1 | 0 | TERMKNZ | ||||||||||||
|
|||||||||||||||||
| TGOON | Scheduling to reoccur when lead float reached | NUMC | 3 | 0 | TGON | ||||||||||||
| HORIZ | Call horizon for maintenance plan calls | NUMC | 3 | 0 | HORIZONT | ||||||||||||
| HORIZ_DAYS | Call horizon for maintenance plan calls | NUMC | 3 | 0 | HORIZONT | ||||||||||||
| HORIZ_QUALIFIER | Calculation Type of Call Horizon | CHAR | 1 | 0 | EAM_CC_CALLHORIZON_QUALIFIER | ||||||||||||
|
|||||||||||||||||
| ANDOR | Indicator for OR or AND link | CHAR | 1 | 0 | ANDOR | ||||||||||||
| KNAUT | Reserved | CHAR | 1 | 0 | KNZABR | ||||||||||||
| BEGRU | Technical Object Authorization Group | CHAR | 4 | 0 | T370B | IAUTG | |||||||||||
| OBJNR | Object number | CHAR | 22 | 0 | J_OBJNR | ||||||||||||
| MPTYP | Maintenance plan category | CHAR | 2 | 0 | T399W | MPTYP | |||||||||||
| HUNIT | Unit for Scheduling Period | UNIT | 3 | 0 | HUNIT | ||||||||||||
| STADT | Start date | DATS | 8 | 0 | STADT | ||||||||||||
| SZAEH | Start counter reading | CHAR | 22 | 0 | SZAEHC | ||||||||||||
| CALL_CONFIRM | Only Create New Call Object After Completing Predecessor | CHAR | 1 | 0 | CALL_CONFIRM | ||||||||||||
| PLAN_SORT | Sort field for maintenance plans | CHAR | 20 | 0 | T399G | PLAN_SORT | |||||||||||
| FABKL | Factory calendar key | CHAR | 2 | 0 | TFACD | FABKL | |||||||||||
| PUFFP | Lead Float in Days | NUMC | 3 | 0 | PUFF_VORL | ||||||||||||
| PUFFN | Follow-up float in days | NUMC | 3 | 0 | PUFF_NACHL | ||||||||||||
| DUMMY_MPLA_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY | ||||||||||||
| START_DATE | Start Date for Scheduling | DATS | 8 | 0 | DATE_START | ||||||||||||
| START_TIME | Start Time for Scheduling | TIMS | 6 | 0 | TIME_START | ||||||||||||
| CALL_UPDATE_IND | Indicator for Adapting Basic Dates of Call Object | CHAR | 1 | 0 | IND_CALL_UPDATE | ||||||||||||
| IND_MPLA_API | Maintenance Plan Was Created/Changed by API | CHAR | 2 | 0 | IND_MPLA_API | ||||||||||||
| MCP_SF | Shift Factor for Multiple Counter Plan | CHAR | 1 | 0 | MCP_SF | ||||||||||||
|
|||||||||||||||||
| ENDDT_FOR_SCHED | End Date for Scheduling | DATS | 8 | 0 | EAM_ENDDT_FOR_SCHED | ||||||||||||
| END_COUNTER | End Counter for Scheduling | CHAR | 22 | 0 | EAM_END_COUNTER | ||||||||||||
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TZNTSTMPS | ||||||||||||
/ Relationships
MPLA foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| MPLA | BEGRU | T370B | Technical object authorization group | MANDT |
| MPLA | BEGRU | T370B | Technical object authorization group | BEGRU |
| MPLA | MANDT | T000 | Clients | MANDT |
| MPLA | MPTYP | T399W | Maintenance Plan Category Parameter | MANDT |
| MPLA | MPTYP | T399W | Maintenance Plan Category Parameter | MPTYP |
| MPLA | PLAN_SORT | T399G | Maintenance Plan Sort Field | MANDT |
| MPLA | PLAN_SORT | T399G | Maintenance Plan Sort Field | PLAN_SORT |
| MPLA | STRAT | T351 | Maintenance strategy | MANDT |