A_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 A_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: AMKT_PROGRAM

CREATE VIEW A_MKT_Program AS
SELECT
  cast(Program.MarketingProgram as cuan_programuuid preserving type ) AS MarketingProgramUUID,
  Program.MarketingProgramID AS MarketingProgramID,
  Program.MarketingProgramName AS MarketingProgramName,
  Program.MarketingArea AS MarketingProgramMarketingArea,
  cast(Program._MarketingProgramMktgArea._Text[1:Language=$session.system_language].MarketingAreaName as cuan_programmarketingareaname preserving type ) AS MktgProgramMktgAreaName,
  Program.MarketingProgramValidFromDate AS MarketingProgramValidFromDate,
  Program.MarketingProgramValidToDate AS MarketingProgramValidToDate,
  Program.MarketingPlanUUID AS MarketingPlanUUID,
  Program.MktgProgramDetailDimension AS MktgProgramDetailDimension,
  Program.MktgProgramTimeDimension AS MktgProgramTimeDimension,
  cast(Program.MktgProgramCreationDateTime as cuan_programcreationdatetime preserving type ) AS MktgProgramCreationDateTime,
  Program.MktgProgramCreatedByUser AS MktgProgramCreatedByUser,
  cast(Program.MktgProgramLastChgdDateTime as cuan_programlastchgddatetime preserving type ) AS MktgProgramLastChgdDateTime,
  Program.MktgProgramLastChgdByUser AS MktgProgramLastChgdByUser,
  cast(Program._MktgProgramCreatedByUser.FullName as cuan_programcreatedbyusername preserving type ) AS MktgProgramCreatedByUserName,
  Program._MKT_MarketingPlan.MarketingPlanName AS MarketingPlanName,
  _ProgramHeaderProposedSpend.MarketingProgramCurrency AS MarketingProgramCurrency
FROM I_MKT_Program AS Program
LEFT OUTER JOIN E_MKT_PROGRAM AS _Extension ON _Extension.MarketingProgram = _Extension.MarketingProgram  -- association [1..1]
LEFT OUTER JOIN A_MKT_PgmHeaderPrpsdSpend AS _ProgramHeaderProposedSpend ON MarketingProgramUUID = _ProgramHeaderProposedSpend.MarketingProgramUUID  -- association [1..1]
LEFT OUTER JOIN A_MKT_MediaTypeSpend AS _MediaTypeSpend ON MarketingProgramUUID = _MediaTypeSpend.MarketingProgramUUID  -- association [0..*]
LEFT OUTER JOIN A_MKT_ProgramPhase AS _ProgramPhase ON MarketingProgramUUID = _ProgramPhase.MarketingProgramUUID  -- association [0..*]
;