Follow us on LinkedIn for your next SAP project
← Back to Search

SAP Table KONV

Conditions (Transaction Data)

KONV (Conditions (Transaction Data)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link KONV to other SAP tables.

KONV table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
 MANDT T000
CLNT
 3 0
KNUMV
Number of the document condition
 KNUMV
CHAR
 10 0
KPOSN
Condition item number
 KPOSN
NUMC
 6 0
STUNR
Step number
 STUNR
NUMC
 3 0
ZAEHK
Condition counter
 DZAEHK
NUMC
 2 0
KAPPL
Application
 KAPPL T681A
CHAR
 2 0
KSCHL
Condition type
 KSCHA
CHAR
 4 0
KDATU
Condition pricing date
 KDATU
DATS
 8 0
KRECH
Calculation type for condition
 KRECH
CHAR
 1 0
KAWRT
Condition base value
 KAWRT
CURR
 15 2
KBETR
Rate (condition amount or percentage)
 KBETR
CURR
 11 2
WAERS
Currency Key
 WAERS TCURC
CUKY
 5 0
KKURS
Condition exchange rate for conversion to local currency
 KKURS
DEC
 9 5
KPEIN
Condition pricing unit
 KPEIN
DEC
 5 0
KMEIN
Condition unit in the document
 KVMEI T006
UNIT
 3 0
KUMZA
Numerator for converting condition units to base units
 KUMZA
DEC
 5 0
KUMNE
Denominator for converting condition units to base units
 KUMNE
DEC
 5 0
KNTYP
Condition category (examples: tax, freight, price, cost)
 KNTYP
CHAR
 1 0
KSTAT
Condition is used for statistics
 KSTAT
CHAR
 1 0
KNPRS
Scale Type
 STFKZ
CHAR
 1 0
KRUEK
Condition is Relevant for Accrual (e.g. Freight)
 KRUEK
CHAR
 1 0
KRELI
Condition for invoice list
 KRELI
CHAR
 1 0
KHERK
Origin of the condition
 KHERK
CHAR
 1 0
KGRPE
Group condition
 KGRPE
CHAR
 1 0
KOUPD
Condition update
 KOUPD
CHAR
 1 0
KOLNR
Access sequence - Access number
 KOLNR
NUMC
 2 0
KNUMH
Condition record number
 KNUMH
CHAR
 10 0
KOPOS
Sequential number of the condition
 KOPOS
NUMC
 2 0
KVSL1
Account key
 KVSL1 T687
CHAR
 3 0
SAKN1
G/L Account Number
 SAKNR SKA1
CHAR
 10 0
MWSK1
Tax on sales/purchases code
 MWSKZ
CHAR
 2 0
KVSL2
Account key - accruals / provisions
 KVSL2 T687
CHAR
 3 0
SAKN2
Number of Provision Account
 SAKNR_ACCR SKA1
CHAR
 10 0
MWSK2
Withholding tax code
 WT_WITHCD
CHAR
 2 0
LIFNR
Account Number of Vendor or Creditor
 LIFNR LFA1
CHAR
 10 0
KUNNR
Customer number (rebate recipient)
 KUNNR_KO KNA1
CHAR
 10 0
KDIFF
Rounding-off difference of the condition
 KDIFF
CURR
 5 2
KWERT
Condition value
 KWERT
CURR
 13 2
KSTEU
Condition control
 KSTEU
CHAR
 1 0
KINAK
Condition is inactive
 KINAK
CHAR
 1 0
KOAID
Condition class
 KOAID
CHAR
 1 0
ZAEKO
Condition counter for (header conditions)
 DZAEKO
NUMC
 2 0
KMXAW
Indicator for maximum condition base value
 KMXAW
CHAR
 1 0
KMXWR
Indicator for maximum condition amount
 KMXWR
CHAR
 1 0
KFAKTOR
Factor for condition base value
 KFAKTOR
FLTP
 16 16
KDUPL
Structure condition
 KDUPL
CHAR
 1 0
KFAKTOR1
Factor for condition basis (period)
 KFAKTOR1
FLTP
 16 16
KZBZG
Scale basis indicator
 KZBZG
CHAR
 1 0
KSTBS
Scale base value of the condition
 KSTBS
CURR
 15 2
KONMS
Condition scale unit of measure
 KONMS T006
UNIT
 3 0
KONWS
Scale currency
 KONWS TCURC
CUKY
 5 0
KAWRT_K
Condition base value
 KAWRT
CURR
 15 2
KWAEH
Condition currency (for cumulation fields)
 KWAEH
CUKY
 5 0
KWERT_K
Condition value
 KWERT
CURR
 13 2
KFKIV
Condition for inter-company billing
 KFKIV
CHAR
 1 0
KVARC
Condition for configuration
 KVARC
CHAR
 1 0
KMPRS
Condition changed manually
 KMPRS
CHAR
 1 0
PRSQU
Price source
 PRSQU1
CHAR
 1 0
VARCOND
Variant condition
 VARCOND
CHAR
 26 0
STUFE
Level (in multi-level BOM explosions)
 HISTU
DEC
 2 0
WEGXX
Path (for multi-level BOM explosions)
 WEGXX
DEC
 4 0
KTREL
Relevance for account assignment
 KTREL
CHAR
 1 0
MDFLG
Indicator: Matrix maintenance
 MDFLG
CHAR
 1 0
TXJLV
Tax jurisdiction code level
 TXJCD_LEVEL
CHAR
 1 0
KBFLAG
Bit encrypted flags in Pricing
 KBFLAG
RAW
 2 0
KOLNR3
Access Sequence - Access Number
 KOLNR3
NUMC
 3 0
CPF_GUID
CPF GUID for Document
 CPF_GUID
CHAR
 32 0
OIKOSTL
Cost center for fee expense accounting
 OIA_KOSTL
CHAR
 10 0
OIACPOL
Fee accounting policy indicator
 OIA_ACPOL
CHAR
 1 0
OIFEEMAN
Fee rate indicator
 OIA_FEEMAN
CHAR
 1 0
OIKWERT
Fee detail clearing amount
 OIA_KWERT
CURR
 13 2
OIFEEPRT
Condition is printed at item level
 OIA_FEEPRT
CHAR
 1 0
OIGRNET
Gross/net pricing indicator
 OIC_GRNET
CHAR
 1 0
OIGNSTRA
Gross/net pricing strategy used
 OIC_GNSTRA
CHAR
 1 0
OIGRCHK
Carry out gross/net unit check
 OIC_GRCHK
CHAR
 1 0
OIINVCYC
Invoice cycle
 OIA_INVCYC TOIA10
NUMC
 1 0
OIINVCYACT
Invoice cycle included indicator active (X/ )
 OIA_INCYCI
CHAR
 1 0
OIINCYST
Cond. statistical due to invoicing cycle
 OIA_INCYST
CHAR
 1 0
OIA_SPLTIV
Indicator for split invoice verification
 OIA_SPLTIV
CHAR
 1 0
OIA_ZTERM
Terms of Payment Key
 DZTERM
CHAR
 4 0
OILICIN
Excise tax internal license number
 OIH_LICIN
CHAR
 10 0
OILICTP
License type
 OIH_LICTP
CHAR
 4 0
OIREPORT
Report number
 OIC_REPORT
CHAR
 8 0
OIDATA
Routine number for data capture
 OIC_DATA
NUMC
 3 0
OIHEAD
Header format routine for second level analysis report
 OIC_HEAD
NUMC
 3 0
OIITEM
Item routine for second level analysis report
 OIC_ITEM
NUMC
 3 0
OIERRHAN
Error handling routine for second level analysis
 OIC_SECERR
NUMC
 3 0
OIU_EP
Exploration and Production condition (PRA)
 OIU_EP
CHAR
 1 0
OIRCONDCL
SSR PC: Condition classification
 OIRE_CONDCLA
CHAR
 1 0

KONV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KONV KAPPL KONV KAPPL T681A
Conditions: Applications
 KAPPL
KONV KMEIN KONV MANDT T006
Units of Measurement
 MANDT
KONV KMEIN KONV KMEIN T006
Units of Measurement
 MSEHI
KONV KONMS KONV MANDT T006
Units of Measurement
 MANDT
KONV KONMS KONV KONMS T006
Units of Measurement
 MSEHI
KONV KONWS KONV MANDT TCURC
Currency Codes
 MANDT
KONV KONWS KONV KONWS TCURC
Currency Codes
 WAERS
KONV KUNNR KONV MANDT KNA1
General Data in Customer Master
 MANDT
KONV KUNNR KONV KUNNR KNA1
General Data in Customer Master
 KUNNR
KONV KVSL1 KONV MANDT T687
Account Determination: Account Key
 MANDT
KONV KVSL1 KONV KAPPL T687
Account Determination: Account Key
 KAPPL
KONV KVSL1 KONV KVSL1 T687
Account Determination: Account Key
 KVSL1
KONV KVSL2 KONV MANDT T687
Account Determination: Account Key
 MANDT
KONV KVSL2 KONV KAPPL T687
Account Determination: Account Key
 KAPPL
KONV KVSL2 KONV KVSL2 T687
Account Determination: Account Key
 KVSL1
KONV LIFNR KONV MANDT LFA1
Vendor Master (General Section)
 MANDT
KONV LIFNR KONV LIFNR LFA1
Vendor Master (General Section)
 LIFNR
KONV MANDT KONV MANDT T000
Clients
 MANDT
KONV OIINVCYC KONV OIINVCYC TOIA10
Invoicing Cycle Number (IS-Oil EXG standard/core object)
 OIINVCYC
KONV OIINVCYC KONV MANDT TOIA10
Invoicing Cycle Number (IS-Oil EXG standard/core object)
 MANDT
KONV SAKN1 KONV SAKN1 SKA1
G/L Account Master (Chart of Accounts)
 SAKNR
KONV SAKN1 KONV MANDT SKA1
G/L Account Master (Chart of Accounts)
 MANDT
KONV SAKN1 SKA1 KTOPL SKA1
G/L Account Master (Chart of Accounts)
 KTOPL
KONV SAKN2 KONV MANDT SKA1
G/L Account Master (Chart of Accounts)
 MANDT
KONV SAKN2 SKA1 KTOPL SKA1
G/L Account Master (Chart of Accounts)
 KTOPL
KONV SAKN2 KONV SAKN2 SKA1
G/L Account Master (Chart of Accounts)
 SAKNR
KONV WAERS KONV MANDT TCURC
Currency Codes
 MANDT
KONV WAERS KONV WAERS TCURC
Currency Codes
 WAERS