SAP WAKH Promotion Header Data, IS-R Table
Overview
WAKH is a standard SAP S/4HANA table that stores Promotion Header Data, IS-R data. There are total 98 fields in the WAKH table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WAKH belongs to Seasonal / Promotion Planning (LO-RFM-MD-PR) module and is located in the package Application development R/3 Promotions (WAKT).
In addition, following links provide an overview of foreign key relationships, if any, that link WAKH to other SAP tables and standard CDS views available based on WAKH table in S/4HANA 2020.
Techincal Settings of WAKH
Below are technical details of the table WAKH
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WAKH Fields
The following table gives you an overview of the fields available in WAKH
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AKTNR | Promotion | WAKTION | CHAR | 10 | |
| AKTYP | Promotion Category | W_AKTYP | TWTY | CHAR | 4 |
| AKART | Promotion Type | W_AKART | TWAA | CHAR | 4 |
| WAELA | Currency Current Promotion - Planning | W_WAELA | TCURC | CUKY | 5 |
| WAERA | Currency reference promotion | W_WAERA | TCURC | CUKY | 5 |
| VGLAK | Comparative promotion | W_VGLAK | WAKH | CHAR | 10 |
| LISRE | Listing procedure for store or other assortment categories | LSTFL | TWLV | CHAR | 2 |
| AUFAR | Allocation Table Type | W_AUFAR | T620 | CHAR | 4 |
| BEKTY | Promotion announcement category | W_BEKTY | T626 | CHAR | 4 |
| KSBEK | Message Schema | W_NACHSM | T683 | CHAR | 6 |
| AKVST | Processing status of the promotion | W_AKVST | CHAR | 1 | |
| AKAST | Allocation table status of the promotion | W_AKAST | CHAR | 1 | |
| AKBST | Listing Status of the Promotion | W_AKBST | CHAR | 1 | |
| VKGST | Price activation status | W_VKKPSH | CHAR | 1 | |
| EKGST | Purchase price activation status at promotion header level | W_EKKPSH | CHAR | 1 | |
| BEKST | Promotion Announcement Status | W_STBEK | CHAR | 1 | |
| AKNBS | No. assigned listing modules | W_AKNBS | INT2 | 5 | |
| AKNFG | Promotion: no. of plant groups | W_AKNFG | INT2 | 5 | |
| AKNBF | No. of module-plant group assignments | W_AKNBF | INT2 | 5 | |
| AKNTH | Promotion no. of themes | W_AKNTH | INT2 | 5 | |
| AKNPO | No. of items with allocation qty > 0 | W_AKNPO | INT2 | 5 | |
| AKNWM | No. of product catalogs in promotion | W_AKNWM | INT2 | 5 | |
| AKNTX | No. of foreign language texts | W_AKNTX | INT2 | 5 | |
| NEKKO | No. of purchase prices maintained via price calcul. (KONP) | W_NEKKO | INT2 | 5 | |
| NVKKO | No. of sales prices maintained via price calculation (KONP) | W_NVKKO | INT2 | 5 | |
| NARTS | No. of blocked materials | W_NARTS | INT2 | 5 | |
| ATNPO | Number of promo materials in generated allocation tables | W_ATNPO | INT2 | 5 | |
| VTART | Check Against Listing Rules/Listing Conditions | W_LCHECK | CHAR | 1 | |
| EKDAB | Purchase price conditions valid from | W_EKDAB | DATS | 8 | |
| EKDBI | Purchase price conditions valid to | W_EKDBI | DATS | 8 | |
| VKDAB | On Sale to Consumers From | W_VKDAB | DATS | 8 | |
| VKDBI | On Sale To Consumers To | W_VKDBI | DATS | 8 | |
| ALIVO | Start of promotion listing | W_ALIVO | DATS | 8 | |
| ALIBI | End of promotion listing | W_ALIBI | DATS | 8 | |
| SPDAB | Promotion blocked on | W_SPDAB | DATS | 8 | |
| SPGRU | Reason for promotion block | W_SPGRU | CHAR | 1 | |
| EKKON | Create purchase price condition records | W_EKKON | CHAR | 1 | |
| VKKON | Create sales price condition records | W_VKKON | CHAR | 1 | |
| KOBOG | Group of condition types/tables for purchasing conditions | W_KOBOG | CHAR | 4 | |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| EKGRP | Purchasing Group | W_EKGRP | T024 | CHAR | 3 |
| VKORG | Sales Organization | W_VKORG_HEADER | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | W_VTWEG_HEADER | TVKOV | CHAR | 2 |
| PLUEP | Promotion plan sales at purchase price | W_PLUEP | CURR | 13 | |
| PLUEN | Planned sales qty for promo at delivered price (net/net) | W_PLUEN | CURR | 13 | |
| PLUVP | Promotion Plan Sales Volume at Promo. Sales Prices | W_PLUVP | CURR | 13 | |
| PLMGE | Promotion plan no. logistics units | W_PLMGE | QUAN | 13 | |
| PLANZ | Promotion plan no. of materials | W_PLANZ | NUMC | 6 | |
| MELAK | Logistics unit promotion plan | W_MELAK | T006 | UNIT | 3 |
| MELRA | Logistics units reference promotion | W_MELRA | T006 | UNIT | 3 |
| PDUEP | Detailed promotion plan sales volume at purchase price | W_PDUEP | CURR | 13 | |
| PDUEN | Planned sales qty at delivered price (net/net) | W_PDUEN | CURR | 13 | |
| PDUVP | Detailed Promotion Plan Sales Volume at Promo. Sales Price | W_PDUVP | CURR | 13 | |
| PDMGE | Detailed promotion plan no. of logistics units | W_PDMGE | QUAN | 13 | |
| PDANZ | Detailed Promotion Plan Number of Materials | W_PDANZ | NUMC | 6 | |
| VAUEP | Sales volume at purchase price for comparative promotion | W_VAUEP | CURR | 13 | |
| VAUEN | Comparative promotion: sales vol.at delivered price(net/net) | W_VAUEN | CURR | 13 | |
| VAUVP | Sales volume of comparative promotion at sales prices | W_VAUVP | CURR | 13 | |
| VAMGE | No. of log. units in comparative promotion | W_VAMGE | QUAN | 13 | |
| RFIND | External description for agreement | ABREX | CHAR | 20 | |
| VAANZ | No. of materials/units of measure in comparative promotion | W_VAANZ | NUMC | 6 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| KOBVK | Group of condition types/tables for sales price conditions | W_KOBVK | CHAR | 4 | |
| FADAT | Earliest Order Date | W_FADAT | DATS | 8 | |
| SADAT | Latest Order Date | W_SADAT | DATS | 8 | |
| FLDAT | Earliest delivery date | W_FLDAT | DATS | 8 | |
| SLDAT | Latest delivery date | W_SLDAT | DATS | 8 | |
| ADDIBELNR | Document number for additional | ADDI_BELNR | CHAR | 10 | |
| VZKON | Create DC condition records | W_VZKON | CHAR | 1 | |
| KALKE | Activation type for sales prices | W_AKTARTH | CHAR | 1 | |
| PLTYP | Price list type: promotion header | W_PLTYP | T189 | CHAR | 2 |
| NO_KALK | Price Activation w/o Price Calculation | NO_KALK | CHAR | 1 | |
| EKERV | Promotion: Purchase price determination sequence | W_EKERV | TWEV | CHAR | 2 |
| RFCDEST | Logical destination (specified in function call) | RFCDEST | * | CHAR | 32 |
| ERAPPL | Application that Created the Promotion | W_ERAPPL | CHAR | 1 | |
| KSCHL_PERC | Condition Type Percentage Discount | KSCHL_PERC | T685 | CHAR | 4 |
| KSCHL_VAL | Condition Type Absolute Discount | KSCHL_VAL | T685 | CHAR | 4 |
| PLUNP | Promotion Plan Invoiced Sales at Standard Sales Prices | W_PLUNP | CURR | 13 | |
| PLURE | Promotion Plan Gross Revenue | W_PLURE | CURR | 13 | |
| PLULO | Promotion Plan Invoiced Lost Sales | W_PLULO | CURR | 13 | |
| MEDIA_TYPE | Media Type | RDM_MEDIA_TYPE | RDMT_MED_TYPE | CHAR | 4 |
| CUSTOMER_TYPE | Customer Type | RDM_CUSTOMER_TYPE | RDMT_CUST_TYPE | CHAR | 4 |
| ALLOW_PMAT_IGNO | Variant Price Allowed (for Promotion Type) | WPM_ALLOW_PMAT_IGNO_PROMO | CHAR | 1 | |
| ITEMS_4_BBY | Control of Subsequent Processing of Bonus Buy Materials | WPM_ITEMS_4_BBYS | CHAR | 1 | |
| ALLOW_DISP_MAT | Addition of Display Materials Allowed | WPM_ALLOW_DISP_MAT | CHAR | 1 | |
| INIT_SLS_PRICE | Allow Initial Sales Price in Price Activation | WPM_ALLOW_INITIAL_SLS_PRICE | CHAR | 1 | |
| REF_PROMO | Higher-Level Promotion | WAKTPP_REF_PROMO | WAKH | CHAR | 10 |
| CGPL_GUID | CGPL Project GUID | WAKTPP_CGPL_GUID | RAW | 16 | |
| EXTERNAL_ID | CGPL Project External ID | WAKTPP_CGPL_EXTID | CHAR | 24 | |
| IS_REF_PROMO | Indicator: Higher-Level Promotion | WAKTPP_IS_REF_PROMO | CHAR | 1 | |
| BEKST2 | Status of New Announcement | WAKTPP_STBEK2 | CHAR | 1 | |
| ERDOCN | Document that Created the Retail Promotion | WAKTPP_ERDOCN | CHAR | 10 | |
| HIER_ID | Hierarchy | WAKT_HIER_CNT | CHAR | 2 | |
| BPROF | Bonus Buy: Bonus buy profile | RDM_BBY_BPROF | CHAR | 4 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WAKH
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WAKH | AKART | 1: CN | TWAA |
| WAKH | AKTYP | : | TWTY |
| WAKH | AUFAR | : | T620 |
| WAKH | BEKTY | : | T626 |
| WAKH | CUSTOMER_TYPE | : | RDMT_CUST_TYPE |
| WAKH | EKERV | : | TWEV |
| WAKH | EKGRP | C: CN | T024 |
| WAKH | EKORG | C: CN | T024E |
| WAKH | KSBEK | : | T683 |
| WAKH | KSCHL_PERC | : | T685 |
| WAKH | KSCHL_VAL | : | T685 |
| WAKH | LISRE | C: N | TWLV |
| WAKH | MANDT | 1: CN | T000 |
| WAKH | MEDIA_TYPE | : | RDMT_MED_TYPE |
| WAKH | MELAK | 1: CN | T006 |
| WAKH | MELRA | 1: CN | T006 |
| WAKH | PLTYP | : | T189 |
| WAKH | REF_PROMO | : | WAKH |
| WAKH | VGLAK | 1: CN | WAKH |
| WAKH | VKORG | C: CN | TVKO |
| WAKH | VTWEG | 1: CN | TVKOV |
| WAKH | WAELA | 1: CN | TCURC |
| WAKH | WAERA | 1: CN | TCURC |