| 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 | KNUMV | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KNUMV | Allow NULL? |
| 3 | KPOSN | Condition item number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | KPOSN | Allow NULL? |
| 4 | STUNR | Step number | nvarchar | 3 | 0 | NUMC | (N'000') | No | * | STUNR | Allow NULL? |
| 5 | ZAEHK | Condition counter | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DZAEHK | Allow NULL? |
| 6 | KAPPL | Application | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T681A | KAPPL | Allow NULL? |
| 7 | KSCHL | Condition type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KSCHA | Allow NULL? |
| 8 | KDATU | Condition pricing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KDATU | Allow NULL? |
| 9 | KRECH | Calculation type for condition | char | 1 | 0 | CHAR | (N' ') | Yes | | KRECH | Allow NULL? |
| 10 | KAWRT | Condition base value | decimal | 15 | 2 | CURR | ((0)) | Yes | | KAWRT | |
| 11 | KBETR | Rate (condition amount or percentage) | decimal | 11 | 2 | CURR | ((0)) | Yes | | KBETR | |
| 12 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 13 | KKURS | Condition exchange rate for conversion to local currency | decimal | 9 | 5 | DEC | ((0)) | Yes | | KKURS | |
| 14 | KPEIN | Condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | KPEIN | |
| 15 | KMEIN | Condition unit in the document | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | KVMEI | Allow NULL? |
| 16 | KUMZA | Numerator for converting condition units to base units | decimal | 5 | 0 | DEC | ((0)) | Yes | | KUMZA | |
| 17 | KUMNE | Denominator for converting condition units to base units | decimal | 5 | 0 | DEC | ((0)) | Yes | | KUMNE | |
| 18 | KNTYP | Condition category (examples: tax, freight, price, cost) | char | 1 | 0 | CHAR | (N' ') | Yes | | KNTYP | Allow NULL? |
| 19 | KSTAT | Condition is used for statistics | char | 1 | 0 | CHAR | (N' ') | Yes | | KSTAT | Allow NULL? |
| 20 | KNPRS | Scale Type | char | 1 | 0 | CHAR | (N' ') | Yes | | STFKZ | Allow NULL? |
| 21 | KRUEK | Condition is Relevant for Accrual (e.g. Freight) | char | 1 | 0 | CHAR | (N' ') | Yes | | KRUEK | Allow NULL? |
| 22 | KRELI | Condition for invoice list | char | 1 | 0 | CHAR | (N' ') | Yes | | KRELI | Allow NULL? |
| 23 | KHERK | Origin of the condition | char | 1 | 0 | CHAR | (N' ') | Yes | | KHERK | Allow NULL? |
| 24 | KGRPE | Group condition | char | 1 | 0 | CHAR | (N' ') | Yes | | KGRPE | Allow NULL? |
| 25 | KOUPD | Condition update | char | 1 | 0 | CHAR | (N' ') | Yes | | KOUPD | Allow NULL? |
| 26 | KOLNR | Access sequence - Access number | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | KOLNR | Allow NULL? |
| 27 | KNUMH | Condition record number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMH | Allow NULL? |
| 28 | KOPOS | Sequential number of the condition | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | KOPOS | Allow NULL? |
| 29 | KVSL1 | Account key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T687 | KVSL1 | Allow NULL? |
| 30 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | SAKNR | Allow NULL? |
| 31 | MWSK1 | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 32 | KVSL2 | Account key - accruals / provisions | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T687 | KVSL2 | Allow NULL? |
| 33 | SAKN2 | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | SAKNR | Allow NULL? |
| 34 | MWSK2 | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 35 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LIFNR | Allow NULL? |
| 36 | KUNNR | Customer number (rebate recipient) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNNR_KO | Allow NULL? |
| 37 | KDIFF | Rounding-off difference of the condition | decimal | 5 | 2 | CURR | ((0)) | Yes | | KDIFF | |
| 38 | KWERT | Condition value | decimal | 13 | 2 | CURR | ((0)) | Yes | | KWERT | |
| 39 | KSTEU | Condition control | char | 1 | 0 | CHAR | (N' ') | Yes | | KSTEU | Allow NULL? |
| 40 | KINAK | Condition is inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | KINAK | Allow NULL? |
| 41 | KOAID | Condition class | char | 1 | 0 | CHAR | (N' ') | Yes | | KOAID | Allow NULL? |
| 42 | ZAEKO | Condition counter for (header conditions) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DZAEKO | Allow NULL? |
| 43 | KMXAW | Indicator for maximum condition base value | char | 1 | 0 | CHAR | (N' ') | Yes | | KMXAW | Allow NULL? |
| 44 | KMXWR | Indicator for maximum condition amount | char | 1 | 0 | CHAR | (N' ') | Yes | | KMXWR | Allow NULL? |
| 45 | KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | KALSM_D | Allow NULL? |
