| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | STRAT | Maintenance strategy | nvarchar | 6 | 0 | | | | Allow NULL? |
| 3 | ZEIEH | Unit for the performance of maintenance tasks | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | LEIEH | Maintenance strategy activity unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | ZYK1G | Total cycle duration of a maintenance strategy | float | 15 | 16 | | | | |
| 6 | ZYK2G | Total cycle duration of a maintenance strategy | float | 15 | 16 | | | | |
| 7 | ZYK1K | Smallest step between two maintenance packages | float | 15 | 16 | | | | |
| 8 | ZYK2K | Smallest step between two performance-based MaintPackages | float | 15 | 16 | | | | |
| 9 | ANZP1 | Number of MaintPackages in the MaintStrategy | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | ANZP2 | Number of MaintPackages in the MaintStrategy (peformance) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | TOLE1 | Tolerance for Late Completion (%) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | TOLE2 | Tolerance for Early Completion (%) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | VERS1 | Shift Factor for Late Completion | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | VERS2 | Shift Factor for Early Completion | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | TERMK | Scheduling indicator | char | 1 | 0 | | | | Allow NULL? |
| 16 | HORIZ | Call horizon for maintenance plan calls | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | FABKL | Factory calendar key | nvarchar | 2 | 0 | | | | Allow NULL? |