| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CAPAB | Capacity Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | CAPA_VOL | Total Volume of Day Capacity | decimal | 13 | 3 | | | | |
| 4 | CAPA_VOL_SUM | Volume of Day Capacity Allocated | decimal | 13 | 3 | | | | |
| 5 | CAPA_WEIGHT | Total Weight of Day Capacity | decimal | 13 | 3 | | | | |
| 6 | CAPA_WEIGHT_SUM | Total Weight of Day Capacity | decimal | 13 | 3 | | | | |
| 7 | PROC_CAPA_M3 | Percentage of Total Capacity for M3 with Difficulties | decimal | 5 | 1 | | | | |
| 8 | CAPA_M3_SUM | Volume of Excess Cubic Meters Already Allocated | decimal | 13 | 3 | | | | |
| 9 | PROC_CAPA_EA | Percentage Portion of Total Capacity for Express Orders | decimal | 5 | 1 | | | | |
| 10 | CAPA_EA_SUM | Volume of Excess M3 Already Allocated | decimal | 13 | 3 | | | | |
| 11 | CAPA_TEXT | Text Field | nvarchar | 50 | 0 | | | | Allow NULL? |
| 12 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | BEGRU | Authorization Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | LOEVM | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |