SAP table KONV (Conditions (Obsolete - replaced by PRCD_ELEMENTS))

SAP table KONV has 5 primary key fields being MANDT,KNUMV,KPOSN,STUNR,ZAEHK.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
KPOSN Condition item number NUMC 6 0 KPOSN
STUNR Step Number NUMC 3 0 STUNR
ZAEHK Condition Counter NUMC 3 0 DZAEHK
KAPPL Application CHAR 2 0 T681A KAPPL
KSCHL Condition Type CHAR 4 0 KSCHA
KDATU Condition Pricing Date DATS 8 0 KDATU
KRECH Calculation Type for Condition CHAR 1 0 KRECH
A Percentage
B Fixed Amount
C Quantity
D Gross Weight
E Net Weight
F Volume
G Formula
H Percentage (in Hundreds)
I Percentage (Travel Costs)
J Per Mille
K Per Mille (in Thousands)
L Points
M Quantity - Monthly Price
N Quantity - Year 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)
V Quantity Adjustment
W Percentage (with 6 Decimal Places)
KAWRT Condition Basis CURR 15 2 KAWRT
KBETR Condition Amount or Percentage CURR 11 2 KBETR
WAERS Currency Key CUKY 5 0 TCURC WAERS
KKURS Condition exchange rate for conversion to local currency DEC 9 5 KKURS
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit in the Document UNIT 3 0 T006 KVMEI
KUMZA Numerator for converting condition units to base units DEC 5 0 KUMZA
KUMNE Denominator for converting condition units to base units DEC 5 0 KUMNE
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) CHAR 1 0 KNTYP
$ TaxJurCode trigger (without license check KNVL)
& AFS Value-Added Services
+ 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
a Reserved (fixed extra pay)
B Delivery costs
b Transfer Price for Group Valuation
C Insurance
c Transfer price for profit centers
d Confirmed purchase net price/value
D Tax
E Cash discount
e Down payment request/down payment clearing
f Free goods - inclusive
F Freight
G Internal price
g Payment
H Basic price
h Profit Center Cost
I Price for intercompany billing
i Ship & Debit 1 (IBU HiTec)
J Customer expected price / customer value (excl.tax)
j Ship & Debit 2 (IBU HiTec)
K Base amount excluding tax
L Generally new when copying
l TP-ILV: Base Tarif That Covers Costs
M Sales tax w/license-checking (VAT)
m SSR Discount (only IS-Oil)
N Input Tax not Deductible
n Profit Center Internal Price (Route)
o AFS Season Determination
O Variants
P Base amount including tax
p SSR Partner Commission (only IS-OIL)
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
KSTAT Condition is used for statistics CHAR 1 0 KSTAT
KNPRS Scale Type CHAR 1 0 STFKZ
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) CHAR 1 0 KRUEK
KRELI Condition for Invoice List CHAR 1 0 KRELI
No
X Yes
KHERK Origin of the Condition CHAR 1 0 KHERK
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 CHAR 1 0 KGRPE
X Group condition
KOUPD Condition Update CHAR 1 0 KOUPD
KOLNR Access sequence - Access number NUMC 3 0 KOLNR
KNUMH Number of the Condition Record CHAR 10 0 KNUMH
KOPOS Sequential number of the condition NUMC 2 0 KOPOS
KVSL1 Account Key CHAR 3 0 T687 KVSL1
SAKN1 G/L Account Number CHAR 10 0 SKA1 SAKNR
MWSK1 Tax on sales/purchases code CHAR 2 0 MWSKZ
KVSL2 Account Key - Accruals / Provisions CHAR 3 0 T687 KVSL2
SAKN2 Number of Accruals Account CHAR 10 0 SKA1 SAKNR_ACCR
MWSK2 Withholding Tax Code CHAR 2 0 WT_WITHCD
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
KUNNR Customer number (rebate recipient) CHAR 10 0 KNA1 KUNNR_KO
KDIFF Rounding-Off Difference of the Condition CURR 5 2 KDIFF
KWERT Condition Value CURR 13 2 KWERT
KSTEU Condition Control CHAR 1 0 KSTEU
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 CHAR 1 0 KINAK
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 formulas or incorrect
Y Inactive because of subsequent price
KOAID Condition Class CHAR 1 0 KOAID
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
P Compare Price Protection
Q Totals record for fees (only IS-OIL)
W Wage Withholding Tax
ZAEKO Condition counter for (header conditions) NUMC 3 0 DZAEKO
KMXAW Indicator for Maximum Condition Basis Value CHAR 1 0 KMXAW
KMXWR Indicator for Maximum Condition Amount CHAR 1 0 KMXWR
X Maximum value set: limit has been exceeded
Y Maximum value set: limit has not yet been exceeded
KFAKTOR Factor for Condition Base Value FLTP 16 16 KFAKTOR
KDUPL Structure Condition CHAR 1 0 KDUPL
None
A Duplication Condition
B Cumulation condition
KFAKTOR1 Factor for Condition Basis (Period) FLTP 16 16 KFAKTOR1
KZBZG Scale Base Type CHAR 1 0 KZBZG
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 CURR 15 2 KSTBS
KONMS Condition Scale Unit of Measure UNIT 3 0 T006 KONMS
KONWS Scale Currency CUKY 5 0 TCURC KONWS
KAWRT_K Condition Basis CURR 15 2 KAWRT
KWAEH Condition Currency (for Cumulation Fields) CUKY 5 0 KWAEH
KWERT_K Condition Value CURR 13 2 KWERT
KFKIV Condition for Intercompany Billing CHAR 1 0 KFKIV
KVARC Condition Used for Variant Configuration CHAR 1 0 KVARC
KMPRS Condition Changed Manually CHAR 1 0 KMPRS
PRSQU Price Source CHAR 1 0 PRSQU1
VARCOND Variant Condition Key CHAR 26 0 VARCOND
STUFE Level (in multi-level BOM explosions) DEC 2 0 HISTU
WEGXX Path (for multi-level BOM explosions) DEC 4 0 WEGXX
KTREL Relevance for Account Assignment CHAR 1 0 KTREL
Relevant for account assignment
B Account assignment with accounting indicator
MDFLG Indicator: Matrix Maintenance CHAR 1 0 MDFLG
Standard maintenance
1 Matrix maintenance: 1-dimensional
2 Matrix maintenance: 2-dimensional
3 Matrix maintenance: 3-dimensional
TXJLV Tax jurisdiction code level CHAR 1 0 TXJCD_LEVEL
KBFLAG Bit encrypted flags in Pricing RAW 2 0 KBFLAG
KOLNR3 OBSOLETE - DO NOT USE (exists for technical reasons only) NUMC 3 0 KOLNR_INOPERATIVE
CPF_GUID Identifier of CPF Formula in Document CHAR 32 0 CPF_GUID
KAQTY Adjusted Quantity DEC 31 14 KAQTY
VAL_ZERO Process Conditions with Value Equal to Zero CHAR 1 0 VAL_ZERO
A Amount of zero will be considered
IS_ACCT_DETN_RELEVANT Statistical and Relevant for Account Determination CHAR 1 0 IS_ACCT_DETN_RELEVANT
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
COMMON_SUPPL_DATA Common Supplementary Data Indicator CHAR 1 0 COMMON_SUPPL_DATA

KONV foreign key relationships

Table Field Check Table Check Field
0 KONV KAPPL T681A Conditions: Applications KAPPL
1 KONV KMEIN T006 Units of Measurement MANDT
0 KONV KONMS T006 Units of Measurement MANDT
1 KONV KONWS TCURC Currency Codes MANDT
1 KONV KONWS TCURC Currency Codes WAERS
0 KONV KUNNR KNA1 General Data in Customer Master MANDT
0 KONV KUNNR KNA1 General Data in Customer Master KUNNR
1 KONV KVSL1 T687 Account Determination: Account Key KAPPL
0 KONV KVSL2 T687 Account Determination: Account Key KAPPL
1 KONV LIFNR LFA1 Supplier Master (General Section) MANDT
1 KONV LIFNR LFA1 Supplier Master (General Section) LIFNR
0 KONV MANDT T000 Clients MANDT
1 KONV SAKN1 SKA1 G/L Account Master (Chart of Accounts) MANDT
1 KONV SAKN1 SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 KONV SAKN1 SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 KONV SAKN2 SKA1 G/L Account Master (Chart of Accounts) MANDT
0 KONV SAKN2 SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 KONV SAKN2 SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 KONV WAERS TCURC Currency Codes MANDT
1 KONV WAERS TCURC Currency Codes WAERS