SAP ABAP Table WAKH (Promotion Header Data, IS-R)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ WAKT (Package) Application development R/3 Promotions

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	WAKH	Table Relationship Diagram
Short Description	Promotion Header Data, IS-R

Delivery and Maintenance

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

History

Last changed by/on	SAP	20130529
SAP Release Created in