I_MKT_CampaignByStatus

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_CampaignByStatus.
-- 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_CMPGNSTAT
-- Parameters: P_StartDate : cuan_start_date, P_EndDate : cuan_end_date

CREATE VIEW I_MKT_CampaignByStatus AS
SELECT
  cube.Campaign AS Campaign,
  cube.CampaignCategory AS CampaignCategory,
  cube.CampaignEndDate AS CampaignEndDate,
  cube.CampaignID AS CampaignID,
  cube.CampaignLifecycleStatus AS CampaignLifecycleStatus,
  cube.CampaignName AS CampaignName,
  cube.CampaignOwner AS CampaignOwner,
  cube.CampaignPriority AS CampaignPriority,
  cube.CampaignProcessType AS CampaignProcessType,
  cube.CampaignStartDate AS CampaignStartDate,
  cube.CommunicationCategoryUUID AS CommunicationCategoryUUID,
  cube.MarketingArea AS MarketingArea,
  cube.MarketingProgram AS MarketingProgram,
  cube._MKT_Program.MarketingProgramName AS MarketingProgramName,
  cube.MediaType AS MediaType,
  cube._MKT_CampaignCategory AS _MKT_CampaignCategory,
  cube._MKT_CampaignOwner AS _MKT_CampaignOwner,
  cube._MKT_CampaignPlanCoordinate AS _MKT_CampaignPlanCoordinate,
  cube._MKT_CampaignPriority AS _MKT_CampaignPriority,
  cube._MKT_CampaignProcessType AS _MKT_CampaignProcessType,
  cube._MKT_CommunicationCategory AS _MKT_CommunicationCategory,
  cube._MKT_MarketingArea AS _MKT_MarketingArea,
  cube._MKT_MediaType AS _MKT_MediaType,
  cube._MKT_Program AS _MKT_Program,
  cube._MKT_User AS _MKT_User,
  cast ( 1 as cuan_numberofcampaigns ) AS NumberOfCampaigns
FROM I_Mkt_Initiative AS cube
LEFT OUTER JOIN I_MKT_CampaignLifeCycleStatus AS _MKT_CampaignLifeCycleStatus ON CampaignLifecycleStatus = _MKT_CampaignLifeCycleStatus.CampaignLifecycleStatus  -- association [1..1]
;