| 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 | KAPID | Capacity ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | KAKO | KAPID | Allow NULL? |
| 3 | VERSN | Available capacity version | nvarchar | 2 | 0 | NUMC | (N'00') | No | TC36 | KAPVERSION | Allow NULL? |
| 4 | DATUB | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 5 | TAGNR | Current weekday number within the available capacity cycle | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CR_TAGNR | Allow NULL? |
| 6 | SCHNR | Shift number of the available capacity | char | 1 | 0 | NUMC | (N'0') | No | | SCHICHTNR | Allow NULL? |
| 7 | ANZHL | Number of individual capacities | smallint | 5 | 0 | INT2 | ((0)) | Yes | | KAPANZAHL | |
| 8 | BEGZT | Start time in seconds (internal) | int | 10 | 0 | INT4 | ((0)) | Yes | | KAPBEGZT | Allow NULL? |
| 9 | EINZT | Operating time in seconds (internal) | int | 10 | 0 | INT4 | ((0)) | Yes | | KAPEINZT | Allow NULL? |
| 10 | ENDZT | Finish time in seconds (internal) | int | 10 | 0 | INT4 | ((0)) | Yes | | KAPENDZT | Allow NULL? |
| 11 | FABTG | Indicator: Workdays | char | 1 | 0 | CHAR | (N' ') | Yes | | KAPFABTAG | Allow NULL? |
| 12 | KAPAZ | Capacity | int | 10 | 0 | INT4 | ((0)) | Yes | | KAPAZITAET | Allow NULL? |
| 13 | PAUSE | Cumulative break time in seconds (internal) | int | 10 | 0 | INT4 | ((0)) | Yes | | KAPPAUSE | Allow NULL? |
| 14 | NGRAD | Capacity utilization rate (percent) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NUTZGRAD | Allow NULL? |
| 15 | TPROG | Shift definition | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TC37T | KAPTPROG | Allow NULL? |
| 16 | WOTAG | Factory calendar weekday | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | SYFDAYW | |
| 17 | ANG_MIN | Minimum capacity in volume unit or unit of measure | decimal | 13 | 3 | QUAN | ((0)) | Yes | | KAPAZIT_VM_MIN | |
| 18 | ANG_MAX | Maximum capacity in volume unit or unit of measure | decimal | 13 | 3 | QUAN | ((0)) | Yes | | KAPAZIT_VM_MAX | |
