| 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 | * | MANDT | Allow NULL? |
| 2 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | CHAR | (N' ') | No | MPLA | WARPL | Allow NULL? |
| 3 | ABNUM | Copy of data element ABNUM with category NUMC | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | ABNUM_UNPACKED | Allow NULL? |
| 4 | ZAEHL | Maintenance Package Number | nvarchar | 2 | 0 | NUMC | (N'00') | No | * | PAKETZAEHL | Allow NULL? |
| 5 | NPLDA | Next planned date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NPLDA | Allow NULL? |
| 6 | TERMA | Scheduling type | char | 1 | 0 | CHAR | (N' ') | Yes | | TERMA | Allow NULL? |
| 7 | STADT | Start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STADT | Allow NULL? |
| 8 | LRMDT | Date of last completion in maintenance plan | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LRMDT | Allow NULL? |
| 9 | OFFZE | Offset in current cycle | float | 15 | 16 | FLTP | ((0)) | Yes | | OFFZE | |
| 10 | OFFZO | Previous offset | float | 15 | 16 | FLTP | ((0)) | Yes | | OFFZO | |
| 11 | ABRUD | Date of the call | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABRUD | Allow NULL? |
| 12 | ABRNA | Name of the person who made the call | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ABRNA | Allow NULL? |
| 13 | SFAKT | Cycle modification factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | SFAKT | |
| 14 | TERMK | Scheduling indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | TERMKNZ | Allow NULL? |
| 15 | VERSCH | Shift Factor for Late Completion | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | VERSCHPLUS | Allow NULL? |
| 16 | TOLER | Tolerance for Late Completion (%) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | TOLERPLUS | Allow NULL? |
| 17 | KNNRM | Indicator for negative completion confirmation | char | 1 | 0 | CHAR | (N' ') | Yes | | KNNRM | Allow NULL? |
| 18 | KNPRM | Indicator: planned counter reading set manually | char | 1 | 0 | CHAR | (N' ') | Yes | | KNPRM | Allow NULL? |
| 19 | NPLDO | Last planned date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NPLDO | Allow NULL? |
| 20 | NPLDZ | Completion for Predecessor | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NPLDZ | Allow NULL? |
| 21 | MANDA | Manual call date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MANDA | Allow NULL? |
| 22 | OFFLE | Estimated annual performance | float | 15 | 16 | FLTP | ((0)) | Yes | | OFFLE | |
| 23 | OFFLO | Shift factor | float | 15 | 16 | FLTP | ((0)) | Yes | | OFFLO | |
| 24 | KNAUT | Reserved | char | 1 | 0 | CHAR | (N' ') | Yes | | KNZABR | Allow NULL? |
| 25 | KNASR | Indicator for leading cycle (multi-counter plan) -> internal | char | 1 | 0 | CHAR | (N' ') | Yes | | KNZSTILL | Allow NULL? |
| 26 | TSABR | Scheduling status: planned date called | char | 1 | 0 | CHAR | (N' ') | Yes | | TSABR | Allow NULL? |
| 27 | TSVBT | Scheduling status: call outstanding | char | 1 | 0 | CHAR | (N' ') | Yes | | TSVBT | Allow NULL? |
| 28 | TSENQ | Scheduling status: call horizon not reached | char | 1 | 0 | CHAR | (N' ') | Yes | | TSENQ | Allow NULL? |
| 29 | TSENM | Scheduling status: stopped manually | char | 1 | 0 | CHAR | (N' ') | Yes | | TSENM | Allow NULL? |
| 30 | HORDA | Call date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | HORDA | Allow NULL? |
| 31 | TSTAT | Scheduling status | char | 1 | 0 | CHAR | (N' ') | Yes | | TSTAT | Allow NULL? |
| 32 | FIXDU | Fixed or skipped by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FIXDU | Allow NULL? |
| 33 | FIXDA | Fixed/skipped on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIXDA | Allow NULL? |
| 34 | VGNUM | Copy of data element VGNUM with category NUMC | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VGNUM_UNPACKED | Allow NULL? |
| 35 | ZYKZT | Maintenance package cycle/offset | float | 15 | 16 | FLTP | ((0)) | Yes | | DZYK_ZEIT | |
| 36 | ZYKLS | Total counter reading on call date | float | 15 | 16 | FLTP | ((0)) | Yes | | DZYK_LEIST | |
| 37 | PUFFP | Lead Float in Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PUFF_VORL | Allow NULL? |
| 38 | PUFFN | Follow-up float in days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PUFF_NACHL | Allow NULL? |
| 39 | SZAEH | Start counter reading | float | 15 | 16 | FLTP | ((0)) | Yes | | SZAEH | |
| 40 | RZAEH | Counter reading confirmation | float | 15 | 16 | FLTP | ((0)) | Yes | | RZAEH | |
| 41 | NZAEH | Next planned counter reading | float | 15 | 16 | FLTP | ((0)) | Yes | | NZAEH | |
| 42 | USERMOD | Scheduling determined by user | char | 1 | 0 | CHAR | (N' ') | Yes | | USERMOD | Allow NULL? |
| 43 | CYCLESEQIND | Cycle set sequence | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CYCLESEQIND | Allow NULL? |
| 44 | ADPOINT | Measuring Point | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | IMRC_POINT | Allow NULL? |
| 45 | ADANDOR | Indicator for OR or AND link | char | 1 | 0 | CHAR | (N' ') | Yes | | ANDOR | Allow NULL? |
| 46 | ADTGOON | Scheduling to reoccur when lead float reached | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | TGON | Allow NULL? |
