V_WKBP SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




Table View field list including key, data, relationships and ABAP select examples

V_WKBP is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The V_WKBP table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include KBELN (Number of pricing document), KBELP (Item Number of Pricing Document), EKKAB (Purchase price conditions valid from), EKKBI (Purchase price conditions valid to).. 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: Not classified


SAP V_WKBP table view 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
KBELNNumber of pricing document KBELNCHAR10WKBKALPHAKBELN
KBELPItem Number of Pricing Document KBELPNUMC5KBELP
EKKABPurchase price conditions valid from EKKABDATS8DATUM
EKKBIPurchase price conditions valid to EKKBIDATS8DATUM
VKKABSales conditions valid from VKKABDATS8DATUM
VKKBISales conditions valid to VKKBIDATS8DATUM
EKNUMSP: Key for Transaction Conditions in Purchase Pricing EKNUMCHAR10KNUMV
VKNUMSP: Key for Transaction Conditions in Purchase Pricing VKNUMCHAR10KNUMV
EKAPPApplication KAPPLCHAR2KAPPLKAP
EKALSSales Pricing: Purchase Price Calculation Schema EKALSCHAR6T683KALSM
VKALSSales Pricing: Sales Price Calculation Schema VKALSCHAR6T683KALSM
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
VRKPESales price unit VRKPEDEC5DEC5
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
HWAERLocal Currency HWAERCUKY5TCURCWAERS
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
LTSNRVendor Subrange LTSNRCHAR6WYT1LTSNR
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
EKPGRPurchase Price Calculation: (Basic Purchase Price) EKPGRCURR11(2) WERTV6
EKPNNSales Pricing: Purchase Price (Net/Net) EKPNNCURR11(2) WERTV6
AUFSGActual Markup in Sales Price Calculation AUFSGCURR11(2) WERTV6
PAUFSPlanned markup PAUFSCURR11(2) WERTV6
PENDPSP calculation: Planned sales pr. w/o price point rounding PENDPCURR11(2) WERTV6
VKPNESales price (net) VKPNECURR11(2) WERTV6
VKPBRSales price (gross) VKPBRCURR11(2) WERTV6
KWAERSales Pricing: Pricing Currency KAWAERCUKY5TCURCWAERS
ENDPRFinal price ENDPRCURR11(2) WERTV6
SPANEMargin (net) in sales price calculation SPANECURR11(2) WERTV6
SPABRMargin (gross) in sales price calculation SPABRCURR11(2) WERTV6
ENDPACurrent Final Price ENDPACURR11(2) WERTV6
SPANACurrent margin (net) SPANACURR11(2) WERTV6
SPABACurrent margin (gross) SPABACURR11(2) WERTV6
ROTPRReduced-from price ROTPRCURR11(2) WERTV6
MITPRCash price MITPRCURR11(2) WERTV6
EMPPRRecommended price EMPPRCURR11(2) WERTV6
VORPRSales Pricing: Suggested Price W_VORPRCURR11(2) WERTV6
VKP01Variable sales price VKPZWCURR11(2) WERTV6
VKP02Variable sales price VKPZWCURR11(2) WERTV6
VKP03Variable sales price VKPZWCURR11(2) WERTV6
PROZ1Sales Price Calculation: (general) percentage-based factor W_PROZCURR11(2) WERTV6
PROZ2Sales Price Calculation: (general) percentage-based factor W_PROZCURR11(2) WERTV6
EVAUFSales Pricing: Markup for Determining the Retail Price EVAUFCURR11(2) WERTV6
EVPRSSales Pricing: Retail Price EVPRSCURR11(2) WERTV6
EVSPASales Pricing: Retail Price Margin EVSPACURR11(2) WERTV6
BPSTAPricing: Status of Item in Pricing Document BPSTACHAR1BPSTA
PLTYPPrice list type PLTYPCHAR2T189PLTYPVPL
VKABASales conditions valid from VKKABDATS8DATUM
VKBIASales conditions valid to VKKBIDATS8DATUM
INFWKInfo record at plant level INFWKCHAR1XFELD
EVPAUPlanned markup for determining the retail price EVPAUCURR11(2) WERTV6
CKNUMSales Price: Key for Transaction Conditions in Master Conds. CKNUMCHAR10KNUMV
VWAERSales currency VWAERCUKY5TCURCWAERS
EVWRSSales currency VWAERCUKY5TCURCWAERS
EGKALData held when basic purchase price changes EGKALCHAR1EGKAL
INIPRFinal price ENDPRCURR11(2) WERTV6
KNUMH_VNumber of the sales price condition record KNUMH_VCHAR10KNUMB
EKERVPurchase price determination sequence EKERV_MCHAR2EKERVEVM
BWERASource determination type BWERACHAR1BWERA
EKERAPurchase price determination type EKERACHAR1EKERA
EFNAMName of the Function Module in PP Determination Type C EFNAMCHAR30FUNCNAME
VKERVSales price determination sequence EKERV_VCHAR2EKERVEVV
VKERASales price determination type VKERACHAR1VKERA
LIFELSales Pricing: List Field for Determining Sales Price LIFELDCHAR5LIFELD
ECKKZSP calc.: price point rounding for suggested final price ECKKZCHAR1XFELD
FAMNRIdentification Number for Price Family WPF_FAMNRCHAR10CHAR10
GRP01Number of a Family Group in a Price Family WPF_GROUPCHAR10CHAR10
FMTYPType of Family Member WPF_FMTYPCHAR2WPF_FMTYP
SMATNMaster Material of a Price Family WPF_SMATNCHAR18MATN1MATNRMATS_MAT1
FCHALPrice Change Allowed (_=No, 1=Group, 2=Group and Article) WPF_FCHALCHAR1WPF_MODKZ
FHIDEPricing Item Hidden for Family Member (X = Yes) WPF_FHIDECHAR1XFELD
EPRGRPrice point group EPRGRCHAR6EPRGREPG
EPRG2Price point group for retail price EPRG2CHAR6EPRGR
NEPGRIndicator: No Price Point Group NEPGRCHAR1XFELD
NEPG2Indicator: No Price Point Group NEPGRCHAR1XFELD
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
KBARTPricing document type KBARTCHAR4KBART
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
BGINTInternal Class Number CLINTNUMC10CLINT
STPLGRStatus of Plant Group WRF_STPLGRCHAR1WRF_STPLGR

Key field Non-key field



How do I retrieve data from SAP table V_WKBP using ABAP code

The following ABAP code Example will allow you to do a basic selection on V_WKBP to SELECT all data from the table
DATA: WA_V_WKBP TYPE V_WKBP.

SELECT SINGLE *
FROM V_WKBP
INTO CORRESPONDING FIELDS OF WA_V_WKBP
WHERE...

How to access SAP table V_WKBP

Within an ECC or HANA version of SAP you can also view further information about V_WKBP 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!