SAP ABAP Table FRE_WAKH_STY (Promotion header data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ WFRE_PI (Package) Connectivity with F&R

Basic Data

Table Category	INTTAB	Structure
Structure	FRE_WAKH_STY	Table Relationship Diagram
Short Description	Promotion header data

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	Promotion Header Data, IS-R
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
4	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
5	AKART	☐	W_AKART	W_AKART	CHAR	4	0	Promotion Type	TWAA
6	WAELA	☐	W_WAELA	WAERS	CUKY	5	0	Currency current promotion - planning	TCURC
7	WAERA	☐	W_WAERA	WAERS	CUKY	5	0	Currency, reference promotion	TCURC
8	VGLAK	☐	W_VGLAK	WAKTION	CHAR	10	0	Comparative promotion	WAKH
9	LISRE	☐	LSTFL	LSTFL	CHAR	2	0	Listing procedure for store or other assortment categories	TWLV
10	AUFAR	☐	W_AUFAR	AUFAR	CHAR	4	0	Allocation Table Type	T620
11	BEKTY	☐	W_BEKTY	AAVIT	CHAR	4	0	Promotion announcement category	T626
12	KSBEK	☐	W_NACHSM	KALSM	CHAR	6	0	Message Schema	T683
13	AKVST	☐	W_AKVST	AKVST	CHAR	1	0	Processing status of the promotion
14	AKAST	☐	W_AKAST	AKAST	CHAR	1	0	Allocation table status of the promotion
15	AKBST	☐	W_AKBST	AKBST	CHAR	1	0	Listing Status of the Promotion
16	VKGST	☐	W_VKKPSH	PREISSH	CHAR	1	0	Price activation status
17	EKGST	☐	W_EKKPSH	PREISSH	CHAR	1	0	Purchase price activation status at promotion header level
18	BEKST	☐	W_STBEK	BEKST	CHAR	1	0	Promotion announcement status
19	AKNBS	☐	W_AKNBS	INT2	INT2	5	0	No. assigned listing modules
20	AKNFG	☐	W_AKNFG	INT2	INT2	5	0	Promotion: no. of plant groups
21	AKNBF	☐	W_AKNBF	INT2	INT2	5	0	No. of module-plant group assignments
22	AKNTH	☐	W_AKNTH	INT2	INT2	5	0	Promotion, no. of themes
23	AKNPO	☐	W_AKNPO	INT2	INT2	5	0	No. of items with allocation qty > 0
24	AKNWM	☐	W_AKNWM	INT2	INT2	5	0	No. of product catalogs in promotion
25	AKNTX	☐	W_AKNTX	INT2	INT2	5	0	No. of foreign language texts
26	NEKKO	☐	W_NEKKO	INT2	INT2	5	0	No. of purchase prices maintained via price calcul. (KONP)
27	NVKKO	☐	W_NVKKO	INT2	INT2	5	0	No. of sales prices maintained via price calculation (KONP)
28	NARTS	☐	W_NARTS	INT2	INT2	5	0	No. of blocked materials
29	ATNPO	☐	W_ATNPO	INT2	INT2	5	0	Number of promo materials in generated allocation tables
30	VTART	☐	W_LCHECK	W_LCHECK	CHAR	1	0	Check Against Listing Rules/Listing Conditions
31	EKDAB	☐	W_EKDAB	DATUM	DATS	8	0	Purchase price conditions valid from
32	EKDBI	☐	W_EKDBI	DATUM	DATS	8	0	Purchase price conditions valid to
33	VKDAB	☐	W_VKDAB	DATUM	DATS	8	0	On Sale to Consumers From
34	VKDBI	☐	W_VKDBI	DATUM	DATS	8	0	On Sale To Consumers To
35	ALIVO	☐	W_ALIVO	DATUM	DATS	8	0	Start of promotion listing
36	ALIBI	☐	W_ALIBI	DATUM	DATS	8	0	End of promotion listing
37	SPDAB	☐	W_SPDAB	DATUM	DATS	8	0	Promotion blocked on
38	SPGRU	☐	W_SPGRU	SPGRU	CHAR	1	0	Reason for promotion block
39	EKKON	☐	W_EKKON	XFELD	CHAR	1	0	Create purchase price condition records
40	VKKON	☐	W_VKKON	XFELD	CHAR	1	0	Create sales price condition records
41	KOBOG	☐	W_KOBOG	CHAR4	CHAR	4	0	Group of condition types/tables for purchasing conditions
42	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
43	EKGRP	☐	W_EKGRP	EKGRP	CHAR	3	0	Purchasing Group - Promotion Header	T024
44	VKORG	☐	W_VKORG_HEADER	VKORG	CHAR	4	0	Sales Organization: Promotion Header	TVKO
45	VTWEG	☐	W_VTWEG_HEADER	VTWEG	CHAR	2	0	Distribution Channel: Promotion Header	TVKOV
46	PLUEP	☐	W_PLUEP	WERT	CURR	13	2	Promotion plan, sales at purchase price
47	PLUEN	☐	W_PLUEN	WERT	CURR	13	2	Planned sales qty for promo at delivered price (net/net)
48	PLUVP	☐	W_PLUVP	WERT	CURR	13	2	Promotion Plan Sales Volume at Promo. Sales Prices
49	PLMGE	☐	W_PLMGE	MENGE	QUAN	13	3	Promotion plan, no. logistics units
50	PLANZ	☐	W_PLANZ	NUMC6	NUMC	6	0	Promotion plan, no. of materials
51	MELAK	☐	W_MELAK	MEINS	UNIT	3	0	Logistics unit, promotion plan	T006
52	MELRA	☐	W_MELRA	MEINS	UNIT	3	0	Logistics units, reference promotion	T006
53	PDUEP	☐	W_PDUEP	WERT	CURR	13	2	Detailed promotion plan, sales volume at purchase price
54	PDUEN	☐	W_PDUEN	WERT	CURR	13	2	Planned sales qty at delivered price (net/net)
55	PDUVP	☐	W_PDUVP	WERT	CURR	13	2	Detailed Promotion Plan Sales Volume at Promo. Sales Price
56	PDMGE	☐	W_PDMGE	MENGE	QUAN	13	3	Detailed promotion plan, no. of logistics units
57	PDANZ	☐	W_PDANZ	NUMC6	NUMC	6	0	Detailed Promotion Plan, Number of Materials
58	VAUEP	☐	W_VAUEP	WERT	CURR	13	2	Sales volume at purchase price for comparative promotion
59	VAUEN	☐	W_VAUEN	WERT	CURR	13	2	Comparative promotion: sales vol.at delivered price(net/net)
60	VAUVP	☐	W_VAUVP	WERT	CURR	13	2	Sales volume of comparative promotion at sales prices
61	VAMGE	☐	W_VAMGE	MENGE	QUAN	13	3	No. of log. units in comparative promotion
62	RFIND	☐	ABREX	CHAR20	CHAR	20	0	External description for agreement
63	VAANZ	☐	W_VAANZ	NUMC6	NUMC	6	0	No. of materials/units of measure in comparative promotion
64	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
65	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
66	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
67	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
68	KOBVK	☐	W_KOBVK	CHAR4	CHAR	4	0	Group of condition types/tables for sales price conditions
69	FADAT	☐	W_FADAT	DATUM	DATS	8	0	Earliest Order Date
70	SADAT	☐	W_SADAT	DATUM	DATS	8	0	Latest Order Date
71	FLDAT	☐	W_FLDAT	DATUM	DATS	8	0	Earliest delivery date
72	SLDAT	☐	W_SLDAT	DATUM	DATS	8	0	Latest delivery date
73	ADDIBELNR	☐	ADDI_BELNR	ADDI_BELNR	CHAR	10	0	Document number for additional
74	VZKON	☐	W_VZKON	XFELD	CHAR	1	0	Create DC condition records
75	KALKE	☐	W_AKTARTH	AKTARTH	CHAR	1	0	Activation type for sales prices
76	PLTYP	☐	W_PLTYP	PLTYP	CHAR	2	0	Price list type: promotion header	T189
77	NO_KALK	☐	NO_KALK	XFELD	CHAR	1	0	Price Activation w/o Price Calculation
78	EKERV	☐	W_EKERV	EKERV	CHAR	2	0	Promotion: Purchase price determination sequence	TWEV
79	RFCDEST	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
80	ERAPPL	☐	W_ERAPPL	W_ERAPPL	CHAR	1	0	Application that Created the Promotion
81	KSCHL_PERC	☐	KSCHL_PERC	KSCHL	CHAR	4	0	Condition Type Percentage Discount	T685
82	KSCHL_VAL	☐	KSCHL_VAL	KSCHL	CHAR	4	0	Condition Type Absolute Discount	T685
83	PLUNP	☐	W_PLUNP	WERT	CURR	13	2	Promotion Plan Invoiced Sales at Standard Sales Prices
84	PLURE	☐	W_PLURE	WERT	CURR	13	2	Promotion Plan Gross Revenue
85	PLULO	☐	W_PLULO	WERT	CURR	13	2	Promotion Plan Invoiced Lost Sales
86	MEDIA_TYPE	☐	RDM_MEDIA_TYPE	RDM_MEDIA_TYPE	CHAR	4	0	Media Type	RDMT_MED_TYPE
87	CUSTOMER_TYPE	☐	RDM_CUSTOMER_TYPE	RDM_CUSTOMER_TYPE	CHAR	4	0	Customer Type	RDMT_CUST_TYPE
88	ALLOW_PMAT_IGNO	☐	WPM_ALLOW_PMAT_IGNO_PROMO	XFELD	CHAR	1	0	Variant Price Allowed (for Promotion Type)
89	ITEMS_4_BBY	☐	WPM_ITEMS_4_BBYS	WPM_ITEMS_4_BBYS	CHAR	1	0	Control of Subsequent Processing of Bonus Buy Materials
90	ALLOW_DISP_MAT	☐	WPM_ALLOW_DISP_MAT	XFELD	CHAR	1	0	Addition of Display Materials Allowed
91	INIT_SLS_PRICE	☐	WPM_ALLOW_INITIAL_SLS_PRICE	XFELD	CHAR	1	0	Allow Initial Sales Price in Price Activation
92	.INCLU--AP	☐				0	0	Higher-Level Promotion
93	.INCLUDE	☐				0	0	Reference to Higher-Level Promotion/Campaign
94	REF_PROMO	☐	WAKTPP_REF_PROMO	WAKTION	CHAR	10	0	Higher-Level Promotion	WAKH
95	CGPL_GUID	☐	WAKTPP_CGPL_GUID	WAKTPP_CGPL_GUID	RAW	16	0	CGPL Project GUID
96	EXTERNAL_ID	☐	WAKTPP_CGPL_EXTID	WAKTPP_CGPL_EXTID	CHAR	24	0	CGPL Project External ID
97	IS_REF_PROMO	☐	WAKTPP_IS_REF_PROMO	WAKTPP_IS_REF_PROMO	CHAR	1	0	Indicator: Higher-Level Promotion
98	BEKST2	☐	WAKTPP_STBEK2	WAKTPP_STBEK2	CHAR	1	0	Status of New Announcement
99	ERDOCN	☐	WAKTPP_ERDOCN	WAKTPP_ERDOCN	CHAR	10	0	Document that Created the Retail Promotion
100	HIER_ID	☐	WAKT_HIER_CNT	WAKT_HIERCNT	CHAR	2	0	Hierarchy

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FRE_WAKH_STY	AKART	TWAA	AKART	KEY	1	CN
2	FRE_WAKH_STY	AKTYP	TWTY	AKTYP
3	FRE_WAKH_STY	AUFAR	T620	AUFAR
4	FRE_WAKH_STY	BEKTY	T626	AAVIT
5	FRE_WAKH_STY	CUSTOMER_TYPE	RDMT_CUST_TYPE	CUSTOMER_TYPE
6	FRE_WAKH_STY	EKERV	TWEV	EKERV
7	FRE_WAKH_STY	EKGRP	T024	EKGRP	REF	C	CN
8	FRE_WAKH_STY	EKORG	T024E	EKORG	REF	C	CN
9	FRE_WAKH_STY	KSBEK	T683	KALSM
10	FRE_WAKH_STY	KSCHL_PERC	T685	KSCHL
11	FRE_WAKH_STY	KSCHL_VAL	T685	KSCHL
12	FRE_WAKH_STY	LISRE	TWLV	LSTFL		C	N
13	FRE_WAKH_STY	MANDT	T000	MANDT	KEY	1	CN
14	FRE_WAKH_STY	MEDIA_TYPE	RDMT_MED_TYPE	MEDIA_TYPE
15	FRE_WAKH_STY	MELAK	T006	MSEHI	KEY	1	CN
16	FRE_WAKH_STY	MELRA	T006	MSEHI	KEY	1	CN
17	FRE_WAKH_STY	PLTYP	T189	PLTYP
18	FRE_WAKH_STY	REF_PROMO	WAKH	AKTNR
19	FRE_WAKH_STY	VGLAK	WAKH	AKTNR	KEY	1	CN
20	FRE_WAKH_STY	VKORG	TVKO	VKORG	REF	C	CN
21	FRE_WAKH_STY	VTWEG	TVKOV	VTWEG	REF	1	CN
22	FRE_WAKH_STY	WAELA	TCURC	WAERS	KEY	1	CN
23	FRE_WAKH_STY	WAERA	TCURC	WAERS	KEY	1	CN

History

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