The KONV table in SAP ERP or S/4HANA stores Conditions (Obsolete – replaced by PRCD_ELEMENTS) data. There are total 71 fields in KONV table. The Conditions (Obsolete – replaced by PRCD_ELEMENTS) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of KONV table. It is in Central Pricing Routines (VF_PRC_CORE) ABAP package and is part of the Pricing and Conditions (SD-BF-PR) module.
SAP KONV Table Fields
Following is the list of fields that are available in SAP KONV table. The primary key fields of the table are MANDT (Client), KNUMV (Number of the Document Condition), KPOSN (Condition item number), STUNR (Step Number), ZAEHK (Condition Counter).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| KNUMV | Number of the Document Condition | KNUMV | CHAR (10) | |
| KPOSN | Condition item number | KPOSN | NUMC (6) | |
| STUNR | Step Number | STUNR | NUMC (3) | |
| ZAEHK | Condition Counter | DZAEHK | NUMC (3) | |
| KAPPL | Application | KAPPL | T681A | CHAR (2) |
| KSCHL | Condition type | KSCHA | CHAR (4) | |
| KDATU | Condition Pricing Date | KDATU | DATS (8) | |
| KRECH | Calculation Type for Condition | KRECH | CHAR (1) | |
| KAWRT | Condition Basis | KAWRT | CURR (15) | |
| KBETR | Condition Amount or Percentage | KBETR | CURR (11) | |
| WAERS | Currency Key | WAERS | TCURC | CUKY (5) |
| KKURS | Condition exchange rate for conversion to local currency | KKURS | DEC (9) | |
| KPEIN | Condition Pricing Unit | KPEIN | DEC (5) | |
| KMEIN | Condition Unit in the Document | KVMEI | T006 | UNIT (3) |
| KUMZA | Numerator for converting condition units to base units | KUMZA | DEC (5) | |
| KUMNE | Denominator for converting condition units to base units | KUMNE | DEC (5) | |
| KNTYP | Condition Category (Examples: Tax, Freight, Price, Cost) | KNTYP | CHAR (1) | |
| KSTAT | Condition is used for statistics | KSTAT | CHAR (1) | |
| KNPRS | Scale Type | STFKZ | CHAR (1) | |
| KRUEK | Condition is Relevant for Accrual (e.g. Freight) | KRUEK | CHAR (1) | |
| KRELI | Condition for Invoice List | KRELI | CHAR (1) | |
| KHERK | Origin of the Condition | KHERK | CHAR (1) | |
| KGRPE | Group Condition | KGRPE | CHAR (1) | |
| KOUPD | Condition Update | KOUPD | CHAR (1) | |
| KOLNR | Access sequence – Access number | KOLNR | NUMC (3) | |
| KNUMH | Number of the Condition Record | KNUMH | CHAR (10) | |
| KOPOS | Sequential number of the condition | KOPOS | NUMC (2) | |
| KVSL1 | Account Key | KVSL1 | T687 | CHAR (3) |
| SAKN1 | G/L Account Number | SAKNR | SKA1 | CHAR (10) |
| MWSK1 | Tax on sales/purchases code | MWSKZ | CHAR (2) | |
| KVSL2 | Account Key – Accruals / Provisions | KVSL2 | T687 | CHAR (3) |
| SAKN2 | Number of Accruals Account | SAKNR_ACCR | SKA1 | CHAR (10) |
| MWSK2 | Withholding Tax Code | WT_WITHCD | CHAR (2) | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR (10) |
| KUNNR | Customer number (rebate recipient) | KUNNR_KO | KNA1 | CHAR (10) |
| KDIFF | Rounding-Off Difference of the Condition | KDIFF | CURR (5) | |
| KWERT | Condition Value | KWERT | CURR (13) | |
| KSTEU | Condition Control | KSTEU | CHAR (1) | |
| KINAK | Condition is Inactive | KINAK | CHAR (1) | |
| KOAID | Condition Class | KOAID | CHAR (1) | |
| ZAEKO | Condition counter for (header conditions) | DZAEKO | NUMC (3) | |
| KMXAW | Indicator for Maximum Condition Basis Value | KMXAW | CHAR (1) | |
| KMXWR | Indicator for Maximum Condition Amount | KMXWR | CHAR (1) | |
| KFAKTOR | Factor for Condition Base Value | KFAKTOR | FLTP (16) | |
| KDUPL | Structure Condition | KDUPL | CHAR (1) | |
| KFAKTOR1 | Factor for Condition Basis (Period) | KFAKTOR1 | FLTP (16) | |
| KZBZG | Scale Base Type | KZBZG | CHAR (1) | |
| KSTBS | Scale Base Value of the Condition | KSTBS | CURR (15) | |
| KONMS | Condition Scale Unit of Measure | KONMS | T006 | UNIT (3) |
| KONWS | Scale Currency | KONWS | TCURC | CUKY (5) |
| KAWRT_K | Condition Basis | KAWRT | CURR (15) | |
| KWAEH | Condition Currency (for Cumulation Fields) | KWAEH | CUKY (5) | |
| KWERT_K | Condition Value | KWERT | CURR (13) | |
| KFKIV | Condition for Intercompany Billing | KFKIV | CHAR (1) | |
| KVARC | Condition Used for Variant Configuration | KVARC | CHAR (1) | |
| KMPRS | Condition Changed Manually | KMPRS | CHAR (1) | |
| PRSQU | Price Source | PRSQU1 | CHAR (1) | |
| VARCOND | Variant Condition Key | VARCOND | CHAR (26) | |
| STUFE | Level (in multi-level BOM explosions) | HISTU | DEC (2) | |
| WEGXX | Path (for multi-level BOM explosions) | WEGXX | DEC (4) | |
| KTREL | Relevance for Account Assignment | KTREL | CHAR (1) | |
| MDFLG | Indicator: Matrix Maintenance | MDFLG | CHAR (1) | |
| TXJLV | Tax jurisdiction code level | TXJCD_LEVEL | CHAR (1) | |
| KBFLAG | Bit encrypted flags in Pricing | KBFLAG | RAW (2) | |
| KOLNR3 | OBSOLETE – DO NOT USE (exists for technical reasons only) | KOLNR_INOPERATIVE | NUMC (3) | |
| CPF_GUID | Identifier of CPF Formula in Document | CPF_GUID | CHAR (32) | |
| KAQTY | Adjusted Quantity | KAQTY | DEC (31) | |
| VAL_ZERO | Process conditions with value equal to zero | VAL_ZERO | CHAR (1) | |
| IS_ACCT_DETN_RELEVANT | Statistical and Relevant for Account Determination | IS_ACCT_DETN_RELEVANT | CHAR (1) | |
| TAX_COUNTRY | Tax Reporting Country | FOT_TAX_COUNTRY | CHAR (3) |
