| 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 | 3 | 0 | | | | Allow NULL? |
| 3 | KSCHL | Pricing - Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | KRECH | Calculation Type for Condition | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | KZBZG | Indicator: Scale Base Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | STFKZ | Scale Type of a Condition | char | 1 | 0 | | | | Allow NULL? |
| 7 | KNTYP | Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost | char | 1 | 0 | | | | Allow NULL? |
| 8 | KGRPE | Condition is Group Condition | char | 1 | 0 | | | | Allow NULL? |
| 9 | KDUPL | Structure Condition | char | 1 | 0 | | | | Allow NULL? |
| 10 | KRUEK | Accruals are Set up for the Condition (e.g. Freight) | char | 1 | 0 | | | | Allow NULL? |
| 11 | KOAID | Condition Class | char | 1 | 0 | | | | Allow NULL? |
| 12 | KFKIV | Condition for Inter-Company Billing | char | 1 | 0 | | | | Allow NULL? |
| 13 | KVARC | Condition for Configuration | char | 1 | 0 | | | | Allow NULL? |
| 14 | KTREL | Relevance for Account Assignment | char | 1 | 0 | | | | Allow NULL? |
| 15 | KBFLAG | Bit Encrypted Flags in Pricing | varbinary | 2 | 0 | | | | |
| 16 | DTASRC | Primary Data Record Source for a Condition Record | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | KRELI | Invoice List Condition Flag | char | 1 | 0 | | | | Allow NULL? |
| 18 | KOUPD | Condition Update Flag | char | 1 | 0 | | | | Allow NULL? |
| 19 | KMANU | Give Way Rule for Manual Entries (KMANU) | char | 1 | 0 | | | | Allow NULL? |
| 20 | GANZZ | Indicator: Currency Conversion after Multiplication | char | 1 | 0 | | | | Allow NULL? |
| 21 | KOFRS | Scale Basis Formula | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | KOFRS_NUM | Scale Basis Formula IPC | nvarchar | 7 | 0 | | | | Allow NULL? |
| 23 | KNEGA | Plus/Minus Sign of the Condition Amount | char | 1 | 0 | | | | Allow NULL? |
| 24 | TXPRF | Rounding Rule | char | 1 | 0 | | | | Allow NULL? |
| 25 | KAEND_BTR | Condition Rate of Change for Amount/Percentage | char | 1 | 0 | | | | Allow NULL? |
| 26 | KAEND_WRT | Scope for Changing the Value | char | 1 | 0 | | | | Allow NULL? |
| 27 | KAEND_UFK | Scope for Changing Conversion Factors | char | 1 | 0 | | | | Allow NULL? |
| 28 | KAEND_RCH | Condition Rate of Change for Calculation Type | char | 1 | 0 | | | | Allow NULL? |
| 29 | KAEND_LOE | Delete the Scope for Changing Rate | char | 1 | 0 | | | | Allow NULL? |
| 30 | KAEND_MEH | Condition Scope of Change for Unit of Measure | char | 1 | 0 | | | | Allow NULL? |
| 31 | BERGL | Calculation Base | char | 1 | 0 | | | | Allow NULL? |
| 32 | RDIFA | Rounding Difference Clearing | char | 1 | 0 | | | | Allow NULL? |
| 33 | KMENG | Quantity Conversion | char | 1 | 0 | | | | Allow NULL? |
| 34 | KKOPF | Flag 'Condition is Condition' | char | 1 | 0 | | | | Allow NULL? |
| 35 | KPOSI | Condition is Item Condition | char | 1 | 0 | | | | Allow NULL? |
| 36 | PURP | Condition Function | nvarchar | 4 | 0 | | | | Allow NULL? |
| 37 | USE_HOLIDAYS | exclude holidays for time-dependent conditions | char | 1 | 0 | | | | Allow NULL? |
| 38 | GRLNR | Group Key Routine | nvarchar | 20 | 0 | | | | Allow NULL? |
| 39 | GRLNR_NUM | Group Key Routine IPC | nvarchar | 7 | 0 | | | | Allow NULL? |
| 40 | GRMEN | Condition Scale Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 41 | KSTPR | Checking Rule for Scale Rates | char | 1 | 0 | | | | Allow NULL? |
| 42 | IDXUP | Update Condition Index | char | 1 | 0 | | | | Allow NULL? |
| 43 | KPRDT | Pricing Date (KPRDT) | char | 1 | 0 | | | | Allow NULL? |
| 44 | PRECH | Period Condition Calculation Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 45 | KFRST | Release Status | char | 1 | 0 | | | | Allow NULL? |
| 46 | KDELE | Condition Records Should be Deleted from the Database | char | 1 | 0 | | | | Allow NULL? |
| 47 | RKSCHL | Pricing - Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 48 | DATA_ORIGIN | Data source system | nvarchar | 10 | 0 | | | | Allow NULL? |
| 49 | BOVER | Rebate Procedure | char | 1 | 0 | | | | Allow NULL? |
| 50 | DETERMINE_SCALE | Application of scales | char | 1 | 0 | | | | Allow NULL? |
