I_MKT_CampaignAllVersions

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_CampaignAllVersions.
-- 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_CPGALL

CREATE VIEW I_MKT_CampaignAllVersions AS
SELECT
  Campaign,
  MktgObjVersHdrUUID,
  CampaignIsVersion,
  CampaignID,
  CampaignName,
  CampaignDescription,
  CampaignCategory,
  MarketingArea,
  MarketingProgram,
  MarketingProgramPhaseUUID,
  CampaignProcessType,
  CommunicationCategoryUUID,
  CampaignCreatedByUser,
  CampaignLastChgdByUser,
  CampaignCreationDateTime,
  CampaignLastChgdDateTime,
  CampaignScheduleDateTime,
  CampaignExecutionFrqcyInterval,
  CampaignExecutionFrqcyUnitName,
  ExportDefinition,
  CampaignOwner,
  CampaignLifecycleStatus,
  CampaignStartDate,
  CampaignEndDate,
  MediaType,
  CampaignPriority,
  CampaignTimeZone,
  CampaignPerfUpdateStatus
FROM P_MKT_CampaignAllVersions AS cpg_live_and_version
LEFT OUTER JOIN E_MKT_INITIATIVE AS _Extension ON Campaign = _Extension.Campaign  -- association [0..1]
LEFT OUTER JOIN E_MKT_CampaignVersion AS _VersionExtension ON Campaign = _VersionExtension.Campaign  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignAllVersionsOwner AS _MKT_CampaignOwner ON Campaign = _MKT_CampaignOwner.Campaign  -- association [1..1]
LEFT OUTER JOIN I_MKT_CmpgnAllVersTeamMember AS _MKT_CampaignTeamMember ON Campaign = _MKT_CampaignTeamMember.Campaign  -- association [0..*]
LEFT OUTER JOIN I_MKT_CmpgnAllVersTeamAuUser AS _MKT_CampaignTeamAuthzdUser ON Campaign = _MKT_CampaignTeamAuthzdUser.Campaign  -- association [0..*]
;