I_RetailPromotion

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 I_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.

CREATE VIEW I_RetailPromotion AS
SELECT
  aktnr AS RetailPromotion,
  vkdab AS RetailPromotionSalesFromDate,
  vkdbi AS RetailPromotionSalesToDate,
  ekdab AS PurPriceCndnStartDate,
  ekdbi AS PurPriceCndnEndDate,
  akart AS RetailPromotionType,
  is_ref_promo AS RetailPromotionIsRefPromotion,
  erappl AS RetailPromotionCrtedByAppl,
  spdab AS RetailPromnHeaderBlockDate,
  spgru AS RetailPromnBlockingReason,
  ref_promo AS RetailPromotionRefPromotion,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  ekorg AS PurchasingOrganization,
  ekgrp AS PurchasingGroup,
  aktyp AS RetailPromotionCategory,
  customer_type AS RetailPromotionCustomerType,
  cast(vkgst as salespriceactivationstatus preserving type ) AS SalesPriceActivationStatus,
  cast(bekst as promotionannouncementstatus preserving type ) AS PromotionAnnouncementStatus,
  akbst AS RtlPromnListingStatus,
  akast AS RtlPromnAllocTableStatus,
  akvst AS PromotionProcessingStatus,
  waela AS PromnPlnHdrCurrency,
  pduep AS PromnPlnTotalItemsPurchasePrc,
  pduvp AS PromnPlnTotalItemsSalesPrice,
  pdanz AS PromnPlnNumberOfArticles,
  erdat AS CreationDate,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aenam AS LastChangedByUser
FROM wakh
LEFT OUTER JOIN I_RetailPromotionT AS _Text ON RetailPromotion = _Text.RetailPromotion  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_RtlPromotionAnnouncementSts AS _RtlPromotionAnnouncementSts ON PromotionAnnouncementStatus = _RtlPromotionAnnouncementSts.PromotionAnnouncementStatus  -- association [1..1]
LEFT OUTER JOIN I_RtlPromnSalesPriceActvtnSts AS _RtlPromnSalesPriceActvtnSts ON SalesPriceActivationStatus = _RtlPromnSalesPriceActvtnSts.SalesPriceActivationStatus  -- association [1..1]
LEFT OUTER JOIN I_RetailPromotionType AS _RetailPromotionType ON RetailPromotionType = _RetailPromotionType.RetailPromotionType  -- association [1..1]
LEFT OUTER JOIN I_RtlPromnCrtedByAppl AS _RtlPromnCrtedByAppl ON RetailPromotionCrtedByAppl = _RtlPromnCrtedByAppl.RetailPromotionCrtedByAppl  -- association [1..1]
LEFT OUTER JOIN I_RtlPromnBlockingReason AS _RtlPromnBlockingReason ON RetailPromnBlockingReason = _RtlPromnBlockingReason.RetailPromnBlockingReason  -- association [1..1]
LEFT OUTER JOIN I_RtlPromnProcessingStatus AS _RtlPromnProcessingStatus ON PromotionProcessingStatus = _RtlPromnProcessingStatus.PromotionProcessingStatus  -- association [1..1]
LEFT OUTER JOIN I_RtlPromnLstgStatus AS _RtlPromnLstgStatus ON RtlPromnListingStatus = _RtlPromnLstgStatus.RtlPromnListingStatus  -- association [1..1]
LEFT OUTER JOIN I_RtlPromnAllocTblStatus AS _RtlPromnAllocTblStatus ON RtlPromnAllocTableStatus = _RtlPromnAllocTblStatus.RtlPromnAllocTableStatus  -- association [1..1]
LEFT OUTER JOIN I_RetailPromotionDiscount AS _RtlPromnHeaderDiscount ON RetailPromotion = _RtlPromnHeaderDiscount.RetailPromotion AND _RtlPromnHeaderDiscount.RetailPromnDiscountLevel = '05'  -- association [0..1]
LEFT OUTER JOIN I_RetailPromotionItem AS _RetailPromotionItem ON RetailPromotion = _RetailPromotionItem.RetailPromotion  -- association [0..*]
LEFT OUTER JOIN I_RetailPromotionDiscount AS _RetailPromotionDiscount ON RetailPromotion = _RetailPromotionDiscount.RetailPromotion  -- association [0..*]
LEFT OUTER JOIN I_RetailPromotionCategory AS _RetailPromotionCategory ON RetailPromotionCategory = _RetailPromotionCategory.RetailPromotionCategory  -- association [0..1]
LEFT OUTER JOIN I_RetailPromotionCustomerType AS _RetailPromotionCustomerType ON RetailPromotionCustomerType = _RetailPromotionCustomerType.RetailPromotionCustomerType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PromnPlnHdrCurrency ON PromnPlnHdrCurrency = _PromnPlnHdrCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;