SAP ABAP Table V_WKBP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_WKBP	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_WKBP	EKALS	T683	KALSM	REF	1	N
2	V_WKBP	EKORG	T024E	EKORG	KEY	1	CN
3	V_WKBP	EVWRS	TCURC	WAERS
4	V_WKBP	HWAER	TCURC	WAERS	REF	1	N
5	V_WKBP	KBELN	WKBK	KBELN	KEY	1	N
6	V_WKBP	KWAER	TCURC	WAERS	REF	1	N
7	V_WKBP	LIFNR	LFA1	LIFNR	KEY	1	CN
8	V_WKBP	LTSNR	WYT1	LTSNR	REF	C	CN
9	V_WKBP	MANDT	T000	MANDT	KEY	1	N
10	V_WKBP	MATKL	T023	MATKL	REF	1	CN
11	V_WKBP	MATNR	MARA	MATNR	REF	1	CN
12	V_WKBP	PLTYP	T189	PLTYP
13	V_WKBP	VKALS	T683	KALSM	REF	1	N
14	V_WKBP	VKORG	TVKO	VKORG	KEY	1	CN
15	V_WKBP	VRKME	T006	MSEHI	REF	C	CN
16	V_WKBP	VTWEG	TVTW	VTWEG	KEY	1	CN
17	V_WKBP	VWAER	TCURC	WAERS
18	V_WKBP	WAERS	TCURC	WAERS	REF	1	N
19	V_WKBP	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in