| 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 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 3 | BOLIF | Settlement partner (vendor or customer) | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | BOPAR | Allow NULL? |
| 4 | KNUMA | Agreement (subsequent settlement) | nvarchar | 10 | 0 | CHAR | (N' ') | No | KONA | KNUMA_BO | Allow NULL? |
| 5 | LIFNR | Vendor (PO, vendor billing document, settlement request) | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | BELIF | Allow NULL? |
| 6 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 7 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | T023 | MATKL | Allow NULL? |
| 8 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | T024E | EKORG | Allow NULL? |
| 9 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | No | T024 | EKGRP | Allow NULL? |
| 10 | DATBI | End date of validity period of an arrangement | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | MC_DATBI | Allow NULL? |
| 11 | KNUMH | Condition record number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KNUMH | Allow NULL? |
| 12 | ABSPW | Currency of rebate arrangement | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | ABSPW | Allow NULL? |
| 13 | KMEIN | Condition unit in the document | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | KVMEI | Allow NULL? |
| 14 | GEWEI | Weight Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | GEWEI | Allow NULL? |
| 15 | VOLEH | Volume unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VOLEH | Allow NULL? |
| 16 | PUNEI | Points unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | PUNEI | Allow NULL? |
| 17 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | KONWA | Allow NULL? |
| 18 | UABSPW | Conversion factor: quantities | float | 15 | 16 | FLTP | ((0)) | Yes | | UMREFF | |
| 19 | UKMEIN | Conversion factor: quantities | float | 15 | 16 | FLTP | ((0)) | Yes | | UMREFF | |
| 20 | UGEWEI | Conversion factor: quantities | float | 15 | 16 | FLTP | ((0)) | Yes | | UMREFF | |
| 21 | UVOLEH | Conversion factor: quantities | float | 15 | 16 | FLTP | ((0)) | Yes | | UMREFF | |
| 22 | UPUNEI | Conversion factor: quantities | float | 15 | 16 | FLTP | ((0)) | Yes | | UMREFF | |
| 23 | UKONWA | Conversion factor: quantities | float | 15 | 16 | FLTP | ((0)) | Yes | | UMREFF | |
| 24 | PLOBJ | Planning object | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | PLOBJ | Allow NULL? |
| 25 | PERKZ | Period indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PERVR | Allow NULL? |
| 26 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T009 | PERIV | Allow NULL? |
| 27 | PLTKZ | Indicator: element used in planning | char | 1 | 0 | CHAR | (N' ') | Yes | | PLTKZ | Allow NULL? |
| 28 | ANTEI | Proportional factor (%) for disaggregation of product group | float | 15 | 16 | FLTP | ((0)) | Yes | | DANTEF | |
