SAP table WKBP (Pricing document: item)

SAP table WKBP has 3 primary key fields being MANDT,KBELN,KBELP.

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
KBELN Number of pricing document CHAR 10 0 WKBK KBELN
KBELP Item Number of Pricing Document NUMC 5 0 KBELP
EKKAB Purchase price conditions valid from DATS 8 0 EKKAB
EKKBI Purchase price conditions valid to DATS 8 0 EKKBI
VKKAB Sales conditions valid from DATS 8 0 VKKAB
VKKBI Sales conditions valid to DATS 8 0 VKKBI
EKNUM SP: Key for Transaction Conditions in Purchase Pricing CHAR 10 0 EKNUM
VKNUM SP: Key for Transaction Conditions in Purchase Pricing CHAR 10 0 VKNUM
EKAPP Application CHAR 2 0 * KAPPL
EKALS Sales Pricing: Purchase Price Calculation Schema CHAR 6 0 T683 EKALS
VKALS Sales Pricing: Sales Price Calculation Schema CHAR 6 0 T683 VKALS
MATKL Material Group CHAR 9 0 T023 MATKL
MATNR Material Number CHAR 40 0 MARA MATNR
VRKPE Sales price unit DEC 5 0 VRKPE
VRKME Sales unit UNIT 3 0 T006 VRKME
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
WERKS Plant CHAR 4 0 T001W WERKS_D
EKORG Purchasing organization CHAR 4 0 T024E EKORG
HWAER Local Currency CUKY 5 0 TCURC HWAER
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
LTSNR Supplier Subrange CHAR 6 0 WYT1 LTSNR
WAERS Currency Key CUKY 5 0 TCURC WAERS
EKPGR Purchase Price Calculation: (Basic Purchase Price) CURR 11 2 EKPGR
EKPNN Sales Pricing: Purchase Price (Net/Net) CURR 11 2 EKPNN
AUFSG Actual Markup in Sales Price Calculation CURR 11 2 AUFSG
PAUFS Planned markup CURR 11 2 PAUFS
PENDP SP calculation: Planned sales pr. w/o price point rounding CURR 11 2 PENDP
VKPNE Sales price (net) CURR 11 2 VKPNE
VKPBR Sales price (gross) CURR 11 2 VKPBR
KWAER Sales Pricing: Pricing Currency CUKY 5 0 TCURC KAWAER
ENDPR Final price CURR 11 2 ENDPR
SPANE Margin (net) in sales price calculation CURR 11 2 SPANE
SPABR Margin (gross) in sales price calculation CURR 11 2 SPABR
ENDPA Current Final Price CURR 11 2 ENDPA
SPANA Current margin (net) CURR 11 2 SPANA
SPABA Current margin (gross) CURR 11 2 SPABA
ROTPR Reduced-from price CURR 11 2 ROTPR
MITPR Cash price CURR 11 2 MITPR
EMPPR Recommended price CURR 11 2 EMPPR
VORPR Sales Pricing: Suggested Price CURR 11 2 W_VORPR
VKP01 Variable sales price CURR 11 2 VKPZW
VKP02 Variable sales price CURR 11 2 VKPZW
VKP03 Variable sales price CURR 11 2 VKPZW
PROZ1 Sales Price Calculation: (general) percentage-based factor CURR 11 2 W_PROZ
PROZ2 Sales Price Calculation: (general) percentage-based factor CURR 11 2 W_PROZ
EVAUF Sales Pricing: Markup for Determining the Retail Price CURR 11 2 EVAUF
EVPRS Sales Pricing: Retail Price CURR 11 2 EVPRS
EVSPA Sales Pricing: Retail Price Margin CURR 11 2 EVSPA
BPSTA Pricing: Status of Item in Pricing Document CHAR 1 0 BPSTA
A New, not saved
B Changed, not saved
C Saved
D Flagged for Deletion
E Cancelled
PLTYP Price List Type CHAR 2 0 T189 PLTYP
VKABA Sales conditions valid from DATS 8 0 VKKAB
VKBIA Sales conditions valid to DATS 8 0 VKKBI
INFWK Info record at plant level CHAR 1 0 INFWK
ESOKZ Purchasing info record category CHAR 1 0 ESOKZ
0 Standard
1 Chargeable
2 Consignment
3 Subcontracting
P Pipeline
EVPAU Planned markup for determining the retail price CURR 11 2 EVPAU
CKNUM Sales Price: Key for Transaction Conditions in Master Conds. CHAR 10 0 CKNUM
VWAER Sales currency CUKY 5 0 TCURC VWAER
EVWRS Sales currency CUKY 5 0 TCURC VWAER
EGKAL Data held when basic purchase price changes CHAR 1 0 EGKAL
1 Markup is held
2 Final price is held
3 Use planned markup
INIPR Final price CURR 11 2 ENDPR
KNUMH_V Number of the sales price condition record CHAR 10 0 KNUMH_V
EKERV Purchase Price Determination Sequence CHAR 2 0 * EKERV_M
BWERA Source determination type CHAR 1 0 BWERA
A No source determination
B Source determination without error handling
C Source determination with error handling
EKERA Purchase price determination type CHAR 1 0 EKERA
A PP determination with schema as in standard schema determin.
B PP determination with specified special schema
C PP determination using customer-defined function module
D Interactive entry
E PP determination from material components (sales set)
F Supplier mixed price
EFNAM Name of the Function Module in PP Determination Type C CHAR 30 0 * EFNAM
VKERV Sales Price Determination Sequence CHAR 2 0 * EKERV_V
VKERA Sales price determination type CHAR 1 0 VKERA
A Calculate sales price from planned markup
B Use current sales price, adjust margin
C Copy sales price from list field
D Percentage price change relating to list field
E Absolute price change relating to list field
LIFEL Sales Pricing: List Field for Determining Sales Price CHAR 5 0 * LIFELD
ECKKZ SP calc.: price point rounding for suggested final price CHAR 1 0 ECKKZ
PVGRD Reason for retail price change CHAR 4 0 TWBN PV_GRUND
FAMNR Identification Number for Price Family CHAR 10 0 WPF_FAMNR
GRP01 Number of a Family Group in a Price Family CHAR 10 0 WPF_GROUP
FMTYP Type of Family Member CHAR 2 0 WPF_FMTYP
01 Main Material
02 Reference material
03 Subsequent Material
SMATN Master Material of a Price Family CHAR 40 0 WPF_SMATN
FCHAL Price Change Allowed (_=No, 1=Group, 2=Group and Article) CHAR 1 0 WPF_FCHAL
FHIDE Pricing Item Hidden for Family Member (X = Yes) CHAR 1 0 WPF_FHIDE
EPRGR Price point group CHAR 6 0 * EPRGR
EPRG2 Price point group for retail price CHAR 6 0 * EPRG2
NEPGR Indicator: No Price Point Group CHAR 1 0 NEPGR
NEPG2 Indicator: No Price Point Group CHAR 1 0 NEPGR
INIAM Sales price calculations: key date for initial price DATS 8 0 W_INIAM
EPTYP Price Point Category CHAR 2 0 EPTYP
01 Final price
02 Retail price (for wholesalers only)
11 Markdown Planning Final Price
21 Promotion Final Price
EPTY2 Price Point Category CHAR 2 0 EPTYP
01 Final price
02 Retail price (for wholesalers only)
11 Markdown Planning Final Price
21 Promotion Final Price
RKTYP Price Point Groups: Ranking Type CHAR 1 0 WRF_RPC_RKTYP
A Default
B Alternative
RKTY2 Price Point Groups: Ranking Type CHAR 1 0 WRF_RPC_RKTYP
A Default
B Alternative
BGINT Internal Class Number NUMC 10 0 * CLINT
STPLGR Status of Plant Group CHAR 1 0 WRF_STPLGR
1 Plant Groups of Classification System
2 Intra-Promotional Plant Groups Generated from Class. System
3 Intra-Promotional Plant Groups Generated Manually
VLGWK Sales Pricing: Reference Plant CHAR 4 0 * VLGWK
KALEB Sales Pricing: Pricing level CHAR 2 0 KALEB
01 Distribution Chain
02 Plant
03 Price list
VKSCH Sales Pricing: Condition Type for the Sales Price CHAR 4 0 * W_VKSCH_KALP
VKOTABN Sales Pricing: Condition Table for the Sales Price CHAR 3 0 * W_VKOTABN_KALP
KALEA Pricing Level of Current Final Price CHAR 2 0 KALEA
VKSCA SP Calculation: Condition Type for Current Sales Price CHAR 4 0 * W_VKSCA_KALP
VKOTABA Sales Pricing: Condition Table for the Current Sales Price CHAR 3 0 * W_VKOTABA_KALP

WKBP foreign key relationships

Table Field Check Table Check Field
0 WKBP EKALS T683 Pricing procedures KAPPL
0 WKBP EKALS T683 Pricing procedures KALSM
1 WKBP EKORG T024E Purchasing Organizations EKORG
0 WKBP EVWRS TCURC Currency Codes MANDT
0 WKBP EVWRS TCURC Currency Codes WAERS
1 WKBP HWAER TCURC Currency Codes MANDT
1 WKBP HWAER TCURC Currency Codes WAERS
0 WKBP KBELN WKBK Pricing document: header MANDT
0 WKBP KBELN WKBK Pricing document: header KBELN
1 WKBP KWAER TCURC Currency Codes MANDT
1 WKBP KWAER TCURC Currency Codes WAERS
0 WKBP LIFNR LFA1 Supplier Master (General Section) MANDT
0 WKBP LIFNR LFA1 Supplier Master (General Section) LIFNR
1 WKBP LTSNR WYT1 Vendor Subrange MANDT
1 WKBP LTSNR WYT1 Vendor Subrange LIFNR
1 WKBP LTSNR WYT1 Vendor Subrange LTSNR
0 WKBP MANDT T000 Clients MANDT
1 WKBP MATKL T023 Material Groups MATKL
0 WKBP MATNR MARA General Material Data MANDT
0 WKBP MATNR MARA General Material Data MATNR
1 WKBP PLTYP T189 Conditions: Price List Types MANDT
1 WKBP PLTYP T189 Conditions: Price List Types PLTYP
0 WKBP PVGRD TWBN Reason for Price Change MANDT
0 WKBP PVGRD TWBN Reason for Price Change PV_GRUND
1 WKBP VKALS T683 Pricing procedures KAPPL
1 WKBP VKALS T683 Pricing procedures KALSM
0 WKBP VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 WKBP VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 WKBP VRKME T006 Units of Measurement MANDT
1 WKBP VRKME T006 Units of Measurement MSEHI
0 WKBP VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 WKBP VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
1 WKBP VWAER TCURC Currency Codes MANDT
1 WKBP VWAER TCURC Currency Codes WAERS
0 WKBP WAERS TCURC Currency Codes MANDT
0 WKBP WAERS TCURC Currency Codes WAERS
1 WKBP WERKS T001W Plants/Branches WERKS