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
MANDT Client MANDT T000 CLNT 3 0
WARPL Maintenance Plan WARPL CHAR 12 0
ERKNZ Creation indicator ERKNZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
AEKNZ Change indicator AEKNZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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
X Yes
NULL No
LVORM Indicator: maintenance plan locked against calls ABSTOP CHAR 1 0
X Yes
NULL No
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
NULL Time
1 Time - key date
2 Time - factory calendar
3 Performance-based
4 Multiple counter
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
NULL Percent
1 Calendar Days
2 Working Days (Factory Calendar Days)
ANDOR Indicator for OR or AND link ANDOR CHAR 1 0
X Choose alternative
. Do not choose alternative
KNAUT Reserved KNZABR CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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
X Yes
NULL No
IND_MPLA_API Maintenance Plan Was Created/Changed by API IND_MPLA_API CHAR 2 0
C Business Object Was Created by API (Created)
U Business Object Was Changed by API (Update)
CU Business Object Was Created/Changed by API
MCP_SF Shift Factor for Multiple Counter Plan MCP_SF CHAR 1 0
N New Multiple Counter Plan ( Release >= ERP2005, EHP5)
O Old MCP (Rel <ERP2005, EHP5, Converted to New Function)
NULL Old MCP (Rel <ERP2005, EHP5, Not Converted to New Function)

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 MANDT T399G Maintenance Plan Sort Field MANDT
MPLA PLAN_SORT MPLA PLAN_SORT T399G Maintenance Plan Sort Field PLAN_SORT
MPLA STRAT MPLA STRAT T351 Maintenance strategy STRAT
MPLA STRAT MPLA MANDT T351 Maintenance strategy MANDT