I_Mkt_LeadInterestsCube

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_Mkt_LeadInterestsCube.
-- 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: IMKT_LEADINTC
-- Parameters: P_EndDate : cuan_end_date

CREATE VIEW I_Mkt_LeadInterestsCube AS
SELECT
  Interaction.Interaction AS Interaction,
  Interests.CampaignInterest AS CampaignInterest,
  Interaction.MarketingArea AS MarketingArea,
  Interaction.InteractionMarketingArea AS InteractionMarketingArea,
  Interaction.CampaignID AS CampaignID,
  Interaction.CampaignName AS CampaignName,
  Interaction.InteractionCreationUTCDate AS InteractionCreationUTCDate,
  _MKT_CalendarDate.CalendarMonth AS CalendarMonth,
  _MKT_CalendarDate.CalendarYear AS CalendarYear,
  _MKT_CalendarDate.CalendarDate AS CalendarDate,
  _MKT_CalendarDate.CalendarQuarter AS CalendarQuarter,
  _MKT_CalendarDate.CalendarWeek AS CalendarWeek,
  Interaction.InteractionContact AS InteractionContact,
  cast(_MKT_ContactRelation.InteractionContact as cuan_cds_company) AS Company,
  Interaction._Mkt_Contact.Country AS Country,
  Interaction._Mkt_Contact.Industry AS Industry,
  Interaction._Mkt_Contact.CompanyName AS CompanyName,
  cast(cast (1 as abap.int4(10) ) as cuan_numberofleads) AS NumberOfLeads,
  _MKT_CalendarDate._MKT_CalendarMonth AS _MKT_CalendarMonth,
  _Mkt_Contact._MKT_Country AS _MKT_Country,
  _Mkt_Contact._MKT_Industry AS _MKT_Industry,
  Interaction._Mkt_Initiative AS _Mkt_Initiative
FROM P_MKT_LeadsOppsCube
LEFT OUTER JOIN I_MKT_CampaignInterest AS Interests ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MKT_CalendarDate AS _MKT_CalendarDate ON InteractionCreationUTCDate = _MKT_CalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_MKT_Interest AS _MKT_Interest ON CampaignInterest = _MKT_Interest.ItemOfInterest  -- association [0..1]
LEFT OUTER JOIN I_MKT_ContactRelation AS _MKT_ContactRelation ON InteractionContact = _MKT_ContactRelation.Person  -- association [0..1]
LEFT OUTER JOIN I_Mkt_Contact AS _MKT_Company ON Company = _MKT_Company.InteractionContact  -- association [0..1]
;