I_RetailPromotionItemStore

Retail Promotion Item Store | view: IRTLPROMNITMSTRE | TRAN | Extraction: Not supported | Component: Seasonal / Promotion Planning
Tables used: WALEWAKPWAGU
Column Name Description
RetailPromotion FK Promotion
Product FK Product Number
SalesQuantityUnit FK Sales unit
StoreCustomer FK Customer Number for Plant
StoreGroupInternalID FK Internal Class Number
Column Name Description
💲 Currency Current Promotion - Planning (PromnPlnItmStoreCurrency):
PromnPlnItmStoreSalesPrice Sales price for promotion item
Column Name Description
📏 Sales unit (SalesQuantityUnit):
PromnPlnItmStoreRequestedQty Quantity requested by store
PromnPlnItmStoreConfdQty Corrected/confirmed allocation quantity for a promotion item
PromnPlnItmSalesQuantity Planned Sales Qty. of Promotion Material in Sales Units
Column Name Description
RtlPromnLatestPossibleGRDate Goods receipt promotional merchandise in plant
Column Name Description
LocHasRepliedToAnnouncement Status of reply to announcement - plant Show values
RtlPromnItmStoreAnncmntSts Detailed status of promotion announcement - plant Show values
IsRegularSupplier Regular Supplier Show values
Column Name Description Domain name
RtlPromotionItemSalesPriceQty Sales price unit DEC5
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • I_RETAILPROMOTIONITEMSTORE.MANDT == TVTW.MANDT
  • I_RETAILPROMOTIONITEMSTORE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Product Number
  • Client
  • Product Number
  • I_RETAILPROMOTIONITEMSTORE.MANDT == MARA.MANDT
  • I_RETAILPROMOTIONITEMSTORE.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_RETAILPROMOTIONITEMSTORE.MANDT == T023.MANDT
  • I_RETAILPROMOTIONITEMSTORE.PRODUCTGROUP == T023.MATKL
Currency Current Promotion - Planning
  • Client
  • Currency Current Promotion - Planning
  • I_RETAILPROMOTIONITEMSTORE.MANDT == TCURC.MANDT
  • I_RETAILPROMOTIONITEMSTORE.PROMNPLNITMSTORECURRENCY == TCURC.WAERS
Plant Number for Supplier Number of DC
  • Client
  • Plant Number for Supplier Number of DC
  • I_RETAILPROMOTIONITEMSTORE.MANDT == T001W.MANDT
  • I_RETAILPROMOTIONITEMSTORE.PROMOTIONSUPPLYINGSITE == T001W.WERKS
Promotion
  • Client
  • Promotion
  • I_RETAILPROMOTIONITEMSTORE.MANDT == WAKH.MANDT
  • I_RETAILPROMOTIONITEMSTORE.RETAILPROMOTION == WAKH.AKTNR
Sales Organization
  • Client
  • Sales Organization
  • I_RETAILPROMOTIONITEMSTORE.MANDT == TVKO.MANDT
  • I_RETAILPROMOTIONITEMSTORE.SALESORGANIZATION == TVKO.VKORG
Sales unit
  • Sales unit
  • Client
  • I_RETAILPROMOTIONITEMSTORE.SALESQUANTITYUNIT == T006.MSEHI
  • I_RETAILPROMOTIONITEMSTORE.MANDT == T006.MANDT
Customer Number for Plant
  • Customer Number for Plant
  • Client
  • I_RETAILPROMOTIONITEMSTORE.STORECUSTOMER == KNA1.KUNNR
  • I_RETAILPROMOTIONITEMSTORE.MANDT == KNA1.MANDT
Internal Class Number
  • Client
  • Internal Class Number
  • I_RETAILPROMOTIONITEMSTORE.MANDT == KLAH.MANDT
  • I_RETAILPROMOTIONITEMSTORE.STOREGROUPINTERNALID == KLAH.CLINT
Supplier Number
  • Client
  • Supplier Number
  • I_RETAILPROMOTIONITEMSTORE.MANDT == LFA1.MANDT
  • I_RETAILPROMOTIONITEMSTORE.SUPPLIER == LFA1.LIFNR