I_EngmntProjectPlnDataVersion

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_EngmntProjectPlnDataVersion.
-- 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: IEPROJPLNDATAVER

CREATE VIEW I_EngmntProjectPlnDataVersion AS
SELECT
  EngagementProjectPlanData.plan_line_guid AS PlanLineItemUUID,
  cast(EngagementProjectPlanData.mp_id as /cpd/eng_mp_id preserving type) AS EngagementProject,
  EngagementProjectPlanData.wp_id AS WorkPackage,
  cast(EngagementProjectPlanData.fp_key as /cpd/eng_pfp_db_key preserving type ) AS EngagementProjFinPlanUUID,
  cast(EngagementProjectPlanData.wp_key as /cpd/wp_db_key preserving type ) AS WorkPackageUUID,
  EngagementProjectPlanData.version AS EngmtProjFinPlanVersion,
  EngagementProjectPlanData.res_type AS EngagementProjectResourceType,
  EngagementProjectPlanData.period AS FiscalPeriod,
  EngagementProjectPlanData.fc_year AS FiscalYear,
  EngagementProjectPlanData.resource_id AS EngagementProjectResource,
  EngagementProjectPlanData.employee AS EmploymentInternalID,
  EngagementProjectPlanData.confirmed AS EngmtProjEmployeeIsStaffed,
  EngagementProjectPlanData.workitem_id AS WorkItem,
  EngagementProjectPlanData.demand_key AS ResourceDemandUUID,
  EngagementProjectPlanData.resource_demand_id AS ResourceDemand,
  EngagementProjectPlanData.resource_supply_id AS ResourceSupply,
  EngagementProjectPlanData.billgctrlcat AS BillingControlCategory,
  EngagementProjectPlanData.delvry_serv_org AS EngagementProjectServiceOrg,
  EngagementProjectPlanData.is_unit_based AS IsUnitBased,
  EngagementProjectPlanData.parent_unit_demand_key AS ParentUnitDemandUUID,
  EngagementProjectPlanData.currency AS Currency,
  EngagementProjectPlanData.cost AS PlndCostAmt,
  EngagementProjectPlanData.uom AS UnitOfMeasure,
  EngagementProjectPlanData.effort AS PlndEffortQty,
  EngagementProjectPlanData.revenue AS PlndRevnAmt,
  EngagementProjectPlanData.cost_deviation AS ActualPlanDeviationCost,
  EngagementProjectPlanData.effort_deviation AS ActualPlanDeviationEffort,
  EngagementProjectPlanData.revenue_deviation AS ActualPlanDeviationRevenue,
  EngagementProjectPlanData.line_type AS EngmntProjPlanLineType,
  EngagementProjectPlanData.source_of_supply AS SourceOfSupply,
  EngagementProjectPlanData.source_of_supply AS SupplySource
FROM /cpd/plandata AS EngagementProjectPlanData
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_WorkPackageWorkItem AS _WorkItem ON WorkItem = _WorkItem.WorkItem AND WorkPackage = _WorkItem.WorkPackage  -- association [0..1]
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_BillingControlCategory AS _BillingControlCategory ON BillingControlCategory = _BillingControlCategory.BillingControlCategory  -- association [0..1]
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreementDet ON EmploymentInternalID = _PersonWorkAgreementDet.PersonWorkAgreement  -- association [0..*]
LEFT OUTER JOIN I_Employment AS _Employment ON EmploymentInternalID = _Employment.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON EmploymentInternalID = _PersonWorkAgreement_1.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _EngagementProjectServiceOrg ON EngagementProjectServiceOrg = _EngagementProjectServiceOrg.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN I_PlanSkillTags AS _PlanSkillTags ON ResourceDemandUUID = _PlanSkillTags.ResourceDemandUUID  -- association [0..1]
LEFT OUTER JOIN I_EngmntProjAssgmtToSessionUsr AS _MyProject ON EngagementProject = _MyProject.EngagementProject  -- association [1..1]
;