1. Home
  2. Resources
  3. SAP Tables
  4. KMBW - SP Calculations: Competitor Prices (Internal Processing)

SAP Table KMBW

SP Calculations: Competitor Prices (Internal Processing)

KMBW (SP Calculations: Competitor Prices (Internal Processing)) 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 KMBW to other SAP tables.

KMBW 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 T685A 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
PRSCH Price levels PRSCH CHAR 4 0
KOFRM Condition formula for alternative calculation type KOFRM NUMC 3 0
STFKZ 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
KSTBM Incremental scale: start of interval KSTBM_AKT CURR 15 2
KSTBM_NEXT Increase scale: end of interval KSTBM_NEXT CURR 15 2
IX_KOMT1 Index number for internal tables KOIDX INT4 10 0
IX_GKOMV Index number for internal tables KOIDX INT4 10 0
ZAEHK_IND Condition item index DZAEHK_IND NUMC 2 0
DRUKZ Print ID for condition lines DRUKZ CHAR 1 0
NULL It was not printed
X Printing at item level (previous procedure)
S Printing at totals level (previous procedure)
A Total: General
B Total: if value <> zero
C Total: if value <> previous value
D Total: if value <> zero and value <> previous value
a at item: General
b at item: if value <> zero
c at item: if value <> previous value
d at item: if value <> zero and value <> previous value
STUNB From Ref. Step for Percentage Conditions STUNB NUMC 3 0
STUN2 From Ref. Step for Percentage Conditions STUNB NUMC 3 0
KZWIW Condition subtotal KZWIW CHAR 1 0
NULL No separate sub-totals
1 Carry over value to KOMP-KZWI1
2 Carry over value to KOMP-KZWI2
3 Carry over value to KOMP-KZWI3
4 Carry over value to KOMP-KZWI4
5 Carry over value to KOMP-KZWI5
6 Carry over value to KOMP-KZWI6
7 Carry over value to KOMP_BONBA (rebate basis 1)
8 Copy values according to KOMP-PREVA (preference value)
9 Copy values to KOMP-BRTWR (gross value)
A Carry over price to KOMP-CMPRE (credit price)
B Carry over value to KOMP-WAVWR (cost)
C Carry over value to KOMP-GKWRT (statistical value)
D Copy value to XWORKD
E Copy value to XWORKE
F Copy value to XWORKF
G Copy value to XWORKG
H Copy value to XWORKH
I Copy value to XWORKI
J Copy value to XWORKJ
K Copy price to XWORKK
L Copy price to XWORKL
M Copy price to XWORKM
Q VAT base amount for internally posted material (only IS-OIL)
S Copy values to KOMP-EFFWR (effective value)
Y Copy value to KOMP-OIIDC (IS-OIL/only JVA CRP Pricing)
Z Copy value to KOMP-OIEBC (IS-OIL/only JVA CRP Pricing)
N Value Transfer to KOMP-NRAB_VALUE (Free Goods)
KOFRA Alternative formula for condition base value KOFRA NUMC 3 0
KOFRS Formula for scale base value KOFRS NUMC 3 0
KMANU Making manual entries KMANU CHAR 1 0
NULL No limitations
A Free
B Automatic entry has priority
C Manual entry has priority
D Not possible to process manually
TXPRF Rounding rule TXPRF CHAR 1 0
NULL Commercial
A Round up
B Round down
KNEGA Plus/minus sign of the condition amount KNEGA CHAR 1 0
NULL positive and negative
X Negative
A Positive
GANZZ Indicator: Currency Translation after Multiplication GANZZ CHAR 1 0
X Yes
NULL No
KOBLI Condition is mandatory KOBLI CHAR 1 0
X Yes
NULL No
KAEND_BTR Condition rate of change for amount/percentage KAEND_BTR CHAR 1 0
X Yes
NULL No
KAEND_WRT Scope for changing the value KAEND_WRT CHAR 1 0
X Yes
NULL No
KAEND_UFK Scope for changing conversion factors KAEND_UFK CHAR 1 0
X Yes
NULL No
KAEND_RCH Calculation type can be changed KAEND_RCH CHAR 1 0
X Yes
NULL No
KAEND_LOE Delete the scope for changing rate KAEND_LOE CHAR 1 0
X Yes
NULL No
KAEND_MEH Condition scope of change for unit of measure KAEND_MEH CHAR 1 0
X Yes
NULL No
KZTERM Terms of payment ID in the condition KZTERM CHAR 1 0
X Yes
NULL No
FXMSG Message number MSGNR CHAR 3 0
UPDKZ Update indicator UPDKZ_D CHAR 1 0
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
BOSTA Status of the agreement BOSTA CHAR 1 0
A Settlement is being checked for release
B Agreement released for settlement
C Settlement has been created
D Final settlement of agreement already carried out
NULL Open
KSPAE Rebate was set up retroactively KSPAE CHAR 1 0
X Yes
NULL No
LOEVM_KO Deletion Indicator for Condition Item LOEVM_KO CHAR 1 0
X Yes
NULL No
KNUMA_BO Agreement (various conditions grouped together) KNUMA KONA CHAR 10 0
BERGL Calculation Base BERGL CHAR 1 0
NULL All
A Delivery
B Delivery item
C Handling units
D Shipment costs item
E Per handling unit
F Shipping unit including delivery item
O Document Item Quantity - Bulk Product Shipment (IS-Oil Only)
P Vehicle - Bulk Product Shipment (IS-Oil Only)
VHART Packaging Material Type VHIART TVTY CHAR 4 0
RDIFA Rounding difference comparison RDIFA CHAR 1 0
X Yes
NULL No
KMENG Quantity conversion KMENG CHAR 1 0
X Yes
NULL No
KBUFF Condition read from buffer KBUFF CHAR 1 0
X Yes
NULL No
BOSTA_CR Condition Record Status (Rebate) BOSTA_CR CHAR 1 0
NULL Open
A Settlement Is Being Checked for Release
B Agreement Released for Settlement
C Settlement Has Been Created
D Condition Record Is Settled
P Condition Record Settled, Other Periods Open
IS_CPF_ENABLED Condition Enabled for Config. Parameters and Formulas (CPF) COND_IS_CPF_ENABLED CHAR 1 0
NULL No
X Yes
OIRKLFN1 Current number of the line scale KLFN1 NUMC 4 0
OIRCOMMREVKAWRT SSR Invoicing end of period commission reversal base qty OIRI_COMMREVKAWRT CURR 15 2
OIRCOMMREVKSTBS SSR Invoicing end of period commission reversal scale base OIRI_COMMREVKSTBS CURR 15 2
BPSTA Pricing: Status of Item in Pricing Document BPSTA CHAR 1 0
A New, not saved
B Changed, not saved
C Saved
D Flagged for Deletion
E Cancelled
NAME1 Name 1 NAME1_GP CHAR 35 0
VAKEY Variable key 100 bytes VAKEY CHAR 100 0
VKKAB Sales conditions valid from VKKAB DATS 8 0
VKKBI Sales conditions valid to VKKBI DATS 8 0
KOTABNR Condition table KOTABNR NUMC 3 0
UPDKZ_KMBW Update indicator UPDKZ_D CHAR 1 0
PRACT Competitor prices: price activation PRACT CHAR 1 0
X Yes
NULL No
MBELN Competitor: document number of price entry document MBELN CHAR 10 0
MBELP Item number of competitor price entry document MBELP NUMC 5 0

KMBW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KMBW KAPPL KMBW KAPPL T681A Conditions: Applications KAPPL
KMBW KMEIN KMBW KMEIN T006 Units of Measurement MSEHI
KMBW KMEIN KMBW MANDT T006 Units of Measurement MANDT
KMBW KNUMA_BO KMBW KNUMA_BO KONA Agreements KNUMA
KMBW KNUMA_BO SY MANDT KONA Agreements MANDT
KMBW KONMS KMBW MANDT T006 Units of Measurement MANDT
KMBW KONMS KMBW KONMS T006 Units of Measurement MSEHI
KMBW KONWS KMBW MANDT TCURC Currency Codes MANDT
KMBW KONWS KMBW KONWS TCURC Currency Codes WAERS
KMBW KSCHL KMBW KAPPL T685A Conditions: Types: Additional Price Element Data KAPPL
KMBW KSCHL KMBW KSCHL T685A Conditions: Types: Additional Price Element Data KSCHL
KMBW KSCHL KMBW MANDT T685A Conditions: Types: Additional Price Element Data MANDT
KMBW KUNNR KMBW MANDT KNA1 General Data in Customer Master MANDT
KMBW KUNNR KMBW KUNNR KNA1 General Data in Customer Master KUNNR
KMBW KVSL1 KMBW MANDT T687 Account Determination: Account Key MANDT
KMBW KVSL1 KMBW KAPPL T687 Account Determination: Account Key KAPPL
KMBW KVSL1 KMBW KVSL1 T687 Account Determination: Account Key KVSL1
KMBW KVSL2 KMBW MANDT T687 Account Determination: Account Key MANDT
KMBW KVSL2 KMBW KAPPL T687 Account Determination: Account Key KAPPL
KMBW KVSL2 KMBW KVSL2 T687 Account Determination: Account Key KVSL1
KMBW LIFNR KMBW MANDT LFA1 Vendor Master (General Section) MANDT
KMBW LIFNR KMBW LIFNR LFA1 Vendor Master (General Section) LIFNR
KMBW MANDT KMBW MANDT T000 Clients MANDT
KMBW OIINVCYC KMBW MANDT TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) MANDT
KMBW OIINVCYC KMBW OIINVCYC TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) OIINVCYC
KMBW SAKN1 KMBW SAKN1 SKA1 G/L Account Master (Chart of Accounts) SAKNR
KMBW SAKN1 SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
KMBW SAKN1 SKA1 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
KMBW SAKN2 SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
KMBW SAKN2 SKA1 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
KMBW SAKN2 KMBW SAKN2 SKA1 G/L Account Master (Chart of Accounts) SAKNR
KMBW VHART SY MANDT TVTY Packaging Material Types MANDT
KMBW VHART KMBW VHART TVTY Packaging Material Types TRATY
KMBW WAERS KMBW WAERS TCURC Currency Codes WAERS
KMBW WAERS KMBW MANDT TCURC Currency Codes MANDT