SAP table MPLA_CD (Maintenance Plan (Change Documents))
SAP table MPLA_CD 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
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
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
IAUTG
OBJNR
Object number
CHAR
22
0
J_OBJNR
MPTYP
Maintenance plan category
CHAR
2
0
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