| 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 | VSNMR | Number or description of a version | nvarchar | 12 | 0 | CHAR | (N' ') | No | | VSNMR | Allow NULL? |
| 3 | BEDID | ID of the capacity requirements record | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | VSKBKO_CN | BEDID | Allow NULL? |
| 4 | BEDZL | Internal counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CIM_COUNT | Allow NULL? |
| 5 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | NUMC | (N'0000') | No | * | CY_COUNT | Allow NULL? |
| 6 | VGW01 | Standard Value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | VGWRT | |
| 7 | VGE01 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 8 | VGW02 | Standard Value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | VGWRT | |
| 9 | VGE02 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 10 | VGW03 | Standard Value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | VGWRT | |
| 11 | VGE03 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 12 | VGW04 | Standard Value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | VGWRT | |
| 13 | VGE04 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 14 | VGW05 | Standard Value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | VGWRT | |
| 15 | VGE05 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 16 | VGW06 | Standard Value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | VGWRT | |
| 17 | VGE06 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 18 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | USRQUAN13 | |
| 19 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | USRUNIT | Allow NULL? |
| 20 | USR05 | User field for quantity (length 10.3) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | USRQUAN13 | |
| 21 | USE05 | User field: Unit for quantity fields | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | USRUNIT | Allow NULL? |
| 22 | LEK01 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 23 | LEK02 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 24 | LEK03 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 25 | LEK04 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 26 | LEK05 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 27 | LEK06 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 28 | RSTZE | Unit of measure for setup time | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | | RSTZE | Allow NULL? |
| 29 | BEAZE | Unit of measure for processing time | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | | BEAZE | Allow NULL? |
| 30 | ARUZE | Unit of measure for teardown | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | | ARUZE | Allow NULL? |
| 31 | ARBEI | Work involved in the activity | decimal | 7 | 1 | QUAN | ((0)) | Yes | | ARBEIT | |
| 32 | ARBEH | Unit for work | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ARBEITE | Allow NULL? |
| 33 | LEKNW | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 34 | ASVRG | Operation scrap | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ASVRG | |
| 35 | UMREN | Denominator for converting rtg and op units of measure | decimal | 5 | 0 | DEC | ((0)) | Yes | | CP_UMREN | |
| 36 | UMREZ | Numerator for converting task list and oper. un. of measure | decimal | 5 | 0 | DEC | ((0)) | Yes | | CP_UMREZ | |
| 37 | BMSCH | Base Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BMSCH | |
| 38 | LMNGA | Total Yield Confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LMNGA | |
| 39 | XMNGA | Total scrap quantity confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | XMNGA | |
| 40 | ISMNW | Actual work | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CO_ISMNW | |
| 41 | ISM01 | Previously confirmed activity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CO_RUMNG | |
| 42 | ISM02 | Previously confirmed activity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CO_RUMNG | |
| 43 | ISM03 | Previously confirmed activity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CO_RUMNG | |
| 44 | ISM04 | Previously confirmed activity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CO_RUMNG | |
| 45 | ISM05 | Previously confirmed activity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CO_RUMNG | |
| 46 | ISM06 | Previously confirmed activity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CO_RUMNG | |
| 47 | ISERH | Confirmed break time | decimal | 9 | 3 | QUAN | ((0)) | Yes | | ISERH | |
| 48 | ZEIER | Unit for the break time | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | DZEIER | Allow NULL? |
| 49 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISDD | Allow NULL? |
| 50 | ISDZ | Actual start: Execution/setup (time) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISDZ | Allow NULL? |
| 51 | IERD | Actual finish: Setup (date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IERD | Allow NULL? |
| 52 | IERZ | Actual finish: Setup (time) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | IERZ | Allow NULL? |
| 53 | ISBD | Actual start: Processing (date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISBD | Allow NULL? |
| 54 | ISBZ | Actual start: Processing (time) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISBZ | Allow NULL? |
| 55 | IEBD | Actual finish: Processing (date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IEBD | Allow NULL? |
| 56 | IEBZ | Actual processing finish (time) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | IEBZ | Allow NULL? |
| 57 | ISAD | Actual start: Teardown (date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISAD | Allow NULL? |
| 58 | ISAZ | Actual start: Teardown (time) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISAZ | Allow NULL? |
| 59 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IEDD | Allow NULL? |
| 60 | IEDZ | Actual finish: Execution (time) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | IEDZ | Allow NULL? |
| 61 | PEDD | Forecast finish date of operation from confirmation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CO_PEDD | Allow NULL? |
| 62 | PEDZ | Forecast finish time of operation from confirmation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CO_PEDZ | Allow NULL? |
| 63 | OFM01 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 64 | OFM02 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 65 | OFM03 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 66 | OFM04 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 67 | OFM05 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 68 | OFM06 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 69 | OFMNW | Forecasted work (actual + remaining) | decimal | 7 | 1 | QUAN | ((0)) | Yes | | OFMNW | |
| 70 | PDAU | Forecasted duration of activity from confirmation | decimal | 5 | 1 | QUAN | ((0)) | Yes | | PDAU | |
| 71 | PDAE | Unit of the forecasted duration from the confirmation | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | PDAE | Allow NULL? |
| 72 | DAUNO | Normal duration of the activity | decimal | 5 | 1 | QUAN | ((0)) | Yes | | DAUNOR | |
| 73 | DAUNE | Normal duration/unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | DAUNORE | Allow NULL? |
| 74 | RMNGA | Total confirmed rework quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RMNGA | |
| 75 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 76 | ILE02 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 77 | ILE03 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 78 | ILE04 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 79 | ILE05 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 80 | ILE06 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 81 | PER_EX | Entry in KPER exists for this split | char | 1 | 0 | CHAR | (N' ') | Yes | | CY_PEREX | Allow NULL? |
| 82 | DELTA_ST | Time Difference Between Start Capacity and Individ. Capacity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CY_DELTAST | |
| 83 | DELTA_EN | Time Difference Between Fin. Capacity and Individ. Capacity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CY_DELTAEN | |
| 84 | GROUP_ID | Group ID (GUID) for Grouped Capacity Requirements | varbinary | 16 | 0 | RAW | | Yes | | COSFD_GROUP_ID | |
| 85 | GROUP_MEMBER | Member Inside a Capacity Requirements Group | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | COSFD_GROUP_MEMBER | |
| 86 | GROUP_COUNT | Number of Members Inside a Capacity Requirements Group | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | COSFD_GROUP_COUNT | |
| 87 | FIXED | Indicator: Dispatching of Capacity Requirement Is Fixed | char | 1 | 0 | CHAR | (N' ') | Yes | | COSFD_FIXED | Allow NULL? |
| 88 | NO_BREAKS | Dispatched in Non-Working Times | char | 1 | 0 | CHAR | (N' ') | Yes | | COSFD_NO_BREAKS | Allow NULL? |
