SAP ABAP Table WVKP_PRICING_DOC_STY (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

Table Category	INTTAB	Structure
Structure	WVKP_PRICING_DOC_STY	Table Relationship Diagram
Short Description	Selection of pricing documents (header and item criteria)

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	KBELN	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document	*
2	KBELP	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document	*
3	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
4	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
5	LIGRU	☐	LIGRU	LIGRU	CHAR	1	0	List group
6	LIVAR	☐	LIVAR	LIVAR	CHAR	2	0	List variant for sales price calculation	*
7	KBART	☐	KBART	KBART	CHAR	4	0	Pricing document type
8	ESTAR	☐	ESTAR	ESTAR	CHAR	1	0	Creation type of document
9	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	VORGA	☐	VORGA	VORGA	CHAR	2	0	Transaction/event
13	FRBNR	☐	FRBNR	XBLNR	CHAR	16	0	Number of bill of lading at time of goods receipt
14	.INCLUDE	☐				0	0	Data part of table WKBP (pricing document: item)
15	EKKAB	☐	EKKAB	DATUM	DATS	8	0	Purchase price conditions valid from
16	EKKBI	☐	EKKBI	DATUM	DATS	8	0	Purchase price conditions valid to
17	VKKAB	☐	VKKAB	DATUM	DATS	8	0	Sales conditions valid from
18	VKKBI	☐	VKKBI	DATUM	DATS	8	0	Sales conditions valid to
19	EKNUM	☐	EKNUM	KNUMV	CHAR	10	0	SP: Key for Transaction Conditions in Purchase Pricing
20	VKNUM	☐	VKNUM	KNUMV	CHAR	10	0	SP: Key for Transaction Conditions in Purchase Pricing
21	EKAPP	☐	KAPPL	KAPPL	CHAR	2	0	Application	*
22	EKALS	☐	EKALS	KALSM	CHAR	6	0	Sales Pricing: Purchase Price Calculation Schema	*
23	VKALS	☐	VKALS	KALSM	CHAR	6	0	Sales Pricing: Sales Price Calculation Schema	*
24	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
25	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
26	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
27	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
28	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
29	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
30	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
31	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
32	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
33	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
34	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
35	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	*
36	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
37	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
38	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
39	AUFSG	☐	AUFSG	WERTV6	CURR	11	2	Actual Markup in Sales Price Calculation
40	PAUFS	☐	PAUFS	WERTV6	CURR	11	2	Planned markup
41	PENDP	☐	PENDP	WERTV6	CURR	11	2	SP calculation: Planned sales pr. w/o price point rounding
42	VKPNE	☐	VKPNE	WERTV6	CURR	11	2	Sales price (net)
43	VKPBR	☐	VKPBR	WERTV6	CURR	11	2	Sales price (gross)
44	KWAER	☐	KAWAER	WAERS	CUKY	5	0	Sales Pricing: Pricing Currency	*
45	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
46	SPANE	☐	SPANE	WERTV6	CURR	11	2	Margin (net) in sales price calculation
47	SPABR	☐	SPABR	WERTV6	CURR	11	2	Margin (gross) in sales price calculation
48	ENDPA	☐	ENDPA	WERTV6	CURR	11	2	Current Final Price
49	SPANA	☐	SPANA	WERTV6	CURR	11	2	Current margin (net)
50	SPABA	☐	SPABA	WERTV6	CURR	11	2	Current margin (gross)
51	ROTPR	☐	ROTPR	WERTV6	CURR	11	2	Reduced-from price
52	MITPR	☐	MITPR	WERTV6	CURR	11	2	Cash price
53	EMPPR	☐	EMPPR	WERTV6	CURR	11	2	Recommended price
54	VORPR	☐	W_VORPR	WERTV6	CURR	11	2	Sales Pricing: Suggested Price
55	VKP01	☐	VKPZW	WERTV6	CURR	11	2	Variable sales price
56	VKP02	☐	VKPZW	WERTV6	CURR	11	2	Variable sales price
57	VKP03	☐	VKPZW	WERTV6	CURR	11	2	Variable sales price
58	PROZ1	☐	W_PROZ	WERTV6	CURR	11	2	Sales Price Calculation: (general) percentage-based factor
59	PROZ2	☐	W_PROZ	WERTV6	CURR	11	2	Sales Price Calculation: (general) percentage-based factor
60	EVAUF	☐	EVAUF	WERTV6	CURR	11	2	Sales Pricing: Markup for Determining the Retail Price
61	EVPRS	☐	EVPRS	WERTV6	CURR	11	2	Sales Pricing: Retail Price
62	EVSPA	☐	EVSPA	WERTV6	CURR	11	2	Sales Pricing: Retail Price Margin
63	BPSTA	☐	BPSTA	BPSTA	CHAR	1	0	Pricing: Status of Item in Pricing Document
64	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	*
65	VKABA	☐	VKKAB	DATUM	DATS	8	0	Sales conditions valid from
66	VKBIA	☐	VKKBI	DATUM	DATS	8	0	Sales conditions valid to
67	INFWK	☐	INFWK	XFELD	CHAR	1	0	Info record at plant level
68	ESOKZ	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
69	EVPAU	☐	EVPAU	WERTV6	CURR	11	2	Planned markup for determining the retail price
70	CKNUM	☐	CKNUM	KNUMV	CHAR	10	0	Sales Price: Key for Transaction Conditions in Master Conds.
71	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	*
72	EVWRS	☐	VWAER	WAERS	CUKY	5	0	Sales currency	*
73	EGKAL	☐	EGKAL	EGKAL	CHAR	1	0	Data held when basic purchase price changes
74	INIPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
75	KNUMH_V	☐	KNUMH_V	KNUMB	CHAR	10	0	Number of the sales price condition record
76	EKERV	☐	EKERV_M	EKERV	CHAR	2	0	Purchase price determination sequence	*
77	BWERA	☐	BWERA	BWERA	CHAR	1	0	Source determination type
78	EKERA	☐	EKERA	EKERA	CHAR	1	0	Purchase price determination type
79	EFNAM	☐	EFNAM	FUNCNAME	CHAR	30	0	Name of the Function Module in PP Determination Type C	*
80	VKERV	☐	EKERV_V	EKERV	CHAR	2	0	Sales price determination sequence	*
81	VKERA	☐	VKERA	VKERA	CHAR	1	0	Sales price determination type
82	LIFEL	☐	LIFELD	LIFELD	CHAR	5	0	Sales Pricing: List Field for Determining Sales Price	*
83	ECKKZ	☐	ECKKZ	XFELD	CHAR	1	0	SP calc.: price point rounding for suggested final price
84	PVGRD	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	*
85	FAMNR	☐	WPF_FAMNR	CHAR10	CHAR	10	0	Identification Number for Price Family
86	GRP01	☐	WPF_GROUP	CHAR10	CHAR	10	0	Number of a Family Group in a Price Family
87	FMTYP	☐	WPF_FMTYP	WPF_FMTYP	CHAR	2	0	Type of Family Member
88	SMATN	☐	WPF_SMATN	MATNR	CHAR	18	0	Master Material of a Price Family	*
89	FCHAL	☐	WPF_FCHAL	WPF_MODKZ	CHAR	1	0	Price Change Allowed (_=No, 1=Group, 2=Group and Article)
90	FHIDE	☐	WPF_FHIDE	XFELD	CHAR	1	0	Pricing Item Hidden for Family Member (X = Yes)
91	EPRGR	☐	EPRGR	EPRGR	CHAR	6	0	Price point group	*
92	EPRG2	☐	EPRG2	EPRGR	CHAR	6	0	Price point group for retail price	*
93	NEPGR	☐	NEPGR	XFELD	CHAR	1	0	Indicator: No Price Point Group
94	NEPG2	☐	NEPGR	XFELD	CHAR	1	0	Indicator: No Price Point Group
95	.INCLUDE	☐				0	0	Include for Table WKBP
96	INIAM	☐	W_INIAM	DATUM	DATS	8	0	Sales price calculations: key date for initial price
97	EPTYP	☐	EPTYP	EPTYP	CHAR	2	0	Price Point Category
98	EPTY2	☐	EPTYP	EPTYP	CHAR	2	0	Price Point Category
99	RKTYP	☐	WRF_RPC_RKTYP	WRF_RPC_RKTYP	CHAR	1	0	Price Point Groups: Ranking Type
100	RKTY2	☐	WRF_RPC_RKTYP	WRF_RPC_RKTYP	CHAR	1	0	Price Point Groups: Ranking Type
101	BGINT	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number	*
102	STPLGR	☐	WRF_STPLGR	WRF_STPLGR	CHAR	1	0	Status of Plant Group
103	VLGWK	☐	VLGWK	WERKS	CHAR	4	0	Sales Pricing: Reference Plant	*
104	KALEB	☐	KALEB	KALEB	CHAR	2	0	Sales Pricing: Pricing level
105	VKSCH	☐	W_VKSCH_KALP	KSCHL	CHAR	4	0	Sales Pricing: Condition Type for the Sales Price	*
106	VKOTABN	☐	W_VKOTABN_KALP	KOTABNR	NUMC	3	0	Sales Pricing: Condition Table for the Sales Price	*
107	KALEA	☐	KALEA	KALEB	CHAR	2	0	Pricing Level of Current Final Price
108	VKSCA	☐	W_VKSCA_KALP	KSCHL	CHAR	4	0	SP Calculation: Condition Type for Current Sales Price	*
109	VKOTABA	☐	W_VKOTABA_KALP	KOTABNR	NUMC	3	0	Sales Pricing: Condition Table for the Current Sales Price	*
110	.INCLUDE	☐				0	0	Plant Grouping Structure (for ALV Field Catalog)
111	FILGR	☐	W_FILGR	KLASSE	CHAR	18	0	Plant grouping, sales promotion
112	MAKT_MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
113	T006A_MSEHT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
114	TVKOT_VTEXT	☐	WVKP_TVKOT_VTEXT	TEXT20	CHAR	20	0	Sales Organization Description
115	TVTWT_VTEXT	☐	WVKP_TVTWT_VTEXT	TEXT20	CHAR	20	0	Distribution Channel Description
116	T001W_NAME1	☐	WVKP_T001W_NAME1	TEXT30	CHAR	30	0	Plant Description
117	T189T_PTEXT	☐	WVKP_T189T_PTEXT	TEXT20	CHAR	20	0	Price list type Description
118	UPDKZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
119	SELKZ	☐	SYMARKY	SYCHAR01	CHAR	1	0	Line Letter
120	BPSTA_ALT	☐	SYMARKY	SYCHAR01	CHAR	1	0	Line Letter

History

Last changed by/on	SAP	20130529
SAP Release Created in	605