1. Home
  2. Resources
  3. SAP Tables
  4. KONV - Conditions (Transaction Data)

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
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
A Percentage
B Fixed amount
C Quantity
D Gross weight
E Net weight
F Volume
G Formula
H Percentage included
I Percentage (travel expenses)
K Per mille
J Per mille
L Points
M Quantity - monthy price
N Quantity - yearly price
O Quantity - daily price
P Quantity - weekly price
Q Commodity Price
R Distance-dependent
S Number of shipping units
T Multi-dimensional
U Percentage FIN (CRM Only)
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
$ TaxJurCode trigger (without license check KNVL)
+ Tax exemption license via conditions
- Total charges (only IS-OIL)
0 Charges - condition records (only IS-OIL)
1 Tax JurDic level 1 (with license check KNVL)
2 Tax JurDic level 2
3 Tax JurDic level 3
4 Tax JurDic level 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
A Packaging
B Delivery costs
C Insurance
D Tax
E Cash discount
F Freight
G Internal price
H Basic price
I Price for intercompany billing
J Customer expected price / customer value (excl.tax)
K Base amount excluding tax
L Generally new when copying
M Sales tax w/license-checking (VAT)
N Input Tax not Deductible
O Variants
P Base amount including tax
Q Costing
R Invoice list condition
S Standard cost
T Moving cost
U Discount/surcharge for precious metals
V Price component
W Expected sales price (including tax)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
a Reserved (fixed extra pay)
b Transfer Price for Group Valuation
c Transfer price for profit centers
d Confirmed purchase net price/value
e Down payment request/down payment clearing
f Free goods - inclusive
g Payment
h Profit Center Cost
i Ship & Debit 1 (IBU HiTec)
j Ship & Debit 2 (IBU HiTec)
l TP-ILV: Base Tarif That Covers Costs
m SSR Discount (only IS-Oil)
n Profit Center Internal Price (Route)
o AFS Season Determination
p SSR Partner Commission (only IS-OIL)
& AFS Value-Added Services
KSTAT Condition is used for statistics KSTAT CHAR 1 0
X Yes
NULL No
KNPRS Scale Type STFKZ CHAR 1 0
NULL can be maintained in condition record
A Base-scale
B To-scale
C not used
D Graduated-to interval scale
KRUEK Condition is Relevant for Accrual (e.g. Freight) KRUEK CHAR 1 0
X Yes
NULL No
KRELI Condition for invoice list KRELI CHAR 1 0
KHERK Origin of the condition KHERK CHAR 1 0
A Automatic pricing
B Duplicated from main item
C Manually entered
D Header condition
E Item total
F Condition supplement
G Original header condition
H Correction Rebate
I Cost Correction
KGRPE Group condition KGRPE CHAR 1 0
X Group condition
NULL
KOUPD Condition update KOUPD CHAR 1 0
X Yes
NULL No
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
A Adjust for quantity variance
B Free
C Changed manually
D Fixed
E Condition value and basis fixed
F Condition value fixed (billed items)
G Condition basis fixed
H Condition value fixed (cost price)
I Scale Base Value and Condition Amount Fixed (for BYD only)
KINAK Condition is inactive KINAK CHAR 1 0
A Condition exclusion item
K Inactive due to calculation basis/shipping material type
L Condition exclusion header or inactive at header level
M Inactive due to manual entry
T Inactive at header level
W The document item is statistical
X Inactive via formulae of incorrect
Y Inactive because of subsequent price
KOAID Condition class KOAID CHAR 1 0
A Discount or surcharge
B Prices
C Expense reimbursement
D Taxes
E Extra pay
F Fees or differential (only IS-OIL)
G Tax Classification
H Determining sales deal
Q Totals record for fees (only IS-OIL)
W Wage Withholding Tax
ZAEKO Condition counter for (header conditions) DZAEKO NUMC 2 0
KMXAW Indicator for maximum condition base value KMXAW CHAR 1 0
X Maximum value set: limit has been exceeded
Y Maximum value set: limit has not yet been exceeded
KMXWR Indicator for maximum condition amount KMXWR CHAR 1 0
X Maximum value set: limit has been exceeded
Y Maximum value set: limit has not yet been exceeded
KFAKTOR Factor for condition base value KFAKTOR FLTP 16 16
KDUPL Structure condition KDUPL CHAR 1 0
NULL
A Condition to be duplicated
B Cumulation condition
KFAKTOR1 Factor for condition basis (period) KFAKTOR1 FLTP 16 16
KZBZG Scale basis indicator KZBZG CHAR 1 0
B Value scale
C Quantity scale
D Gross weight scale
E Net weight scale
F Volume scale
G Scale based on a formula
L Point scale
M Time period scale - Month
N Time period scale - Years
O Time period scale - Days
P Time period scale - Week
R Distance
S Number of shipping units
T reserved (IS-OIL, time prices)
X reserved (IS-OIL, day prices)
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
X Yes
NULL No
KVARC Condition for configuration KVARC CHAR 1 0
X Yes
NULL No
KMPRS Condition changed manually KMPRS CHAR 1 0
X Yes
NULL No
PRSQU Price source PRSQU1 CHAR 1 0
NULL Order
A Purchase order
B Purchase order/delivery
C not used
D Delivery
E Delivery/order
F Shipment costs
G external
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
NULL Relevant for account assignment
B Account assignment with accounting indicator
MDFLG Indicator: Matrix maintenance MDFLG CHAR 1 0
NULL Standard maintenance
1 Matrix maintenance: 1-dimensional
2 Matrix maintenance: 2-dimensional
3 Matrix maintenance: 3-dimensional
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
1 Fees included in inventory
2 Fees posted to expense account
3 Fees posted to revenue account
OIFEEMAN Fee rate indicator OIA_FEEMAN CHAR 1 0
X Fee rate manually entered
NULL Fee rate automatically determined
OIKWERT Fee detail clearing amount OIA_KWERT CURR 13 2
OIFEEPRT Condition is printed at item level OIA_FEEPRT CHAR 1 0
X Yes
NULL No
OIGRNET Gross/net pricing indicator OIC_GRNET CHAR 1 0
NULL Normal Processing
G Invoicing Always Based on Gross Volume
N Invoicing Always Based on Net Volume
R Invoicing Based on Line Item Rule (OIGNRULE)
OIGNSTRA Gross/net pricing strategy used OIC_GNSTRA CHAR 1 0
X Unit of Measure was replaced
NULL Unit of Measure not replaced
OIGRCHK Carry out gross/net unit check OIC_GRCHK CHAR 1 0
X Yes
NULL No
OIINVCYC Invoice cycle OIA_INVCYC TOIA10 NUMC 1 0
OIINVCYACT Invoice cycle included indicator active (X/ ) OIA_INCYCI CHAR 1 0
X
NULL
OIINCYST Cond. statistical due to invoicing cycle OIA_INCYST CHAR 1 0
X
NULL
OIA_SPLTIV Indicator for split invoice verification OIA_SPLTIV CHAR 1 0
NULL No split invoice verification
X Split invoice verification
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
X Flag set. Event has occurred.
NULL Flag is Not Set
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