C_RetailPromotionObjPg

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 C_RetailPromotionObjPg.
-- 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: CRTLPROMNOBJPG

CREATE VIEW C_RetailPromotionObjPg AS
SELECT
  RetailPromotion,
  _Text[1:Language=$session.system_language].RetailPromotionName AS RetailPromotionName,
  RetailPromotionSalesFromDate,
  RetailPromotionSalesToDate,
  CreationDate,
  case when _CreatedByUser.UserID is null then CreatedByUser when _CreatedByUser.UserDescription = '' then _CreatedByUser.UserID else _CreatedByUser.UserDescription end as CreatedByUser AS UserDescriptionendasCreatedByUser,
  LastChangeDate,
  case when _LastChangedByUser.UserID is null then LastChangedByUser when _LastChangedByUser.UserDescription = '' then _LastChangedByUser.UserID else _LastChangedByUser.UserDescription end as LastChangedByUser AS UserDescriptionendasLastChangedByUser,
  cast('' as char80) AS PurPriceCndnPeriod,
  PurPriceCndnStartDate,
  PurPriceCndnEndDate,
  RetailPromotionType,
  cast(RetailPromotionIsRefPromotion as boolean preserving type) AS RetailPromotionIsRefPromotion,
  RetailPromotionCrtedByAppl,
  RetailPromotionRefPromotion,
  cast(rpad('',80,' ') as abap.sstring(80)) AS RtlPromnBlkgDateWthReasonName,
  RetailPromnHeaderBlockDate,
  RetailPromnBlockingReason,
  _RtlPromnBlockingReason._Text[1:Language=$session.system_language].RetailPromnBlockReasonName AS RetailPromnBlockReasonName,
  PromotionProcessingStatus,
  RtlPromnListingStatus,
  RtlPromnAllocTableStatus,
  PromotionAnnouncementStatus,
  SalesPriceActivationStatus,
  SalesOrganization,
  DistributionChannel,
  PurchasingOrganization,
  PurchasingGroup,
  PromnPlnTotalItemsPurchasePrc,
  PromnPlnHdrCurrency,
  PromnPlnTotalItemsSalesPrice,
  PromnPlnNumberOfArticles,
  _RtlPromnHeaderDiscount.RetailPromotionDiscountPercent AS RetailPromotionDiscountPercent,
  _RtlPromnHeaderDiscount.QuantityUnit AS QuantityUnit,
  _RtlPromnHeaderDiscount.RetailPromnDiscountAmount AS RetailPromnDiscountAmount,
  _RtlPromnHeaderDiscount.RetailPromnDiscountCurrency AS RetailPromnDiscountCurrency,
  _RtlPromnHeaderDiscount._Currency AS _Currency,
  _RtlPromnHeaderDiscount.RetailPromnDiscountUnit AS RetailPromnDiscountUnit,
  _RtlPromnHeaderDiscount.RetailPromotionDiscountStatus AS RetailPromotionDiscountStatus,
  _RtlPromnHeaderDiscount._RtlPromnDiscountStatus AS _RtlPromnDiscountStatus
FROM I_RetailPromotion
LEFT OUTER JOIN C_RetailPromotionItemObjPg AS _RetailPromotionItemObjPg ON RetailPromotion = _RetailPromotionItemObjPg.RetailPromotion  -- association [0..*]
LEFT OUTER JOIN C_RtlPromnSiteObjPg AS _RtlPromnSiteObjPg ON RetailPromotion = _RtlPromnSiteObjPg.RetailPromotion  -- association [0..*]
LEFT OUTER JOIN C_RtlPromnObjPgProdGrpDisc AS _RtlPromnObjPgProdGrpDisc ON RetailPromotion = _RtlPromnObjPgProdGrpDisc.RetailPromotion  -- association [0..*]
LEFT OUTER JOIN C_RtlPromnObjPgArticleHierDisc AS _RtlPromnObjPgArticleHierDisc ON RetailPromotion = _RtlPromnObjPgArticleHierDisc.RetailPromotion  -- association [0..*]
LEFT OUTER JOIN C_RtlPromnObjPgStoreGroup AS _RtlPromnObjPgStoreGroup ON RetailPromotion = _RtlPromnObjPgStoreGroup.RetailPromotion  -- association [0..*]
LEFT OUTER JOIN C_RtlPromnObjPgAllocationTable AS _RtlPromnObjPgAllocationTable ON RetailPromotion = _RtlPromnObjPgAllocationTable.RetailPromotion  -- association [0..*]
LEFT OUTER JOIN C_RtlPromnObjPgPurchaseOrder AS _RtlPromnObjPgPurchaseOrder ON RetailPromotion = _RtlPromnObjPgPurchaseOrder.RetailPromotion  -- association [0..*]
;