| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KNUMD | Condition record number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | ZUSKO | Number of additional condition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | KSCHL | Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | KNUMB | Rebate data number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | KNUMK | Account assignment number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | KNUMT | Number of texts | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | KNUMS | Number of scale values | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | KNUM1 | Number of the line scale (scaling) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | STFKZ | Scale Type | char | 1 | 0 | | | | Allow NULL? |
| 13 | KZBZG | Scale basis indicator | char | 1 | 0 | | | | Allow NULL? |
| 14 | KONBE | Scale basis (unit of measure) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | KNUM2 | Number of column scale | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | STFK2 | Scale Type | char | 1 | 0 | | | | Allow NULL? |
| 17 | KZBZ2 | Scale basis indicator | char | 1 | 0 | | | | Allow NULL? |
| 18 | KONB2 | Scale basis (unit of measure) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | KRECH | Calculation type for condition | char | 1 | 0 | | | | Allow NULL? |
| 20 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | KMEIN | Condition unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | KPEIN | Condition pricing unit | decimal | 5 | 0 | | | | |
| 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 | KWAEH | Condition currency (for cumulation fields) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | KSKTO | Condition is qualifying for cash discount | char | 1 | 0 | | | | Allow NULL? |
| 27 | KNTYP | Condition category (examples: tax, freight, price, cost) | char | 1 | 0 | | | | Allow NULL? |
| 28 | KMWST | Condition VAT indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | KSTAT | Condition is used for statistics | char | 1 | 0 | | | | Allow NULL? |
| 30 | KNPRS | Pricing type | char | 1 | 0 | | | | Allow NULL? |
| 31 | KRUEK | Condition is Relevant for Accrual (e.g. Freight) | char | 1 | 0 | | | | Allow NULL? |
| 32 | KRELI | Condition for invoice list | char | 1 | 0 | | | | Allow NULL? |
| 33 | KMANU | Making manual entries | char | 1 | 0 | | | | Allow NULL? |
| 34 | KGRPE | Group condition | char | 1 | 0 | | | | Allow NULL? |
| 35 | KAUFT | Absolute condition is to be split up | char | 1 | 0 | | | | Allow NULL? |
| 36 | MXWRT | Lower limit of the condition rate/amount | decimal | 11 | 2 | | | | |
| 37 | GKWRT | Upper limit for the condition rate | decimal | 11 | 2 | | | | |
| 38 | PKWRT | Planned condition value | decimal | 15 | 2 | | | | |
| 39 | FKWRT | Cumulative guaranteed discount (not used) | decimal | 15 | 2 | | | | |
| 40 | RSWRT | Accumulated accruals values (not used) | decimal | 15 | 2 | | | | |
| 41 | UKBAS | Planned condition basis | decimal | 15 | 2 | | | | |
| 42 | PRBAS | Price basis | decimal | 11 | 2 | | | | |
| 43 | KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 44 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 45 | KONKZ | Account assignment allowed | char | 1 | 0 | | | | Allow NULL? |
| 46 | KZNEP | Condition exclusion indicator | char | 1 | 0 | | | | Allow NULL? |
| 47 | KOUPD | Condition update | char | 1 | 0 | | | | Allow NULL? |
| 48 | STBAS | Accumulated scale base (from settlement run) | decimal | 15 | 2 | | | | |
| 49 | KOBAS | Cumulative condition basis (from settlement run) | decimal | 15 | 2 | | | | |
| 50 | GRUMS | Minimum business volume | decimal | 15 | 2 | | | | |
| 51 | MAXRA | Maximum discount from total sales volume | decimal | 11 | 2 | | | | |
| 52 | AUBET | Payment amount | decimal | 11 | 2 | | | | |
| 53 | ABRBG | Start of accounting settlement period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 54 | ABREN | End of accounting settlement period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 55 | KWRTA | Payment amount | decimal | 11 | 2 | | | | |
| 56 | KWRTR | Accrual Amount | decimal | 11 | 2 | | | | |
| 57 | KVSL1 | Account key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 58 | KVSL2 | Account key - accruals / provisions | nvarchar | 3 | 0 | | | | Allow NULL? |
| 59 | KSTBS | Scale base value of the condition | decimal | 15 | 2 | | | | |
| 60 | KBETR | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | | | | |
