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