SAP ABAP View V_WKBP (Selection of pricing documents (header and item criteria))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WVKP (Package) IS-R: Sales pricing

Basic Data

View Type	D	Database View
Database View	V_WKBP
Short Description	Selection of pricing documents (header and item criteria)
Root table	WKBK	Pricing document: header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WKBK	WKBK
2	WKBP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	WKBK	MANDT	JL	EQ				0	0
2	WKBP	MANDT	JR	EQ			AND	0	0
3	WKBK	KBELN	JL	EQ				0	0
4	WKBP	KBELN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	WKBP	MANDT		☐	MANDT	☐	Client
2	KBELN	WKBP	KBELN		☐	KBELN	☐	Number of pricing document
3	KBELP	WKBP	KBELP		☐	KBELP	☐	Item Number of Pricing Document
4	EKKAB	WKBP	EKKAB		☐	EKKAB	☐	Purchase price conditions valid from
5	EKKBI	WKBP	EKKBI		☐	EKKBI	☐	Purchase price conditions valid to
6	VKKAB	WKBP	VKKAB		☐	VKKAB	☐	Sales conditions valid from
7	VKKBI	WKBP	VKKBI		☐	VKKBI	☐	Sales conditions valid to
8	EKNUM	WKBP	EKNUM		☐	EKNUM	☐	SP: Key for Transaction Conditions in Purchase Pricing
9	VKNUM	WKBP	VKNUM		☐	VKNUM	☐	SP: Key for Transaction Conditions in Purchase Pricing
10	EKAPP	WKBP	EKAPP		☐	KAPPL	☐	Application
11	EKALS	WKBP	EKALS		☐	EKALS	☐	Sales Pricing: Purchase Price Calculation Schema
12	VKALS	WKBP	VKALS		☐	VKALS	☐	Sales Pricing: Sales Price Calculation Schema
13	MATKL	WKBP	MATKL		☐	MATKL	☐	Material Group
14	MATNR	WKBP	MATNR		☐	MATNR	☐	Material Number
15	VRKPE	WKBP	VRKPE		☐	VRKPE	☐	Sales price unit
16	VRKME	WKBP	VRKME		☐	VRKME	☐	Sales unit
17	EAN11	WKBP	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)
18	VKORG	WKBP	VKORG		☐	VKORG	☐	Sales Organization
19	VTWEG	WKBP	VTWEG		☐	VTWEG	☐	Distribution Channel
20	WERKS	WKBP	WERKS		☐	WERKS_D	☐	Plant
21	EKORG	WKBP	EKORG		☐	EKORG	☐	Purchasing organization
22	HWAER	WKBP	HWAER		☐	HWAER	☐	Local Currency
23	LIFNR	WKBP	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
24	LTSNR	WKBP	LTSNR		☐	LTSNR	☐	Vendor Subrange
25	WAERS	WKBP	WAERS		☐	WAERS	☐	Currency Key
26	EKPGR	WKBP	EKPGR		☐	EKPGR	☐	Purchase Price Calculation: (Basic Purchase Price)
27	EKPNN	WKBP	EKPNN		☐	EKPNN	☐	Sales Pricing: Purchase Price (Net/Net)
28	AUFSG	WKBP	AUFSG		☐	AUFSG	☐	Actual Markup in Sales Price Calculation
29	PAUFS	WKBP	PAUFS		☐	PAUFS	☐	Planned markup
30	PENDP	WKBP	PENDP		☐	PENDP	☐	SP calculation: Planned sales pr. w/o price point rounding
31	VKPNE	WKBP	VKPNE		☐	VKPNE	☐	Sales price (net)
32	VKPBR	WKBP	VKPBR		☐	VKPBR	☐	Sales price (gross)
33	KWAER	WKBP	KWAER		☐	KAWAER	☐	Sales Pricing: Pricing Currency
34	ENDPR	WKBP	ENDPR		☐	ENDPR	☐	Final price
35	SPANE	WKBP	SPANE		☐	SPANE	☐	Margin (net) in sales price calculation
36	SPABR	WKBP	SPABR		☐	SPABR	☐	Margin (gross) in sales price calculation
37	ENDPA	WKBP	ENDPA		☐	ENDPA	☐	Current Final Price
38	SPANA	WKBP	SPANA		☐	SPANA	☐	Current margin (net)
39	SPABA	WKBP	SPABA		☐	SPABA	☐	Current margin (gross)
40	ROTPR	WKBP	ROTPR		☐	ROTPR	☐	Reduced-from price
41	MITPR	WKBP	MITPR		☐	MITPR	☐	Cash price
42	EMPPR	WKBP	EMPPR		☐	EMPPR	☐	Recommended price
43	VORPR	WKBP	VORPR		☐	W_VORPR	☐	Sales Pricing: Suggested Price
44	VKP01	WKBP	VKP01		☐	VKPZW	☐	Variable sales price
45	VKP02	WKBP	VKP02		☐	VKPZW	☐	Variable sales price
46	VKP03	WKBP	VKP03		☐	VKPZW	☐	Variable sales price
47	PROZ1	WKBP	PROZ1		☐	W_PROZ	☐	Sales Price Calculation: (general) percentage-based factor
48	PROZ2	WKBP	PROZ2		☐	W_PROZ	☐	Sales Price Calculation: (general) percentage-based factor
49	EVAUF	WKBP	EVAUF		☐	EVAUF	☐	Sales Pricing: Markup for Determining the Retail Price
50	EVPRS	WKBP	EVPRS		☐	EVPRS	☐	Sales Pricing: Retail Price
51	EVSPA	WKBP	EVSPA		☐	EVSPA	☐	Sales Pricing: Retail Price Margin
52	BPSTA	WKBP	BPSTA		☐	BPSTA	☐	Pricing: Status of Item in Pricing Document
53	PLTYP	WKBP	PLTYP		☐	PLTYP	☐	Price list type
54	VKABA	WKBP	VKABA		☐	VKKAB	☐	Sales conditions valid from
55	VKBIA	WKBP	VKBIA		☐	VKKBI	☐	Sales conditions valid to
56	INFWK	WKBP	INFWK		☐	INFWK	☐	Info record at plant level
57	EVPAU	WKBP	EVPAU		☐	EVPAU	☐	Planned markup for determining the retail price
58	CKNUM	WKBP	CKNUM		☐	CKNUM	☐	Sales Price: Key for Transaction Conditions in Master Conds.
59	VWAER	WKBP	VWAER		☐	VWAER	☐	Sales currency
60	EVWRS	WKBP	EVWRS		☐	VWAER	☐	Sales currency
61	EGKAL	WKBP	EGKAL		☐	EGKAL	☐	Data held when basic purchase price changes
62	INIPR	WKBP	INIPR		☐	ENDPR	☐	Final price
63	KNUMH_V	WKBP	KNUMH_V		☐	KNUMH_V	☐	Number of the sales price condition record
64	EKERV	WKBP	EKERV		☐	EKERV_M	☐	Purchase price determination sequence
65	BWERA	WKBP	BWERA		☐	BWERA	☐	Source determination type
66	EKERA	WKBP	EKERA		☐	EKERA	☐	Purchase price determination type
67	EFNAM	WKBP	EFNAM		☐	EFNAM	☐	Name of the Function Module in PP Determination Type C
68	VKERV	WKBP	VKERV		☐	EKERV_V	☐	Sales price determination sequence
69	VKERA	WKBP	VKERA		☐	VKERA	☐	Sales price determination type
70	LIFEL	WKBP	LIFEL		☐	LIFELD	☐	Sales Pricing: List Field for Determining Sales Price
71	ECKKZ	WKBP	ECKKZ		☐	ECKKZ	☐	SP calc.: price point rounding for suggested final price
72	FAMNR	WKBP	FAMNR		☐	WPF_FAMNR	☐	Identification Number for Price Family
73	GRP01	WKBP	GRP01		☐	WPF_GROUP	☐	Number of a Family Group in a Price Family
74	FMTYP	WKBP	FMTYP		☐	WPF_FMTYP	☐	Type of Family Member
75	SMATN	WKBP	SMATN		☐	WPF_SMATN	☐	Master Material of a Price Family
76	FCHAL	WKBP	FCHAL		☐	WPF_FCHAL	☐	Price Change Allowed (_=No, 1=Group, 2=Group and Article)
77	FHIDE	WKBP	FHIDE		☐	WPF_FHIDE	☐	Pricing Item Hidden for Family Member (X = Yes)
78	EPRGR	WKBP	EPRGR		☐	EPRGR	☐	Price point group
79	EPRG2	WKBP	EPRG2		☐	EPRG2	☐	Price point group for retail price
80	NEPGR	WKBP	NEPGR		☐	NEPGR	☐	Indicator: No Price Point Group
81	NEPG2	WKBP	NEPG2		☐	NEPGR	☐	Indicator: No Price Point Group
82	ERNAM	WKBK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
83	ERDAT	WKBK	ERDAT		☐	ERDAT	☐	Date on which the record was created
84	KBART	WKBK	KBART		☐	KBART	☐	Pricing document type
85	AENAM	WKBK	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
86	AEDAT	WKBK	AEDAT		☐	AEDAT	☐	Last Changed On
87	BGINT	WKBP	BGINT		☐	CLINT	☐	Internal Class Number
88	STPLGR	WKBP	STPLGR		☐	WRF_STPLGR	☐	Status of Plant Group

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in