| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KAPPL | Application | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | KSCHL | Condition type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | KRECH | Calculation type for condition | char | 1 | 0 | | | | Allow NULL? |
| 5 | KZBZG | Scale basis indicator | char | 1 | 0 | | | | Allow NULL? |
| 6 | KNTYP | Condition category (examples: tax, freight, price, cost) | char | 1 | 0 | | | | Allow NULL? |
| 7 | KONAU | Condition is mandatory | char | 1 | 0 | | | | Allow NULL? |
| 8 | KMANU | Making manual entries | char | 1 | 0 | | | | Allow NULL? |
| 9 | GRZGF | Access sequence for the group key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | GRLNR | Routine number for creating group key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | GRMEN | Scale unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | GANZZ | Indicator: Currency Translation after Multiplication | char | 1 | 0 | | | | Allow NULL? |
| 13 | KGRPE | Group condition | char | 1 | 0 | | | | Allow NULL? |
| 14 | KRELI | Condition for invoice list | char | 1 | 0 | | | | Allow NULL? |
| 15 | KDUPL | Structure condition | char | 1 | 0 | | | | Allow NULL? |
| 16 | KRUEK | Condition is Relevant for Accrual (e.g. Freight) | char | 1 | 0 | | | | Allow NULL? |
| 17 | KOUPD | Condition update | char | 1 | 0 | | | | Allow NULL? |
| 18 | SOSTA | Special form for scale determination | char | 1 | 0 | | | | Allow NULL? |
| 19 | KOFRS | Formula for scale base value | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | KALSM | Sales and Distribution: Pricing Procedure in Pricing | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | KZNEP | Condition exclusion indicator | char | 1 | 0 | | | | Allow NULL? |
| 22 | KOAID | Condition class | char | 1 | 0 | | | | Allow NULL? |
| 23 | KKOPF | Condition applies to header | char | 1 | 0 | | | | Allow NULL? |
| 24 | KPOSI | Condition applies to items | char | 1 | 0 | | | | Allow NULL? |
| 25 | KNEGA | Plus/minus sign of the condition amount | char | 1 | 0 | | | | Allow NULL? |
| 26 | TXPRF | Rounding rule | char | 1 | 0 | | | | Allow NULL? |
| 27 | KSTPR | Checking rule for scale rates | char | 1 | 0 | | | | Allow NULL? |
| 28 | KAEND_BTR | Condition rate of change for amount/percentage | char | 1 | 0 | | | | Allow NULL? |
| 29 | KAEND_WRT | Scope for changing the value | char | 1 | 0 | | | | Allow NULL? |
| 30 | KAEND_UFK | Scope for changing conversion factors | char | 1 | 0 | | | | Allow NULL? |
| 31 | KAEND_RCH | Calculation type can be changed | char | 1 | 0 | | | | Allow NULL? |
| 32 | KAEND_LOE | Delete the scope for changing rate | char | 1 | 0 | | | | Allow NULL? |
| 33 | KAEND_MEH | Condition scope of change for unit of measure | char | 1 | 0 | | | | Allow NULL? |
| 34 | IDXUP | Update condition index | char | 1 | 0 | | | | Allow NULL? |
| 35 | RUKOR | Rebate: Accruals correction procedure | char | 1 | 0 | | | | Allow NULL? |
| 36 | BOVER | Rebate procedure | char | 1 | 0 | | | | Allow NULL? |
| 37 | KPRDT | Pricing date | char | 1 | 0 | | | | Allow NULL? |
| 38 | STFKZ | Scale Type | char | 1 | 0 | | | | Allow NULL? |
| 39 | PRECH | Period Condition Calculation Rule | char | 1 | 0 | | | | Allow NULL? |
| 40 | BNKWE | Enter vendor for delivery costs in goods receipt document | char | 1 | 0 | | | | Allow NULL? |
| 41 | AKTKO | Condition Type for Promotions | char | 1 | 0 | | | | Allow NULL? |
| 42 | VKKAL | Sales Price Calculation: Relevant to pricing | char | 1 | 0 | | | | Allow NULL? |
| 43 | VKOBL | SP Calculation: "Relevant to pricing" ID can be changed | char | 1 | 0 | | | | Allow NULL? |
| 44 | RKAPPL | Reference application | nvarchar | 2 | 0 | | | | Allow NULL? |
| 45 | RKSCHL | Reference condition type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 46 | BERGL | Calculation Base | char | 1 | 0 | | | | Allow NULL? |
| 47 | VHART | Packaging Material Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 48 | RDIFA | Rounding difference comparison | char | 1 | 0 | | | | Allow NULL? |
| 49 | KFKIV | Condition for inter-company billing | char | 1 | 0 | | | | Allow NULL? |
| 50 | KVARC | Condition for configuration | char | 1 | 0 | | | | Allow NULL? |
| 51 | KMENG | Quantity conversion | char | 1 | 0 | | | | Allow NULL? |
| 52 | MDFLG | Indicator: Matrix maintenance | char | 1 | 0 | | | | Allow NULL? |
| 53 | KTREL | Relevance for account assignment | char | 1 | 0 | | | | Allow NULL? |
| 54 | BNKTK | Copy delivery costs from shipment costs document | char | 1 | 0 | | | | Allow NULL? |
| 55 | KFRST | Release status | char | 1 | 0 | | | | Allow NULL? |
| 56 | TXTGR | Text determination procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 57 | TDID | Text ID for text edit control | nvarchar | 4 | 0 | | | | Allow NULL? |
| 58 | KDELE | Condition records should be deleted from the database | char | 1 | 0 | | | | Allow NULL? |
| 59 | KBFLAG | Bit encrypted flags in Pricing | varbinary | 2 | 0 | | | | |
| 60 | PURP | Condition Function | nvarchar | 4 | 0 | | | | Allow NULL? |
| 61 | DTASRC | Primary Data Record Source for a Condition Record | nvarchar | 2 | 0 | | | | Allow NULL? |
| 62 | IS_CPF_ENABLED | Condition Enabled for Config. Parameters and Formulas (CPF) | char | 1 | 0 | | | | Allow NULL? |
| 63 | IS_QTYCNVFCT_ENABLED | Agreed Conversion Factors Are Allowed | char | 1 | 0 | | | | Allow NULL? |
| 64 | OIGRNET | Gross/net pricing indicator | char | 1 | 0 | | | | Allow NULL? |
| 65 | OIINVCYC | Invoice cycle | char | 1 | 0 | | | | Allow NULL? |
| 66 | OIREPORT | Report number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 67 | OIHEAD | Header format routine for second level analysis report | nvarchar | 3 | 0 | | | | Allow NULL? |
| 68 | OIITEM | Item routine for second level analysis report | nvarchar | 3 | 0 | | | | Allow NULL? |
| 69 | OIERRHAN | Error handling routine for second level analysis | nvarchar | 3 | 0 | | | | Allow NULL? |
| 70 | OIDATA | Routine number for data capture | nvarchar | 3 | 0 | | | | Allow NULL? |
| 71 | OIA_SPLTIV | Indicator for split invoice verification | char | 1 | 0 | | | | Allow NULL? |
| 72 | OIRCONDCL | SSR PC: Condition classification | char | 1 | 0 | | | | Allow NULL? |
| 73 | OIU_EP | Exploration and Production condition (PRA) | char | 1 | 0 | | | | Allow NULL? |
| 74 | WTY_KONDM | Material Pricing Group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 75 | WTY_KATEG | Category | nvarchar | 2 | 0 | | | | Allow NULL? |
