I_MKT_BudgetSource

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_BudgetSource.
-- 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_BUDGETSRCE

CREATE VIEW I_MKT_BudgetSource AS
SELECT
  cast(cuan_d_budg_src.db_key as cuan_budgetsourceuuid preserving type) AS MarketingBudgetSourceUUID,
  cuan_d_budg_src.parent_key AS MarketingProgram,
  cast(cuan_d_budg_src.plan_coordinate_guid as cuan_plancoordinateuuid preserving type) AS MarketingPlanCoordinateUUID
FROM cuan_d_budg_src
LEFT OUTER JOIN I_MKT_Program AS _MKT_Program ON MarketingProgram = _MKT_Program.MarketingProgram  -- association [1..1]
LEFT OUTER JOIN I_MKT_PlanCoordinate AS _MKT_PlanCoordinate ON MarketingPlanCoordinateUUID = _MKT_PlanCoordinate.MarketingPlanCoordinateUUID  -- association [1..1]
LEFT OUTER JOIN I_Mkt_Initiative AS _Campaign ON MarketingProgram = _Campaign.MarketingProgram  -- association [0..*]
LEFT OUTER JOIN I_MKT_CampaignAllVersions AS _CampaignAllVersions ON MarketingProgram = _CampaignAllVersions.MarketingProgram  -- association [0..*]
;