I_EngagementProjFinancialPlan

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_EngagementProjFinancialPlan.
-- 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: IEPFINANPLN

CREATE VIEW I_EngagementProjFinancialPlan AS
SELECT
  cast(EngagementProjFinancialPlan.db_key as /cpd/eng_pfp_db_key preserving type ) AS EngagementProjFinPlanUUID,
  cast(EngagementProjFinancialPlan.mp_id_int as /cpd/pfp_mp_id_int preserving type ) AS EngagementProjectUUID,
  EngagementProjFinancialPlan.currency AS Currency,
  EngagementProjFinancialPlan.proj_uom AS UnitOfMeasure,
  cast(EngagementProjFinancialPlan.changed_on as /cpd/cpm_changedon) AS LastChangeDateTime,
  EngagementProjFinancialPlan.changed_by AS LastChangedByUser,
  cast(EngagementProjFinancialPlan.review_period_sc as /cpd/pfp_review_year_period) AS EngmntProjReviewYearPeriod,
  EngagementProjFinancialPlan.period_end_forecast_status AS EngagementProjectReviewStatus
FROM /cpd/d_pfp_ph AS EngagementProjFinancialPlan
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON EngagementProjectUUID = _EngagementProject.EngagementProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON EngagementProjFinPlanUUID = _WorkPackage.EngagementProjFinPlanUUID  -- association [0..*]
LEFT OUTER JOIN I_EngagementProjectPlanData AS _EngagementProjectPlanData ON EngagementProjFinPlanUUID = _EngagementProjectPlanData.EngagementProjFinPlanUUID  -- association [0..*]
LEFT OUTER JOIN I_EngmntProjFinPlanStatus AS _EngmntProjFinPlanStatus ON EngagementProjectReviewStatus = _EngmntProjFinPlanStatus.EngagementProjectReviewStatus  -- association [0..1]
;