SAP ABAP Table MPDPSD (MPD: Planning & Scheduling data)
Hierarchy
☛
ECC-DIMP (Software Component) DIMP
⤷ IS-AD-MPD (Application Component) Maintenance Program Definition
⤷ AD_MPD (Package) Maintenance Program Definition
⤷ IS-AD-MPD (Application Component) Maintenance Program Definition
⤷ AD_MPD (Package) Maintenance Program Definition
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | MPDPSD | Table Relationship Diagram |
Short Description | MPD: Planning & Scheduling data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | PLAN_DATA_ID | MPD_DOCID | SYSUUID | RAW | 16 | 0 | Planning and Scheduling Data Identifier | ||
3 | DOKAR | DOKAR | DOKAR | CHAR | 3 | 0 | Document Type | TDWA | |
4 | DOKNR | DOKNR | DOKNR | CHAR | 25 | 0 | Document number | DRAW | |
5 | DOKVR | DOKVR | DOKVR | CHAR | 2 | 0 | Document version | ||
6 | DOKTL | DOKTL_D | DOKTL | CHAR | 3 | 0 | Document part | ||
7 | AENNR | AENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
8 | MPTYP | MPTYP | MPTYP | CHAR | 2 | 0 | Maintenance plan category | T399W | |
9 | WSET | WSET | WSTRA | CHAR | 6 | 0 | Cycle set for multiple counter plan | * | |
10 | WPTXT | WPTXT | TEXT40 | CHAR | 40 | 0 | Maintenance Plan Text | ||
11 | PLAN_SORT | PLAN_SORT | CHAR20 | CHAR | 20 | 0 | Sort field for maintenance plans | T399G | |
12 | BEGRU | IAUTG | IAUTG | CHAR | 4 | 0 | Authorization Group for Technical Object | T370B | |
13 | VSPOS | VERSCHPLUS | NUM3 | NUMC | 3 | 0 | Shift Factor for Late Completion | ||
14 | VSNEG | VERSCHNEG | NUM3 | NUMC | 3 | 0 | Shift Factor for Early Completion | ||
15 | TOPOS | TOLERPLUS | NUM3 | NUMC | 3 | 0 | Tolerance for Late Completion (%) | ||
16 | TOSNEG | TOLERNEG | NUM3 | NUMC | 3 | 0 | Tolerance for Early Completion (%) | ||
17 | SFAKT | SFAKT | SFAKT | DEC | 3 | 2 | Cycle modification factor | ||
18 | STICH | TERMKNZ | TERMKNZ | CHAR | 1 | 0 | Scheduling indicator | ||
19 | FABKL | FABKL | WFCID | CHAR | 2 | 0 | Factory calendar key | * | |
20 | ABRHO | ABRHO | ANZTA | NUMC | 3 | 0 | Scheduling Period | ||
21 | HUNIT | HUNIT | MEINS | UNIT | 3 | 0 | Unit in scheduling interval | T006 | |
22 | HORIZ | HORIZ | DATUM | DATS | 8 | 0 | Horizon until which dates in billing/invoice plan are valid | ||
23 | CALL_CONFIRM | CALL_CONFIRM | CHAR1 | CHAR | 1 | 0 | Only Create New Call Object After Completing Predecessor | ||
24 | STADT | STADT | DATUM | DATS | 8 | 0 | Start date | ||
25 | SZAEH | SZAEHC | WZYKL | CHAR | 22 | 0 | Start counter reading | ||
26 | PSTXT | POSTXT | TEXT40 | CHAR | 40 | 0 | Item Short Text | ||
27 | IWERK | IWERK | WERKS | CHAR | 4 | 0 | Maintenance Planning Plant | T399I | |
28 | WPGRP | INGRP | INGRP | CHAR | 3 | 0 | Planner Group for Customer Service and Plant Maintenance | T024I | |
29 | AUFART | AUFART | AUFART | CHAR | 4 | 0 | Order Type | T003O | |
30 | ILART | ILA | ILART | CHAR | 3 | 0 | Maintenance activity type | * | |
31 | GEWERK | GEWRK | ARBPL | CHAR | 8 | 0 | Main work center for maintenance tasks | ||
32 | WERGW | WERGW | WERKS | CHAR | 4 | 0 | Plant associated with main work center | T001W | |
33 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
34 | PLNTY | PLNTY | PLNTY | CHAR | 1 | 0 | Task List Type | * | |
35 | PLNNR | PLNNR | PLNNR | CHAR | 8 | 0 | Key for Task List Group | ||
36 | PLNAL | PLNAL | ALTNR | CHAR | 2 | 0 | Group Counter | ||
37 | APFKT | APFKT | AFAKT | DEC | 3 | 0 | Execution factor for whole task list | ||
38 | QMART | QMART | QMART | CHAR | 2 | 0 | Message Type | TQ80 | |
39 | PRIOK | PRIOK | PRIOK | CHAR | 1 | 0 | Priority | T356 | |
40 | TASK_DETERMINE | TASK_DETERMINE | CHAR1 | CHAR | 1 | 0 | Automatic task determination in the notification | ||
41 | DOC_UPDT | MPD_UPD | XFELD | CHAR | 1 | 0 | Planning and Scheduling Data Update Indicator | ||
42 | TLC_IND | MPD_TLC | XFELD | CHAR | 1 | 0 | Life-Limited Component Indicator | ||
43 | MP_CRTD_IND | MPD_CRTD_IND | XFELD | CHAR | 1 | 0 | Maintenance Plan Creation Indicator | ||
44 | COMPLIANCE_DATE | MPD_COMPL_DATE | DATUM | DATS | 8 | 0 | Compliance Date | ||
45 | JOBNAME | BTCJOB | CHAR32 | CHAR | 32 | 0 | Background job name | ||
46 | JOBCOUNT | BTCJOBCNT | CHAR8 | CHAR | 8 | 0 | Job ID | ||
47 | START_DATE | DATE_START | DATUM | DATS | 8 | 0 | Start Date for Scheduling | ||
48 | START_TIME | TIME_START | TIME | TIMS | 6 | 0 | Start Time for Scheduling | ||
49 | OR_KNZ | ANDOR | RADIO | CHAR | 1 | 0 | Indicator for OR or AND link | ||
50 | AND_KNZ | ANDOR | RADIO | CHAR | 1 | 0 | Indicator for OR or AND link | ||
51 | VORLAUF | PUFF_VORL | NUM3 | NUMC | 3 | 0 | Lead Float in Days |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MPDPSD | AENNR | AENR | AENNR | KEY | 1 | C |
2 | MPDPSD | AUFART | T003O | AUART | REF | C | CN |
3 | MPDPSD | BEGRU | T370B | BEGRU | KEY | C | CN |
4 | MPDPSD | DOKAR | TDWA | DOKAR | KEY | 1 | CN |
5 | MPDPSD | DOKNR | DRAW | DOKNR | KEY | 1 | CN |
6 | MPDPSD | GSBER | TGSB | GSBER | |||
7 | MPDPSD | HUNIT | T006 | MSEHI | |||
8 | MPDPSD | IWERK | T399I | IWERK | REF | C | CN |
9 | MPDPSD | MPTYP | T399W | MPTYP | KEY | 1 | CN |
10 | MPDPSD | PLAN_SORT | T399G | PLAN_SORT | KEY | 1 | CN |
11 | MPDPSD | PRIOK | T356 | PRIOK | REF | C | CN |
12 | MPDPSD | QMART | TQ80 | QMART | |||
13 | MPDPSD | WERGW | T001W | WERKS | |||
14 | MPDPSD | WPGRP | T024I | INGRP |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 500 |