SAP Table MPDCYCLE
MPD: Cycle Data for Maintenance Document Items
MPDCYCLE (MPD: Cycle Data for Maintenance Document Items) 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 MPDCYCLE to other SAP tables.
Source: MPDCYCLE (MPD: Cycle Data for Maintenance Document Items)
MPDCYCLE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||||||||||||||
| PLAN_DATA_ID | Document Identification GUID | MPD_DOCID | MPDPSD | RAW | 16 | 0 | ||||||||||||||||||||||
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 | 0 | ||||||||||||||||||||||
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 | 0 | ||||||||||||||||||||||
| NUMMER | Counter in control tables | DZAEHLER | NUMC | 2 | 0 | |||||||||||||||||||||||
| CYCLESEQIND | Cycle Set Sequence | CYCLESETSEQ | NUMC | 2 | 0 | |||||||||||||||||||||||
| SETREPEATIND | Repeat Factor for Cycle Set Sequence | IND_SET_REPEAT | NUMC | 2 | 0 | |||||||||||||||||||||||
| ZYKL1 | Maintenance cycle | WZYKL1 | CHAR | 22 | 0 | |||||||||||||||||||||||
| ZEIEH | Unit for the performance of maintenance tasks | DZEIEH | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||
| PAK_TEXT | Text for maintenance package/cycle (time/performance) | TXZYKLUS | CHAR | 30 | 0 | |||||||||||||||||||||||
| POINT | Measuring Point | IMRC_POINT | CHAR | 12 | 0 | |||||||||||||||||||||||
| PTTXT | Description of Measuring Point | IMRC_PTTXT | CHAR | 40 | 0 | |||||||||||||||||||||||
| OFFS1 | Maintenance package offset | WOFFS1 | CHAR | 22 | 0 | |||||||||||||||||||||||
| INAKTIV | Indicator: event scheduling inactive | INAKT_TERM | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
| DOC_UPDT | Planning and Scheduling Data Update Indicator | MPD_UPD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
| JOBNAME | Background job name | BTCJOB | CHAR | 32 | 0 | |||||||||||||||||||||||
| JOBCOUNT | Job ID | BTCJOBCNT | CHAR | 8 | 0 | |||||||||||||||||||||||
| START_DATE | MPD: Start Date for Maintenance Plans | MPD_DATE_START | DATS | 8 | 0 | |||||||||||||||||||||||
| START_TIME | MPD: Start Time for Maintenance Plans | MPD_TIME_START | TIMS | 6 | 0 | |||||||||||||||||||||||
| EFF_START_DATE | MPD: Effective Start Date for Maintenance Plans | MPD_EFF_DATE_START | DATS | 8 | 0 | |||||||||||||||||||||||
| EFF_START_TIME | MPD: Effective Start Time for Maintenance Plans | MPD_EFF_TIME_START | TIMS | 6 | 0 | |||||||||||||||||||||||
| TOBE_UPDATED | Maintenance Plan to Be Updated | TOBE_UPDATED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
| UPDATED | Maintenance Plan Already Updated | UPDATED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
| TOBE_RESTARTED | Maintenance Plan to Be Restarted | TOBE_RESTARTED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
| RESTARTED | Maintenance Plan Already Restarted | RESTARTED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
| OPERATOR | Comparison operator for maint. package cycle duration | PM_VERGL | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||
| NZAEH | Next planned counter reading | NZAEH | FLTP | 16 | 16 | |||||||||||||||||||||||
| ZAEHL | Maintenance Package Number | PAKETZAEHL | NUMC | 2 | 0 | |||||||||||||||||||||||
MPDCYCLE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MPDCYCLE | EQUNR | MPDCYCLE | MANDT | EQUI | Equipment master data | MANDT |
| MPDCYCLE | EQUNR | MPDCYCLE | EQUNR | EQUI | Equipment master data | EQUNR |
| MPDCYCLE | PLAN_DATA_ID | MPDCYCLE | MANDT | MPDPSD | MPD: MPD and MP header data | MANDT |
| MPDCYCLE | PLAN_DATA_ID | MPDCYCLE | PLAN_DATA_ID | MPDPSD | MPD: MPD and MP header data | PLAN_DATA_ID |
| MPDCYCLE | PLAN_DATA_ID | * | MPDPSD | MPD: MPD and MP header data | DOKAR | |
| MPDCYCLE | PLAN_DATA_ID | * | MPDPSD | MPD: MPD and MP header data | DOKNR | |
| MPDCYCLE | PLAN_DATA_ID | * | MPDPSD | MPD: MPD and MP header data | DOKVR | |
| MPDCYCLE | PLAN_DATA_ID | * | MPDPSD | MPD: MPD and MP header data | DOKTL | |
| MPDCYCLE | PLAN_DATA_ID | * | MPDPSD | MPD: MPD and MP header data | AENNR | |
| MPDCYCLE | TPLNR | MPDCYCLE | MANDT | IFLOT | Functional Location (Table) | MANDT |
| MPDCYCLE | TPLNR | MPDCYCLE | TPLNR | IFLOT | Functional Location (Table) | TPLNR |
| MPDCYCLE | ZEIEH | MPDCYCLE | MANDT | T006 | Units of Measurement | MANDT |
| MPDCYCLE | ZEIEH | MPDCYCLE | ZEIEH | T006 | Units of Measurement | MSEHI |
