C_MKT_CampaignOverview

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_CampaignOverview.
-- 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: CMKTCPGNOVP

CREATE VIEW C_MKT_CampaignOverview AS
SELECT
  Campaign AS CampaignUUID,
  CampaignID,
  _MKT_CampaignTM.UserID AS UserID,
  CampaignStartDate,
  _MKT_camp.CampaignCategory AS CampaignCategory,
  CampaignName,
  MarketingArea,
  CampaignLifecycleStatus,
  MediaType,
  CampaignLastChgdDateTime,
  CampaignProcessType,
  cast('' as char255 ) AS CampaignIconURL,
  case when CampaignStartDate < $session.system_date and CampaignLifecycleStatus <> '2' then '1' when CampaignStartDate = $session.system_date then '2' when CampaignStartDate = DATS_ADD_DAYS(cast($session.system_date as abap.dats),1,'INITIAL') then '3' when CampaignStartDate > DATS_ADD_DAYS(cast($session.system_date as abap.dats),1,'INITIAL') and CampaignStartDate < DATS_ADD_DAYS(cast(_MKT_CalendarDate.FirstDayOfWeekDate as abap.dats),7,'INITIAL') then '4' when CampaignStartDate >= DATS_ADD_DAYS(cast(_MKT_CalendarDate.FirstDayOfWeekDate as abap.dats),7,'INITIAL')and CampaignStartDate < DATS_ADD_DAYS(cast(_MKT_CalendarDate.FirstDayOfWeekDate as abap.dats),14,'INITIAL') then '5' when CampaignStartDate >= DATS_ADD_DAYS(cast(_MKT_CalendarDate.LastDayOfMonthDate as abap.dats),1,'INITIAL') and CampaignStartDate < DATS_ADD_months(cast(_MKT_CalendarDate.FirstDayOfMonthDate as abap.dats),2,'FAIL') then '7' when CampaignStartDate >= DATS_ADD_months(cast(_MKT_CalendarDate.FirstDayOfMonthDate as abap.dats),2,'FAIL') and CampaignStartDate < DATS_ADD_months(cast(_MKT_CalendarDate.FirstDayOfMonthDate as abap.dats),4,'FAIL') then '8' when CampaignStartDate >= DATS_ADD_months(cast(_MKT_CalendarDate.FirstDayOfMonthDate as abap.dats),4,'FAIL') and CampaignStartDate < DATS_ADD_months(cast(_MKT_CalendarDate.FirstDayOfMonthDate as abap.dats),7,'FAIL') then '9' else '0' end as CalendarDate AS dats7FAILthen9else0endasCalendarDate
FROM I_Mkt_Initiative AS _MKT_camp
LEFT OUTER JOIN I_MKT_CalendarDate AS _MKT_CalendarDate ON _MKT_CalendarDate.CalendarDate = $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignLifeCycleStsText AS _Life_cycleText ON _MKT_camp.CampaignLifecycleStatus = _Life_cycleText.CampaignLifecycleStatus AND _Life_cycleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MKT_MediaTypeText AS _MediaTypeText ON _MKT_camp.MediaType = _MediaTypeText.MediaType AND _MediaTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MKT_MarketingAreaText AS _MKT_MarketingAreaText ON MarketingArea = _MKT_MarketingAreaText.MarketingArea AND _MKT_MarketingAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignTeamMember AS _MKT_CampaignTM ON CampaignUUID = _MKT_CampaignTM.Campaign AND _MKT_CampaignTM.UserID = $session.user  -- association [0..1]
;