ESH_N_RETAILPROMOTION

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