I_RetailPromotion

Retail Promotion | view: IRTLPROMN | TRAN | Extraction: Not supported | Component: Seasonal / Promotion Planning
Tables used: WAKH
Column Name Description
RetailPromotion Promotion
Column Name Description
💲 Currency Current Promotion - Planning (PromnPlnHdrCurrency):
PromnPlnTotalItemsPurchasePrc Detailed promotion plan, sales volume at purchase price
PromnPlnTotalItemsSalesPrice Detailed Promotion Plan Sales Volume at Promo. Sales Price
Column Name Description
Column Name Description
RetailPromotionSalesFromDate On Sale to Consumers From
RetailPromotionSalesToDate On Sale To Consumers To
PurPriceCndnStartDate Purchase price conditions valid from
PurPriceCndnEndDate Purchase price conditions valid to
RetailPromnHeaderBlockDate Promotion blocked on
CreationDate Date on which the record was created
LastChangeDate Last Changed On
Column Name Description
RetailPromotionIsRefPromotion Indicator: Higher-Level Promotion Show values
RetailPromotionCrtedByAppl Application that Created the Promotion Show values
RetailPromnBlockingReason Reason for promotion block Show values
SalesPriceActivationStatus Sales Price Activation Status Show values
PromotionAnnouncementStatus Promotion Announcement Status Show values
RtlPromnListingStatus Listing Status of the Promotion Show values
RtlPromnAllocTableStatus Allocation table status of the promotion Show values
PromotionProcessingStatus Processing status of the promotion Show values
Column Name Description Domain name
PromnPlnNumberOfArticles Detailed Promotion Plan, Number of Materials NUMC6
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Distribution Channel
  • Sales Organization
  • Distribution Channel
  • Client
  • I_RETAILPROMOTION.SALESORGANIZATION == TVKOV.VKORG
  • I_RETAILPROMOTION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_RETAILPROMOTION.MANDT == TVKOV.MANDT
Currency Current Promotion - Planning
  • Client
  • Currency Current Promotion - Planning
  • I_RETAILPROMOTION.MANDT == TCURC.MANDT
  • I_RETAILPROMOTION.PROMNPLNHDRCURRENCY == TCURC.WAERS
Purchasing Group
  • Purchasing Group
  • Client
  • I_RETAILPROMOTION.PURCHASINGGROUP == T024.EKGRP
  • I_RETAILPROMOTION.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_RETAILPROMOTION.PURCHASINGORGANIZATION == T024E.EKORG
  • I_RETAILPROMOTION.MANDT == T024E.MANDT
Promotion Category
  • Promotion Category
  • Client
  • I_RETAILPROMOTION.RETAILPROMOTIONCATEGORY == TWTY.AKTYP
  • I_RETAILPROMOTION.MANDT == TWTY.MANDT
Customer Type
  • Customer Type
  • Client
Promotion Number
  • Higher-Level Promotion
  • Client
  • I_RETAILPROMOTION.RETAILPROMOTIONREFPROMOTION == WAKH.AKTNR
  • I_RETAILPROMOTION.MANDT == WAKH.MANDT
Promotion Type
  • Promotion Type
  • Client
  • I_RETAILPROMOTION.RETAILPROMOTIONTYPE == TWAA.AKART
  • I_RETAILPROMOTION.MANDT == TWAA.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_RETAILPROMOTION.SALESORGANIZATION == TVKO.VKORG
  • I_RETAILPROMOTION.MANDT == TVKO.MANDT