WAEL

Delivery Phases in Retail 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
LWNUM Serial number
Column Name Description
Column Name Description
📏 Sales unit (MEBME):
AUFME Corrected/confirmed allocation quantity for a promotion item
WMNGE Quantity requested by store
PAUFME Planned allocation quantity for promotion item for a plant
PABBM Planned Sales Qty. of Promotion Material in Sales Units
Column Name Description
WEDAT Delivery date
WEUZT Delivery Date Time-Spot
Column Name Description
WETYP Date type (day, week, month, interval) Show values
WEPRZ Delivery phase in percent of total qty Show values
VLFKZ Plant category Show values
RUSTB Status of reply to announcement - plant Show values
Column Name Description Domain name
WERKS Plant in SAP Retail (store/DC) WERKS
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • WAEL.AKTNR == WAKH.AKTNR
  • WAEL.MANDT == WAKH.MANDT
Material Number
  • Material Number
  • Client
  • WAEL.ARTNR == MARA.MATNR
  • WAEL.MANDT == MARA.MANDT
Customer Number for Plant
  • WAEL.MANDT == KNA1.MANDT
  • WAEL.KUNNR == KNA1.KUNNR
Client WAEL.MANDT == T000.MANDT
Sales unit
  • WAEL.MANDT == T006.MANDT
  • WAEL.MEBME == T006.MSEHI