ESH_S_RETAILPROMOTION

Search view -RETAILPROMOTION | view: ESH_U_RETAILPROM | Extraction: Not supported | Component: Seasonal / Promotion Planning
Column Name Description
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
RETAILPROMNHEADERBLOCKDATE Promotion blocked on
RETAILPROMOTIONSALESFROMDATE On Sale to Consumers From
RETAILPROMOTIONSALESTODATE On Sale To Consumers To
Column Name Description
Column Name Description Domain name
DISTRIBUTIONCHANNELNAME Distribution Channel Description
PRODUCT Product Number MATNR
PRODUCTNAME Product Description TEXT40
PROMNPROCESSINGSTATUSNAME Short Text for Fixed Values
PROMOTIONPROCESSINGSTATUS Processing status of the promotion
PURCHASINGGROUPNAME Purchasing Group Name
PURCHASINGORGANIZATIONNAME Purchasing Organization Name
RETAILPROMNBLOCKINGREASON Reason for promotion block
RETAILPROMNBLOCKREASONNAME Short Text for Fixed Values DDTEXT
RETAILPROMOTION Promotion WAKTION
RETAILPROMOTIONCATEGORYNAME Description
RETAILPROMOTIONCUSTTYPEDESC Description TEXT20
RETAILPROMOTIONNAME Promotion Description TEXT40
RETAILPROMOTIONTYPENAME Description
SALESORGANIZATIONNAME Sales Organization Description
SUPPLYINGSITENAME Site Name
Master Data Relations Join Conditions
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • ESH_S_RETAILPROMOTION.SALESORGANIZATION == TVKOV.VKORG
  • ESH_S_RETAILPROMOTION.MANDT == TVKOV.MANDT
  • ESH_S_RETAILPROMOTION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Currency Current Promotion - Planning
  • Currency Current Promotion - Planning
  • Client
  • ESH_S_RETAILPROMOTION.PROMNPLNHDRCURRENCY == TCURC.WAERS
  • ESH_S_RETAILPROMOTION.MANDT == TCURC.MANDT
Plant Number for Supplier Number of DC
  • Client
  • Plant Number for Supplier Number of DC
  • ESH_S_RETAILPROMOTION.MANDT == T001W.MANDT
  • ESH_S_RETAILPROMOTION.PROMOTIONSUPPLYINGSITE == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_S_RETAILPROMOTION.PURCHASINGGROUP == T024.EKGRP
  • ESH_S_RETAILPROMOTION.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • ESH_S_RETAILPROMOTION.PURCHASINGORGANIZATION == T024E.EKORG
  • ESH_S_RETAILPROMOTION.MANDT == T024E.MANDT
Promotion Category
  • Promotion Category
  • Client
  • ESH_S_RETAILPROMOTION.RETAILPROMOTIONCATEGORY == TWTY.AKTYP
  • ESH_S_RETAILPROMOTION.MANDT == TWTY.MANDT
Customer Type
  • Customer Type
  • Client
Promotion Type
  • Promotion Type
  • Client
  • ESH_S_RETAILPROMOTION.RETAILPROMOTIONTYPE == TWAA.AKART
  • ESH_S_RETAILPROMOTION.MANDT == TWAA.MANDT
Sales Organization
  • Sales Organization
  • Client
  • ESH_S_RETAILPROMOTION.SALESORGANIZATION == TVKO.VKORG
  • ESH_S_RETAILPROMOTION.MANDT == TVKO.MANDT