I_EngmntProjPlnDataUnitVers

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_EngmntProjPlnDataUnitVers.
-- 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: IEPRJPLNDATAUVER

CREATE VIEW I_EngmntProjPlnDataUnitVers AS
SELECT
  A.PlanLineItemUUID AS PlanLineItemUUID,
  A.EngagementProject AS EngagementProject,
  A.WorkPackage AS WorkPackage,
  A.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  A.WorkPackageUUID AS WorkPackageUUID,
  A.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  A.EngagementProjectResourceType AS EngagementProjectResourceType,
  A.FiscalPeriod AS FiscalPeriod,
  A.FiscalYear AS FiscalYear,
  A.EngagementProjectResource AS EngagementProjectResource,
  A.EmploymentInternalID AS EmploymentInternalID,
  A.EngmtProjEmployeeIsStaffed AS EngmtProjEmployeeIsStaffed,
  A.WorkItem AS WorkItem,
  A.ResourceDemandUUID AS ResourceDemandUUID,
  A.BillingControlCategory AS BillingControlCategory,
  A.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  A.IsUnitBased AS IsUnitBased,
  A.ParentUnitDemandUUID AS ParentUnitDemandUUID,
  A.Currency AS Currency,
  A.PlndCostAmt AS PlndCostAmt,
  A.UnitOfMeasure AS UnitOfMeasure,
  A.PlndEffortQty AS PlndEffortQty,
  A.PlndRevnAmt AS PlndRevnAmt,
  A.ActualPlanDeviationCost AS ActualPlanDeviationCost,
  A.ActualPlanDeviationEffort AS ActualPlanDeviationEffort,
  A.ActualPlanDeviationRevenue AS ActualPlanDeviationRevenue,
  A.EngmntProjPlanLineType AS EngmntProjPlanLineType,
  A.ResourceDemand AS ResourceDemand,
  A.ResourceSupply AS ResourceSupply,
  A.SourceOfSupply AS SourceOfSupply,
  A.SupplySource AS SupplySource,
  _EngagementProject.EngagementProjectType AS EngagementProjectType,
  _EngagementProject.EngagementProjectCategory AS EngagementProjectCategory,
  _EngagementProject.ProjectProfileCode AS ProjectProfileCode,
  _EngagementProject.CompanyCode AS CompanyCode,
  cast( _EngagementProject.CostCenter as fis_kostl) AS CostCenter,
  _EngagementProject.ProfitCenter AS ProfitCenter
FROM I_EngmntProjPlanDataWithDraft AS A
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]
;