WALE

Material to store assignment to promotion | #transactional | Component: Seasonal / Promotion Planning
Column Name Description
MANDT FK Client
AKTNR FK Promotion
ARTNR FK Material Number
MEBME FK Sales unit
KUNNR FK Customer Number for Plant
CLINT FK Internal Class Number
Column Name Description
💲 Purchase price currency (WAEEK):
PLEKP Basic purchase price (gross) per plant/material
💲 Currency Current Promotion - Planning (WAELA):
PLVKP Sales price for promotion item
VABGP Transfer price, distribution center
EKPNN Purchase price (net/net)
VKPNN Sales price (net)
NVKP Standard sales price at plant level
SPANE Margin (net) in sales price calculation
SPABR Margin (gross) in sales price calculation
AUFSG Actual Markup in Sales Price Calculation
VSPAN Net warehouse margin
VSPAB Gross warehouse margin
VAUFS Warehouse markup
Column Name Description
📏 Sales unit (MEBME):
WMNGE Quantity requested by store
AUFME Corrected/confirmed allocation quantity for a promotion item
PABBM Planned Sales Qty. of Promotion Material in Sales Units
MIAMG Minimum order qty for promotional material
PAUFME Planned allocation quantity for promotion item for a plant
Column Name Description
ABDTB Confirmation request date
RUDAB Reply date plant
RUDAV Reply date DC
EKDAB Purchase price conditions valid from
EKDBI Purchase price conditions valid to
VKDAB On Sale to Consumers From
VKDBI On Sale To Consumers To
ERDAT Date on which the record was created
AEDAT Last Changed On
ALIVO Starting date for activating DC transfer prices
ALIBI Final date for activating DC transfer prices
Column Name Description
GENLI Execute generation if listing check error detected Show values
LIFTY Supplier Category - Retail Show values
INFWK Info record at plant level Show values
BZQFI Supply Source Determination Status Show values
RUSTB Status of reply to announcement - plant Show values
RUSTV Status of reply to announcement - DC Show values
BESTB Confirmation can be carried out for plant Show values
BESTV Confirmation can be carried out for DC Show values
AENDB Send change to plant Show values
AENDV Send change to DC Show values
PARKZ Price type indicator (gross, net) Show values
AUGEN Allocation table creation status Show values
VKGEN Sales price generation status Show values
EKGEN Purchase price generation status Show values
BEGEB Generation status of announcement - plant Show values
BEGEV Announcement status - DC Show values
BEDEB Detailed status of promotion announcement - plant Show values
BEDEV Detailed status of promotion announcement - DC Show values
RELIF Regular Supplier Show values
ECKPKZ Indicates whether price point tables should override price Show values
SPGRU Reason for promotion block Show values
Column Name Description Domain name
WALNR Plant - material of promotion in message control WA_NUM10
ERLIS Error cat. after listing rule check ERLIS
EPEIN Price unit DEC5
VZEPE Price unit Transfer price DC DEC5
VPEIN Sales price unit DEC5
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
LIGEN Listing generation status LIGEN
ADGEN Additionals maintained CHAR1
EPRGR Price point group EPRGR
Master Data Relations Join Conditions
Promotion theme
  • WALE.MANDT == TWAT.MANDT
  • WALE.AKTHE == TWAT.AKTHE
Promotion
  • Promotion
  • Client
  • WALE.AKTNR == WAKH.AKTNR
  • WALE.MANDT == WAKH.MANDT
Material Number
  • Material Number
  • Client
  • WALE.ARTNR == MARA.MATNR
  • WALE.MANDT == MARA.MANDT
Announcement category - plant
  • WALE.MANDT == T626.MANDT
  • WALE.BEKTB == T626.AAVIT
Announcement category - distribution center
  • WALE.MANDT == T626.MANDT
  • WALE.BEKTV == T626.AAVIT
Internal Class Number
  • WALE.MANDT == KLAH.MANDT
  • WALE.CLINT == KLAH.CLINT
Purchasing Group
  • Purchasing Group
  • Client
  • WALE.EKGRP == T024.EKGRP
  • WALE.MANDT == T024.MANDT
Purchasing organization
  • WALE.MANDT == T024E.MANDT
  • WALE.EKORG == T024E.EKORG
External Supplier
  • WALE.MANDT == LFA1.MANDT
  • WALE.EXTLI == LFA1.LIFNR
Customer Number for Plant
  • WALE.MANDT == KNA1.MANDT
  • WALE.KUNNR == KNA1.KUNNR
Supplier Number
  • WALE.MANDT == LFA1.MANDT
  • WALE.LIFNR == LFA1.LIFNR
Client WALE.MANDT == T000.MANDT
Sales unit
  • WALE.MANDT == T006.MANDT
  • WALE.MEBME == T006.MSEHI
Order Price Unit (Purchasing)
  • WALE.MANDT == T006.MANDT
  • WALE.MEBPR == T006.MSEHI
Division
  • WALE.MANDT == TSPA.MANDT
  • WALE.SPART == TSPA.SPART
Sales unit
  • WALE.MANDT == T006.MANDT
  • WALE.VABGM == T006.MSEHI
Sales Organization
  • WALE.MANDT == TVKO.MANDT
  • WALE.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • WALE.VTWEG == TVTW.VTWEG
  • WALE.MANDT == TVTW.MANDT
Purchasing organization of distribution center
  • WALE.MANDT == T024E.MANDT
  • WALE.VZEKO == T024E.EKORG
Division of distribution center
  • WALE.MANDT == TSPA.MANDT
  • WALE.VZSPA == TSPA.SPART
Sales organization of distribution center
  • WALE.MANDT == TVKO.MANDT
  • WALE.VZVKO == TVKO.VKORG
Distribution channel of distribution center
  • Distribution channel of distribution center
  • Client
  • WALE.VZVTW == TVTW.VTWEG
  • WALE.MANDT == TVTW.MANDT
Plant Number for Supplier Number of DC
  • WALE.MANDT == T001W.MANDT
  • WALE.VZWRK == T001W.WERKS
Purchase price currency
  • WALE.MANDT == TCURC.MANDT
  • WALE.WAEEK == TCURC.WAERS
Currency Current Promotion - Planning
  • WALE.MANDT == TCURC.MANDT
  • WALE.WAELA == TCURC.WAERS