I_EngmntProjectUnitDataVersion

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_EngmntProjectUnitDataVersion.
-- 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: IEPROJUNITDATVER

CREATE VIEW I_EngmntProjectUnitDataVersion AS
SELECT
  EngagementProjectUnitData.plan_line_guid AS PlanLineItemUUID,
  cast(EngagementProjectUnitData.mp_id as /cpd/eng_mp_id preserving type) AS EngagementProject,
  EngagementProjectUnitData.wp_id AS WorkPackage,
  cast(EngagementProjectUnitData.fp_key as /cpd/eng_pfp_db_key preserving type ) AS EngagementProjFinPlanUUID,
  cast(EngagementProjectUnitData.wp_key as /cpd/wp_db_key preserving type ) AS WorkPackageUUID,
  EngagementProjectUnitData.version AS EngmtProjFinPlanVersion,
  EngagementProjectUnitData.res_type AS EngagementProjectResourceType,
  EngagementProjectUnitData.period AS FiscalPeriod,
  EngagementProjectUnitData.fc_year AS FiscalYear,
  EngagementProjectUnitData.resource_id AS EngagementProjectResource,
  EngagementProjectUnitData.demand_key AS ResourceDemandUUID,
  EngagementProjectUnitData.billgctrlcat AS BillingControlCategory,
  EngagementProjectUnitData.delvry_serv_org AS EngagementProjectServiceOrg,
  EngagementProjectUnitData.currency AS Currency,
  EngagementProjectUnitData.cost AS PlndCostAmt,
  EngagementProjectUnitData.uom AS UnitOfMeasure,
  EngagementProjectUnitData.effort AS PlndEffortQty,
  EngagementProjectUnitData.revenue AS PlndRevnAmt,
  EngagementProjectUnitData.line_type AS EngmntProjPlanLineType,
  EngagementProjectUnitData.source_of_supply AS SourceOfSupply,
  EngagementProjectUnitData.source_of_supply AS SupplySource,
  EngagementProjectUnitData.is_unit_based AS IsUnitBased,
  EngagementProjectUnitData.parent_unit_demand_key AS ParentUnitDemandUUID
FROM /cpd/plandata AS EngagementProjectUnitData
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON EngagementProject = _EngagementProject.EngagementProject  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjFinancialPlan AS _EngagementProjFinancialPlan ON EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID  -- association [0..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [1..1]
LEFT OUTER JOIN I_EngmtProjFinPlanVersion AS _EngmtProjFinPlanVersion ON EngagementProjFinPlanUUID = _EngmtProjFinPlanVersion.EngagementProjFinPlanUUID AND EngmtProjFinPlanVersion = _EngmtProjFinPlanVersion.EngmtProjFinPlanVersion  -- association [0..1]
LEFT OUTER JOIN I_EngmntProjResourceType AS _EngmntProjResourceType ON EngagementProjectResourceType = _EngmntProjResourceType.EngagementProjectResourceType  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectResource AS _EngagementProjectResource ON EngagementProjectResource = _EngagementProjectResource.EngagementProjectResource  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _EngagementProjectServiceOrg ON EngagementProjectServiceOrg = _EngagementProjectServiceOrg.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN I_BillingControlCategory AS _BillingControlCategory ON BillingControlCategory = _BillingControlCategory.BillingControlCategory  -- association [0..1]
;