SAP ABAP Table WRF_PPW_PPDFIELDCATPA_STY (Field Catalog to Display PA View)

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_PPDFIELDCATPA_STY	Table Relationship Diagram
Short Description	Field Catalog to Display PA View

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

History

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