SAP Table WAKH

Promotion Header Data, IS-R

WAKH (Promotion Header Data, IS-R) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WAKH to other SAP tables.

WAKH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AKTNR Promotion WAKTION CHAR 10 0
AKTYP Promotion Category W_AKTYP TWTY CHAR 4 0
AKART Promotion Type W_AKART TWAA CHAR 4 0
WAELA Currency current promotion - planning W_WAELA TCURC CUKY 5 0
WAERA Currency, reference promotion W_WAERA TCURC CUKY 5 0
VGLAK Comparative promotion W_VGLAK WAKH CHAR 10 0
LISRE Listing procedure for store or other assortment categories LSTFL TWLV CHAR 2 0
AUFAR Allocation Table Type W_AUFAR T620 CHAR 4 0
BEKTY Promotion announcement category W_BEKTY T626 CHAR 4 0
KSBEK Message Schema W_NACHSM T683 CHAR 6 0
AKVST Processing status of the promotion W_AKVST CHAR 1 0
A Partially processed
B Completely processed
C In planning
D Subsequent Processing Started in PPW
AKAST Allocation table status of the promotion W_AKAST CHAR 1 0
NULL Alloc tbl not generated
A Alloc tbl partially generated
B Alloc tbl generated for all items
AKBST Listing Status of the Promotion W_AKBST CHAR 1 0
NULL Listing not successful
A Listing partially successful with manual modules
B Listing successful for all items with manual modules
X Listing partially successful with autom. module generation
Y List successful for all items with autom. module generation
Z Autom. module generation determined. Listing no successful
VKGST Price activation status W_VKKPSH CHAR 1 0
NULL No prices activated
A Some prices activated
B Prices for all items activated
EKGST Purchase price activation status at promotion header level W_EKKPSH CHAR 1 0
NULL No prices activated
A Some prices activated
B Prices for all items activated
BEKST Promotion announcement status W_STBEK CHAR 1 0
NULL Announcement not made
A Announcement partially made
B Announcement made
AKNBS No. assigned listing modules W_AKNBS INT2 5 0
AKNFG Promotion: no. of plant groups W_AKNFG INT2 5 0
AKNBF No. of module-plant group assignments W_AKNBF INT2 5 0
AKNTH Promotion, no. of themes W_AKNTH INT2 5 0
AKNPO No. of items with allocation qty > 0 W_AKNPO INT2 5 0
AKNWM No. of product catalogs in promotion W_AKNWM INT2 5 0
AKNTX No. of foreign language texts W_AKNTX INT2 5 0
NEKKO No. of purchase prices maintained via price calcul. (KONP) W_NEKKO INT2 5 0
NVKKO No. of sales prices maintained via price calculation (KONP) W_NVKKO INT2 5 0
NARTS No. of blocked materials W_NARTS INT2 5 0
ATNPO Number of promo materials in generated allocation tables W_ATNPO INT2 5 0
VTART Check Against Listing Rules/Listing Conditions W_LCHECK CHAR 1 0
NULL No check against listing rules/listing conditions
X Check against listing rules
Y Check against listing conditions
EKDAB Purchase price conditions valid from W_EKDAB DATS 8 0
EKDBI Purchase price conditions valid to W_EKDBI DATS 8 0
VKDAB On Sale to Consumers From W_VKDAB DATS 8 0
VKDBI On Sale To Consumers To W_VKDBI DATS 8 0
ALIVO Start of promotion listing W_ALIVO DATS 8 0
ALIBI End of promotion listing W_ALIBI DATS 8 0
SPDAB Promotion blocked on W_SPDAB DATS 8 0
SPGRU Reason for promotion block W_SPGRU CHAR 1 0
A Delivery difficulties
B Procurement unclear
C Material damaged
D Other
F Plant deleted
EKKON Create purchase price condition records W_EKKON CHAR 1 0
X Yes
NULL No
VKKON Create sales price condition records W_VKKON CHAR 1 0
X Yes
NULL No
KOBOG Group of condition types/tables for purchasing conditions W_KOBOG CHAR 4 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EKGRP Purchasing Group - Promotion Header W_EKGRP T024 CHAR 3 0
VKORG Sales Organization: Promotion Header W_VKORG_HEADER TVKO CHAR 4 0
VTWEG Distribution Channel: Promotion Header W_VTWEG_HEADER TVKOV CHAR 2 0
PLUEP Promotion plan, sales at purchase price W_PLUEP CURR 13 2
PLUEN Planned sales qty for promo at delivered price (net/net) W_PLUEN CURR 13 2
PLUVP Promotion Plan Sales Volume at Promo. Sales Prices W_PLUVP CURR 13 2
PLMGE Promotion plan, no. logistics units W_PLMGE QUAN 13 3
PLANZ Promotion plan, no. of materials W_PLANZ NUMC 6 0
MELAK Logistics unit, promotion plan W_MELAK T006 UNIT 3 0
MELRA Logistics units, reference promotion W_MELRA T006 UNIT 3 0
PDUEP Detailed promotion plan, sales volume at purchase price W_PDUEP CURR 13 2
PDUEN Planned sales qty at delivered price (net/net) W_PDUEN CURR 13 2
PDUVP Detailed Promotion Plan Sales Volume at Promo. Sales Price W_PDUVP CURR 13 2
PDMGE Detailed promotion plan, no. of logistics units W_PDMGE QUAN 13 3
PDANZ Detailed Promotion Plan, Number of Materials W_PDANZ NUMC 6 0
VAUEP Sales volume at purchase price for comparative promotion W_VAUEP CURR 13 2
VAUEN Comparative promotion: sales vol.at delivered price(net/net) W_VAUEN CURR 13 2
VAUVP Sales volume of comparative promotion at sales prices W_VAUVP CURR 13 2
VAMGE No. of log. units in comparative promotion W_VAMGE QUAN 13 3
RFIND External description for agreement ABREX CHAR 20 0
VAANZ No. of materials/units of measure in comparative promotion W_VAANZ NUMC 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
KOBVK Group of condition types/tables for sales price conditions W_KOBVK CHAR 4 0
FADAT Earliest Order Date W_FADAT DATS 8 0
SADAT Latest Order Date W_SADAT DATS 8 0
FLDAT Earliest delivery date W_FLDAT DATS 8 0
SLDAT Latest delivery date W_SLDAT DATS 8 0
ADDIBELNR Document number for additional ADDI_BELNR CHAR 10 0
VZKON Create DC condition records W_VZKON CHAR 1 0
X Yes
NULL No
KALKE Activation type for sales prices W_AKTARTH CHAR 1 0
1 Plant
2 Plant group
3 Price List
4 Distribution Chain
5 Several Price Lists (only for PPW Promotions)
PLTYP Price list type: promotion header W_PLTYP T189 CHAR 2 0
NO_KALK Price Activation w/o Price Calculation NO_KALK CHAR 1 0
X Yes
NULL No
EKERV Promotion: Purchase price determination sequence W_EKERV TWEV CHAR 2 0
RFCDEST Logical Destination (Specified in Function Call) RFCDEST CHAR 32 0
ERAPPL Application that Created the Promotion W_ERAPPL CHAR 1 0
NULL Promotion Processing
A Merchandise and assortment planning
B Price Planning Workbench
X BAPI Interface
C Promotion Optimization - Demand Management
W Enterprise Service
KSCHL_PERC Condition Type Percentage Discount KSCHL_PERC T685 CHAR 4 0
KSCHL_VAL Condition Type Absolute Discount KSCHL_VAL T685 CHAR 4 0
PLUNP Promotion Plan Invoiced Sales at Standard Sales Prices W_PLUNP CURR 13 2
PLURE Promotion Plan Gross Revenue W_PLURE CURR 13 2
PLULO Promotion Plan Invoiced Lost Sales W_PLULO CURR 13 2
MEDIA_TYPE Media Type RDM_MEDIA_TYPE RDMT_MED_TYPE CHAR 4 0
CUSTOMER_TYPE Customer Type RDM_CUSTOMER_TYPE RDMT_CUST_TYPE CHAR 4 0
ALLOW_PMAT_IGNO Variant Price Allowed (for Promotion Type) WPM_ALLOW_PMAT_IGNO_PROMO CHAR 1 0
X Yes
NULL No
ITEMS_4_BBY Control of Subsequent Processing of Bonus Buy Materials WPM_ITEMS_4_BBYS CHAR 1 0
NULL No subsequent processing
1 Manual Processing of articles of selected BBY
2 Automatic Processing of all BBY articles
ALLOW_DISP_MAT Addition of Display Materials Allowed WPM_ALLOW_DISP_MAT CHAR 1 0
X Yes
NULL No
INIT_SLS_PRICE Allow Initial Sales Price in Price Activation WPM_ALLOW_INITIAL_SLS_PRICE CHAR 1 0
X Yes
NULL No
REF_PROMO Higher-Level Promotion WAKTPP_REF_PROMO WAKH CHAR 10 0
CGPL_GUID CGPL Project GUID WAKTPP_CGPL_GUID RAW 16 0
EXTERNAL_ID CGPL Project External ID WAKTPP_CGPL_EXTID CHAR 24 0
IS_REF_PROMO Indicator: Higher-Level Promotion WAKTPP_IS_REF_PROMO CHAR 1 0
NULL Operational Promotion
X Higher-Level Promotion
BEKST2 Status of New Announcement WAKTPP_STBEK2 CHAR 1 0
NULL New Announcement Not Required
X New Announcement Required
ERDOCN Document that Created the Retail Promotion WAKTPP_ERDOCN CHAR 10 0
HIER_ID Hierarchy WAKT_HIER_CNT CHAR 2 0
BPROF Bonus Buy: Bonus buy profile RDM_BBY_BPROF CHAR 4 0

WAKH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WAKH AKART WAKH MANDT TWAA Promotion Type, IS-R MANDT
WAKH AKART WAKH AKART TWAA Promotion Type, IS-R AKART
WAKH AKTYP WAKH AKTYP TWTY Promotion category, IS-R AKTYP
WAKH AKTYP WAKH MANDT TWTY Promotion category, IS-R MANDT
WAKH AUFAR WAKH AUFAR T620 Allocation Table Document Types AUFAR
WAKH AUFAR WAKH MANDT T620 Allocation Table Document Types MANDT
WAKH BEKTY WAKH MANDT T626 Allocation Table Notification Categories MANDT
WAKH BEKTY WAKH BEKTY T626 Allocation Table Notification Categories AAVIT
WAKH CUSTOMER_TYPE WAKH MANDT RDMT_CUST_TYPE Customer Types MANDT
WAKH CUSTOMER_TYPE WAKH CUSTOMER_TYPE RDMT_CUST_TYPE Customer Types CUSTOMER_TYPE
WAKH EKERV 'M' TWEV Pricing: Determination procedure KAPPL
WAKH EKERV WAKH EKERV TWEV Pricing: Determination procedure EKERV
WAKH EKERV WAKH MANDT TWEV Pricing: Determination procedure MANDT
WAKH EKGRP WAKH MANDT T024 Purchasing Groups MANDT
WAKH EKGRP WAKH EKGRP T024 Purchasing Groups EKGRP
WAKH EKORG WAKH MANDT T024E Purchasing Organizations MANDT
WAKH EKORG WAKH EKORG T024E Purchasing Organizations EKORG
WAKH KSBEK WAKH KSBEK T683 Pricing procedures KALSM
WAKH KSBEK WAKH MANDT T683 Pricing procedures MANDT
WAKH KSBEK 'B' T683 Pricing procedures KVEWE
WAKH KSBEK 'WB' T683 Pricing procedures KAPPL
WAKH KSCHL_PERC WAKH MANDT T685 Conditions: Types MANDT
WAKH KSCHL_PERC 'A' T685 Conditions: Types KVEWE
WAKH KSCHL_PERC 'V' T685 Conditions: Types KAPPL
WAKH KSCHL_PERC WAKH KSCHL_PERC T685 Conditions: Types KSCHL
WAKH KSCHL_VAL WAKH MANDT T685 Conditions: Types MANDT
WAKH KSCHL_VAL 'A' T685 Conditions: Types KVEWE
WAKH KSCHL_VAL 'V' T685 Conditions: Types KAPPL
WAKH KSCHL_VAL WAKH KSCHL_VAL T685 Conditions: Types KSCHL
WAKH LISRE WAKH MANDT TWLV Listing procedure, assortments MANDT
WAKH LISRE WAKH LISRE TWLV Listing procedure, assortments LSTFL
WAKH MANDT WAKH MANDT T000 Clients MANDT
WAKH MEDIA_TYPE WAKH MANDT RDMT_MED_TYPE Media Types MANDT
WAKH MEDIA_TYPE WAKH MEDIA_TYPE RDMT_MED_TYPE Media Types MEDIA_TYPE
WAKH MELAK WAKH MELAK T006 Units of Measurement MSEHI
WAKH MELAK WAKH MANDT T006 Units of Measurement MANDT
WAKH MELRA WAKH MANDT T006 Units of Measurement MANDT
WAKH MELRA WAKH MELRA T006 Units of Measurement MSEHI
WAKH PLTYP WAKH MANDT T189 Conditions: Price List Categories MANDT
WAKH PLTYP WAKH PLTYP T189 Conditions: Price List Categories PLTYP
WAKH REF_PROMO SYST MANDT WAKH Promotion Header Data, IS-R MANDT
WAKH REF_PROMO WAKH REF_PROMO WAKH Promotion Header Data, IS-R AKTNR
WAKH VGLAK WAKH MANDT WAKH Promotion Header Data, IS-R MANDT
WAKH VGLAK WAKH VGLAK WAKH Promotion Header Data, IS-R AKTNR
WAKH VKORG WAKH MANDT TVKO Organizational Unit: Sales Organizations MANDT
WAKH VKORG WAKH VKORG TVKO Organizational Unit: Sales Organizations VKORG
WAKH VTWEG WAKH VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
WAKH VTWEG WAKH VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
WAKH VTWEG WAKH MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
WAKH WAELA WAKH WAELA TCURC Currency Codes WAERS
WAKH WAELA WAKH MANDT TCURC Currency Codes MANDT
WAKH WAERA WAKH MANDT TCURC Currency Codes MANDT
WAKH WAERA WAKH WAERA TCURC Currency Codes WAERS