| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KNUMV | Number of the document condition | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | KPOSN | Condition item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | STUNR | Step number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | ZAEHK | Condition counter | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | KAPPL | Application | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | KSCHL | Condition type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | KDATU | Condition pricing date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | KRECH | Calculation type for condition | char | 1 | 0 | | | | Allow NULL? |
| 10 | KAWRT | Condition base value | decimal | 15 | 2 | | | | |
| 11 | KBETR | Rate (condition amount or percentage) | decimal | 11 | 2 | | | | |
| 12 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 13 | KKURS | Condition exchange rate for conversion to local currency | decimal | 9 | 5 | | | | |
| 14 | KPEIN | Condition pricing unit | decimal | 5 | 0 | | | | |
| 15 | KMEIN | Condition unit in the document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | KUMZA | Numerator for converting condition units to base units | decimal | 5 | 0 | | | | |
| 17 | KUMNE | Denominator for converting condition units to base units | decimal | 5 | 0 | | | | |
| 18 | KNTYP | Condition category (examples: tax, freight, price, cost) | char | 1 | 0 | | | | Allow NULL? |
| 19 | KSTAT | Condition is used for statistics | char | 1 | 0 | | | | Allow NULL? |
| 20 | KNPRS | Pricing type | char | 1 | 0 | | | | Allow NULL? |
| 21 | KRUEK | Condition is Relevant for Accrual (e.g. Freight) | char | 1 | 0 | | | | Allow NULL? |
| 22 | KRELI | Condition for invoice list | char | 1 | 0 | | | | Allow NULL? |
| 23 | KHERK | Origin of the condition | char | 1 | 0 | | | | Allow NULL? |
| 24 | KGRPE | Group condition | char | 1 | 0 | | | | Allow NULL? |
| 25 | KOUPD | Condition update | char | 1 | 0 | | | | Allow NULL? |
| 26 | KOLNR | Access sequence - Access number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | KNUMH | Condition record number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | KOPOS | Sequential number of the condition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | KVSL1 | Account key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | MWSK1 | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | KVSL2 | Account key - accruals / provisions | nvarchar | 3 | 0 | | | | Allow NULL? |
| 33 | SAKN2 | G/L Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | MWSK2 | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 36 | KUNNR | Customer number (rebate recipient) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | KDIFF | Rounding-off difference of the condition | decimal | 5 | 2 | | | | |
| 38 | KWERT | Condition value | decimal | 13 | 2 | | | | |
| 39 | KSTEU | Condition control | char | 1 | 0 | | | | Allow NULL? |
| 40 | KINAK | Condition is inactive | char | 1 | 0 | | | | Allow NULL? |
| 41 | KOAID | Condition class | char | 1 | 0 | | | | Allow NULL? |
| 42 | ZAEKO | Condition counter for (header conditions) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 43 | KMXAW | Indicator for maximum condition base value | char | 1 | 0 | | | | Allow NULL? |
| 44 | KMXWR | Indicator for maximum condition amount | char | 1 | 0 | | | | Allow NULL? |
| 45 | OIKOSTL | Cost center for fee expense accounting | nvarchar | 10 | 0 | | | | Allow NULL? |
| 46 | OIACPOL | Fee accounting policy indicator | char | 1 | 0 | | | | Allow NULL? |
| 47 | OIFEEMAN | Fee rate indicator | char | 1 | 0 | | | | Allow NULL? |
| 48 | OIKWERT | Fee detail clearing amount | decimal | 13 | 2 | | | | |
| 49 | OIFEEPRT | Condition is printed at item level | char | 1 | 0 | | | | Allow NULL? |
| 50 | OIGRNET | Gross/net pricing indicator | char | 1 | 0 | | | | Allow NULL? |
| 51 | OIGNSTRA | Gross/net pricing strategy used | char | 1 | 0 | | | | Allow NULL? |
| 52 | OIGRCHK | Carry out gross/net unit check | char | 1 | 0 | | | | Allow NULL? |
| 53 | OIINVCYC | Invoice cycle | char | 1 | 0 | | | | Allow NULL? |
| 54 | OIINVCYACT | Invoice cycle included indicator active (X/ ) | char | 1 | 0 | | | | Allow NULL? |
| 55 | OIINCYST | Cond. statistical due to invoicing cycle | char | 1 | 0 | | | | Allow NULL? |
| 56 | OIA_SPLTIV | Indicator for split invoice verification | char | 1 | 0 | | | | Allow NULL? |
| 57 | OIA_ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 58 | KFAKTOR | Factor for condition base value | float | 15 | 16 | | | | |
| 59 | KDUPL | Structure condition | char | 1 | 0 | | | | Allow NULL? |
| 60 | KFAKTOR1 | Factor for condition basis (period) | float | 15 | 16 | | | | |
| 61 | OILICIN | Excise tax internal license number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 62 | OILICTP | License type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 63 | OIREPORT | Report number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 64 | OIDATA | Routine number for data capture | nvarchar | 3 | 0 | | | | Allow NULL? |
| 65 | OIHEAD | Header format routine for second level analysis report | nvarchar | 3 | 0 | | | | Allow NULL? |
| 66 | OIITEM | Item routine for second level analysis report | nvarchar | 3 | 0 | | | | Allow NULL? |
| 67 | OIERRHAN | Error handling routine for second level analysis | nvarchar | 3 | 0 | | | | Allow NULL? |
| 68 | KZBZG | Scale basis indicator | char | 1 | 0 | | | | Allow NULL? |
| 69 | KSTBS | Scale base value of the condition | decimal | 15 | 2 | | | | |
| 70 | KONMS | Condition scale unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 71 | KONWS | Scale currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 72 | KAWRT_K | Condition base value | decimal | 15 | 2 | | | | |
| 73 | KWAEH | Condition currency (for cumulation fields) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 74 | KWERT_K | Condition value | decimal | 13 | 2 | | | | |
