SAP ABAP Table WRF_PPW_PPDFCPA_STY (Include for Display Structure at PA Level)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-MD-PPW (Application Component) Price Planning Workbench
     ⤷ WRF_PPW_DDIC (Package) Price Planning Workbench - DDIC

Basic Data

Table Category	INTTAB	Structure
Structure	WRF_PPW_PPDFCPA_STY	Table Relationship Diagram
Short Description	Include for Display Structure at PA Level

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	.INCLUDE	☐				0	0	PPW: Structure for Pricing Items
2	GUID_CALC	☐	WRF_PPW_GUID		RAW	16	0	Unique, Generated Key
3	.INCLUDE	☐				0	0	Sales price calculation: key fields in a price calculation
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
5	VRKME	☐	W_VRKME_VKP	MEINS	UNIT	3	0	Sales Unit	*
6	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
7	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
10	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	*
11	BGINT	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number	*
12	.INCLUDE	☐				0	0	PPW: Structure to Display Pricing Item Data
13	VKKAB	☐	VKKAB	DATUM	DATS	8	0	Sales conditions valid from
14	VKKBI	☐	VKKBI	DATUM	DATS	8	0	Sales conditions valid to
15	VKKAM	☐	VKKAM	DATUM	DATS	8	0	Key date for sales price conditions
16	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
17	VLGWK	☐	VLGWK	WERKS	CHAR	4	0	Sales Pricing: Reference Plant	*
18	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
19	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
20	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
21	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
22	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
23	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
24	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
25	KWAER	☐	KAWAER	WAERS	CUKY	5	0	Sales Pricing: Pricing Currency	*
26	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
27	AUFSG	☐	AUFSG	WERTV6	CURR	11	2	Actual Markup in Sales Price Calculation
28	PAUFS	☐	PAUFS	WERTV6	CURR	11	2	Planned markup
29	PENDP	☐	PENDP	WERTV6	CURR	11	2	SP calculation: Planned sales pr. w/o price point rounding
30	VKPNE	☐	VKPNE	WERTV6	CURR	11	2	Sales price (net)
31	VKPBR	☐	VKPBR	WERTV6	CURR	11	2	Sales price (gross)
32	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	*
33	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
34	KALEB	☐	KALEB	KALEB	CHAR	2	0	Sales Pricing: Pricing level
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	KALEA	☐	WRF_RPC_KALEA	KALEB	CHAR	2	0	Pricing Level of Current Final Price
39	SPANA	☐	SPANA	WERTV6	CURR	11	2	Current margin (net)
40	SPABA	☐	SPABA	WERTV6	CURR	11	2	Current margin (gross)
41	ROTPR	☐	ROTPR	WERTV6	CURR	11	2	Reduced-from price
42	MITPR	☐	MITPR	WERTV6	CURR	11	2	Cash price
43	EMPPR	☐	EMPPR	WERTV6	CURR	11	2	Recommended price
44	VORPR	☐	W_VORPR	WERTV6	CURR	11	2	Sales Pricing: Suggested Price
45	VKP01	☐	WRF_RPC_VKP01	WERTV6	CURR	11	2	Variable Sales Price 1
46	VKP02	☐	WRF_RPC_VKP02	WERTV6	CURR	11	2	Variable Sales Price 2
47	VKP03	☐	WRF_RPC_VKP03	WERTV6	CURR	11	2	Variable Sales Price 3
48	PROZ1	☐	WRF_RPC_PROZ1	WERTV6	CURR	11	2	SP Calculation: Variable Percentage 1
49	PROZ2	☐	WRF_RPC_PROZ2	WERTV6	CURR	11	2	SP Calculation: Variable Percentage 2
50	MPROZ	☐	MPROZ	WERTV6	CURR	11	2	Pricing: Price Change in Percent
51	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
52	EKERV	☐	EKERV_M	EKERV	CHAR	2	0	Purchase price determination sequence	*
53	EKERA	☐	EKERA	EKERA	CHAR	1	0	Purchase price determination type
54	VKERV	☐	EKERV_V	EKERV	CHAR	2	0	Sales price determination sequence	*
55	VKERA	☐	VKERA	VKERA	CHAR	1	0	Sales price determination type
56	EPTYP	☐	EPTYP	EPTYP	CHAR	2	0	Price Point Category
57	RKTYP	☐	WRF_RPC_RKTYP	WRF_RPC_RKTYP	CHAR	1	0	Price Point Groups: Ranking Type
58	EPRGR	☐	EPRGR	EPRGR	CHAR	6	0	Price point group	TWPK
59	PVGRD	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	TWBN
60	ENDNE	☐	WRF_PPW_ENDNE	WERTV6	CURR	11	2	Final Price (Net)
61	ENDBR	☐	WRF_PPW_ENDBR	WERTV6	CURR	11	2	Final Price (Gross)
62	ENDPA_PROMO	☐	WRF_PPW_ENDPA_PROMO	WERTV6	CURR	11	2	Current Promotion Sales Price
63	ENDNA	☐	WRF_PPW_ENDNA	WERTV6	CURR	11	2	Current Final Price (Net)
64	ENDBA	☐	WRF_PPW_ENDBA	WERTV6	CURR	11	2	Current Final Price (Gross)
65	MABSO	☐	WRF_PPW_MABSO	WERTV6	CURR	11	2	Absolute Price Change in Relation to Current Final Price
66	NABSO	☐	WRF_PPW_NABSO	WERTV6	CURR	11	2	Absolute Net Price Change in Relation to Current Final Price
67	INIAM	☐	W_INIAM	DATUM	DATS	8	0	Sales price calculations: key date for initial price
68	INIPR	☐	WRF_PPW_INIPR	WERTV6	CURR	11	2	Original Price
69	IPROZ	☐	WRF_PPW_IPROZ	WERTV6	CURR	11	2	Percentage Price Change in Relation to Original Price
70	IABSO	☐	WRF_PPW_IABSO	WERTV6	CURR	11	2	Absolute Price Change in Relation to Original Price
71	EPROZ	☐	WRF_PPW_EPROZ	WERTV6	CURR	11	2	Percentage Price Change (Compared to Last Final Price)
72	EABSO	☐	WRF_PPW_EABSO	WERTV6	CURR	11	2	Absolute Price Change (Compared to Last Final Price)
73	PPROZ	☐	WRF_PPW_PPROZ	WERTV6	CURR	11	2	Percentage Price Change (Compared to Planned Final Price)
74	PABSO	☐	WRF_PPW_PABSO	WERTV6	CURR	11	2	Absolute Price Change (Comp. to Last Final Price)
75	NWLEV	☐	WRF_PPW_NWLEV	XFELD	CHAR	1	0	Flag: New Pricing Level
76	ENDPA_PROMO_CHECKED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
77	DEC_POS	☐	WAERST	WAERS	CUKY	5	0	Technical currency (3 decimal places)	*
78	RECAL	☐	WRF_PPW_RECAL	FLAG	CHAR	1	0	Indicator: Redetermine Prices
79	ROUND	☐	WRF_PPW_ROUND	FLAG	CHAR	1	0	Rounding Category
80	DECPL	☐	NUM02	NUM02	NUMC	2	0	ABAB Dictionary: Two-Digit Numeric Field
81	BONKZ	☐	W_BONKZ_KALP	XFELD	CHAR	1	0	Sales Pricing: Indicator - Is Final Price Net or Gross Price
82	NEPGR	☐	NEPGR	XFELD	CHAR	1	0	Indicator: No Price Point Group
83	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
84	SATNR	☐	WSTR_SATNR	MATNR	CHAR	18	0	Material Number of the Generic Material	*
85	KBELN	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document	*
86	KBELP	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document	*
87	KBELN_COPY	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document	*
88	KBELP_COPY	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document	*
89	KNUMH_V	☐	KNUMH_V	KNUMB	CHAR	10	0	Number of the sales price condition record
90	BPSTA	☐	BPSTA	BPSTA	CHAR	1	0	Pricing: Status of Item in Pricing Document
91	SUBRC	☐	SUBRC	EK08R_RC	NUMC	2	0	Subroutines for return code
92	HERKU	☐	W_HERKU	W_ARCH	CHAR	1	0	Origin of Pricing Document
93	ICON_BUDGET	☐	WRF_PPW_ICON_BUDGET	ICON	CHAR	4	0	Budget Status	*
94	ICON_DEP_ART	☐	WRF_PPW_ICON_DEP_ART	ICON	CHAR	4	0	Display "Dependent Material Exists" as Icon	*
95	ICON_DEVI_PRICE	☐	WRF_PPW_ICON_DEVI_PRICE	ICON	CHAR	4	0	Organization Levels with Own Prices Exist	*
96	ICON_SISTER	☐	WRF_PPW_ICON_SISTER	ICON	CHAR	4	0	Display "Related Markdown Proposals Exist" as Icon	*
97	LOEKZ	☐	LOEKZ	XFELD	CHAR	1	0	Asset class marked for deletion
98	DEVI_PRICE_EXIST	☐	WRF_PPW_DEVI_PRICE_EXIST	CHAR1	CHAR	1	0	Flag: Price Variances Exist
99	FILGR	☐	WRF_PPW_FILGR		CHAR	18	0	Local Plant Groups
100	TEXT_WERKS	☐	WRF_PPW_TEXT_WERKS	TEXT20	CHAR	20	0	Name for Plant
101	TEXT_PLTYP	☐	WRF_PPW_TEXT_PLTYP	TEXT20	CHAR	20	0	Name for Price List
102	TEXT_VKORG	☐	WRF_PPW_TEXT_VKORG	TEXT20	CHAR	20	0	Name for Sales Organization
103	TEXT_VTWEG	☐	WRF_PPW_TEXT_VTWEG	TEXT20	CHAR	20	0	Name for Distribution Channel
104	AKTIV	☐	WRF_PPW_AKTIV	XFELD	CHAR	1	0	Processed by Activation Report and Budgets (if Used) Updated
105	PROMO_CHANGED	☐	WRF_PPW_PROMO_CHANGED	WRF_PPW_PROMO_CHANGED	CHAR	1	0	Flag for Subsequent Change of a Promotion
106	PROCESS_TEXT	☐	WRF_PPW_PROCESS_TEXT	CHAR80	CHAR	80	0	Name of a Process ID
107	BUDG_TEXT	☐	WRF_PPW_BUDG_TEXT	CHAR80	CHAR	80	0	Name of a Budget in Price Planning
108	PLND_QTY_COMPL	☐	WRF_PPW_PLND_QTY_COMPLETE	MENGE	QUAN	13	3	Total Planned Quantity
109	REFERENCE_PRICE	☐	WRF_PPW_REFERENCE_PRICE	WERTV6	CURR	11	2	Reference Price for Calculating Budget in Promotion Process
110	MIN_VK	☐	WRF_PPW_MIN_VK		CURR	11	2	Minimum Price for Dependent Stores

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF_PPW_PPDFCPA_STY	EPRGR	TWPK	EPRGR
2	WRF_PPW_PPDFCPA_STY	PVGRD	TWBN	PV_GRUND

History

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