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 | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
AKAST
Allocation table status of the promotion
|
W_AKAST |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
AKBST
Listing Status of the Promotion
|
W_AKBST |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VKGST
Price activation status
|
W_VKKPSH |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
EKGST
Purchase price activation status at promotion header level
|
W_EKKPSH |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
BEKST
Promotion announcement status
|
W_STBEK |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
EKKON
Create purchase price condition records
|
W_EKKON |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VKKON
Create sales price condition records
|
W_VKKON |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
KALKE
Activation type for sales prices
|
W_AKTARTH |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
ITEMS_4_BBY
Control of Subsequent Processing of Bonus Buy Materials
|
WPM_ITEMS_4_BBYS |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
ALLOW_DISP_MAT
Addition of Display Materials Allowed
|
WPM_ALLOW_DISP_MAT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
INIT_SLS_PRICE
Allow Initial Sales Price in Price Activation
|
WPM_ALLOW_INITIAL_SLS_PRICE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
BEKST2
Status of New Announcement
|
WAKTPP_STBEK2 |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 |