SAP table MPDPSD (MPD: MPD and MP header data)

SAP table MPDPSD has 7 primary key fields being MANDT,PLAN_DATA_ID,DOKAR,DOKNR,DOKVR,DOKTL,AENNR.

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
PLAN_DATA_ID Document Identification GUID RAW 16 0 MPD_DOCID
DOKAR Document Type CHAR 3 0 TDWA DOKAR
DOKNR Document number CHAR 25 0 DRAW DOKNR
DOKVR Document Version CHAR 2 0 DOKVR
DOKTL Document Part CHAR 3 0 DOKTL_D
AENNR Change Number CHAR 12 0 AENR AENNR
MPTYP Maintenance Plan Category CHAR 2 0 T399W MPD_MPTYP
WSET Cycle set for multiple counter plan CHAR 6 0 * WSET
WPTXT Maintenance Plan Text CHAR 40 0 WPTXT
PLAN_SORT Sort field for maintenance plans CHAR 20 0 T399G PLAN_SORT
BEGRU Technical Object Authorization Group CHAR 4 0 T370B IAUTG
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
TOSNEG 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
FABKL Factory calendar key CHAR 2 0 * FABKL
ABRHO Scheduling Period NUMC 3 0 ABRHO
HUNIT Unit for Scheduling Period UNIT 3 0 T006 HUNIT
HORIZ Horizon until which dates in billing/invoice plan are valid DATS 8 0 HORIZ
CALL_CONFIRM Only Create New Call Object After Completing Predecessor CHAR 1 0 CALL_CONFIRM
STADT Start date DATS 8 0 STADT
SZAEH Start counter reading CHAR 22 0 SZAEHC
PSTXT Item Short Text CHAR 40 0 POSTXT
IWERK Maintenance Planning Plant CHAR 4 0 T399I IWERK
WPGRP Planner Group for Customer Service and Plant Maintenance CHAR 3 0 T024I INGRP
AUFART Order Type CHAR 4 0 T003O AUFART
ILART Maintenance activity type CHAR 3 0 * ILA
GEWERK Main work center for maintenance tasks CHAR 8 0 GEWRK
WERGW Plant associated with main work center CHAR 4 0 T001W WERGW
GSBER Business Area CHAR 4 0 TGSB GSBER
PLNTY Task List Type CHAR 1 0 * PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNAL Group Counter CHAR 2 0 PLNAL
APFKT Execution factor for whole task list DEC 3 0 APFKT
QMART Notification Type CHAR 2 0 TQ80 QMART
PRIOK Priority CHAR 1 0 T356 PRIOK
TASK_DETERMINE Automatic task determination in the notification CHAR 1 0 TASK_DETERMINE
DOC_UPDT Planning and Scheduling Data Update Indicator CHAR 1 0 MPD_UPD
TLC_IND Life-Limited Component Indicator CHAR 1 0 MPD_TLC
MP_CRTD_IND Maintenance Plan Creation Indicator CHAR 1 0 MPD_CRTD_IND
COMPLIANCE_DATE Compliance Date DATS 8 0 MPD_COMPL_DATE
JOBNAME Background Job Name CHAR 32 0 BTCJOB
JOBCOUNT Job ID CHAR 8 0 BTCJOBCNT
START_DATE MPD: Default Start Date for Maintenance Plans DATS 8 0 MPD_DEFAULT_START_DATE
START_TIME MPD: Default Start Time for Maintenance Plans TIMS 6 0 MPD_DEFAULT_START_TIME
OR_KNZ Indicator for OR or AND link CHAR 1 0 ANDOR
AND_KNZ Indicator for OR or AND link CHAR 1 0 ANDOR
VORLAUF Lead Float in Days NUMC 3 0 PUFF_VORL
TOBE_UPDATED Maintenance Plan to Be Updated CHAR 1 0 TOBE_UPDATED
TOBE_RESTARTED Maintenance Plan to Be Restarted CHAR 1 0 TOBE_RESTARTED

MPDPSD foreign key relationships

Table Field Check Table Check Field
0 MPDPSD AENNR AENR Change Master AENNR
1 MPDPSD AUFART T003O Order Types AUART
0 MPDPSD BEGRU T370B Technical object authorization group MANDT
0 MPDPSD BEGRU T370B Technical object authorization group BEGRU
1 MPDPSD DOKAR TDWA Document Types MANDT
1 MPDPSD DOKAR TDWA Document Types DOKAR
0 MPDPSD DOKNR DRAW Document Info Record DOKNR
0 MPDPSD DOKNR DRAW Document Info Record DOKVR
0 MPDPSD DOKNR DRAW Document Info Record DOKTL
1 MPDPSD GSBER TGSB Business Areas MANDT
1 MPDPSD GSBER TGSB Business Areas GSBER
0 MPDPSD HUNIT T006 Units of Measurement MANDT
0 MPDPSD HUNIT T006 Units of Measurement MSEHI
1 MPDPSD IWERK T399I Planning plant parameters MANDT
0 MPDPSD MPTYP T399W Maintenance Plan Category Parameter MANDT
0 MPDPSD MPTYP T399W Maintenance Plan Category Parameter MPTYP
1 MPDPSD PLAN_SORT T399G Maintenance Plan Sort Field MANDT
1 MPDPSD PLAN_SORT T399G Maintenance Plan Sort Field PLAN_SORT
0 MPDPSD PRIOK T356 Priorities MANDT
0 MPDPSD PRIOK T356 Priorities ARTPR
1 MPDPSD QMART TQ80 Notification Types MANDT
1 MPDPSD QMART TQ80 Notification Types QMART
0 MPDPSD WERGW T001W Plants/Branches WERKS
1 MPDPSD WPGRP T024I Maintenance planner groups INGRP