SAP ABAP Table WRF_PPW_PPDART_STY (PPW: Display Structure for POS 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_PPDART_STY	Table Relationship Diagram
Short Description	PPW: Display Structure for POS 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	PPD Material Item
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	AVPOS	☐	WRF_PPW_AVPOS	XFELD	CHAR	1	0	Item from Worklist
6	VKORG	☐	WRF_PPW_VKORG	VKORG	CHAR	4	0	Sales Organization	*
7	VTWEG	☐	WRF_PPW_VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
8	USRGRP	☐	WRF_PPW_USRGRP_PPD		CHAR	4	0	Processor Group
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
10	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
11	PPD_ART	☐	WRF_PPW_PPD_ART		CHAR	4	0	Price Planning Type
12	VKKAB_MDP	☐	WRF_PPW_VKKAB	DATUM	DATS	8	0	Valid From Date on Which Price Will Become Active
13	POS_OK	☐	WRF_PPW_ARTPOS_OK	XFELD	CHAR	1	0	Material Item OK
14	DEAKT	☐	WRF_PPW_DEAKT	XFELD	CHAR	1	0	Price Plan Item Was Deactivated
15	SATNR	☐	WSTR_SATNR	MATNR	CHAR	18	0	Material Number of the Generic Material	*
16	BUDGET_NR	☐	WRF_PPW_BUDGET_NR		NUMC	16	0	Budget Number
17	PROCESS_ID	☐	WRF_BUDG_PROC_ID	WRF_BUDG_PROC_ID	NUMC	2	0	Budget ID
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	DEP_ART	☐	WRF_PPW_DEP_ART	XFELD	CHAR	1	0	Dependent Material Exists for Pricing Reference Material
23	ME_REGEL	☐	WRF_PPW_ME_REGEL	WRF_PPW_ME_REGEL	NUMC	1	0	Quantity Rule for Promotions
24	PLND_SALES_QTY	☐	WRF_PPW_PLAN_MENGE	MENGE	QUAN	13	3	Planned Quantity
25	PRICE_CALC_TYP	☐	WRF_PPW_PRICE_CALC_TYP	WRF_PPW_PRICE_CALC_TYP	CHAR	1	0	Price Calculation Type (Relative or Absolute Price Changes)
26	ORGSET_ID	☐	WRF_PPW_ORGSET_ID		INT4	10	0	Number of an Organization Set in a Price Plan
27	HIER_ID	☐	WRF_HIER_CNT	WRF_HIERCNT	CHAR	2	0	Hierarchy
28	CREATIONDATE	☐	WRF_PPW_CREATIONDATE	DATS	DATS	8	0	Date of Hierarchy Determination
29	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
30	.INCLUDE	☐				0	0	Path Info of a Material in a Hierarchy (Bottom -> Up)
31	NODE01	☐	WRF_HIER_NODE1	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 1
32	NODE02	☐	WRF_HIER_NODE2	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 2
33	NODE03	☐	WRF_HIER_NODE3	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 3
34	NODE04	☐	WRF_HIER_NODE4	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 4
35	NODE05	☐	WRF_HIER_NODE5	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 5
36	NODE06	☐	WRF_HIER_NODE6	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 6
37	NODE07	☐	WRF_HIER_NODE7	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 7
38	NODE08	☐	WRF_HIER_NODE8	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 8
39	NODE09	☐	WRF_HIER_NODE9	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 9
40	NODE10	☐	WRF_HIER_NODE10	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 10
41	ATTYP	☐	WRF_PPW_ATTYP	ATTYP	CHAR	2	0	Material Category
42	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
43	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
44	BUDGET_VP	☐	WRF_PPW_BUDGET_VP	WRF_PPW_BUDGET	CURR	13	2	Planned Budget for an Item in Price Planning
45	STOCK	☐	WRF_PPW_STOCK	WRF_PPW_STOCK	QUAN	17	3	Current Stock
46	STOCK_IA	☐	WRF_PPW_STOCK_IA		QUAN	17	3	Included Stock Quantity
47	STOCK_NIA	☐	WRF_PPW_STOCK_NIA		QUAN	17	3	Non-Included Stock Quantity
48	STOCKUNIT	☐	WRF_PPW_STOCKUNIT	MEINS	UNIT	3	0	Base Unit of Measure	*
49	ABV_SOLL	☐	WRF_PPW_TARGSLSRTIO	WRF_PPW_PROCENT	DEC	5	2	Target Sales Ratio
50	ABV_IST	☐	WRF_PPW_ACTSLSRTIO	WRF_PPW_PROCENT	DEC	5	2	Actual Sales Ratio
51	MDPRC	☐	WRF_PPW_MDPRC	WRF_PPW_PROCENT	DEC	5	2	Price Reduction as Percentage of Initial Price
52	SELLPER	☐	WRF_PPW_SELLPER		NUMC	4	0	Validity Period of Material According to Markdown Profile
53	MAXPER	☐	WRF_PPW_MAXPER		NUMC	4	0	Validity Period of Markdown Profile
54	MDPROF	☐	WRF_PPW_MDPROF	WRF_SSMPROF	CHAR	10	0	Markdown Profile
55	PAEBENE	☐	WRF_PPW_PAEBENE		CHAR	1	0	Affected Price Activation Level
56	DEVI_PRICE_EXIST	☐	WRF_PPW_DEVI_PRICE_EXIST	CHAR1	CHAR	1	0	Flag: Price Variances Exist
57	BUDGET_STAT	☐	WRF_PPW_BUDGET_STAT		CHAR	1	0	Budget Status
58	.INCLUDE	☐				0	0	PPW: Structure to Display Pricing Item Data
59	VKKAB	☐	VKKAB	DATUM	DATS	8	0	Sales conditions valid from
60	VKKBI	☐	VKKBI	DATUM	DATS	8	0	Sales conditions valid to
61	VKKAM	☐	VKKAM	DATUM	DATS	8	0	Key date for sales price conditions
62	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
63	VLGWK	☐	VLGWK	WERKS	CHAR	4	0	Sales Pricing: Reference Plant	*
64	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
65	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
66	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
67	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
68	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
69	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
70	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
71	KWAER	☐	KAWAER	WAERS	CUKY	5	0	Sales Pricing: Pricing Currency	*
72	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
73	AUFSG	☐	AUFSG	WERTV6	CURR	11	2	Actual Markup in Sales Price Calculation
74	PAUFS	☐	PAUFS	WERTV6	CURR	11	2	Planned markup
75	PENDP	☐	PENDP	WERTV6	CURR	11	2	SP calculation: Planned sales pr. w/o price point rounding
76	VKPNE	☐	VKPNE	WERTV6	CURR	11	2	Sales price (net)
77	VKPBR	☐	VKPBR	WERTV6	CURR	11	2	Sales price (gross)
78	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	*
79	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
80	KALEB	☐	KALEB	KALEB	CHAR	2	0	Sales Pricing: Pricing level
81	SPANE	☐	SPANE	WERTV6	CURR	11	2	Margin (net) in sales price calculation
82	SPABR	☐	SPABR	WERTV6	CURR	11	2	Margin (gross) in sales price calculation
83	ENDPA	☐	ENDPA	WERTV6	CURR	11	2	Current Final Price
84	KALEA	☐	WRF_RPC_KALEA	KALEB	CHAR	2	0	Pricing Level of Current Final Price
85	SPANA	☐	SPANA	WERTV6	CURR	11	2	Current margin (net)
86	SPABA	☐	SPABA	WERTV6	CURR	11	2	Current margin (gross)
87	ROTPR	☐	ROTPR	WERTV6	CURR	11	2	Reduced-from price
88	MITPR	☐	MITPR	WERTV6	CURR	11	2	Cash price
89	EMPPR	☐	EMPPR	WERTV6	CURR	11	2	Recommended price
90	VORPR	☐	W_VORPR	WERTV6	CURR	11	2	Sales Pricing: Suggested Price
91	VKP01	☐	WRF_RPC_VKP01	WERTV6	CURR	11	2	Variable Sales Price 1
92	VKP02	☐	WRF_RPC_VKP02	WERTV6	CURR	11	2	Variable Sales Price 2
93	VKP03	☐	WRF_RPC_VKP03	WERTV6	CURR	11	2	Variable Sales Price 3
94	PROZ1	☐	WRF_RPC_PROZ1	WERTV6	CURR	11	2	SP Calculation: Variable Percentage 1
95	PROZ2	☐	WRF_RPC_PROZ2	WERTV6	CURR	11	2	SP Calculation: Variable Percentage 2
96	MPROZ	☐	MPROZ	WERTV6	CURR	11	2	Pricing: Price Change in Percent
97	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
98	EKERV	☐	EKERV_M	EKERV	CHAR	2	0	Purchase price determination sequence	*
99	EKERA	☐	EKERA	EKERA	CHAR	1	0	Purchase price determination type
100	VKERV	☐	EKERV_V	EKERV	CHAR	2	0	Sales price determination sequence	*
101	VKERA	☐	VKERA	VKERA	CHAR	1	0	Sales price determination type
102	EPTYP	☐	EPTYP	EPTYP	CHAR	2	0	Price Point Category
103	RKTYP	☐	WRF_RPC_RKTYP	WRF_RPC_RKTYP	CHAR	1	0	Price Point Groups: Ranking Type
104	EPRGR	☐	EPRGR	EPRGR	CHAR	6	0	Price point group	TWPK
105	PVGRD	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	TWBN
106	ENDNE	☐	WRF_PPW_ENDNE	WERTV6	CURR	11	2	Final Price (Net)
107	ENDBR	☐	WRF_PPW_ENDBR	WERTV6	CURR	11	2	Final Price (Gross)
108	ENDPA_PROMO	☐	WRF_PPW_ENDPA_PROMO	WERTV6	CURR	11	2	Current Promotion Sales Price
109	ENDNA	☐	WRF_PPW_ENDNA	WERTV6	CURR	11	2	Current Final Price (Net)
110	ENDBA	☐	WRF_PPW_ENDBA	WERTV6	CURR	11	2	Current Final Price (Gross)
111	MABSO	☐	WRF_PPW_MABSO	WERTV6	CURR	11	2	Absolute Price Change in Relation to Current Final Price
112	NABSO	☐	WRF_PPW_NABSO	WERTV6	CURR	11	2	Absolute Net Price Change in Relation to Current Final Price
113	INIAM	☐	W_INIAM	DATUM	DATS	8	0	Sales price calculations: key date for initial price
114	INIPR	☐	WRF_PPW_INIPR	WERTV6	CURR	11	2	Original Price
115	IPROZ	☐	WRF_PPW_IPROZ	WERTV6	CURR	11	2	Percentage Price Change in Relation to Original Price
116	IABSO	☐	WRF_PPW_IABSO	WERTV6	CURR	11	2	Absolute Price Change in Relation to Original Price
117	EPROZ	☐	WRF_PPW_EPROZ	WERTV6	CURR	11	2	Percentage Price Change (Compared to Last Final Price)
118	EABSO	☐	WRF_PPW_EABSO	WERTV6	CURR	11	2	Absolute Price Change (Compared to Last Final Price)
119	PPROZ	☐	WRF_PPW_PPROZ	WERTV6	CURR	11	2	Percentage Price Change (Compared to Planned Final Price)
120	PABSO	☐	WRF_PPW_PABSO	WERTV6	CURR	11	2	Absolute Price Change (Comp. to Last Final Price)
121	NWLEV	☐	WRF_PPW_NWLEV	XFELD	CHAR	1	0	Flag: New Pricing Level
122	ENDPA_PROMO_CHECKED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
123	DEC_POS	☐	WAERST	WAERS	CUKY	5	0	Technical currency (3 decimal places)	*
124	.INCLUDE	☐				0	0	Path Texts of a Material in a Hierarchy (Bottom -> Up)
125	NODE01_T	☐	WRF_MATGRP_TEXT1	TEXT40	CHAR	40	0	Short Text 1
126	NODE02_T	☐	WRF_MATGRP_TEXT02	TEXT40	CHAR	40	0	Name of a Node in an Article Hierarchy
127	NODE03_T	☐	WRF_MATGRP_TEXT3	TEXT40	CHAR	40	0	Description 3
128	NODE04_T	☐	WRF_MATGRP_TEXT4	TEXT40	CHAR	40	0	Name 4
129	NODE05_T	☐	WRF_MATGRP_TEXT5	TEXT40	CHAR	40	0	Name 5
130	NODE06_T	☐	WRF_MATGRP_TEXT6	TEXT40	CHAR	40	0	Name 6
131	NODE07_T	☐	WRF_MATGRP_TEXT7	TEXT40	CHAR	40	0	Name 7
132	NODE08_T	☐	WRF_MATGRP_TEXT8	TEXT40	CHAR	40	0	Name 8
133	NODE09_T	☐	WRF_MATGRP_TEXT9	TEXT40	CHAR	40	0	Name 9
134	NODE10_T	☐	WRF_MATGRP_TEXT10	TEXT40	CHAR	40	0	Name 10
135	.INCLUDE	☐				0	0	PPW: Structure for Promotion Item Data
136	BEDAT	☐	W_BEDAT	DATUM	DATS	8	0	Order date with vendor
137	MIAMG	☐	W_MIAMG	MENGE	QUAN	13	3	Minimum order qty for promotional material
138	AUFME	☐	W_AUFME	MENGE	QUAN	13	3	Promotion plan: Material allocation table quantity
139	MEAUF	☐	W_MEAUF	MEINS	UNIT	3	0	Allocation table unit	*
140	VREGE	☐	VREGE	SBELN	CHAR	10	0	Retail Promotion: Allocation Rule Number	*
141	ASTRA	☐	W_ASTRA	ASTRA	CHAR	4	0	Retail Promotion: Allocation Strategy	*
142	APSTP	☐	APSTP	APSTP	CHAR	4	0	Item category of allocation table	*
143	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	*
144	BEKTY	☐	W_BEKTY	AAVIT	CHAR	4	0	Promotion announcement category	*
145	DIFFERENT_PRICES	☐	WRF_PPW_DIFFERENT_PRICES		CHAR	1	0	Flag: Different Prices Exist
146	SISTER	☐	WRF_PPW_SISTER	XFELD	CHAR	1	0	Related Markdown Proposals Exist
147	NO_OF_DEP_ART	☐	WRF_PPW_NO_OF_DEP_ART	NUMC3	NUMC	3	0	Number of Materials Dependent on Pricing Reference Material
148	NO_OF_STORES	☐	WRF_PPW_NO_OF_STORES		DEC	6	0	Number of Plants Affected by a Price Change
149	REFERENCE_PRICE	☐	WRF_PPW_REFERENCE_PRICE	WERTV6	CURR	11	2	Reference Price for Calculating Budget in Promotion Process
150	MIN_VK	☐	WRF_PPW_MIN_VK		CURR	11	2	Minimum Price for Dependent Stores
151	AKTIV	☐	WRF_PPW_AKTIV	XFELD	CHAR	1	0	Processed by Activation Report and Budgets (if Used) Updated
152	PROMO_CHANGED	☐	WRF_PPW_PROMO_CHANGED	WRF_PPW_PROMO_CHANGED	CHAR	1	0	Flag for Subsequent Change of a Promotion
153	WGBEZ	☐	WGBEZ	TEXT20	CHAR	20	0	Material Group Description
154	BUDG_TYPE	☐	WRF_PPW_BUDG_TYPE	WRF_BUDG_TYPE	CHAR	2	0	Budget Type

Foreign Keys

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

History

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