SAP ABAP Table WRF_PPW_PPDFCDEVIANTPRICES_STY (Field Catalog to Maintain Org. Levels with Own Prices)

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_PPDFCDEVIANTPRICES_STY	Table Relationship Diagram
Short Description	Field Catalog to Maintain Org. Levels with Own Prices

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	ICON_PRICE_RISE	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
2	FLAG_SORT_RED	☐	FLAG	FLAG	CHAR	1	0	General Flag
3	FLAG_SORT_YELLOW	☐	FLAG	FLAG	CHAR	1	0	General Flag
4	FLAG_SORT_GREEN	☐	FLAG	FLAG	CHAR	1	0	General Flag
5	FLAG_SORT_INACTIVE	☐	FLAG	FLAG	CHAR	1	0	General Flag
6	ENDPR_NEW	☐	WRF_PPW_ENDPR_FUTURE	WERTV6	CURR	11	2	Final Price of the Superordinate Organization Level
7	BEQUEST_LEVEL	☐	WRF_PPW_BEQUEST_LEVEL	CHAR10	CHAR	10	0	Superordinate Organization Level
8	.INCLUDE	☐				0	0	Field Catalog to Display PA View
9	.INCLUDE	☐				0	0	PPD Price Activation Level
10	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
11	GUID	☐	WRF_PPW_GUID		RAW	16	0	Unique, Generated Key
12	PARENT	☐	WRF_PPW_PARENT		RAW	16	0	Parent
13	REFERENCE	☐			RAW	16	0
14	DEVI_PRICE	☐	WRF_PPW_DEVI_PRICE	XFELD	CHAR	1	0	Price Variance
15	SISTER	☐	WRF_PPW_SISTER	XFELD	CHAR	1	0	Related Markdown Proposals Exist
16	NO_OF_STORES	☐	WRF_PPW_NO_OF_STORES		DEC	6	0	Number of Plants Affected by a Price Change
17	.INCLUDE	☐				0	0	Material Data for Field Catalog for Display at PA Level
18	SAISO	☐	WRF_PPW_SAISO	PERIOD	CHAR	6	0	Season
19	SAISJ	☐	WRF_PPW_SAISJ	CJAHR	CHAR	4	0	Season Year
20	FASHGRD	☐	WRF_PPW_FASHGRD		CHAR	4	0	Fashion Grade
21	SAITY	☐	WRF_PPW_SAITY		CHAR	2	0	Rollout
22	ATTYP	☐	WRF_PPW_ATTYP	ATTYP	CHAR	2	0	Material Category
23	.INCLUDE	☐				0	0	Path Info of a Material in a Hierarchy (Bottom -> Up)
24	NODE01	☐	WRF_HIER_NODE1	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 1
25	NODE02	☐	WRF_HIER_NODE2	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 2
26	NODE03	☐	WRF_HIER_NODE3	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 3
27	NODE04	☐	WRF_HIER_NODE4	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 4
28	NODE05	☐	WRF_HIER_NODE5	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 5
29	NODE06	☐	WRF_HIER_NODE6	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 6
30	NODE07	☐	WRF_HIER_NODE7	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 7
31	NODE08	☐	WRF_HIER_NODE8	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 8
32	NODE09	☐	WRF_HIER_NODE9	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 9
33	NODE10	☐	WRF_HIER_NODE10	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 10
34	.INCLUDE	☐				0	0	Path Texts of a Material in a Hierarchy (Bottom -> Up)
35	NODE01_T	☐	WRF_MATGRP_TEXT1	TEXT40	CHAR	40	0	Short Text 1
36	NODE02_T	☐	WRF_MATGRP_TEXT02	TEXT40	CHAR	40	0	Name of a Node in an Article Hierarchy
37	NODE03_T	☐	WRF_MATGRP_TEXT3	TEXT40	CHAR	40	0	Description 3
38	NODE04_T	☐	WRF_MATGRP_TEXT4	TEXT40	CHAR	40	0	Name 4
39	NODE05_T	☐	WRF_MATGRP_TEXT5	TEXT40	CHAR	40	0	Name 5
40	NODE06_T	☐	WRF_MATGRP_TEXT6	TEXT40	CHAR	40	0	Name 6
41	NODE07_T	☐	WRF_MATGRP_TEXT7	TEXT40	CHAR	40	0	Name 7
42	NODE08_T	☐	WRF_MATGRP_TEXT8	TEXT40	CHAR	40	0	Name 8
43	NODE09_T	☐	WRF_MATGRP_TEXT9	TEXT40	CHAR	40	0	Name 9
44	NODE10_T	☐	WRF_MATGRP_TEXT10	TEXT40	CHAR	40	0	Name 10
45	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
46	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
47	DEP_ART	☐	WRF_PPW_DEP_ART	XFELD	CHAR	1	0	Dependent Material Exists for Pricing Reference Material
48	DEAKT	☐	WRF_PPW_DEAKT	XFELD	CHAR	1	0	Price Plan Item Was Deactivated
49	NO_OF_DEP_ART	☐	WRF_PPW_NO_OF_DEP_ART	NUMC3	NUMC	3	0	Number of Materials Dependent on Pricing Reference Material
50	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
51	WGBEZ	☐	WGBEZ	TEXT20	CHAR	20	0	Material Group Description
52	.INCLUDE	☐				0	0	PPD Budget Set: Attributes
53	BUDGET_NR	☐	WRF_PPW_BUDGET_NR		NUMC	16	0	Budget Number
54	PROCESS_ID	☐	WRF_BUDG_PROC_ID	WRF_BUDG_PROC_ID	NUMC	2	0	Budget ID
55	BUDGET_VP	☐	WRF_PPW_BUDGET_VP	WRF_PPW_BUDGET	CURR	13	2	Planned Budget for an Item in Price Planning
56	DATE_FROM	☐	WRF_PPW_DATE_FROM	DATUM	DATS	8	0	Validity Start Date of Budget Period
57	DATE_TO	☐	WRF_PPW_DATE_TO	DATUM	DATS	8	0	Validity End Date of Budget Period
58	WAERS_BG	☐	WRF_PPW_BGWAER	WAERS	CUKY	5	0	Budget Currency	TCURC
59	BUDGET_VP_REL	☐	WRF_PPW_BUDGET_VP_REL	WRF_PPW_BUDGET	CURR	13	2	Internally Released Budget
60	BUDGET_VP_SOLD	☐	WRF_PPW_BUDGET_VP_SOLD	WRF_PPW_BUDGET	CURR	13	2	Budget from Sold Articles
61	.INCLUDE	☐				0	0	PPD Stock Set: Attributes
62	STOCK	☐	WRF_PPW_STOCK	WRF_PPW_STOCK	QUAN	17	3	Current Stock
63	STOCK_IA	☐	WRF_PPW_STOCK_IA		QUAN	17	3	Included Stock Quantity
64	STOCK_NIA	☐	WRF_PPW_STOCK_NIA		QUAN	17	3	Non-Included Stock Quantity
65	STOCKUNIT	☐	WRF_PPW_STOCKUNIT	MEINS	UNIT	3	0	Base Unit of Measure	*
66	PLND_SALES_QTY	☐	WRF_PPW_PLAN_MENGE	MENGE	QUAN	13	3	Planned Quantity
67	STOCK_DIFF	☐	WRF_PPW_STOCK_DIFFERENCE	WRF_PPW_STOCK	QUAN	17	3	Stock Difference for Postprocessed Promotion PA Items
68	.INCLUDE	☐				0	0	PPD Markdown Set: Attributes
69	ABV_SOLL	☐	WRF_PPW_TARGSLSRTIO	WRF_PPW_PROCENT	DEC	5	2	Target Sales Ratio
70	ABV_IST	☐	WRF_PPW_ACTSLSRTIO	WRF_PPW_PROCENT	DEC	5	2	Actual Sales Ratio
71	MDPRC	☐	WRF_PPW_MDPRC	WRF_PPW_PROCENT	DEC	5	2	Price Reduction as Percentage of Initial Price
72	SELLPER	☐	WRF_PPW_SELLPER		NUMC	4	0	Validity Period of Material According to Markdown Profile
73	MAXPER	☐	WRF_PPW_MAXPER		NUMC	4	0	Validity Period of Markdown Profile
74	MDPROF	☐	WRF_PPW_MDPROF	WRF_SSMPROF	CHAR	10	0	Markdown Profile
75	GUID_AV	☐	WRF_PPW_GUID_AV		RAW	16	0	Worklist GUID
76	RUN_NO	☐	WRF_PPW_RUN_NO		RAW	16	0	Run Number
77	.INCLUDE	☐				0	0	Include for Display Structure at PA Level
78	.INCLUDE	☐				0	0	PPW: Structure for Pricing Items
79	GUID_CALC	☐	WRF_PPW_GUID		RAW	16	0	Unique, Generated Key
80	.INCLUDE	☐				0	0	Sales price calculation: key fields in a price calculation
81	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
82	VRKME	☐	W_VRKME_VKP	MEINS	UNIT	3	0	Sales Unit	*
83	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
84	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
85	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
86	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
87	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	*
88	BGINT	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number	*
89	.INCLUDE	☐				0	0	PPW: Structure to Display Pricing Item Data
90	VKKAB	☐	VKKAB	DATUM	DATS	8	0	Sales conditions valid from
91	VKKBI	☐	VKKBI	DATUM	DATS	8	0	Sales conditions valid to
92	VKKAM	☐	VKKAM	DATUM	DATS	8	0	Key date for sales price conditions
93	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
94	VLGWK	☐	VLGWK	WERKS	CHAR	4	0	Sales Pricing: Reference Plant	*
95	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
96	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
97	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
98	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
99	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
100	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
101	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
102	KWAER	☐	KAWAER	WAERS	CUKY	5	0	Sales Pricing: Pricing Currency	*
103	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
104	AUFSG	☐	AUFSG	WERTV6	CURR	11	2	Actual Markup in Sales Price Calculation
105	PAUFS	☐	PAUFS	WERTV6	CURR	11	2	Planned markup
106	PENDP	☐	PENDP	WERTV6	CURR	11	2	SP calculation: Planned sales pr. w/o price point rounding
107	VKPNE	☐	VKPNE	WERTV6	CURR	11	2	Sales price (net)
108	VKPBR	☐	VKPBR	WERTV6	CURR	11	2	Sales price (gross)
109	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	*
110	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
111	KALEB	☐	KALEB	KALEB	CHAR	2	0	Sales Pricing: Pricing level
112	SPANE	☐	SPANE	WERTV6	CURR	11	2	Margin (net) in sales price calculation
113	SPABR	☐	SPABR	WERTV6	CURR	11	2	Margin (gross) in sales price calculation
114	ENDPA	☐	ENDPA	WERTV6	CURR	11	2	Current Final Price
115	KALEA	☐	WRF_RPC_KALEA	KALEB	CHAR	2	0	Pricing Level of Current Final Price
116	SPANA	☐	SPANA	WERTV6	CURR	11	2	Current margin (net)
117	SPABA	☐	SPABA	WERTV6	CURR	11	2	Current margin (gross)
118	ROTPR	☐	ROTPR	WERTV6	CURR	11	2	Reduced-from price
119	MITPR	☐	MITPR	WERTV6	CURR	11	2	Cash price
120	EMPPR	☐	EMPPR	WERTV6	CURR	11	2	Recommended price
121	VORPR	☐	W_VORPR	WERTV6	CURR	11	2	Sales Pricing: Suggested Price
122	VKP01	☐	WRF_RPC_VKP01	WERTV6	CURR	11	2	Variable Sales Price 1
123	VKP02	☐	WRF_RPC_VKP02	WERTV6	CURR	11	2	Variable Sales Price 2
124	VKP03	☐	WRF_RPC_VKP03	WERTV6	CURR	11	2	Variable Sales Price 3
125	PROZ1	☐	WRF_RPC_PROZ1	WERTV6	CURR	11	2	SP Calculation: Variable Percentage 1
126	PROZ2	☐	WRF_RPC_PROZ2	WERTV6	CURR	11	2	SP Calculation: Variable Percentage 2
127	MPROZ	☐	MPROZ	WERTV6	CURR	11	2	Pricing: Price Change in Percent
128	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
129	EKERV	☐	EKERV_M	EKERV	CHAR	2	0	Purchase price determination sequence	*
130	EKERA	☐	EKERA	EKERA	CHAR	1	0	Purchase price determination type
131	VKERV	☐	EKERV_V	EKERV	CHAR	2	0	Sales price determination sequence	*
132	VKERA	☐	VKERA	VKERA	CHAR	1	0	Sales price determination type
133	EPTYP	☐	EPTYP	EPTYP	CHAR	2	0	Price Point Category
134	RKTYP	☐	WRF_RPC_RKTYP	WRF_RPC_RKTYP	CHAR	1	0	Price Point Groups: Ranking Type
135	EPRGR	☐	EPRGR	EPRGR	CHAR	6	0	Price point group	TWPK
136	PVGRD	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	TWBN
137	ENDNE	☐	WRF_PPW_ENDNE	WERTV6	CURR	11	2	Final Price (Net)
138	ENDBR	☐	WRF_PPW_ENDBR	WERTV6	CURR	11	2	Final Price (Gross)
139	ENDPA_PROMO	☐	WRF_PPW_ENDPA_PROMO	WERTV6	CURR	11	2	Current Promotion Sales Price
140	ENDNA	☐	WRF_PPW_ENDNA	WERTV6	CURR	11	2	Current Final Price (Net)
141	ENDBA	☐	WRF_PPW_ENDBA	WERTV6	CURR	11	2	Current Final Price (Gross)
142	MABSO	☐	WRF_PPW_MABSO	WERTV6	CURR	11	2	Absolute Price Change in Relation to Current Final Price
143	NABSO	☐	WRF_PPW_NABSO	WERTV6	CURR	11	2	Absolute Net Price Change in Relation to Current Final Price
144	INIAM	☐	W_INIAM	DATUM	DATS	8	0	Sales price calculations: key date for initial price
145	INIPR	☐	WRF_PPW_INIPR	WERTV6	CURR	11	2	Original Price
146	IPROZ	☐	WRF_PPW_IPROZ	WERTV6	CURR	11	2	Percentage Price Change in Relation to Original Price
147	IABSO	☐	WRF_PPW_IABSO	WERTV6	CURR	11	2	Absolute Price Change in Relation to Original Price
148	EPROZ	☐	WRF_PPW_EPROZ	WERTV6	CURR	11	2	Percentage Price Change (Compared to Last Final Price)
149	EABSO	☐	WRF_PPW_EABSO	WERTV6	CURR	11	2	Absolute Price Change (Compared to Last Final Price)
150	PPROZ	☐	WRF_PPW_PPROZ	WERTV6	CURR	11	2	Percentage Price Change (Compared to Planned Final Price)
151	PABSO	☐	WRF_PPW_PABSO	WERTV6	CURR	11	2	Absolute Price Change (Comp. to Last Final Price)
152	NWLEV	☐	WRF_PPW_NWLEV	XFELD	CHAR	1	0	Flag: New Pricing Level
153	ENDPA_PROMO_CHECKED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
154	DEC_POS	☐	WAERST	WAERS	CUKY	5	0	Technical currency (3 decimal places)	*
155	RECAL	☐	WRF_PPW_RECAL	FLAG	CHAR	1	0	Indicator: Redetermine Prices
156	ROUND	☐	WRF_PPW_ROUND	FLAG	CHAR	1	0	Rounding Category
157	DECPL	☐	NUM02	NUM02	NUMC	2	0	ABAB Dictionary: Two-Digit Numeric Field
158	BONKZ	☐	W_BONKZ_KALP	XFELD	CHAR	1	0	Sales Pricing: Indicator - Is Final Price Net or Gross Price
159	NEPGR	☐	NEPGR	XFELD	CHAR	1	0	Indicator: No Price Point Group
160	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
161	SATNR	☐	WSTR_SATNR	MATNR	CHAR	18	0	Material Number of the Generic Material	*
162	KBELN	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document	*
163	KBELP	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document	*
164	KBELN_COPY	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document	*
165	KBELP_COPY	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document	*
166	KNUMH_V	☐	KNUMH_V	KNUMB	CHAR	10	0	Number of the sales price condition record
167	BPSTA	☐	BPSTA	BPSTA	CHAR	1	0	Pricing: Status of Item in Pricing Document
168	SUBRC	☐	SUBRC	EK08R_RC	NUMC	2	0	Subroutines for return code
169	HERKU	☐	W_HERKU	W_ARCH	CHAR	1	0	Origin of Pricing Document
170	ICON_BUDGET	☐	WRF_PPW_ICON_BUDGET	ICON	CHAR	4	0	Budget Status	*
171	ICON_DEP_ART	☐	WRF_PPW_ICON_DEP_ART	ICON	CHAR	4	0	Display "Dependent Material Exists" as Icon	*
172	ICON_DEVI_PRICE	☐	WRF_PPW_ICON_DEVI_PRICE	ICON	CHAR	4	0	Organization Levels with Own Prices Exist	*
173	ICON_SISTER	☐	WRF_PPW_ICON_SISTER	ICON	CHAR	4	0	Display "Related Markdown Proposals Exist" as Icon	*
174	LOEKZ	☐	LOEKZ	XFELD	CHAR	1	0	Asset class marked for deletion
175	DEVI_PRICE_EXIST	☐	WRF_PPW_DEVI_PRICE_EXIST	CHAR1	CHAR	1	0	Flag: Price Variances Exist
176	FILGR	☐	WRF_PPW_FILGR		CHAR	18	0	Local Plant Groups
177	TEXT_WERKS	☐	WRF_PPW_TEXT_WERKS	TEXT20	CHAR	20	0	Name for Plant
178	TEXT_PLTYP	☐	WRF_PPW_TEXT_PLTYP	TEXT20	CHAR	20	0	Name for Price List
179	TEXT_VKORG	☐	WRF_PPW_TEXT_VKORG	TEXT20	CHAR	20	0	Name for Sales Organization
180	TEXT_VTWEG	☐	WRF_PPW_TEXT_VTWEG	TEXT20	CHAR	20	0	Name for Distribution Channel
181	AKTIV	☐	WRF_PPW_AKTIV	XFELD	CHAR	1	0	Processed by Activation Report and Budgets (if Used) Updated
182	PROMO_CHANGED	☐	WRF_PPW_PROMO_CHANGED	WRF_PPW_PROMO_CHANGED	CHAR	1	0	Flag for Subsequent Change of a Promotion
183	PROCESS_TEXT	☐	WRF_PPW_PROCESS_TEXT	CHAR80	CHAR	80	0	Name of a Process ID
184	BUDG_TEXT	☐	WRF_PPW_BUDG_TEXT	CHAR80	CHAR	80	0	Name of a Budget in Price Planning
185	PLND_QTY_COMPL	☐	WRF_PPW_PLND_QTY_COMPLETE	MENGE	QUAN	13	3	Total Planned Quantity
186	REFERENCE_PRICE	☐	WRF_PPW_REFERENCE_PRICE	WERTV6	CURR	11	2	Reference Price for Calculating Budget in Promotion Process
187	MIN_VK	☐	WRF_PPW_MIN_VK		CURR	11	2	Minimum Price for Dependent Stores
188	WRF_PPW_PLND_SALES_QTY	☐	WRF_PPW_PLND_SALES_QTY		QUAN	13	0	Planned Quantity
189	CT	☐	LVC_T_SCOL		TTYP	0	0
190	CELLTAB	☐	LVC_T_STYL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF_PPW_PPDFCDEVIANTPRICES_STY	EPRGR	TWPK	EPRGR
2	WRF_PPW_PPDFCDEVIANTPRICES_STY	PVGRD	TWBN	PV_GRUND
3	WRF_PPW_PPDFCDEVIANTPRICES_STY	WAERS_BG	TCURC	WAERS	KEY	1	CN

History

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