C_MKT_MktgCntntPlugInOffer

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_MKT_MktgCntntPlugInOffer.
-- 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: CMKTCNTPIOFFER

CREATE VIEW C_MKT_MktgCntntPlugInOffer AS
SELECT
  OfferContent.MarketingOfferContentUUID AS MarketingOfferContentUUID,
  OfferContent.MarketingOfferUUID AS MarketingOfferUUID,
  OfferContent.MarketingOfferContent AS MarketingOfferContent,
  cast(OfferContent._Offer.MarketingOffer as cuan_ofm_offer_id_int preserving type) AS MarketingOffer,
  OfferContent.CommunicationMedium AS CommunicationMedium,
  OfferContent._CommunicationMedium._Text[1: Language = $session.system_language].CommunicationMediumName AS CommunicationMediumName,
  OfferContent.OfferContentType AS OfferContentType,
  OfferContent._OfferContentType._OfferContentTypeText[1: Language = $session.system_language].OfferContentTypeName AS OfferContentTypeName,
  OfferContent.LanguageISOCode AS LanguageISOCode,
  OfferContent._Language.LanguageName AS LanguageName,
  OfferContent.OfferContentPosition AS OfferContentPosition,
  OfferContent.MarketingArea AS MarketingArea,
  OfferToCoupon._Offer._MarketingArea._Text[1: Language = $session.system_language].MarketingAreaName AS MarketingAreaName,
  OfferContent._Offer.OfferName AS OfferName,
  OfferContent._Offer.OfferStatus AS OfferStatus,
  cast(OfferContent._Offer.OfferStartDate as cuan_ofm_offer_start_dats) AS OfferStartDate,
  cast(OfferContent._Offer.OfferEndDate as cuan_ofm_offer_end_dats) AS OfferEndDate,
  cast( tstmp_to_tims(OfferContent._Offer.OfferStartDateTime, 'UTC', $session.client, 'INITIAL') as cuan_ofm_offer_start_time ) AS OfferStartTime,
  cast( tstmp_to_tims(OfferContent._Offer.OfferEndDateTime, 'UTC', $session.client, 'INITIAL') as cuan_ofm_offer_end_time ) AS OfferEndTime,
  cast(OfferContent._Offer.OfferStartDateTime as cuan_ofm_offer_start_tstmp) AS OfferStartDateTime,
  OfferContent.OfferContentSourceURL AS OfferContentSourceURL,
  OfferContent.OfferContentSourceURLDesc AS OfferContentSourceURLDesc,
  OfferContent.OfferContentTargetURL AS OfferContentTargetURL,
  OfferContent.OfferContentTargetURLDesc AS OfferContentTargetURLDesc,
  OfferContent._Offer.OfferDescription AS OfferDescription,
  OfferContent._Offer.ExternalOfferStatus AS ExternalOfferStatus,
  OfferContent._Offer.CouponUUID AS CouponUUID,
  _Coupon.Coupon AS Coupon,
  _Coupon._CouponText[1: Language = $session.system_language].CouponDescription AS CouponDescription,
  _Coupon._CouponText[1: Language = $session.system_language].CouponName AS CouponName,
  _Coupon.CouponType AS CouponType,
  _Coupon.TotalNumberOfRedemption AS TotalNumberOfRedemption,
  CouponCode.EANCodeImageURL AS EANCodeImageURL,
  CouponCode.CouponCode AS CouponCode,
  CouponCode.CouponCodeUUID AS CouponCodeUUID,
  CouponCode.QRCodeImageURL AS QRCodeImageURL,
  CouponCode.CouponCodeSerialNumber AS CouponCodeSerialNumber,
  CouponCode._CouponCodeUsage.ValidityEndDateTime AS ValidityEndDateTime,
  cast( tstmp_to_dats(CouponCode._CouponCodeUsage.ValidityEndDateTime, 'UTC', $session.client, 'INITIAL') as cuan_cpn_code_validity_end_dat ) AS ValidityEndDate,
  cast( tstmp_to_tims(CouponCode._CouponCodeUsage.ValidityEndDateTime, 'UTC', $session.client, 'INITIAL') as cuan_cpn_code_validity_end_tim ) AS ValidityEndTime,
  CouponCode._CouponCodeUsage.ValidityStartDateTime AS ValidityStartDateTime,
  cast( tstmp_to_dats(CouponCode._CouponCodeUsage.ValidityStartDateTime, 'UTC', $session.client, 'INITIAL') as cuan_cpn_code_validity_start_d ) AS ValidityStartDate,
  cast( tstmp_to_tims(CouponCode._CouponCodeUsage.ValidityStartDateTime, 'UTC', $session.client, 'INITIAL') as cuan_cpn_code_validity_start_t ) AS ValidityStartTime,
  OfferContent._CommunicationMedium AS _CommunicationMedium
FROM I_MKT_OfferContent AS OfferContent
LEFT OUTER JOIN I_MKT_CouponTP AS _Coupon ON OfferToCoupon.CouponUUID = _Coupon.CouponUUID  -- association [0..1]
LEFT OUTER JOIN E_Mkt_Offer_Content AS _ExtensionOfferContent ON MarketingOfferContentUUID = _ExtensionOfferContent.MarketingOfferContent  -- association [1..1]
LEFT OUTER JOIN E_MKT_OFFER_ROOT AS _ExtensionOffer ON MarketingOfferUUID = _ExtensionOffer.MarketingOffer  -- association [1..1]
LEFT OUTER JOIN E_MKT_CouponCode AS _ExtensionCouponCode ON CouponCodeUUID = _ExtensionCouponCode.CouponCodeUUID  -- association [1..1]
;