SAP Table MPDPSD
MPD: MPD and MP header data
MPDPSD (MPD: MPD and MP header data) 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 MPDPSD to other SAP tables.
Source: MPDPSD (MPD: MPD and MP header data)
MPDPSD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||||
| PLAN_DATA_ID | Document Identification GUID | MPD_DOCID | RAW | 16 | 0 | |||||||||||||
| DOKAR | Document Type | DOKAR | TDWA | CHAR | 3 | 0 | ||||||||||||
| DOKNR | Document number | DOKNR | DRAW | CHAR | 25 | 0 | ||||||||||||
| DOKVR | Document Version | DOKVR | CHAR | 2 | 0 | |||||||||||||
| DOKTL | Document Part | DOKTL_D | CHAR | 3 | 0 | |||||||||||||
| AENNR | Change Number | AENNR | AENR | CHAR | 12 | 0 | ||||||||||||
| MPTYP | Maintenance Plan Category | MPD_MPTYP | T399W | CHAR | 2 | 0 | ||||||||||||
| WSET | Cycle set for multiple counter plan | WSET | CHAR | 6 | 0 | |||||||||||||
| WPTXT | Maintenance Plan Text | WPTXT | CHAR | 40 | 0 | |||||||||||||
| PLAN_SORT | Sort field for maintenance plans | PLAN_SORT | T399G | CHAR | 20 | 0 | ||||||||||||
| BEGRU | Technical object authorization group | IAUTG | T370B | CHAR | 4 | 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 | |||||||||||||
| TOSNEG | Tolerance for Early Completion (%) | TOLERNEG | NUMC | 3 | 0 | |||||||||||||
| SFAKT | Cycle modification factor | SFAKT | DEC | 3 | 2 | |||||||||||||
| STICH | Scheduling indicator | TERMKNZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| FABKL | Factory calendar key | FABKL | CHAR | 2 | 0 | |||||||||||||
| ABRHO | Scheduling Period | ABRHO | NUMC | 3 | 0 | |||||||||||||
| HUNIT | Unit in scheduling interval | HUNIT | T006 | UNIT | 3 | 0 | ||||||||||||
| HORIZ | Horizon until which dates in billing/invoice plan are valid | HORIZ | DATS | 8 | 0 | |||||||||||||
| CALL_CONFIRM | Only Create New Call Object After Completing Predecessor | CALL_CONFIRM | CHAR | 1 | 0 | |||||||||||||
| STADT | Start date | STADT | DATS | 8 | 0 | |||||||||||||
| SZAEH | Start counter reading | SZAEHC | CHAR | 22 | 0 | |||||||||||||
| PSTXT | Item Short Text | POSTXT | CHAR | 40 | 0 | |||||||||||||
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 | 0 | ||||||||||||
| WPGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 | 0 | ||||||||||||
| AUFART | Order Type | AUFART | T003O | CHAR | 4 | 0 | ||||||||||||
| ILART | Maintenance activity type | ILA | CHAR | 3 | 0 | |||||||||||||
| GEWERK | Main work center for maintenance tasks | GEWRK | CHAR | 8 | 0 | |||||||||||||
| WERGW | Plant associated with main work center | WERGW | T001W | CHAR | 4 | 0 | ||||||||||||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||||||
| PLNTY | Task List Type | PLNTY | CHAR | 1 | 0 | |||||||||||||
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | 0 | |||||||||||||
| PLNAL | Group Counter | PLNAL | CHAR | 2 | 0 | |||||||||||||
| APFKT | Execution factor for whole task list | APFKT | DEC | 3 | 0 | |||||||||||||
| QMART | Notification Type | QMART | TQ80 | CHAR | 2 | 0 | ||||||||||||
| PRIOK | Priority | PRIOK | T356 | CHAR | 1 | 0 | ||||||||||||
| TASK_DETERMINE | Automatic task determination in the notification | TASK_DETERMINE | CHAR | 1 | 0 | |||||||||||||
| DOC_UPDT | Planning and Scheduling Data Update Indicator | MPD_UPD | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| TLC_IND | Life-Limited Component Indicator | MPD_TLC | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| MP_CRTD_IND | Maintenance Plan Creation Indicator | MPD_CRTD_IND | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| COMPLIANCE_DATE | Compliance Date | MPD_COMPL_DATE | DATS | 8 | 0 | |||||||||||||
| JOBNAME | Background job name | BTCJOB | CHAR | 32 | 0 | |||||||||||||
| JOBCOUNT | Job ID | BTCJOBCNT | CHAR | 8 | 0 | |||||||||||||
| START_DATE | MPD: Default Start Date for Maintenance Plans | MPD_DEFAULT_START_DATE | DATS | 8 | 0 | |||||||||||||
| START_TIME | MPD: Default Start Time for Maintenance Plans | MPD_DEFAULT_START_TIME | TIMS | 6 | 0 | |||||||||||||
| OR_KNZ | Indicator for OR or AND link | ANDOR | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| AND_KNZ | Indicator for OR or AND link | ANDOR | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| VORLAUF | Lead Float in Days | PUFF_VORL | NUMC | 3 | 0 | |||||||||||||
| TOBE_UPDATED | Maintenance Plan to Be Updated | TOBE_UPDATED | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| TOBE_RESTARTED | Maintenance Plan to Be Restarted | TOBE_RESTARTED | CHAR | 1 | 0 |
Possible values
|
||||||||||||
MPDPSD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MPDPSD | AENNR | MPDPSD | AENNR | AENR | Change Master | AENNR |
| MPDPSD | AENNR | MPDPSD | MANDT | AENR | Change Master | MANDT |
| MPDPSD | AUFART | MPDPSD | AUFART | T003O | Order Types | AUART |
| MPDPSD | AUFART | MPDPSD | MANDT | T003O | Order Types | CLIENT |
| MPDPSD | BEGRU | MPDPSD | BEGRU | T370B | Technical object authorization group | BEGRU |
| MPDPSD | BEGRU | MPDPSD | MANDT | T370B | Technical object authorization group | MANDT |
| MPDPSD | DOKAR | MPDPSD | DOKAR | TDWA | Document Types | DOKAR |
| MPDPSD | DOKAR | MPDPSD | MANDT | TDWA | Document Types | MANDT |
| MPDPSD | DOKNR | MPDPSD | DOKAR | DRAW | Document Info Record | DOKAR |
| MPDPSD | DOKNR | MPDPSD | MANDT | DRAW | Document Info Record | MANDT |
| MPDPSD | DOKNR | MPDPSD | DOKNR | DRAW | Document Info Record | DOKNR |
| MPDPSD | DOKNR | MPDPSD | DOKVR | DRAW | Document Info Record | DOKVR |
| MPDPSD | DOKNR | MPDPSD | DOKTL | DRAW | Document Info Record | DOKTL |
| MPDPSD | GSBER | MPDPSD | GSBER | TGSB | Business Areas | GSBER |
| MPDPSD | GSBER | MPDPSD | MANDT | TGSB | Business Areas | MANDT |
| MPDPSD | HUNIT | MPDPSD | HUNIT | T006 | Units of Measurement | MSEHI |
| MPDPSD | HUNIT | MPDPSD | MANDT | T006 | Units of Measurement | MANDT |
| MPDPSD | IWERK | MPDPSD | IWERK | T399I | Planning plant parameters | IWERK |
| MPDPSD | IWERK | MPDPSD | MANDT | T399I | Planning plant parameters | MANDT |
| MPDPSD | MPTYP | MPDPSD | MANDT | T399W | Maintenance Plan Category Parameter | MANDT |
| MPDPSD | MPTYP | MPDPSD | MPTYP | T399W | Maintenance Plan Category Parameter | MPTYP |
| MPDPSD | PLAN_SORT | MPDPSD | PLAN_SORT | T399G | Maintenance Plan Sort Field | PLAN_SORT |
| MPDPSD | PLAN_SORT | MPDPSD | MANDT | T399G | Maintenance Plan Sort Field | MANDT |
| MPDPSD | PRIOK | MPDPSD | MANDT | T356 | Priorities | MANDT |
| MPDPSD | PRIOK | * | T356 | Priorities | ARTPR | |
| MPDPSD | PRIOK | MPDPSD | PRIOK | T356 | Priorities | PRIOK |
| MPDPSD | QMART | MPDPSD | QMART | TQ80 | Notification Types | QMART |
| MPDPSD | QMART | MPDPSD | MANDT | TQ80 | Notification Types | MANDT |
| MPDPSD | WERGW | MPDPSD | WERGW | T001W | Plants/Branches | WERKS |
| MPDPSD | WERGW | MPDPSD | MANDT | T001W | Plants/Branches | MANDT |
| MPDPSD | WPGRP | MPDPSD | WPGRP | T024I | Maintenance planner groups | INGRP |
| MPDPSD | WPGRP | MPDPSD | IWERK | T024I | Maintenance planner groups | IWERK |
| MPDPSD | WPGRP | MPDPSD | MANDT | T024I | Maintenance planner groups | MANDT |
