I_Mkt_Initiative

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_Initiative.
-- 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_INITIATIVE

CREATE VIEW I_Mkt_Initiative AS
SELECT
  persistence.db_key AS Campaign,
  persistence.id AS CampaignID,
  persistence.name AS CampaignName,
  persistence.description AS CampaignDescription,
  cast( persistence.type as cuan_cds_cpg_category ) AS CampaignCategory,
  cast( persistence.mkt_area_id as cuan_cds_mkt_area ) AS MarketingArea,
  persistence.program_guid AS MarketingProgram,
  persistence.process_type AS CampaignProcessType,
  persistence.comm_cat_key AS CommunicationCategoryUUID,
  persistence.crea_uname AS CampaignCreatedByUser,
  persistence.lchg_uname AS CampaignLastChgdByUser,
  persistence.crea_date_time AS CampaignCreationDateTime,
  persistence.lchg_date_time AS CampaignLastChgdDateTime,
  persistence.period_start_timestmp AS CampaignScheduleDateTime,
  persistence.period_distance AS CampaignExecutionFrqcyInterval,
  persistence.period_unit AS CampaignExecutionFrqcyUnitName,
  persistence.definition_id AS ExportDefinition,
  _MKT_CampaignOwner.CampaignOwner AS CampaignOwner,
  persistence.life_cycle_status AS CampaignLifecycleStatus,
  persistence.start_date AS CampaignStartDate,
  persistence.end_date AS CampaignEndDate,
  cast(persistence.media_type_id as cuan_cds_media_type_id) AS MediaType,
  persistence.priority AS CampaignPriority,
  cast (persistence.cpg_timezone as cuan_campaign_time_zone) AS CampaignTimeZone,
  persistence.ignore_mkt_permission AS MarketingPermissionIsIgnored,
  cuan_d_ini_tg.target_group_key AS TargetGroupUUID,
  _MKT_CampaignAgency.MarketingAgencyUUID AS MarketingAgencyUUID,
  persistence.campaignperfupdatestatus AS CampaignPerfUpdateStatus,
  _MKT_CampaignOwner._MKT_User AS _MKT_User
FROM cuan_d_ini_root AS persistence
LEFT OUTER JOIN E_MKT_INITIATIVE AS _Extension ON Campaign = _Extension.Campaign  -- association [1..1]
LEFT OUTER JOIN I_MKT_CampaignCategory AS _MKT_CampaignCategory ON CampaignCategory = _MKT_CampaignCategory.CampaignCategory  -- association [1..1]
LEFT OUTER JOIN I_MKT_CampaignProcessType AS _MKT_CampaignProcessType ON CampaignProcessType = _MKT_CampaignProcessType.CampaignProcessType  -- association [0..1]
LEFT OUTER JOIN I_MKT_Program AS _MKT_Program ON MarketingProgram = _MKT_Program.MarketingProgram  -- association [0..1]
LEFT OUTER JOIN I_MKT_ProgramPhase AS _MKT_ProgramPhase ON MarketingProgramPhaseUUID = _MKT_ProgramPhase.MarketingProgramPhaseUUID  -- association [0..1]
LEFT OUTER JOIN I_MKT_MarketingArea AS _MKT_MarketingArea ON MarketingArea = _MKT_MarketingArea.MarketingArea  -- association [0..1]
LEFT OUTER JOIN I_MKT_CommunicationCategory AS _MKT_CommunicationCategory ON CommunicationCategoryUUID = _MKT_CommunicationCategory.CommunicationCategoryUUID  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignOwner AS _MKT_CampaignOwner ON Campaign = _MKT_CampaignOwner.Campaign  -- association [1..1]
LEFT OUTER JOIN I_MKT_MediaType AS _MKT_MediaType ON MediaType = _MKT_MediaType.MediaType  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignPriority AS _MKT_CampaignPriority ON CampaignPriority = _MKT_CampaignPriority.CampaignPriority  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignPlanCoordinate AS _MKT_CampaignPlanCoordinate ON Campaign = _MKT_CampaignPlanCoordinate.Campaign  -- association [0..*]
LEFT OUTER JOIN I_MKT_User AS _MKT_CampaignCreatedByUser ON CampaignCreatedByUser = _MKT_CampaignCreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MKT_User AS _MKT_CampaignLastChgdByUser ON CampaignLastChgdByUser = _MKT_CampaignLastChgdByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MKT_TargetGroup AS _MKT_TargetGroup ON TargetGroupUUID = _MKT_TargetGroup.TargetGroupUUID  -- association [1..1]
LEFT OUTER JOIN I_MKT_CampaignAgency AS _MKT_CampaignAgency ON Campaign = _MKT_CampaignAgency.Campaign  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignTeamMember AS _MKT_CampaignTeamMember ON Campaign = _MKT_CampaignTeamMember.Campaign  -- association [0..*]
;