| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | KNUMH | Condition record number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | KOPOS | Sequential number of the condition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | LIFNR | Vendor (PO, vendor billing document, settlement request) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | ABSPW | Currency of rebate arrangement | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | KMEIN | Condition unit in the document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | GEWEI | Weight Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | VOLEH | Volume unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | PUNEI | Points unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | KONWS | Scale currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | KONMS | Condition scale unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | UABSPW | Conversion factor: quantities | float | 15 | 16 | | | | |
| 17 | UKMEIN | Conversion factor: quantities | float | 15 | 16 | | | | |
| 18 | UGEWEI | Conversion factor: quantities | float | 15 | 16 | | | | |
| 19 | UVOLEH | Conversion factor: quantities | float | 15 | 16 | | | | |
| 20 | UPUNEI | Conversion factor: quantities | float | 15 | 16 | | | | |
| 21 | UKONWS | Conversion factor: quantities | float | 15 | 16 | | | | |
| 22 | UKONWA | Conversion factor: quantities | float | 15 | 16 | | | | |
| 23 | UKONMS | Conversion factor: quantities | float | 15 | 16 | | | | |
| 24 | PLOBJ | Planning object | nvarchar | 18 | 0 | | | | Allow NULL? |
| 25 | PERKZ | Period indicator | char | 1 | 0 | | | | Allow NULL? |
| 26 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | PLTKZ | Indicator: element used in planning | char | 1 | 0 | | | | Allow NULL? |
| 28 | ANTEI | Proportional factor (%) for disaggregation of product group | float | 15 | 16 | | | | |