| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BEDID | ID of the capacity requirements record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | BEDZL | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | ARBID | Work center ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | TYPKZ | Category of object causing the load (order category) | char | 1 | 0 | | | | Allow NULL? |
| 7 | OBJKZ | Indicator: Remaining split record | char | 1 | 0 | | | | Allow NULL? |
| 8 | KAPID | Capacity ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | BEDKZ | Indicator: Remaining split record | char | 1 | 0 | | | | Allow NULL? |
| 10 | KRUESOLL | Scheduled cap. requirements for the op. segment "setup" | float | 15 | 16 | | | | |
| 11 | KRUEREST | Remaining capacity rqmts. for operation segment "Setup" | float | 15 | 16 | | | | |
| 12 | KBEASOLL | Scheduled cap. requirements for the op. segment "processing" | float | 15 | 16 | | | | |
| 13 | KBEAREST | Remaining capacity rqmts.for operation segment "Processing" | float | 15 | 16 | | | | |
| 14 | KABRSOLL | Scheduled cap. requirements for the op. segment teardown | float | 15 | 16 | | | | |
| 15 | KABRREST | Remaining capacity requirements for op. segment "tear down" | float | 15 | 16 | | | | |
| 16 | KEINH | Unit of of measure for displaying capacity requirements | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | FSTAD | Earliest start / date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | FSTAU | Earliest start / time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | FENDD | Earliest finish /date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | FENDU | Earliest finish /time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | SSTAD | Latest start / date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | SSTAU | Latest start / time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | SENDD | Latest finish / date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | SENDU | Latest finish / time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | ISTAD | Actual start / date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | ISTAU | Actual start / time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 27 | IENDD | Actual finish / date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | IENDU | Actual finish / time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | PENDD | Forecast finish / date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | PENDU | Forecast finish / time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | ISPLI | Actual number of splits | decimal | 3 | 0 | | | | |
| 32 | KPVER | Distribution of capacity requirements (Planned/prod.order) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | OBSTA | Object status (order status) | nvarchar | 22 | 0 | | | | Allow NULL? |
| 34 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | APLZL | General counter for order | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | PLNUM | Planned order number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | PLNTY | Task List Type | char | 1 | 0 | | | | Allow NULL? |
| 38 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | PLNAL | Group Counter | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | PLNFL | Sequence | nvarchar | 6 | 0 | | | | Allow NULL? |
| 42 | ZAEHF | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | PLNKN | Number of the task list node | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | ZAEHP | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 45 | SPLKN | Number of the task list node of the sub-operation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 46 | SZAEHL | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 47 | SAFNR | SOP order number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 48 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 49 | OTYPE | Object Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 50 | PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 51 | CANUMF | Counter for the main capacity requirements record | nvarchar | 4 | 0 | | | | Allow NULL? |
| 52 | SPLIT | Split number | tinyint | 3 | 0 | | | | |
| 53 | KBSTA | Status of a capacity requirements (object number) | nvarchar | 22 | 0 | | | | Allow NULL? |
| 54 | FSSBD | Earliest scheduled start: Processing (date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 55 | FSSBZ | Earliest scheduled start: Processing (time) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 56 | FSSAD | Earliest scheduled start: Teardown (date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 57 | FSSAZ | Earliest scheduled start: Teardown (time) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 58 | SSSBD | Latest scheduled start: Processing (date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 59 | SSSBZ | Latest scheduled start: Processing (time) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 60 | SSSAD | Latest scheduled start: Teardown (date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 61 | SSSAZ | Latest scheduled start: Teardown (time) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 62 | MGVRG | Operation Quantity | decimal | 13 | 3 | | | | |
| 63 | MEINH | Unit of Measure for Activity/Operation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 64 | RSTUF | Reduction level which reduces operation lead time | char | 1 | 0 | | | | Allow NULL? |
| 65 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | | | Allow NULL? |
| 66 | BSTKZ | Indicator rqmts.record is confirmed (cap.availability check) | char | 1 | 0 | | | | Allow NULL? |
| 67 | BEDZLF | BEDZL of Main Operation (for Phases and Their Main Ops) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 68 | PHASE_KZ | Indicator: Phase | char | 1 | 0 | | | | Allow NULL? |
| 69 | MAXBD_KZ | Indicator: Capacity fully committed | char | 1 | 0 | | | | Allow NULL? |
| 70 | ANZMA | Number of employees | decimal | 5 | 2 | | | | |
