WAKH SAP (Promotion Header Data, IS-R) Table details
Dictionary Type: Table
Description: Promotion Header Data, IS-R
Description: Promotion Header Data, IS-R
Table field list including key, data, relationships and ABAP select examples
WAKH is a standard SAP Table which is used to store Promotion Header Data, IS-R data and is available within R/3 SAP systems depending on the version and release level.
The WAKH table consists of various fields, each holding specific information or linking keys about Promotion Header Data, IS-R data available in SAP. These include AKTNR (COUPON), AKTYP (Promotion Category), AKART (Promotion Type), WAELA (Currency current promotion - planning).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = WAKT
SAP WAKH table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AKTNR | COUPON | WAKTION | CHAR | 10 | ALPHA | WAKTION | WAK | ||
AKTYP | Promotion Category | W_AKTYP | CHAR | 4 | TWTY | AKTTY | |||
AKART | Promotion Type | W_AKART | CHAR | 4 | TWAA | W_AKART | WAA | ||
WAELA | Currency current promotion - planning | W_WAELA | CUKY | 5 | TCURC | WAERS | FWS | ||
WAERA | Currency, reference promotion | W_WAERA | CUKY | 5 | TCURC | WAERS | |||
VGLAK | Comparative promotion | W_VGLAK | CHAR | 10 | WAKH | ALPHA | WAKTION | ||
LISRE | Listing procedure for store or other assortment categories | LSTFL | CHAR | 2 | TWLV | LSTFL | WLV | ||
AUFAR | Allocation Table Type | W_AUFAR | CHAR | 4 | T620 | AUFAR | ATG | ||
BEKTY | Promotion announcement category | W_BEKTY | CHAR | 4 | T626 | AAVIT | |||
KSBEK | Message Schema | W_NACHSM | CHAR | 6 | T683 | KALSM | |||
AKVST | Processing status of the promotion | W_AKVST | CHAR | 1 | AKVST | ||||
AKAST | Allocation table status of the promotion | W_AKAST | CHAR | 1 | AKAST | ||||
AKBST | Listing Status of the Promotion | W_AKBST | CHAR | 1 | AKBST | ||||
VKGST | Price activation status | W_VKKPSH | CHAR | 1 | PREISSH | ||||
EKGST | Purchase price activation status at promotion header level | W_EKKPSH | CHAR | 1 | PREISSH | ||||
BEKST | Promotion announcement status | W_STBEK | CHAR | 1 | BEKST | ||||
AKNBS | No. assigned listing modules | W_AKNBS | INT2 | 5 | INT2 | ||||
AKNFG | Promotion: no. of plant groups | W_AKNFG | INT2 | 5 | INT2 | ||||
AKNBF | No. of module-plant group assignments | W_AKNBF | INT2 | 5 | INT2 | ||||
AKNTH | Promotion, no. of themes | W_AKNTH | INT2 | 5 | INT2 | ||||
AKNPO | No. of items with allocation qty > 0 | W_AKNPO | INT2 | 5 | INT2 | ||||
AKNWM | No. of product catalogs in promotion | W_AKNWM | INT2 | 5 | INT2 | ||||
AKNTX | No. of foreign language texts | W_AKNTX | INT2 | 5 | INT2 | ||||
NEKKO | No. of purchase prices maintained via price calcul. (KONP) | W_NEKKO | INT2 | 5 | INT2 | ||||
NVKKO | No. of sales prices maintained via price calculation (KONP) | W_NVKKO | INT2 | 5 | INT2 | ||||
NARTS | No. of blocked materials | W_NARTS | INT2 | 5 | INT2 | ||||
ATNPO | Number of promo materials in generated allocation tables | W_ATNPO | INT2 | 5 | INT2 | ||||
VTART | Check Against Listing Rules/Listing Conditions | W_LCHECK | CHAR | 1 | W_LCHECK | ||||
EKDAB | Purchase price conditions valid from | W_EKDAB | DATS | 8 | DATUM | ||||
EKDBI | Purchase price conditions valid to | W_EKDBI | DATS | 8 | DATUM | ||||
VKDAB | On Sale to Consumers From | W_VKDAB | DATS | 8 | DATUM | ||||
VKDBI | On Sale To Consumers To | W_VKDBI | DATS | 8 | DATUM | ||||
ALIVO | Start of promotion listing | W_ALIVO | DATS | 8 | DATUM | ||||
ALIBI | End of promotion listing | W_ALIBI | DATS | 8 | DATUM | ||||
SPDAB | Promotion blocked on | W_SPDAB | DATS | 8 | DATUM | ||||
SPGRU | Reason for promotion block | W_SPGRU | CHAR | 1 | SPGRU | ||||
EKKON | Create purchase price condition records | W_EKKON | CHAR | 1 | XFELD | ||||
VKKON | Create sales price condition records | W_VKKON | CHAR | 1 | XFELD | ||||
KOBOG | Group of condition types/tables for purchasing conditions | W_KOBOG | CHAR | 4 | CHAR4 | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
EKGRP | Purchasing Group - Promotion Header | W_EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
VKORG | Sales Organization: Promotion Header | W_VKORG_HEADER | CHAR | 4 | TVKO | VKORG | VKO | ||
VTWEG | Distribution Channel: Promotion Header | W_VTWEG_HEADER | CHAR | 2 | TVKOV | VTWEG | VTW | ||
PLUEP | Promotion plan, sales at purchase price | W_PLUEP | CURR | 13(2) | WERT | ||||
PLUEN | Planned sales qty for promo at delivered price (net/net) | W_PLUEN | CURR | 13(2) | WERT | ||||
PLUVP | Promotion Plan Sales Volume at Promo. Sales Prices | W_PLUVP | CURR | 13(2) | WERT | ||||
PLMGE | Promotion plan, no. logistics units | W_PLMGE | QUAN | 13(3) | MENGE | ||||
PLANZ | Promotion plan, no. of materials | W_PLANZ | NUMC | 6 | NUMC6 | ||||
MELAK | Logistics unit, promotion plan | W_MELAK | UNIT | 3 | T006 | CUNIT | MEINS | ||
MELRA | Logistics units, reference promotion | W_MELRA | UNIT | 3 | T006 | CUNIT | MEINS | ||
PDUEP | Detailed promotion plan, sales volume at purchase price | W_PDUEP | CURR | 13(2) | WERT | ||||
PDUEN | Planned sales qty at delivered price (net/net) | W_PDUEN | CURR | 13(2) | WERT | ||||
PDUVP | Detailed Promotion Plan Sales Volume at Promo. Sales Price | W_PDUVP | CURR | 13(2) | WERT | ||||
PDMGE | Detailed promotion plan, no. of logistics units | W_PDMGE | QUAN | 13(3) | MENGE | ||||
PDANZ | Detailed Promotion Plan, Number of Materials | W_PDANZ | NUMC | 6 | NUMC6 | ||||
VAUEP | Sales volume at purchase price for comparative promotion | W_VAUEP | CURR | 13(2) | WERT | ||||
VAUEN | Comparative promotion: sales vol.at delivered price(net/net) | W_VAUEN | CURR | 13(2) | WERT | ||||
VAUVP | Sales volume of comparative promotion at sales prices | W_VAUVP | CURR | 13(2) | WERT | ||||
VAMGE | No. of log. units in comparative promotion | W_VAMGE | QUAN | 13(3) | MENGE | ||||
RFIND | External description for agreement | ABREX | CHAR | 20 | CHAR20 | ||||
VAANZ | No. of materials/units of measure in comparative promotion | W_VAANZ | NUMC | 6 | NUMC6 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
KOBVK | Group of condition types/tables for sales price conditions | W_KOBVK | CHAR | 4 | CHAR4 | ||||
FADAT | Earliest Order Date | W_FADAT | DATS | 8 | DATUM | ||||
SADAT | Latest Order Date | W_SADAT | DATS | 8 | DATUM | ||||
FLDAT | Earliest delivery date | W_FLDAT | DATS | 8 | DATUM | ||||
SLDAT | Latest delivery date | W_SLDAT | DATS | 8 | DATUM | ||||
ADDIBELNR | Document number for additional | ADDI_BELNR | CHAR | 10 | ALPHA | ADDI_BELNR | |||
VZKON | Create DC condition records | W_VZKON | CHAR | 1 | XFELD | ||||
KALKE | Activation type for sales prices | W_AKTARTH | CHAR | 1 | AKTARTH | ||||
PLTYP | Price list type: promotion header | W_PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
NO_KALK | Price Activation w/o Price Calculation | NO_KALK | CHAR | 1 | XFELD | ||||
EKERV | Promotion: Purchase price determination sequence | W_EKERV | CHAR | 2 | TWEV | EKERV | |||
RFCDEST | Logical Destination (Specified in Function Call) | RFCDEST | CHAR | 32 | Assigned to domain | RFCDEST | RFC | F4_RFCDESTYPEALL | |
ERAPPL | Application that Created the Promotion | W_ERAPPL | CHAR | 1 | W_ERAPPL | ||||
KSCHL_PERC | Condition Type Percentage Discount | KSCHL_PERC | CHAR | 4 | T685 | KSCHL | |||
KSCHL_VAL | Condition Type Absolute Discount | KSCHL_VAL | CHAR | 4 | T685 | KSCHL | |||
PLUNP | Promotion Plan Invoiced Sales at Standard Sales Prices | W_PLUNP | CURR | 13(2) | WERT | ||||
PLURE | Promotion Plan Gross Revenue | W_PLURE | CURR | 13(2) | WERT | ||||
PLULO | Promotion Plan Invoiced Lost Sales | W_PLULO | CURR | 13(2) | WERT | ||||
MEDIA_TYPE | Media Type | RDM_MEDIA_TYPE | CHAR | 4 | RDMT_MED_TYPE | RDM_MEDIA_TYPE | |||
CUSTOMER_TYPE | Customer Type | RDM_CUSTOMER_TYPE | CHAR | 4 | RDMT_CUST_TYPE | RDM_CUSTOMER_TYPE | |||
ALLOW_PMAT_IGNO | Variant Price Allowed (for Promotion Type) | WPM_ALLOW_PMAT_IGNO_PROMO | CHAR | 1 | XFELD | ||||
ITEMS_4_BBY | Control of Subsequent Processing of Bonus Buy Materials | WPM_ITEMS_4_BBYS | CHAR | 1 | WPM_ITEMS_4_BBYS | ||||
ALLOW_DISP_MAT | Addition of Display Materials Allowed | WPM_ALLOW_DISP_MAT | CHAR | 1 | XFELD | ||||
INIT_SLS_PRICE | Allow Initial Sales Price in Price Activation | WPM_ALLOW_INITIAL_SLS_PRICE | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
REF_PROMO | Higher-Level Promotion | WAKTPP_REF_PROMO | CHAR | 10 | WAKH | ALPHA | WAKTION | ||
CGPL_GUID | CGPL Project GUID | WAKTPP_CGPL_GUID | RAW | 16 | WAKTPP_CGPL_GUID | ||||
EXTERNAL_ID | CGPL Project External ID | WAKTPP_CGPL_EXTID | CHAR | 24 | WAKTPP_CGPL_EXTID | ||||
IS_REF_PROMO | Indicator: Higher-Level Promotion | WAKTPP_IS_REF_PROMO | CHAR | 1 | WAKTPP_IS_REF_PROMO | ||||
BEKST2 | Status of New Announcement | WAKTPP_STBEK2 | CHAR | 1 | WAKTPP_STBEK2 | ||||
ERDOCN | Document that Created the Retail Promotion | WAKTPP_ERDOCN | CHAR | 10 | ALPHA | WAKTPP_ERDOCN | |||
HIER_ID | Hierarchy | WAKT_HIER_CNT | CHAR | 2 | WAKT_HIERCNT | ||||
.INCLU--AP | 0 | ||||||||
BPROF | Bonus Buy: Bonus buy profile | RDM_BBY_BPROF | CHAR | 4 | CHAR4 | RDM_BBY_BPROF | RDM_BBY_BPROF_SHLP |
Key field | Non-key field |
How do I retrieve data from SAP table WAKH using ABAP code
The following ABAP code Example will allow you to do a basic selection on WAKH to SELECT all data from the tableDATA: WA_WAKH TYPE WAKH.
SELECT SINGLE *
FROM WAKH
INTO CORRESPONDING FIELDS OF WA_WAKH
WHERE...
How to access SAP table WAKH
Within an ECC or HANA version of SAP you can also view further information about WAKH and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects