ESH_N_RETAILPROMOTION

DDL: ESH_N_RETAILPROMOTION SQL: ESH_L_RETAILPROM Type: view
30 Fields 1 Data Sources 2 Associations

ESH_N_RETAILPROMOTION is a CDS View in SAP S/4HANA. It reads from 1 data source (I_RETAILPROMOTION) and exposes 30 fields with key field RETAILPROMOTION. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RETAILPROMOTION I_RETAILPROMOTION from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (2)

CardinalityTargetAliasCondition
[0..*] dd07t _RTLPROMNPROCESSINGSTATUS $projection.PromotionProcessingStatus=_RTLPROMNPROCESSINGSTATUS.domvalue_l and _RTLPROMNPROCESSINGSTATUS.domname='AKVST' and _RTLPROMNPROCESSINGSTATUS.as4local='A'
[0..*] dd07t _RTLPROMNBLOCKINGREASON ( $projection.RetailPromnBlockingReason=_RTLPROMNBLOCKINGREASON.domvalue_l AND _RTLPROMNBLOCKINGREASON.domname='SPGRU' AND _RTLPROMNBLOCKINGREASON.as4local='A' )

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_RETAILPROM view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY RETAILPROMOTION RETAILPROMOTION Promotion
DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL RefDistCh-Cust/Mat.
DISTRIBUTIONCHANNELNAME
PRODUCT
PRODUCTNAME
PROMNPLNHDRCURRENCY PROMNPLNHDRCURRENCY Plnd crrncy
PROMNPLNTOTALITEMSPURCHASEPRC PROMNPLNTOTALITEMSPURCHASEPRC Sales at PP
PROMNPLNTOTALITEMSSALESPRICE PROMNPLNTOTALITEMSSALESPRICE Sales vol.at SP
PROMNPROCESSINGSTATUSNAME
PROMOTIONPROCESSINGSTATUS PROMOTIONPROCESSINGSTATUS Subseq. process
PROMOTIONSUPPLYINGSITE
PURCHASINGGROUP PURCHASINGGROUP Purchasing Group
PURCHASINGGROUPNAME _PURCHASINGGROUP PURCHASINGGROUPNAME Purchasing Grp. Name
PURCHASINGORGANIZATION PURCHASINGORGANIZATION Purchasing Organization
PURCHASINGORGANIZATIONNAME _PURCHASINGORGANIZATION PURCHASINGORGANIZATIONNAME Purch. Org. Name
RETAILPROMNBLOCKINGREASON RETAILPROMNBLOCKINGREASON Blocking reason
RETAILPROMNBLOCKREASONNAME
RETAILPROMNHEADERBLOCKDATE RETAILPROMNHEADERBLOCKDATE Pro.blocked on
RETAILPROMOTIONCATEGORY RETAILPROMOTIONCATEGORY Promotion Cat.
RETAILPROMOTIONCATEGORYNAME
RETAILPROMOTIONCUSTOMERTYPE RETAILPROMOTIONCUSTOMERTYPE Part. Type
RETAILPROMOTIONCUSTTYPEDESC
RETAILPROMOTIONNAME
RETAILPROMOTIONSALESFROMDATE RETAILPROMOTIONSALESFROMDATE On sale from
RETAILPROMOTIONSALESTODATE RETAILPROMOTIONSALESTODATE to
RETAILPROMOTIONTYPE RETAILPROMOTIONTYPE Promotion Type
RETAILPROMOTIONTYPENAME
SALESORGANIZATION SALESORGANIZATION Sales Organization
SALESORGANIZATIONNAME
SUPPLYINGSITENAME

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ESH_N_RETAILPROMOTION.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ESH_L_RETAILPROM
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_RETAILPROMOTION AS
SELECT
  RETAILPROMOTION,
  DISTRIBUTIONCHANNEL,
  _DISTRIBUTIONCHANNEL._TEXT[1: LANGUAGE = $parameters. P_Language].DISTRIBUTIONCHANNELNAME AS DISTRIBUTIONCHANNELNAME,
  _RETAILPROMOTIONITEM._PRODUCT.PRODUCT AS PRODUCT,
  _RETAILPROMOTIONITEM._PRODUCT._TEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTNAME AS PRODUCTNAME,
  PROMNPLNHDRCURRENCY,
  PROMNPLNTOTALITEMSPURCHASEPRC,
  PROMNPLNTOTALITEMSSALESPRICE,
  _RTLPROMNPROCESSINGSTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS PROMNPROCESSINGSTATUSNAME,
  PROMOTIONPROCESSINGSTATUS,
  _RETAILPROMOTIONITEM._RETAILPROMOTIONITEMSTORE.PROMOTIONSUPPLYINGSITE AS PROMOTIONSUPPLYINGSITE,
  PURCHASINGGROUP,
  _PURCHASINGGROUP.PURCHASINGGROUPNAME AS PURCHASINGGROUPNAME,
  PURCHASINGORGANIZATION,
  _PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS PURCHASINGORGANIZATIONNAME,
  RETAILPROMNBLOCKINGREASON,
  _RTLPROMNBLOCKINGREASON[1: ddlanguage = $parameters. P_Language].ddtext AS RETAILPROMNBLOCKREASONNAME,
  RETAILPROMNHEADERBLOCKDATE,
  RETAILPROMOTIONCATEGORY,
  _RETAILPROMOTIONCATEGORY._TEXT[1: LANGUAGE = $parameters. P_Language].RETAILPROMOTIONCATEGORYNAME AS RETAILPROMOTIONCATEGORYNAME,
  RETAILPROMOTIONCUSTOMERTYPE,
  _RETAILPROMOTIONCUSTOMERTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].RETAILPROMOTIONCUSTTYPEDESC AS RETAILPROMOTIONCUSTTYPEDESC,
  _TEXT[1: LANGUAGE = $parameters. P_Language].RETAILPROMOTIONNAME AS RETAILPROMOTIONNAME,
  RETAILPROMOTIONSALESFROMDATE,
  RETAILPROMOTIONSALESTODATE,
  RETAILPROMOTIONTYPE,
  _RETAILPROMOTIONTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].RETAILPROMOTIONTYPENAME AS RETAILPROMOTIONTYPENAME,
  SALESORGANIZATION,
  _SALESORGANIZATION._TEXT[1: LANGUAGE = $parameters. P_Language].SALESORGANIZATIONNAME AS SALESORGANIZATIONNAME,
  _RETAILPROMOTIONITEM._RETAILPROMOTIONITEMSTORE._SUPPLYINGSITE.SITENAME AS SUPPLYINGSITENAME
FROM I_RETAILPROMOTION
LEFT OUTER JOIN dd07t AS _RTLPROMNPROCESSINGSTATUS ON PromotionProcessingStatus=_RTLPROMNPROCESSINGSTATUS.domvalue_l AND _RTLPROMNPROCESSINGSTATUS.domname='AKVST' AND _RTLPROMNPROCESSINGSTATUS.as4local='A'  -- association [0..*]
LEFT OUTER JOIN dd07t AS _RTLPROMNBLOCKINGREASON ON ( RetailPromnBlockingReason=_RTLPROMNBLOCKINGREASON.domvalue_l AND _RTLPROMNBLOCKINGREASON.domname='SPGRU' AND _RTLPROMNBLOCKINGREASON.as4local='A' )  -- association [0..*]
;

Learn More