I_RetailPromotionItem

Retail Promotion Item | view: IRTLPROMNITEM | TRAN | Extraction: Not supported | Component: Seasonal / Promotion Planning
Tables used: WAKP
Column Name Description
RetailPromotion FK Promotion
Product FK Product Number
SalesQuantityUnit FK Sales unit
Column Name Description
💲 Currency Current Promotion - Planning (PromnPlnItmCurrency):
PromnPlnItmSalesPrice Sales price for promotion item
RetailPromnDiscountAmount Value of Absolute Discount
PromnPlnItmTotalQtyPurPrice Promotion plan: mat. sales at PP in sales currency
💲 Purchase price currency (PromnPlnItmPurchaseCurrency):
PromnPlnItmPurchasePrice Purchase price for promotion item
PromnPlnItmTotalQtySalesPrice Promotion Plan Mat. Sales Vol. at Promo. Sales Price
Column Name Description
📏 Sales unit (SalesQuantityUnit):
PromnPlnItmSalesQuantity Planned Sales Qty. of Promotion Material in Sales Units
Column Name Description
RetailPromnItemBlockDate Date on which promotion material is blocked for promotion
RetailPromotionSalesFromDate Sales prices active from
RetailPromotionSalesToDate Sales price active to
CreationDate Date on which the record was created
LastChangeDate Last Changed On
Column Name Description
RetailPromotionDiscountStatus Discount Status Show values
PrcWithoutPrcCalcIsActive Price Activation w/o Price Calculation Show values
RetailPromnBlockingReason Reason for promotion block Show values
Column Name Description Domain name
RetailPromotionItem Promotion Item Number NUMC6
RtlPromotionItemSalesPriceQty Sales price unit DEC5
RetailPromotionDiscountPercent Percentage Discount REB_PERC
NmbrOfRtlPromnItmPriceActvtn No. of successful price activations INT1
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Product Number
  • Client
  • Product Number
  • I_RETAILPROMOTIONITEM.MANDT == MARA.MANDT
  • I_RETAILPROMOTIONITEM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
xx
  • Client
  • Product Number
  • I_RETAILPROMOTIONITEM.MANDT == MARA.MANDT
  • I_RETAILPROMOTIONITEM.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_RETAILPROMOTIONITEM.MANDT == T023.MANDT
  • I_RETAILPROMOTIONITEM.PRODUCTGROUP == T023.MATKL
Currency Current Promotion - Planning
  • Client
  • Currency Current Promotion - Planning
  • I_RETAILPROMOTIONITEM.MANDT == TCURC.MANDT
  • I_RETAILPROMOTIONITEM.PROMNPLNITMCURRENCY == TCURC.WAERS
Purchase price currency
  • Client
  • Purchase price currency
  • I_RETAILPROMOTIONITEM.MANDT == TCURC.MANDT
  • I_RETAILPROMOTIONITEM.PROMNPLNITMPURCHASECURRENCY == TCURC.WAERS
Promotion
  • Promotion
  • Client
  • I_RETAILPROMOTIONITEM.RETAILPROMOTION == WAKH.AKTNR
  • I_RETAILPROMOTIONITEM.MANDT == WAKH.MANDT
Sales unit
  • Client
  • Sales unit
  • I_RETAILPROMOTIONITEM.MANDT == T006.MANDT
  • I_RETAILPROMOTIONITEM.SALESQUANTITYUNIT == T006.MSEHI