| 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 | KOPOS | Sequential number of the condition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | KAPPL | Application | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | KSCHL | Condition type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | KNUMT | Number of texts | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | STFKZ | Scale Type | char | 1 | 0 | | | | Allow NULL? |
| 8 | KZBZG | Scale basis indicator | char | 1 | 0 | | | | Allow NULL? |
| 9 | KSTBM | Condition scale quantity | decimal | 15 | 3 | | | | |
| 10 | KONMS | Condition scale unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | KSTBW | Scale value | decimal | 15 | 2 | | | | |
| 12 | KONWS | Scale currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 13 | KRECH | Calculation type for condition | char | 1 | 0 | | | | Allow NULL? |
| 14 | KBETR | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | | | | |
| 15 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | KPEIN | Condition pricing unit | decimal | 5 | 0 | | | | |
| 17 | KMEIN | Condition unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | PRSCH | Price levels | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | KUMZA | Numerator for converting condition units to base units | decimal | 5 | 0 | | | | |
| 20 | KUMNE | Denominator for converting condition units to base units | decimal | 5 | 0 | | | | |
| 21 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | MXWRT | Lower limit of the condition rate/amount | decimal | 11 | 2 | | | | |
| 23 | GKWRT | Upper limit for the condition rate | decimal | 11 | 2 | | | | |
| 24 | PKWRT | Planned condition value | decimal | 15 | 2 | | | | |
| 25 | FKWRT | Cumulative guaranteed discount (not used) | decimal | 15 | 2 | | | | |
| 26 | RSWRT | Accumulated accruals values (not used) | decimal | 15 | 2 | | | | |
| 27 | KWAEH | Condition currency (for cumulation fields) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | UKBAS | Planned condition basis | decimal | 15 | 2 | | | | |
| 29 | KZNEP | Condition exclusion indicator | char | 1 | 0 | | | | Allow NULL? |
| 30 | KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | MWSK1 | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | LOEVM_KO | Deletion Indicator for Condition Item | char | 1 | 0 | | | | Allow NULL? |
| 34 | ZAEHK_IND | Condition item index | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | BOMAT | Material for rebate settlement | nvarchar | 18 | 0 | | | | Allow NULL? |
| 36 | KBRUE | Accrual Amount | decimal | 11 | 2 | | | | |
| 37 | KSPAE | Rebate was set up retroactively | char | 1 | 0 | | | | Allow NULL? |
| 38 | BOSTA | Status of the agreement | char | 1 | 0 | | | | Allow NULL? |
| 39 | KNUMA_PI | Promotion | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | KNUMA_AG | Sales deal | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | KNUMA_SQ | Sales quote | nvarchar | 10 | 0 | | | | Allow NULL? |
| 42 | VALTG | Additional value days | nvarchar | 2 | 0 | | | | Allow NULL? |
| 43 | VALDT | Fixed value date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | ANZAUF | Maximum number of sales orders per condition record | nvarchar | 2 | 0 | | | | Allow NULL? |
| 46 | MIKBAS | Minimum condition base value | decimal | 15 | 3 | | | | |
| 47 | MXKBAS | Maximum condition base value | decimal | 15 | 3 | | | | |
| 48 | KOMXWRT | Maximum condition value | decimal | 13 | 2 | | | | |
| 49 | KLF_STG | Number of incremental scale | nvarchar | 4 | 0 | | | | Allow NULL? |
| 50 | KLF_KAL | Scale number for pricing | nvarchar | 4 | 0 | | | | Allow NULL? |
| 51 | VKKAL | Sales Price Calculation: Relevant to pricing | char | 1 | 0 | | | | Allow NULL? |
| 52 | AKTNR | Promotion | nvarchar | 10 | 0 | | | | Allow NULL? |
| 53 | KNUMA_BO | Agreement (subsequent settlement) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 54 | MWSK2 | Withholding tax code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 55 | VERTT | Contract Type | char | 1 | 0 | | | | Allow NULL? |
| 56 | VERTN | Contract Number | nvarchar | 13 | 0 | | | | Allow NULL? |
| 57 | VBEWA | Flow Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 58 | /BEV1/ECRTT | Contract Type | char | 1 | 0 | | | | Allow NULL? |
| 59 | /BEV1/ECRTN | Contract Number | nvarchar | 13 | 0 | | | | Allow NULL? |
| 60 | /BEV1/ECEWA | Flow Type | nvarchar | 4 | 0 | | | | Allow NULL? |
