SAP table MPLA (Maintenance plan)

SAP table MPLA has 2 primary key fields being MANDT,WARPL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
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
Time
1 Time - key date
2 Time - factory calendar
3 Performance-based
4 Multiple counter
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
Percent
1 Calendar Days
2 Working Days (Factory Calendar Days)
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
Old MCP (Rel <ERP2005, EHP5, Not Converted to New Function)
N New Multiple Counter Plan ( Release >= ERP2005, EHP5)
O Old MCP (Rel <ERP2005, EHP5, Converted to New Function)
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

MPLA foreign key relationships

Table Field Check Table Check Field
0 MPLA BEGRU T370B Technical object authorization group MANDT
0 MPLA BEGRU T370B Technical object authorization group BEGRU
1 MPLA MANDT T000 Clients MANDT
0 MPLA MPTYP T399W Maintenance Plan Category Parameter MANDT
0 MPLA MPTYP T399W Maintenance Plan Category Parameter MPTYP
1 MPLA PLAN_SORT T399G Maintenance Plan Sort Field MANDT
1 MPLA PLAN_SORT T399G Maintenance Plan Sort Field PLAN_SORT
0 MPLA STRAT T351 Maintenance strategy MANDT