| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KNUMH | Condition record number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | KUNWE | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 5 | VBELN | Billing Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | POSNR | Billing item | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | BUTYP | Type Posting CO-PA/Rebate | char | 1 | 0 | | | | Allow NULL? |
| 8 | SIMKEY | Key Simulation Rebate/Allocation CO-PA | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | BONEM | Rebate recipient | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | VKORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | SPART | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | KNUMA_BO | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | KSCHL | Condition type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | | | Allow NULL? |
| 16 | KOPOS | Sequential number of the condition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | BOART | Agreement type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | BOMAT | Material for rebate settlement | nvarchar | 18 | 0 | | | | Allow NULL? |
| 19 | KBETR | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | | | | |
| 20 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | KPEIN | Condition pricing unit | decimal | 5 | 0 | | | | |
| 22 | KMEIN | Condition unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | KUMZA | Numerator for converting condition units to base units | decimal | 5 | 0 | | | | |
| 24 | KUMNE | Denominator for converting condition units to base units | decimal | 5 | 0 | | | | |
| 25 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | KRECH | Calculation type for condition | char | 1 | 0 | | | | Allow NULL? |
| 27 | KWAEH | Condition currency (for cumulation fields) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 29 | STFKZ | Scale Type | char | 1 | 0 | | | | Allow NULL? |
| 30 | KZBZG | Scale basis indicator | char | 1 | 0 | | | | Allow NULL? |
| 31 | KONMS | Condition scale unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 32 | KONWS | Scale currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | KBRUE | Accrual Amount | decimal | 11 | 2 | | | | |
| 34 | BEGAB | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | ENDAB | Valid To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | KWERT | Condition value | nvarchar | 19 | 0 | | | | Allow NULL? |
| 38 | ZBONBA | Rebate: Accumulated sales volume in local currency | decimal | 19 | 2 | | | | |
| 39 | ZMENG | Target quantity in sales units | decimal | 13 | 3 | | | | |
| 40 | KAWRT_A | Condition base value | decimal | 15 | 2 | | | | |
| 41 | KMENG_A | Sales quantity | decimal | 15 | 3 | | | | |
| 42 | KSTBS_A | Scale base value of the condition | decimal | 15 | 2 | | | | |
| 43 | RUWRT_A | Rebate: Accrued value in local currency | decimal | 19 | 2 | | | | |
| 44 | KWERT_A | Condition base value | decimal | 15 | 2 | | | | |
| 45 | KBETS | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | | | | |
| 46 | KSTBS | Rebate: Accrued value in local currency | decimal | 19 | 2 | | | | |
| 47 | KSTBM | Condition scale quantity | decimal | 15 | 3 | | | | |
| 48 | AUBEL | Sales Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 49 | BELNR | Document number of line item in Profitability Analysis | nvarchar | 10 | 0 | | | | Allow NULL? |
| 50 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 51 | PERDE | Period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 52 | FKART | Billing Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 53 | HERKUNFT | Origin Rebate Basis/Rebate Planning | nvarchar | 4 | 0 | | | | Allow NULL? |
| 54 | ABRKZ | Settlement Indicator | char | 1 | 0 | | | | Allow NULL? |
| 55 | MODUS | Mode | char | 1 | 0 | | | | Allow NULL? |
| 56 | STORKZ | Indicator Rebate Cancellation | char | 1 | 0 | | | | Allow NULL? |
| 57 | ARCHKZ | Status Archiving Log Table Rebate | char | 1 | 0 | | | | Allow NULL? |
| 58 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 59 | ERZET | Entry time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 60 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 61 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 62 | AEZET | Time last change was made | nvarchar | 6 | 0 | | | | Allow NULL? |
| 63 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
