SAP ABAP Table WRF_PPW_PPDPA_STY (PA Level Representation of a PPD)

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_PPDPA_STY	Table Relationship Diagram
Short Description	PA Level Representation of a PPD

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	PPD Price Activation Level
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	WRF_PPW_GUID		RAW	16	0	Unique, Generated Key
4	PARENT	☐	WRF_PPW_PARENT		RAW	16	0	Parent
5	REFERENCE	☐			RAW	16	0
6	DEVI_PRICE	☐	WRF_PPW_DEVI_PRICE	XFELD	CHAR	1	0	Price Variance
7	SISTER	☐	WRF_PPW_SISTER	XFELD	CHAR	1	0	Related Markdown Proposals Exist
8	NO_OF_STORES	☐	WRF_PPW_NO_OF_STORES		DEC	6	0	Number of Plants Affected by a Price Change
9	GUID_BG	☐			RAW	16	0
10	BUDGET_VP_ACCU	☐	WRF_PPW_BUDGET_VP	WRF_PPW_BUDGET	CURR	13	2	Planned Budget for an Item in Price Planning
11	BG	☐	WRF_PPW_PPDBGPA_STY		STRU	0	0
12	BUDGET_NR	☐	WRF_PPW_BUDGET_NR		NUMC	16	0	Budget Number
13	PROCESS_ID	☐	WRF_BUDG_PROC_ID	WRF_BUDG_PROC_ID	NUMC	2	0	Budget ID
14	BUDGET_VP	☐	WRF_PPW_BUDGET_VP	WRF_PPW_BUDGET	CURR	13	2	Planned Budget for an Item in Price Planning
15	DATE_FROM	☐	WRF_PPW_DATE_FROM	DATUM	DATS	8	0	Validity Start Date of Budget Period
16	DATE_TO	☐	WRF_PPW_DATE_TO	DATUM	DATS	8	0	Validity End Date of Budget Period
17	WAERS_BG	☐	WRF_PPW_BGWAER	WAERS	CUKY	5	0	Budget Currency
18	BUDGET_VP_REL	☐	WRF_PPW_BUDGET_VP_REL	WRF_PPW_BUDGET	CURR	13	2	Internally Released Budget
19	BUDGET_VP_SOLD	☐	WRF_PPW_BUDGET_VP_SOLD	WRF_PPW_BUDGET	CURR	13	2	Budget from Sold Articles
20	BG_TAB	☐	WRF_PPW_PPDBGPA_TTY		TTYP	0	0
21	GUID_STOCK	☐			RAW	16	0
22	STOCK	☐	WRF_PPW_PPDSTOCK_STY		STRU	0	0
23	STOCK	☐	WRF_PPW_STOCK	WRF_PPW_STOCK	QUAN	17	3	Current Stock
24	STOCK_IA	☐	WRF_PPW_STOCK_IA		QUAN	17	3	Included Stock Quantity
25	STOCK_NIA	☐	WRF_PPW_STOCK_NIA		QUAN	17	3	Non-Included Stock Quantity
26	STOCKUNIT	☐	WRF_PPW_STOCKUNIT	MEINS	UNIT	3	0	Base Unit of Measure
27	PLND_SALES_QTY	☐	WRF_PPW_PLAN_MENGE	MENGE	QUAN	13	3	Planned Quantity
28	STOCK_DIFF	☐	WRF_PPW_STOCK_DIFFERENCE	WRF_PPW_STOCK	QUAN	17	3	Stock Difference for Postprocessed Promotion PA Items
29	PLND_QTY_COMPL	☐	WRF_PPW_PLND_QTY_COMPLETE	MENGE	QUAN	13	3	Total Planned Quantity
30	GUID_MDP	☐			RAW	16	0
31	MDP	☐	WRF_PPW_PPDMDP_STY		STRU	0	0
32	ABV_SOLL	☐	WRF_PPW_TARGSLSRTIO	WRF_PPW_PROCENT	DEC	5	2	Target Sales Ratio
33	ABV_IST	☐	WRF_PPW_ACTSLSRTIO	WRF_PPW_PROCENT	DEC	5	2	Actual Sales Ratio
34	MDPRC	☐	WRF_PPW_MDPRC	WRF_PPW_PROCENT	DEC	5	2	Price Reduction as Percentage of Initial Price
35	SELLPER	☐	WRF_PPW_SELLPER		NUMC	4	0	Validity Period of Material According to Markdown Profile
36	MAXPER	☐	WRF_PPW_MAXPER		NUMC	4	0	Validity Period of Markdown Profile
37	MDPROF	☐	WRF_PPW_MDPROF	WRF_SSMPROF	CHAR	10	0	Markdown Profile
38	GUID_AV	☐	WRF_PPW_GUID_AV		RAW	16	0	Worklist GUID
39	RUN_NO	☐	WRF_PPW_RUN_NO		RAW	16	0	Run Number
40	CALCITEM	☐	WRF_PPW_PPDCALCITEM_STY		STRU	0	0
41	GUID_CALC	☐	WRF_PPW_GUID		RAW	16	0	Unique, Generated Key
42	.INCLUDE	☐				0	0	Sales price calculation: key fields in a price calculation
43	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
44	VRKME	☐	W_VRKME_VKP	MEINS	UNIT	3	0	Sales Unit
45	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
46	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization
47	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel
48	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant
49	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type
50	BGINT	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number
51	.INCLUDE	☐				0	0	PPW: Structure to Display Pricing Item Data
52	VKKAB	☐	VKKAB	DATUM	DATS	8	0	Sales conditions valid from
53	VKKBI	☐	VKKBI	DATUM	DATS	8	0	Sales conditions valid to
54	VKKAM	☐	VKKAM	DATUM	DATS	8	0	Key date for sales price conditions
55	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
56	VLGWK	☐	VLGWK	WERKS	CHAR	4	0	Sales Pricing: Reference Plant
57	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization
58	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency
59	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor
60	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record
61	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type
62	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key
63	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
64	KWAER	☐	KAWAER	WAERS	CUKY	5	0	Sales Pricing: Pricing Currency
65	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
66	AUFSG	☐	AUFSG	WERTV6	CURR	11	2	Actual Markup in Sales Price Calculation
67	PAUFS	☐	PAUFS	WERTV6	CURR	11	2	Planned markup
68	PENDP	☐	PENDP	WERTV6	CURR	11	2	SP calculation: Planned sales pr. w/o price point rounding
69	VKPNE	☐	VKPNE	WERTV6	CURR	11	2	Sales price (net)
70	VKPBR	☐	VKPBR	WERTV6	CURR	11	2	Sales price (gross)
71	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency
72	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
73	KALEB	☐	KALEB	KALEB	CHAR	2	0	Sales Pricing: Pricing level
74	SPANE	☐	SPANE	WERTV6	CURR	11	2	Margin (net) in sales price calculation
75	SPABR	☐	SPABR	WERTV6	CURR	11	2	Margin (gross) in sales price calculation
76	ENDPA	☐	ENDPA	WERTV6	CURR	11	2	Current Final Price
77	KALEA	☐	WRF_RPC_KALEA	KALEB	CHAR	2	0	Pricing Level of Current Final Price
78	SPANA	☐	SPANA	WERTV6	CURR	11	2	Current margin (net)
79	SPABA	☐	SPABA	WERTV6	CURR	11	2	Current margin (gross)
80	ROTPR	☐	ROTPR	WERTV6	CURR	11	2	Reduced-from price
81	MITPR	☐	MITPR	WERTV6	CURR	11	2	Cash price
82	EMPPR	☐	EMPPR	WERTV6	CURR	11	2	Recommended price
83	VORPR	☐	W_VORPR	WERTV6	CURR	11	2	Sales Pricing: Suggested Price
84	VKP01	☐	WRF_RPC_VKP01	WERTV6	CURR	11	2	Variable Sales Price 1
85	VKP02	☐	WRF_RPC_VKP02	WERTV6	CURR	11	2	Variable Sales Price 2
86	VKP03	☐	WRF_RPC_VKP03	WERTV6	CURR	11	2	Variable Sales Price 3
87	PROZ1	☐	WRF_RPC_PROZ1	WERTV6	CURR	11	2	SP Calculation: Variable Percentage 1
88	PROZ2	☐	WRF_RPC_PROZ2	WERTV6	CURR	11	2	SP Calculation: Variable Percentage 2
89	MPROZ	☐	MPROZ	WERTV6	CURR	11	2	Pricing: Price Change in Percent
90	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
91	EKERV	☐	EKERV_M	EKERV	CHAR	2	0	Purchase price determination sequence
92	EKERA	☐	EKERA	EKERA	CHAR	1	0	Purchase price determination type
93	VKERV	☐	EKERV_V	EKERV	CHAR	2	0	Sales price determination sequence
94	VKERA	☐	VKERA	VKERA	CHAR	1	0	Sales price determination type
95	EPTYP	☐	EPTYP	EPTYP	CHAR	2	0	Price Point Category
96	RKTYP	☐	WRF_RPC_RKTYP	WRF_RPC_RKTYP	CHAR	1	0	Price Point Groups: Ranking Type
97	EPRGR	☐	EPRGR	EPRGR	CHAR	6	0	Price point group
98	PVGRD	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change
99	ENDNE	☐	WRF_PPW_ENDNE	WERTV6	CURR	11	2	Final Price (Net)
100	ENDBR	☐	WRF_PPW_ENDBR	WERTV6	CURR	11	2	Final Price (Gross)
101	ENDPA_PROMO	☐	WRF_PPW_ENDPA_PROMO	WERTV6	CURR	11	2	Current Promotion Sales Price
102	ENDNA	☐	WRF_PPW_ENDNA	WERTV6	CURR	11	2	Current Final Price (Net)
103	ENDBA	☐	WRF_PPW_ENDBA	WERTV6	CURR	11	2	Current Final Price (Gross)
104	MABSO	☐	WRF_PPW_MABSO	WERTV6	CURR	11	2	Absolute Price Change in Relation to Current Final Price
105	NABSO	☐	WRF_PPW_NABSO	WERTV6	CURR	11	2	Absolute Net Price Change in Relation to Current Final Price
106	INIAM	☐	W_INIAM	DATUM	DATS	8	0	Sales price calculations: key date for initial price
107	INIPR	☐	WRF_PPW_INIPR	WERTV6	CURR	11	2	Original Price
108	IPROZ	☐	WRF_PPW_IPROZ	WERTV6	CURR	11	2	Percentage Price Change in Relation to Original Price
109	IABSO	☐	WRF_PPW_IABSO	WERTV6	CURR	11	2	Absolute Price Change in Relation to Original Price
110	EPROZ	☐	WRF_PPW_EPROZ	WERTV6	CURR	11	2	Percentage Price Change (Compared to Last Final Price)
111	EABSO	☐	WRF_PPW_EABSO	WERTV6	CURR	11	2	Absolute Price Change (Compared to Last Final Price)
112	PPROZ	☐	WRF_PPW_PPROZ	WERTV6	CURR	11	2	Percentage Price Change (Compared to Planned Final Price)
113	PABSO	☐	WRF_PPW_PABSO	WERTV6	CURR	11	2	Absolute Price Change (Comp. to Last Final Price)
114	NWLEV	☐	WRF_PPW_NWLEV	XFELD	CHAR	1	0	Flag: New Pricing Level
115	ENDPA_PROMO_CHECKED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
116	DEC_POS	☐	WAERST	WAERS	CUKY	5	0	Technical currency (3 decimal places)
117	RECAL	☐	WRF_PPW_RECAL	FLAG	CHAR	1	0	Indicator: Redetermine Prices
118	ROUND	☐	WRF_PPW_ROUND	FLAG	CHAR	1	0	Rounding Category
119	DECPL	☐	NUM02	NUM02	NUMC	2	0	ABAB Dictionary: Two-Digit Numeric Field
120	BONKZ	☐	W_BONKZ_KALP	XFELD	CHAR	1	0	Sales Pricing: Indicator - Is Final Price Net or Gross Price
121	NEPGR	☐	NEPGR	XFELD	CHAR	1	0	Indicator: No Price Point Group
122	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material
123	SATNR	☐	WSTR_SATNR	MATNR	CHAR	18	0	Material Number of the Generic Material
124	KBELN	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document
125	KBELP	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document
126	KBELN_COPY	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document
127	KBELP_COPY	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document
128	KNUMH_V	☐	KNUMH_V	KNUMB	CHAR	10	0	Number of the sales price condition record
129	BPSTA	☐	BPSTA	BPSTA	CHAR	1	0	Pricing: Status of Item in Pricing Document
130	SUBRC	☐	SUBRC	EK08R_RC	NUMC	2	0	Subroutines for return code
131	HERKU	☐	W_HERKU	W_ARCH	CHAR	1	0	Origin of Pricing Document
132	GUID_VERS	☐			RAW	16	0
133	TIMEST_CALC	☐	WRF_PPW_TIMEST_CALC	CHAR14	CHAR	14	0	Time Stamp for Creating Costing Data
134	FILGR	☐	WRF_PPW_FILGR		CHAR	18	0	Local Plant Groups
135	REFSITE_VK	☐	WRF_PPW_REFSITE_VK		CURR	11	2	Int. Calculation: Price of Reference Store
136	WEIGH_AVERAGE_VK	☐	WRF_PPW_WEIGHTED_AVERAGE_VK		CURR	11	2	Int. Calculation: Median Weighted Sales Price of Assg. Store
137	AVERAGE_VK	☐	WRF_PPW_AVERAGE_VK		CURR	11	2	Int. Calculation: Median Sales Price of Assigned Stores
138	MIN_VK	☐	WRF_PPW_MIN_VK		CURR	11	2	Minimum Price for Dependent Stores
139	REFERENCE_PRICE	☐	WRF_PPW_REFERENCE_PRICE	WERTV6	CURR	11	2	Reference Price for Calculating Budget in Promotion Process
140	SORTKEY_PA	☐	WRF_PPW_SORTKEY_PA	CHAR22	CHAR	22	0	Sort Key for Price Activation Levels
141	AKTIV	☐	WRF_PPW_AKTIV	XFELD	CHAR	1	0	Processed by Activation Report and Budgets (if Used) Updated
142	DEVI_PRICE_EXIST	☐	WRF_PPW_DEVI_PRICE_EXIST	CHAR1	CHAR	1	0	Flag: Price Variances Exist
143	LOEKZ	☐	WRF_PPW_LOEKZ	XFELD	CHAR	1	0	Deletion Indicator
144	PROMO_CHANGED	☐	WRF_PPW_PROMO_CHANGED	WRF_PPW_PROMO_CHANGED	CHAR	1	0	Flag for Subsequent Change of a Promotion
145	DEAKT	☐	WRF_PPW_DEAKT	XFELD	CHAR	1	0	Price Plan Item Was Deactivated
146	BUDGET_VP_ACCU_REL	☐	WRF_PPW_BUDGET_VP_REL	WRF_PPW_BUDGET	CURR	13	2	Internally Released Budget
147	REFSITE_VK_ORIG	☐	WRF_PPW_REFSITE_VK		CURR	11	2	Int. Calculation: Price of Reference Store
148	WEIGH_AVRG_VK_OR	☐	WRF_PPW_WEIGHTED_AVERAGE_VK		CURR	11	2	Int. Calculation: Median Weighted Sales Price of Assg. Store
149	AVERAGE_VK_ORIG	☐	WRF_PPW_AVERAGE_VK		CURR	11	2	Int. Calculation: Median Sales Price of Assigned Stores
150	BUDGET_VP_ACCU_SOLD	☐	WRF_PPW_BUDGET_VP_SOLD	WRF_PPW_BUDGET	CURR	13	2	Budget from Sold Articles

History

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