KMBW SAP (SP Calculations: Competitor Prices (Internal Processing)) Structure details

Dictionary Type: Structure
Description: SP Calculations: Competitor Prices (Internal Processing)




ABAP Code to SELECT data from KMBW
Related tables to KMBW
Access table KMBW




Structure field list including key, data, relationships and ABAP select examples

KMBW is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SP Calculations: Competitor Prices (Internal Processing)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_KMBW TYPE KMBW.

The KMBW table consists of various fields, each holding specific information or linking keys about SP Calculations: Competitor Prices (Internal Processing) data available in SAP. These include MANDT (Client), KNUMV (Number of the document condition), KPOSN (Condition item number), STUNR (Step number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP KMBW structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
KPOSNCondition item number KPOSNNUMC6NUM6
STUNRStep number STUNRNUMC3Assigned to domainSTUNR
ZAEHKCondition counter DZAEHKNUMC2ZAEHK
KAPPLApplication KAPPLCHAR2T681AKAPPLKAP
KSCHLCondition type KSCHACHAR4T685AKSCHLVKS
KDATUCondition pricing date KDATUDATS8DATUM
KRECHCalculation type for condition KRECHCHAR1KRECH
KAWRTCondition base value KAWRTCURR15(2) WERTV8
KBETRRate (condition amount or percentage) KBETRCURR11(2) WERTV6
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
KKURSCondition exchange rate for conversion to local currency KKURSDEC9(5) KKURS
KPEINCondition pricing unit KPEINDEC5KPEIN
KMEINCondition unit in the document KVMEIUNIT3T006CUNITMEINS
KUMZANumerator for converting condition units to base units KUMZADEC5UMBSZ
KUMNEDenominator for converting condition units to base units KUMNEDEC5UMBSN
KNTYPCondition category (examples: tax, freight, price, cost) KNTYPCHAR1KNTYP
KSTATCondition is used for statistics KSTATCHAR1XFELD
KNPRSScale Type STFKZCHAR1STFKZ
KRUEKCondition is Relevant for Accrual (e.g. Freight) KRUEKCHAR1XFELD
KRELICondition for invoice list KRELICHAR1KRELI
KHERKOrigin of the condition KHERKCHAR1KHERK
KGRPEGroup condition KGRPECHAR1KGRPE
KOUPDCondition update KOUPDCHAR1XFELD
KOLNRAccess sequence - Access number KOLNRNUMC2Assigned to domainKOLNR
KNUMHCondition record number KNUMHCHAR10KNUMB
KOPOSSequential number of the condition KOPOSNUMC2NUM02
KVSL1Account key KVSL1CHAR3T687KVSCHL
SAKN1G/L Account Number SAKNRCHAR10SKA1ALPHASAKNRSAKC_SAKNR
MWSK1Tax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
KVSL2Account key - accruals / provisions KVSL2CHAR3T687KVSCHL
SAKN2Number of Provision Account SAKNR_ACCRCHAR10SKA1ALPHASAKNRSAKSAKO
MWSK2Withholding tax code WT_WITHCDCHAR2Assigned to domainWT_WITHCD
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
KUNNRCustomer number (rebate recipient) KUNNR_KOCHAR10KNA1ALPHAKUNNRKUN
KDIFFRounding-off difference of the condition KDIFFCURR5(2) WERTV3
KWERTCondition value KWERTCURR13(2) WERTV7
KSTEUCondition control KSTEUCHAR1KSTEU
KINAKCondition is inactive KINAKCHAR1KINAK
KOAIDCondition class KOAIDCHAR1KOAID
ZAEKOCondition counter for (header conditions) DZAEKONUMC2ZAEHK
KMXAWIndicator for maximum condition base value KMXAWCHAR1KMXWR
KMXWRIndicator for maximum condition amount KMXWRCHAR1KMXWR
KFAKTORFactor for condition base value KFAKTORFLTP16(16) FLTP
KDUPLStructure condition KDUPLCHAR1KDUPL
KFAKTOR1Factor for condition basis (period) KFAKTOR1FLTP16(16) FLTP
KZBZGScale basis indicator KZBZGCHAR1KZBZG
KSTBSScale base value of the condition KSTBSCURR15(2) WERTV8
KONMSCondition scale unit of measure KONMSUNIT3T006CUNITMEINS
KONWSScale currency KONWSCUKY5TCURCWAERSFWS
KAWRT_KCondition base value KAWRTCURR15(2) WERTV8
KWAEHCondition currency (for cumulation fields) KWAEHCUKY5Assigned to domainWAERSFWS
KWERT_KCondition value KWERTCURR13(2) WERTV7
KFKIVCondition for inter-company billing KFKIVCHAR1XFELD
KVARCCondition for configuration KVARCCHAR1XFELD
KMPRSCondition changed manually KMPRSCHAR1XFELD
PRSQUPrice source PRSQU1CHAR1PRSQU
VARCONDVariant condition VARCONDCHAR26Assigned to domainVARCON
STUFELevel (in multi-level BOM explosions) HISTUDEC2DEC2
WEGXXPath (for multi-level BOM explosions) WEGXXDEC4DEC4
KTRELRelevance for account assignment KTRELCHAR1KTREL
MDFLGIndicator: Matrix maintenance MDFLGCHAR1MDFLG
TXJLVTax jurisdiction code level TXJCD_LEVELCHAR1CHAR1
KBFLAGBit encrypted flags in Pricing KBFLAGRAW2KBFLAG
KOLNR3Access Sequence - Access Number KOLNR3NUMC3Assigned to domainKOLNR3
CPF_GUIDCPF GUID for Document CPF_GUIDCHAR32SYSUUID_C
PRSCHPrice levels PRSCHCHAR4CHAR4
KOFRMCondition formula for alternative calculation type KOFRMNUMC3KOFRM
STFKZScale Type STFKZCHAR1STFKZ
KSTBMIncremental scale: start of interval KSTBM_AKTCURR15(2) WERT8
KSTBM_NEXTIncrease scale: end of interval KSTBM_NEXTCURR15(2) WERT8
IX_KOMT1Index number for internal tables KOIDXINT410KOIDX
IX_GKOMVIndex number for internal tables KOIDXINT410KOIDX
ZAEHK_INDCondition item index DZAEHK_INDNUMC2ZAEHK
DRUKZPrint ID for condition lines DRUKZCHAR1DRUKZ
STUNBFrom Ref. Step for Percentage Conditions STUNBNUMC3Assigned to domainSTUNR
STUN2From Ref. Step for Percentage Conditions STUNBNUMC3Assigned to domainSTUNR
KZWIWCondition subtotal KZWIWCHAR1KZWIW
KOFRAAlternative formula for condition base value KOFRANUMC3KOFRM
KOFRSFormula for scale base value KOFRSNUMC3KOFRM
KMANUMaking manual entries KMANUCHAR1KMANU
TXPRFRounding rule TXPRFCHAR1TXPRF
KNEGAPlus/minus sign of the condition amount KNEGACHAR1KNEGA
GANZZIndicator: Currency Translation after Multiplication GANZZCHAR1XFELD
KOBLICondition is mandatory KOBLICHAR1XFELD
KAEND_BTRCondition rate of change for amount/percentage KAEND_BTRCHAR1XFELD
KAEND_WRTScope for changing the value KAEND_WRTCHAR1XFELD
KAEND_UFKScope for changing conversion factors KAEND_UFKCHAR1XFELD
KAEND_RCHCalculation type can be changed KAEND_RCHCHAR1XFELD
KAEND_LOEDelete the scope for changing rate KAEND_LOECHAR1XFELD
KAEND_MEHCondition scope of change for unit of measure KAEND_MEHCHAR1XFELD
KZTERMTerms of payment ID in the condition KZTERMCHAR1XFELD
FXMSGMessage number MSGNRCHAR3Assigned to domainMSGNR
UPDKZUpdate indicator UPDKZ_DCHAR1UPDKZ
SELKZSelection flag SELKZCHAR1SELKZ
BOSTAStatus of the agreement BOSTACHAR1BOSTA
KSPAERebate was set up retroactively KSPAECHAR1XFELD
LOEVM_KODeletion Indicator for Condition Item LOEVM_KOCHAR1XFELD
KNUMA_BOAgreement (various conditions grouped together) KNUMACHAR10KONAALPHAKNUMAVMBO
BERGLCalculation Base BERGLCHAR1BERGL
VHARTPackaging Material Type VHIARTCHAR4TVTYTRATY
RDIFARounding difference comparison RDIFACHAR1XFELD
KMENGQuantity conversion KMENGCHAR1XFELD
KBUFFCondition read from buffer KBUFFCHAR1XFELD
BOSTA_CRCondition Record Status (Rebate) BOSTA_CRCHAR1BOSTA_CR
IS_CPF_ENABLEDCondition Enabled for Config. Parameters and Formulas (CPF) COND_IS_CPF_ENABLEDCHAR1IS_CPF_ENABLED
BPSTAPricing: Status of Item in Pricing Document BPSTACHAR1BPSTA
NAME1Name 1 NAME1_GPCHAR35NAME
VAKEYVariable key 100 bytes VAKEYCHAR100VAKEY
VKKABSales conditions valid from VKKABDATS8DATUM
VKKBISales conditions valid to VKKBIDATS8DATUM
KOTABNRCondition table KOTABNRNUMC3Assigned to domainKOTABNRKON
UPDKZ_KMBWUpdate indicator UPDKZ_DCHAR1UPDKZ
PRACTCompetitor prices: price activation PRACTCHAR1XFELD
MBELNCompetitor: document number of price entry document MBELNCHAR10Assigned to domainALPHAMBELN
MBELPItem number of competitor price entry document MBELPNUMC5Assigned to domainMBELP

Key field Non-key field



How do I retrieve data from SAP structure KMBW using ABAP code?

As KMBW is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on KMBW as there is no data to select.

How to access SAP table KMBW

Within an ECC or HANA version of SAP you can also view further information about KMBW and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!