SAP table MCKONV (Pricing Communications-Condition Record)

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 T685A 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
DUMMY Dummy function in length 1 CHAR 1 0 DUMMY

MCKONV foreign key relationships

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