SAP ABAP Table WRF_PPW_PROMOWAKPDGUID_STY (PPW: Structure WAKPD (Promotion Item Data) with GUID)

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_PROMOWAKPDGUID_STY	Table Relationship Diagram
Short Description	PPW: Structure WAKPD (Promotion Item Data) with GUID

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	GUID	☐	WRF_PPW_GUID		RAW	16	0	Unique, Generated Key
2	.INCLUDE	☐				0	0	Screen Field String for Promotion Item Data
3	.INCLUDE	☐				0	0	Promotion Item Data
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
6	ARTNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	MEBME	☐	W_MEBME	MEINS	UNIT	3	0	Sales unit	T006
8	AKPOS	☐	W_AKPOS	NUMC6	NUMC	6	0	Promotion Item Number
9	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
10	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
11	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
12	BZQFI	☐	W_BZQFI	BZQFA	CHAR	1	0	Supply Source Determination Status
13	AKBSP	☐	W_AKBSP	LISTSH	CHAR	1	0	Item status, listing
14	NBPOS	☐	W_NBPOS	INT2	INT2	5	0	No. of modules with this material as an item
15	RESKZ	☐	W_LCHECK	W_LCHECK	CHAR	1	0	Check Against Listing Rules/Listing Conditions
16	BEKTY	☐	W_BEKTY	AAVIT	CHAR	4	0	Promotion announcement category	T626
17	SPDAT	☐	W_SPDAT	DATUM	DATS	8	0	Date on which promotion material is blocked for promotion
18	SPGRU	☐	W_SPGRU	SPGRU	CHAR	1	0	Reason for promotion block
19	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
20	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
21	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
22	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
23	AKLIZ	☐	W_PLIFZ	DEC3	DEC	3	0	Planned delivery time for promotional goods
24	PUMVP	☐	W_PUMVP	WERT	CURR	13	2	Promotion Plan Mat. Sales Vol. at Promo. Sales Price
25	PUMEP	☐	W_PUMEP	WERT	CURR	13	2	Promotion plan: mat. sales at PP in sales currency
26	PUMEN	☐	W_PUMEN	WERT	CURR	13	2	Promotion plan: sales volume at purchase price (net/net)
27	PABBM	☐	W_PABBM	MENGE	QUAN	13	3	Planned Sales Qty. of Promotion Material in Sales Units
28	PABLM	☐	W_PABLM	MENGE	QUAN	13	3	Planned Sales Qty of Promotion Material in Logistics Units
29	AUFME	☐	W_AUFME	MENGE	QUAN	13	3	Promotion plan: Material allocation table quantity
30	PLVKP	☐	W_PLVKP	PREIS	CURR	11	2	Sales price for promotion item
31	VPEIN	☐	VPEIN	DEC5	DEC	5	0	Sales price unit
32	PLEKP	☐	W_PLEKP	PREIS	CURR	11	2	Purchase price for promotion item
33	PLEKN	☐	W_PLEKN	PREIS	CURR	11	2	Basic purchase price: net/net - promotion item
34	EPEIN	☐	EPEIN	DEC5	DEC	5	0	Price unit
35	WAEEK	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
36	WAELA	☐	W_WAELA	WAERS	CUKY	5	0	Currency current promotion - planning	TCURC
37	MEINS	☐	W_MEINS	MEINS	UNIT	3	0	Base unit of measure	T006
38	MELOG	☐	W_MELOG	MEINS	UNIT	3	0	Logistics unit	T006
39	MEBPR	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
40	MEAUF	☐	W_MEAUF	MEINS	UNIT	3	0	Allocation table unit	T006
41	RGART	☐	W_RGART	RGART	CHAR	1	0	Return type for promotional material
42	MIAMG	☐	W_MIAMG	MENGE	QUAN	13	3	Minimum order qty for promotional material
43	NDISP	☐	W_NDISP	CHAR2	CHAR	2	0	Replenishment indicator
44	FBDAT	☐	W_FADAT	DATUM	DATS	8	0	Earliest Order Date
45	SBDAT	☐	W_SADAT	DATUM	DATS	8	0	Latest Order Date
46	FLDAT	☐	W_FLDAT	DATUM	DATS	8	0	Earliest delivery date
47	SLDAT	☐	W_SLDAT	DATUM	DATS	8	0	Latest delivery date
48	APSTP	☐	APSTP	APSTP	CHAR	4	0	Item category of allocation table	T621
49	BEDAT	☐	W_BEDAT	DATUM	DATS	8	0	Order date with vendor
50	VREGE	☐	VREGE	SBELN	CHAR	10	0	Retail Promotion: Allocation Rule Number	SVKO
51	ABELN	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
52	ABELP	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table	AUPO
53	ETIAG	☐	W_ETIAG	ETIAG	CHAR	18	0	IS-R Labeling: material grouping (deactivated in 4.0)	TWEA
54	EKKPS	☐	W_EKKPS	EKKPS	CHAR	1	0	Maintenance status of purchase price conditions
55	VKKPS	☐	W_VKKPS	VKKPS	CHAR	1	0	Maintenance status of sales price conditions
56	EKKON	☐	W_EKKON	XFELD	CHAR	1	0	Create purchase price condition records
57	VKKON	☐	W_VKKON	XFELD	CHAR	1	0	Create sales price condition records
58	ACTIV	☐	W_ACTIV	INT1	INT1	3	0	No. of successful price activations
59	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
60	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
61	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
62	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
63	ECKPKZ	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
64	VZKON	☐	W_VZKON	XFELD	CHAR	1	0	Create DC condition records
65	VZKPS	☐	W_VZKPS	VZKPS	CHAR	1	0	Maintenance status of DC conditions
66	EPRGR	☐	W_EPRGR	EPRGR	CHAR	6	0	Price Point Group, Promotion Item	*
67	NVKP	☐	W_NVKP	PREIS	CURR	11	2	Standard sales price
68	VK_AKTIV_AB	☐	W_VK_AKTIV_AB	DATS	DATS	8	0	Sales prices active from
69	VK_AKTIV_BI	☐	W_VK_AKTIV_BI	DATS	DATS	8	0	Sales price active to
70	BATNR	☐	BSTARTNR	MATNR	CHAR	18	0	Allocation material number	MARA
71	EKERV	☐	W_EKERV	EKERV	CHAR	2	0	Promotion: Purchase price determination sequence	TWEV
72	REB_VALUE	☐	REB_VALUE	WERT6	CURR	11	2	Value of Absolute Discount
73	REB_PERC	☐	REB_PERC	REB_PERC	DEC	5	2	Percentage Discount
74	REB_STATUS	☐	REB_STATUS	REB_STATUS	CHAR	1	0	Discount Status
75	NO_KALK	☐	NO_KALK	XFELD	CHAR	1	0	Price Activation w/o Price Calculation
76	ASTRA	☐	W_ASTRA	ASTRA	CHAR	4	0	Retail Promotion: Allocation Strategy	T627
77	OFFER_TYPE	☐	RDM_OFFER_TYPE_PRICE	RDM_OFFER_TYPE_PRICE	CHAR	2	0	Offer Type Price
78	OFFER_TYPE_DSC	☐	RDM_OFFER_TYPE_DISCOUNT	RDM_OFFER_TYPE_DISCOUNT	CHAR	2	0	Offer Type Discount
79	OFFER_ID	☐	WPM_OFFERID_PRICE	WPM_OFFERID	CHAR	36	0	Offer ID for Price
80	OFFER_ID_DSC	☐	WPM_OFFERID_DISCOUNT	WPM_OFFERID	CHAR	36	0	Offer ID for Discount
81	OFFER_PRDGRP	☐	WPM_OFFER_PRODUCT_GROUP_PRICE	WPM_OFFER_PRODUCT_GROUP	NUMC	3	0	Product Group in Offer (Price)
82	OFFER_PRDGRP_DSC	☐	WPM_OFFER_PRODUCT_GROUP_DSCNT	WPM_OFFER_PRODUCT_GROUP	NUMC	3	0	Product Group in Offer (Discount)
83	ITEM_CREAT_INDIC	☐	WPM_PROMO_ITEM	XFELD	CHAR	1	0	Promotion Item Indicator for Transferred Materials
84	PABBM_OFFER_PRC	☐	W_PABBM_OFFER_PRC	MENGE	QUAN	13	3	Planned sales qty in sales units for material in price offer
85	PABBM_OFFER_DSC	☐	W_PABBM_OFFER_DSC	MENGE	QUAN	13	3	Planned sales qty in sales units of material in discnt offer
86	.INCLU--AP	☐				0	0	Enhancement of Allocation Strategy Variant
87	ASTRA_VAR	☐	ASTRA_VAR	VARIANT	CHAR	14	0	Allocation Strategy Variant	*
88	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
89	SELBM	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
90	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
91	TXTL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
92	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
93	AKTTT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
94	RFOLG	☐	W_TABIX	W_TABIX	INT4	10	0	Pointer to an entry in an internal table
95	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
96	PMATA	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
97	PMATR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
98	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
99	WAE_EKWVK	☐	W_WAELA	WAERS	CUKY	5	0	Currency current promotion - planning	*
100	EKWVK	☐	W_EKWVK	WERTV6	CURR	11	2	Purchase price in sales price currency and sales unit
101	KZADDI	☐	W_KZADDI	XFELD	CHAR	1	0	Indicator: additionals are assigned
102	KZBAT	☐	W_KZBAT	XFELD	CHAR	1	0	Indicator: item with allocation material
103	REB_SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
104	PUMNP	☐	W_PUMNP	WERT	CURR	13	2	Promotion Plan Material Invoiced Sales at Stand.Sales Prices
105	PUMRE	☐	W_PUMRE	WERT	CURR	13	2	Promotion Plan Gross Revenue Material
106	PUMLO	☐	W_PUMLO	WERT	CURR	13	2	Promotion Plan Invoiced Lost Sales Material
107	IGNORE_PMAT	☐	WPM_IGNORE_PMAT	XFELD	CHAR	1	0	Variant Price Allowed - Promotion-Internal Handling
108	OFFER_TYPE_BBY	☐	WPM_OFFER_TYPE_BBY	XFELD	CHAR	1	0	Material is part of bonus buy offer
109	OFFER_TYPE_GENERIC	☐	WPM_OFFER_TYPE_GENERIC	RDM_OFFER_TYPE_GENERIC	CHAR	2	0	Generic offer type
110	OFFER_ID_GENERIC	☐	WPM_OFFERID	WPM_OFFERID	CHAR	36	0	Offer ID for Promotion
111	BBYNR	☐	BBYNR	BBYNR	CHAR	12	0	Bonus buy	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF_PPW_PROMOWAKPDGUID_STY	ABELN	AUKO	ABELN
2	WRF_PPW_PROMOWAKPDGUID_STY	ABELP	AUPO	ABELP
3	WRF_PPW_PROMOWAKPDGUID_STY	AKTHE	TWAT	AKTHE
4	WRF_PPW_PROMOWAKPDGUID_STY	AKTNR	WAKH	AKTNR
5	WRF_PPW_PROMOWAKPDGUID_STY	APSTP	T621	APSTP	KEY	1	CN
6	WRF_PPW_PROMOWAKPDGUID_STY	ARTNR	MARA	MATNR
7	WRF_PPW_PROMOWAKPDGUID_STY	ASTRA	T627	ASTRA
8	WRF_PPW_PROMOWAKPDGUID_STY	BATNR	MARA	MATNR
9	WRF_PPW_PROMOWAKPDGUID_STY	BEKTY	T626	AAVIT		C	N
10	WRF_PPW_PROMOWAKPDGUID_STY	EKERV	TWEV	EKERV
11	WRF_PPW_PROMOWAKPDGUID_STY	EKGRP	T024	EKGRP
12	WRF_PPW_PROMOWAKPDGUID_STY	EKORG	T024E	EKORG
13	WRF_PPW_PROMOWAKPDGUID_STY	ETIAG	TWEA	ARTGR
14	WRF_PPW_PROMOWAKPDGUID_STY	MANDT	T000	MANDT
15	WRF_PPW_PROMOWAKPDGUID_STY	MATKL	T023	MATKL		C	N
16	WRF_PPW_PROMOWAKPDGUID_STY	MEAUF	T006	MSEHI
17	WRF_PPW_PROMOWAKPDGUID_STY	MEBME	T006	MSEHI
18	WRF_PPW_PROMOWAKPDGUID_STY	MEBPR	T006	MSEHI
19	WRF_PPW_PROMOWAKPDGUID_STY	MEINS	T006	MSEHI		C	N
20	WRF_PPW_PROMOWAKPDGUID_STY	MELOG	T006	MSEHI
21	WRF_PPW_PROMOWAKPDGUID_STY	SATNR	MARA	MATNR	KEY	1	CN
22	WRF_PPW_PROMOWAKPDGUID_STY	VKORG	TVKO	VKORG
23	WRF_PPW_PROMOWAKPDGUID_STY	VREGE	SVKO	SBELN		C	N
24	WRF_PPW_PROMOWAKPDGUID_STY	VTWEG	TVKOV	VTWEG
25	WRF_PPW_PROMOWAKPDGUID_STY	WAEEK	TCURC	WAERS
26	WRF_PPW_PROMOWAKPDGUID_STY	WAELA	TCURC	WAERS

History

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