| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KNUMV | Pricing Document GUID | varbinary | 16 | 0 | | | | |
| 3 | KPOSN | Item Number | varbinary | 16 | 0 | | | | |
| 4 | STUNR | Level Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | ZAEHK | Condition Counter | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | KSCHL | Pricing - Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | KSTAT | Condition is Statistical | char | 1 | 0 | | | | Allow NULL? |
| 8 | KVSL1 | Account Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | KVSL2 | Account Key - Accruals | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | KVEWE | Usage for Condition Technique | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | KRECH | Calculation Type for Condition | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | KZBZG | Indicator: Scale Base Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | STFKZ | Scale Type of a Condition | char | 1 | 0 | | | | Allow NULL? |
| 14 | KNTYP | Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost | char | 1 | 0 | | | | Allow NULL? |
| 15 | KGRPE | Condition is Group Condition | char | 1 | 0 | | | | Allow NULL? |
| 16 | KDUPL | Structure Condition | char | 1 | 0 | | | | Allow NULL? |
| 17 | KRUEK | Accruals are Set up for the Condition (e.g. Freight) | char | 1 | 0 | | | | Allow NULL? |
| 18 | KOAID | Condition Class | char | 1 | 0 | | | | Allow NULL? |
| 19 | KFKIV | Condition for Inter-Company Billing | char | 1 | 0 | | | | Allow NULL? |
| 20 | KVARC | Condition for Configuration | char | 1 | 0 | | | | Allow NULL? |
| 21 | KTREL | Relevance for Account Assignment | char | 1 | 0 | | | | Allow NULL? |
| 22 | KBFLAG | Bit Encrypted Flags in Pricing | varbinary | 2 | 0 | | | | |
| 23 | DTASRC | Primary Data Record Source for a Condition Record | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | KRELI | Invoice List Condition Flag | char | 1 | 0 | | | | Allow NULL? |
| 25 | KOUPD | Condition Update Flag | char | 1 | 0 | | | | Allow NULL? |
| 26 | KAPPL | Application | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | KAWRT | Price Determination: Condition Basis | decimal | 18 | 5 | | | | |
| 28 | KHERK | Condition Origin | char | 1 | 0 | | | | Allow NULL? |
| 29 | KDIFF | Rounding-Off Difference of the Condition | decimal | 5 | 2 | | | | |
| 30 | KWERT | Price Determination: Condition Value | decimal | 15 | 2 | | | | |
| 31 | KSTEU | Condition Control | char | 1 | 0 | | | | Allow NULL? |
| 32 | KINAK | Condition is Inactive | char | 1 | 0 | | | | Allow NULL? |
| 33 | ZAEKO | Condition Counter (Header) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | KFAKTOR1 | Correction Factor for Condition Basis (Interval Scale) | float | 15 | 16 | | | | |
| 35 | KMPRS | Indicator: Condition Manually Changed | char | 1 | 0 | | | | Allow NULL? |
| 36 | KWAEH | Second Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 37 | KWERT_K | Second Condition Value | decimal | 15 | 2 | | | | |
| 38 | KAWRT_K | Second Condition Basis | decimal | 18 | 5 | | | | |
| 39 | KSTBS | Pricing: Scale Basis | decimal | 18 | 5 | | | | |
| 40 | KDATU | Condition Pricing Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | WAERS | Condition Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 42 | KKURS | Condition Exchange Rate for Conversion to Local Currency | decimal | 9 | 5 | | | | |
| 43 | KFAKTOR | Correction Factor for Conditions From Configuration | float | 15 | 16 | | | | |
| 44 | PRSQU | Price Source | char | 1 | 0 | | | | Allow NULL? |
| 45 | VARCOND | Variant Key of a Variant Condition | nvarchar | 26 | 0 | | | | Allow NULL? |
| 46 | TXJLV | Tax Jurisdiction Code Level | char | 1 | 0 | | | | Allow NULL? |
| 47 | DTASRC2 | Secondary Data Record Source for a Condition Record | nvarchar | 2 | 0 | | | | Allow NULL? |
| 48 | KNUMH | ID of a Condition Record | varbinary | 16 | 0 | | | | |
| 49 | KBETR | Condition Rate | decimal | 15 | 2 | | | | |
| 50 | KPEIN | Condition Pricing Unit | decimal | 5 | 0 | | | | |
| 51 | KMEIN | Condition Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 52 | KUMZA | Counter for Conversion to Base Unit of Measure | int | 10 | 0 | | | | Allow NULL? |
| 53 | KUMNE | Denominator for Conversion to Base Unit of Measure | int | 10 | 0 | | | | Allow NULL? |
| 54 | EXPNT | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | | | |
| 55 | MWSK1 | Sales Tax Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 56 | MWSK2 | Withholding Tax Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 57 | KONMS | Condition Scale Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 58 | KONWS | Currency Key: Condition Scale | nvarchar | 5 | 0 | | | | Allow NULL? |
| 59 | DUMMY | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |
| 60 | KOTABNR | Condition Table | nvarchar | 8 | 0 | | | | Allow NULL? |
