1. Home
  2. Resources
  3. SAP Tables
  4. WKBP - Pricing document: item

SAP Table WKBP

Pricing document: item

WKBP (Pricing document: item) 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 WKBP to other SAP tables.

WKBP table fields

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

WKBP foreign key relationships

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