P_RtlPromnItmStoreSlsUoM_F4674

Retail Promotion Items with Qty in Sales Unit | view: PRTLPRMSTSUF4674 | Extraction: Not supported | Component: In-Store Merchandise and Inventory Management - Fiori Apps
Tables used: WALEMARAT001WMARAMAW1MVKEMARMWAKPWAGU
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
Column Name Description
📏 Sales unit (SalesUnit):
PromnPlnItmStoreRequestedQty Quantity requested by store
RtlPromnPlndSalesQtyPerStore Planned Sales Qty. of Promotion Material in Sales Units
Column Name Description
Column Name Description
Column Name Description Domain name
Store Plant WERKS
Master Data Relations Join Conditions
Product Number
  • Client
  • Product Number
  • P_RTLPROMNITMSTORESLSUOM_F4674.MANDT == MARA.MANDT
  • P_RTLPROMNITMSTORESLSUOM_F4674.PRODUCT == MARA.MATNR
Promotion
  • Client
  • Promotion
  • P_RTLPROMNITMSTORESLSUOM_F4674.MANDT == WAKH.MANDT
  • P_RTLPROMNITMSTORESLSUOM_F4674.RETAILPROMOTION == WAKH.AKTNR
Sales unit
  • Client
  • Sales unit
  • P_RTLPROMNITMSTORESLSUOM_F4674.MANDT == T006.MANDT
  • P_RTLPROMNITMSTORESLSUOM_F4674.SALESQUANTITYUNIT == T006.MSEHI
Customer Number for Plant
  • Client
  • Customer Number for Plant
  • P_RTLPROMNITMSTORESLSUOM_F4674.MANDT == KNA1.MANDT
  • P_RTLPROMNITMSTORESLSUOM_F4674.STORECUSTOMER == KNA1.KUNNR
Internal Class Number
  • Internal Class Number
  • Client
  • P_RTLPROMNITMSTORESLSUOM_F4674.STOREGROUPINTERNALID == KLAH.CLINT
  • P_RTLPROMNITMSTORESLSUOM_F4674.MANDT == KLAH.MANDT