SAP Table MPLA
Maintenance plan
MPLA (Maintenance plan) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MPLA to other SAP tables.
MPLA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
WARPL
Maintenance Plan
|
WARPL |
CHAR
|
12 | 0 | ||||||||||||||
|
ERKNZ
Creation indicator
|
ERKNZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
AEKNZ
Change indicator
|
AEKNZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ERSDT
Date of creation
|
EDATUM |
DATS
|
8 | 0 | ||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||||
|
WPTXT
Maintenance Plan Text
|
WPTXT |
CHAR
|
40 | 0 | ||||||||||||||
|
STRAT
Maintenance strategy
|
STRAT | T351 |
CHAR
|
6 | 0 | |||||||||||||
|
ABRHO
Scheduling Period
|
ABRHO |
NUMC
|
3 | 0 | ||||||||||||||
|
EQUNR
Equipment Number
|
EQUNR |
CHAR
|
18 | 0 | ||||||||||||||
|
TPLNR
Functional Location
|
TPLNR |
CHAR
|
30 | 0 | ||||||||||||||
|
KUNUM
Customer Number
|
KUNUM |
CHAR
|
10 | 0 | ||||||||||||||
|
LTKNZ
Long Text Indicator
|
MPLTX |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LVORM
Indicator: maintenance plan locked against calls
|
ABSTOP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ANZPS
Number of maintenance items in the maintenance plan
|
ANZMPOS |
NUMC
|
4 | 0 | ||||||||||||||
|
ABNUM
Maintenance Plan Call Number
|
ABNUM |
INT4
|
10 | 0 | ||||||||||||||
|
LANGU
Language key of the long text
|
MPLANGU |
LANG
|
1 | 0 | ||||||||||||||
|
VSPOS
Shift Factor for Late Completion
|
VERSCHPLUS |
NUMC
|
3 | 0 | ||||||||||||||
|
VSNEG
Shift Factor for Early Completion
|
VERSCHNEG |
NUMC
|
3 | 0 | ||||||||||||||
|
TOPOS
Tolerance for Late Completion (%)
|
TOLERPLUS |
NUMC
|
3 | 0 | ||||||||||||||
|
TONEG
Tolerance for Early Completion (%)
|
TOLERNEG |
NUMC
|
3 | 0 | ||||||||||||||
|
SFAKT
Cycle modification factor
|
SFAKT |
DEC
|
3 | 2 | ||||||||||||||
|
STICH
Scheduling indicator
|
TERMKNZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TGOON
Scheduling to reoccur when lead float reached
|
TGON |
NUMC
|
3 | 0 | ||||||||||||||
|
HORIZ
Call horizon for maintenance plan calls
|
HORIZONT |
NUMC
|
3 | 0 | ||||||||||||||
|
HORIZ_DAYS
Call horizon for maintenance plan calls
|
HORIZONT |
NUMC
|
3 | 0 | ||||||||||||||
|
HORIZ_QUALIFIER
Calculation Type of Call Horizon
|
EAM_CC_CALLHORIZON_QUALIFIER |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ANDOR
Indicator for OR or AND link
|
ANDOR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KNAUT
Reserved
|
KNZABR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BEGRU
Technical object authorization group
|
IAUTG | T370B |
CHAR
|
4 | 0 | |||||||||||||
|
OBJNR
Object number
|
J_OBJNR |
CHAR
|
22 | 0 | ||||||||||||||
|
MPTYP
Maintenance plan category
|
MPTYP | T399W |
CHAR
|
2 | 0 | |||||||||||||
|
HUNIT
Unit in scheduling interval
|
HUNIT |
UNIT
|
3 | 0 | ||||||||||||||
|
STADT
Start date
|
STADT |
DATS
|
8 | 0 | ||||||||||||||
|
SZAEH
Start counter reading
|
SZAEHC |
CHAR
|
22 | 0 | ||||||||||||||
|
CALL_CONFIRM
Only Create New Call Object After Completing Predecessor
|
CALL_CONFIRM |
CHAR
|
1 | 0 | ||||||||||||||
|
PLAN_SORT
Sort field for maintenance plans
|
PLAN_SORT | T399G |
CHAR
|
20 | 0 | |||||||||||||
|
FABKL
Factory calendar key
|
FABKL | TFACD |
CHAR
|
2 | 0 | |||||||||||||
|
PUFFP
Lead Float in Days
|
PUFF_VORL |
NUMC
|
3 | 0 | ||||||||||||||
|
PUFFN
Follow-up float in days
|
PUFF_NACHL |
NUMC
|
3 | 0 | ||||||||||||||
|
START_DATE
Start Date for Scheduling
|
DATE_START |
DATS
|
8 | 0 | ||||||||||||||
|
START_TIME
Start Time for Scheduling
|
TIME_START |
TIMS
|
6 | 0 | ||||||||||||||
|
CALL_UPDATE_IND
Indicator for Adapting Basic Dates of Call Object
|
IND_CALL_UPDATE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
IND_MPLA_API
Maintenance Plan Was Created/Changed by API
|
IND_MPLA_API |
CHAR
|
2 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MCP_SF
Shift Factor for Multiple Counter Plan
|
MCP_SF |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
MPLA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MPLA | BEGRU | MPLA | MANDT |
T370B
Technical object authorization group
|
MANDT |
| MPLA | BEGRU | MPLA | BEGRU |
T370B
Technical object authorization group
|
BEGRU |
| MPLA | FABKL | MPLA | FABKL |
TFACD
Factory calendar definition
|
IDENT |
| MPLA | MANDT | MPLA | MANDT |
T000
Clients
|
MANDT |
| MPLA | MPTYP | MPLA | MANDT |
T399W
Maintenance Plan Category Parameter
|
MANDT |
| MPLA | MPTYP | MPLA | MPTYP |
T399W
Maintenance Plan Category Parameter
|
MPTYP |
| MPLA | PLAN_SORT | MPLA | PLAN_SORT |
T399G
Maintenance Plan Sort Field
|
PLAN_SORT |
| MPLA | PLAN_SORT | MPLA | MANDT |
T399G
Maintenance Plan Sort Field
|
MANDT |
| MPLA | STRAT | MPLA | MANDT |
T351
Maintenance strategy
|
MANDT |
| MPLA | STRAT | MPLA | STRAT |
T351
Maintenance strategy
|
STRAT |