I_MKT_Program

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_Program.
-- 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_PROGRAM

CREATE VIEW I_MKT_Program AS
SELECT
  db_key AS MarketingProgram,
  cast(cuan_d_pgm_root.id as cuan_programid preserving type) AS MarketingProgramID,
  cast(cuan_d_pgm_root.name as cuan_programname preserving type) AS MarketingProgramName,
  cast(cuan_d_pgm_root.description as cuan_programdescription preserving type ) AS MarketingProgramDescription,
  cast(cuan_d_pgm_root.mkt_area as cuan_programmarketingarea preserving type) AS MarketingArea,
  cast(cuan_d_pgm_root.valid_from as cuan_programvalidfromdate preserving type) AS MarketingProgramValidFromDate,
  cast(cuan_d_pgm_root.valid_to as cuan_programvalidtodate preserving type) AS MarketingProgramValidToDate,
  cast(cuan_d_pgm_root.marketing_plan_guid as cuan_marketingplanuuid preserving type) AS MarketingPlanUUID,
  cuan_d_pgm_root.status AS MarketingProgramStatus,
  cuan_d_pgm_root.detail_dimension AS MktgProgramDetailDimension,
  cuan_d_pgm_root.time_dimension AS MktgProgramTimeDimension,
  cuan_d_pgm_root.created_on AS MktgProgramCreationDateTime,
  cuan_d_pgm_root.created_by AS MktgProgramCreatedByUser,
  cuan_d_pgm_root.changed_on AS MktgProgramLastChgdDateTime,
  cuan_d_pgm_root.changed_by AS MktgProgramLastChgdByUser
FROM cuan_d_pgm_root
LEFT OUTER JOIN E_MKT_PROGRAM AS _Extension ON MarketingProgram = _Extension.MarketingProgram  -- association [1..1]
LEFT OUTER JOIN I_Mkt_Initiative AS _MKT_Campaign ON MarketingProgram = _MKT_Campaign.MarketingProgram  -- association [0..*]
LEFT OUTER JOIN I_MKT_CampaignAllVersions AS _MKT_CampaignAllVersions ON MarketingProgram = _MKT_CampaignAllVersions.MarketingProgram  -- association [0..*]
LEFT OUTER JOIN I_MKT_MarketingPlan AS _MKT_MarketingPlan ON MarketingPlanUUID = _MKT_MarketingPlan.MarketingPlanUUID  -- association [0..1]
LEFT OUTER JOIN I_MKT_ProgramPhase AS _MKT_ProgramPhase ON MarketingProgram = _MKT_ProgramPhase.MarketingProgram  -- association [0..*]
LEFT OUTER JOIN I_MKT_ProgramMediaType AS _MKT_ProgramMediaType ON MarketingProgram = _MKT_ProgramMediaType.MarketingProgram  -- association [0..*]
LEFT OUTER JOIN I_MKT_BudgetSource AS _MKT_BudgetSource ON MarketingProgram = _MKT_BudgetSource.MarketingProgram  -- association [0..1]
LEFT OUTER JOIN I_MKT_ProgramPlan AS _MKT_ProgramPlan ON MarketingProgram = _MKT_ProgramPlan.MarketingProgram  -- association [1..1]
LEFT OUTER JOIN I_MKT_MarketingArea AS _MarketingProgramMktgArea ON MarketingArea = _MarketingProgramMktgArea.MarketingArea  -- association [1..1]
LEFT OUTER JOIN I_MKT_ProgramStatus AS _MKT_StatusForBusObj ON MarketingProgramStatus = _MKT_StatusForBusObj.ObjectStatus  -- association [1..1]
LEFT OUTER JOIN I_MKT_ProgramTeamMember AS _MKT_ProgramTeamMember ON MarketingProgram = _MKT_ProgramTeamMember.MarketingProgram  -- association [0..*]
LEFT OUTER JOIN I_MKT_ProgramTeamAuthzdUser AS _MKT_ProgramTeamAuthzdUser ON MarketingProgram = _MKT_ProgramTeamAuthzdUser.MarketingProgram  -- association [0..*]
LEFT OUTER JOIN I_MKT_User AS _MktgProgramCreatedByUser ON MktgProgramCreatedByUser = _MktgProgramCreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MKT_User AS _MktgProgramLastChgdByUser ON MktgProgramLastChgdByUser = _MktgProgramLastChgdByUser.UserID  -- association [0..1]
;