WAKH

Promotion Header Data, IS-R | #masterdata | Component: Seasonal / Promotion Planning
Column Name Description
MANDT FK Client
AKTNR Promotion
Column Name Description
💲 Currency Current Promotion - Planning (WAELA):
PLUEP Promotion plan, sales at purchase price
PLUEN Planned sales qty for promo at delivered price (net/net)
PLUVP Promotion Plan Sales Volume at Promo. Sales Prices
PDUEP Detailed promotion plan, sales volume at purchase price
PDUEN Planned sales qty at delivered price (net/net)
PDUVP Detailed Promotion Plan Sales Volume at Promo. Sales Price
PLUNP Promotion Plan Invoiced Sales at Standard Sales Prices
PLURE Promotion Plan Gross Revenue
PLULO Promotion Plan Invoiced Lost Sales
💲 Currency, reference promotion (WAERA):
VAUEP Sales volume at purchase price for comparative promotion
VAUEN Comparative promotion: sales vol.at delivered price(net/net)
VAUVP Sales volume of comparative promotion at sales prices
Column Name Description
📏 Logistics unit, promotion plan (MELAK):
PLMGE Promotion plan, no. logistics units
PDMGE Detailed promotion plan, no. of logistics units
📏 Logistics units, reference promotion (MELRA):
VAMGE No. of log. units in comparative promotion
Column Name Description
EKDAB Purchase price conditions valid from
EKDBI Purchase price conditions valid to
VKDAB On Sale to Consumers From
VKDBI On Sale To Consumers To
ALIVO Start of promotion listing
ALIBI End of promotion listing
SPDAB Promotion blocked on
ERDAT Date on which the record was created
AEDAT Last Changed On
FADAT Earliest Order Date
SADAT Latest Order Date
FLDAT Earliest delivery date
SLDAT Latest delivery date
Column Name Description
AKVST Processing status of the promotion Show values
AKAST Allocation table status of the promotion Show values
AKBST Listing Status of the Promotion Show values
VKGST Price activation status Show values
EKGST Purchase price activation status at promotion header level Show values
BEKST Promotion Announcement Status Show values
VTART Check Against Listing Rules/Listing Conditions Show values
SPGRU Reason for promotion block Show values
EKKON Create purchase price condition records Show values
VKKON Create sales price condition records Show values
VZKON Create DC condition records Show values
KALKE Activation type for sales prices Show values
NO_KALK Price Activation w/o Price Calculation Show values
ERAPPL Application that Created the Promotion Show values
ALLOW_PMAT_IGNO Variant Price Allowed (for Promotion Type) Show values
ITEMS_4_BBY Control of Subsequent Processing of Bonus Buy Materials Show values
ALLOW_DISP_MAT Addition of Display Materials Allowed Show values
INIT_SLS_PRICE Allow Initial Sales Price in Price Activation Show values
IS_REF_PROMO Indicator: Higher-Level Promotion Show values
BEKST2 Status of New Announcement Show values
Column Name Description Domain name
AKNBS No. assigned listing modules INT2
AKNFG Promotion: no. of plant groups INT2
AKNBF No. of module-plant group assignments INT2
AKNTH Promotion, no. of themes INT2
AKNPO No. of items with allocation qty > 0 INT2
AKNWM No. of product catalogs in promotion INT2
AKNTX No. of foreign language texts INT2
NEKKO No. of purchase prices maintained via price calcul. (KONP) INT2
NVKKO No. of sales prices maintained via price calculation (KONP) INT2
NARTS No. of blocked materials INT2
ATNPO Number of promo materials in generated allocation tables INT2
KOBOG Group of condition types/tables for purchasing conditions CHAR4
PLANZ Promotion plan, no. of materials NUMC6
PDANZ Detailed Promotion Plan, Number of Materials NUMC6
RFIND External description for agreement CHAR20
VAANZ No. of materials/units of measure in comparative promotion NUMC6
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
KOBVK Group of condition types/tables for sales price conditions CHAR4
ADDIBELNR Document number for additional ADDI_BELNR
RFCDEST Logical destination (specified in function call) RFCDEST
CGPL_GUID CGPL Project GUID WAKTPP_CGPL_GUID
EXTERNAL_ID CGPL Project External ID WAKTPP_CGPL_EXTID
ERDOCN Document that Created the Retail Promotion WAKTPP_ERDOCN
HIER_ID Hierarchy WAKT_HIERCNT
BPROF Bonus Buy: Bonus buy profile CHAR4
Master Data Relations Join Conditions
Promotion Type
  • WAKH.MANDT == TWAA.MANDT
  • WAKH.AKART == TWAA.AKART
Promotion Category
  • Promotion Category
  • Client
  • WAKH.AKTYP == TWTY.AKTYP
  • WAKH.MANDT == TWTY.MANDT
Allocation Table Type
  • WAKH.MANDT == T620.MANDT
  • WAKH.AUFAR == T620.AUFAR
Promotion announcement category
  • WAKH.MANDT == T626.MANDT
  • WAKH.BEKTY == T626.AAVIT
Customer Type
Promotion: Purchase price determination sequence
  • ?
  • Client
  • Promotion: Purchase price determination sequence
  • WAKH.[column in domain "KAPPL"] == TWEV.KAPPL
  • WAKH.MANDT == TWEV.MANDT
  • WAKH.EKERV == TWEV.EKERV
Purchasing Group
  • Purchasing Group
  • Client
  • WAKH.EKGRP == T024.EKGRP
  • WAKH.MANDT == T024.MANDT
Purchasing organization
  • WAKH.MANDT == T024E.MANDT
  • WAKH.EKORG == T024E.EKORG
Message Schema
  • ?
  • Message Schema
  • ?
  • WAKH.MANDT == T683.MANDT
  • WAKH.[column in domain "KAPPL"] == T683.KAPPL
  • WAKH.KSBEK == T683.KALSM
  • WAKH.[column in domain "KVEWE"] == T683.KVEWE
Condition Type Percentage Discount
  • Condition Type Percentage Discount
  • Client
  • ?
  • ?
  • WAKH.KSCHL_PERC == T685.KSCHL
  • WAKH.MANDT == T685.MANDT
  • WAKH.[column in domain "KVEWE"] == T685.KVEWE
  • WAKH.[column in domain "KAPPL"] == T685.KAPPL
Condition Type Absolute Discount
  • Condition Type Absolute Discount
  • Client
  • ?
  • ?
  • WAKH.KSCHL_VAL == T685.KSCHL
  • WAKH.MANDT == T685.MANDT
  • WAKH.[column in domain "KVEWE"] == T685.KVEWE
  • WAKH.[column in domain "KAPPL"] == T685.KAPPL
Listing procedure for store or other assortment categories
  • Listing procedure for store or other assortment categories
  • Client
  • WAKH.LISRE == TWLV.LSTFL
  • WAKH.MANDT == TWLV.MANDT
Client WAKH.MANDT == T000.MANDT
Media Type
Logistics unit, promotion plan
  • WAKH.MANDT == T006.MANDT
  • WAKH.MELAK == T006.MSEHI
Logistics units, reference promotion
  • WAKH.MANDT == T006.MANDT
  • WAKH.MELRA == T006.MSEHI
Price list type: promotion header
  • WAKH.MANDT == T189.MANDT
  • WAKH.PLTYP == T189.PLTYP
Promotion Number
  • Higher-Level Promotion
  • Client
  • WAKH.REF_PROMO == WAKH.AKTNR
  • WAKH.MANDT == WAKH.MANDT
Comparative promotion
  • Comparative promotion
  • Client
  • WAKH.VGLAK == WAKH.AKTNR
  • WAKH.MANDT == WAKH.MANDT
Sales Organization
  • WAKH.MANDT == TVKO.MANDT
  • WAKH.VKORG == TVKO.VKORG
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • WAKH.VKORG == TVKOV.VKORG
  • WAKH.MANDT == TVKOV.MANDT
  • WAKH.VTWEG == TVKOV.VTWEG
Currency Current Promotion - Planning
  • WAKH.MANDT == TCURC.MANDT
  • WAKH.WAELA == TCURC.WAERS
Currency, reference promotion
  • WAKH.MANDT == TCURC.MANDT
  • WAKH.WAERA == TCURC.WAERS