C_MKT_MarketingPlanSearch

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_MarketingPlanSearch.
-- 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: CMKT_MKTGPLAN

CREATE VIEW C_MKT_MarketingPlanSearch AS
SELECT
  I_MKT_MarketingPlan.MarketingPlanUUID AS MarketingPlanUUID,
  I_MKT_MarketingPlan.MktgObjVersHdrUUID AS MktgObjVersHdrUUID,
  I_MKT_MarketingPlan.MarketingPlan AS MarketingPlan,
  I_MKT_MarketingPlan.MarketingPlanName AS MarketingPlanName,
  I_MKT_MarketingPlan.MarketingPlanStartDate AS MarketingPlanStartDate,
  I_MKT_MarketingPlan.MarketingPlanEndDate AS MarketingPlanEndDate,
  I_MKT_MarketingPlan.MarketingArea AS MarketingArea,
  I_MKT_MarketingPlan._MarketingPlanMktgArea._Text[1: Language = $session.system_language ].MarketingAreaName AS MarketingAreaName,
  I_MKT_MarketingPlan.MarketingPlanStatus AS MarketingPlanStatus,
  I_MKT_MarketingPlan._MKT_MarketingPlanBudgetPlan.MarketingBudgetPlanUUID AS MarketingBudgetPlanUUID,
  I_MKT_MarketingPlan.MarketingPlanCreatedByUser AS MarketingPlanCreatedByUser,
  I_MKT_MarketingPlan.MarketingPlanLastChangedByUser AS MarketingPlanLastChangedByUser,
  I_MKT_MarketingPlan.MktgPlanCreationDateTime AS MktgPlanCreationDateTime,
  I_MKT_MarketingPlan.MktgPlanLastChangedDateTime AS MktgPlanLastChangedDateTime
FROM I_MKT_MarketingPlan
LEFT OUTER JOIN E_MKT_MarketingPlan AS _MarketingPlanExtension ON MarketingPlanUUID = _MarketingPlanExtension.MarketingPlanUUID  -- association [0..1]
LEFT OUTER JOIN I_MKT_ObjectVersionHeaderTP AS _MKT_ObjectVersionHeaders ON MarketingPlanUUID = _MKT_ObjectVersionHeaders.MktgObjOriginalObjectUUID AND _MKT_ObjectVersionHeaders.MktgObjOriginalObjectType = 'CUAN_MARKETING_PLAN'  -- association [0..*]
LEFT OUTER JOIN I_MKT_ObjectVersionHeaderTP AS _MKT_ObjectVersionHeaderDetail ON MktgObjVersHdrUUID = _MKT_ObjectVersionHeaderDetail.MktgObjVersHdrUUID AND _MKT_ObjectVersionHeaderDetail.MktgObjOriginalObjectType = 'CUAN_MARKETING_PLAN'  -- association [0..1]
;