SAP table reference
MPLA
Maintenance planExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table MPLA.
SAP table MPLA has 2 primary key fields: MANDT,WARPL.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
MPLA fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||
| Key WARPL | 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 relationships.
| 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 |