| 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 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | KNUMH | Condition record number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | KOPOS | Sequential number of the condition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | LIFNR | Vendor (PO, vendor billing document, settlement request) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | ABSPW | Currency of rebate arrangement | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | KMEIN | Condition unit in the document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | GEWEI | Weight Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | VOLEH | Volume unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | PUNEI | Points unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | KONWS | Scale currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | KONMS | Condition scale unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | AUWRT | Rebate income from settlement w. regard to condition record | decimal | 19 | 2 | | | | |
| 24 | RUWRT | Provision for accrued condition income | decimal | 19 | 2 | | | | |
| 25 | MENGE | Vendor business volume: quantity in condition unit | decimal | 13 | 3 | | | | |
| 26 | BONBA | Vendor business volume: value in rebate arrangement currency | decimal | 15 | 2 | | | | |
| 27 | BRGEW | Vendor business volume: gross weight (subsequent settlement) | decimal | 15 | 3 | | | | |
| 28 | NTGEW | Vendor business volume: net weight (subsequent settlement) | decimal | 15 | 3 | | | | |
| 29 | VOLUM | Vendor business volume: physical volume (subseq. settlement) | decimal | 15 | 3 | | | | |
| 30 | RRWRT | Dissolved (reversed) provision for accrued condition income | decimal | 19 | 2 | | | | |
| 31 | ANZPU | Vendor business volume: no. of points (subseq. settlement) | decimal | 13 | 3 | | | | |
| 32 | AGWRT | Rebate income from final settlement | decimal | 19 | 2 | | | | |
| 33 | BONBAST | Vendor busn. vol. value in scale curr.: settlement-relevant | decimal | 17 | 2 | | | | |
| 34 | BONBAKD | Vendor busn. vol. value in cond. curr.: settlement-relevant | decimal | 17 | 2 | | | | |
| 35 | MENGEST | Vendor business volume: quantity in scale unit | decimal | 15 | 3 | | | | |
