| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | CHAR | (N' ') | No | MPLA | WARPL | Allow NULL? |
| 3 | NUMMER | Counter in control tables | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DZAEHLER | Allow NULL? |
| 4 | OPERATOR | Comparison operator for maint. package cycle duration | nvarchar | 2 | 0 | CHAR | (N' ') | No | | PM_VERGL | Allow NULL? |
| 5 | ZYKL1 | Maintenance package cycle/offset | float | 15 | 16 | FLTP | ((0)) | No | | DZYK_ZEIT | |
| 6 | ZEIEH | Unit for the performance of maintenance tasks | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | DZEIEH | Allow NULL? |
| 7 | PAK_TEXT | Text for maintenance package/cycle (time/performance) | nvarchar | 30 | 0 | CHAR | (N' ') | No | | TXZYKLUS | Allow NULL? |
| 8 | LANGU | Primary language for object texts | char | 1 | 0 | LANG | (N' ') | No | T002 | MLANG | Allow NULL? |
| 9 | POINT | Measuring Point | nvarchar | 12 | 0 | CHAR | (N' ') | No | IMPTT | IMRC_POINT | Allow NULL? |
| 10 | OFFSET | Start offset of a time-based maintenance package | float | 15 | 16 | FLTP | ((0)) | No | | DZYK_OFFZT | |
| 11 | INAKTIV | Indicator: event scheduling inactive | char | 1 | 0 | CHAR | (N' ') | No | | INAKT_TERM | Allow NULL? |
| 12 | NZAEH | Next planned counter reading | float | 15 | 16 | FLTP | ((0)) | No | | NZAEH | |
| 13 | ZAEHL | Maintenance Package Number | nvarchar | 2 | 0 | NUMC | (N'00') | No | * | PAKETZAEHL | Allow NULL? |
| 14 | KTEXTYZK | Short text for the maintenance cycle (time/performance) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | KTEXTZYK | Allow NULL? |
| 15 | CYCLESEQIND | Cycle Set Sequence | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CYCLESETSEQ | Allow NULL? |
| 16 | SETREPEATIND | Repeat Factor for Cycle Set Sequence | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | IND_SET_REPEAT | Allow NULL? |
