P_WorkPackageUnitKPI

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 P_WorkPackageUnitKPI.
-- 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: PWRKPKGUKPI

CREATE VIEW P_WorkPackageUnitKPI AS
SELECT
  B.EngagementProject AS EngagementProject,
  B.WorkPackage AS WorkPackage,
  B.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  B.WorkPackageUUID AS WorkPackageUUID,
  B.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  B.EngagementProjectResourceType AS EngagementProjectResourceType,
  B.EngagementProjectResource AS WorkPackageUnit,
  B.ResourceDemandUUID AS ResourceDemandUUID,
  B.BillingControlCategory AS BillingControlCategory,
  B.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  B.Currency AS Currency,
  B.PlndCostAmt AS PlndCostAmt,
  B.UnitOfMeasure AS WorkPackageUnitUoM,
  B.PlndEffortQty AS PlanUnitQuantity,
  B.PlndRevnAmt AS PlndRevnAmt,
  B.EngmntProjPlanLineType AS EngmntProjPlanLineType,
  A.EngagementProjectCategory AS EngagementProjectCategory,
  A.EngagementProjectServiceOrg AS CustomerProjectServiceOrg,
  A.Customer AS Customer,
  A.ProjectVisibility AS ProjectVisibility,
  A.EngagementProjectStage AS EngagementProjectStage,
  A.ProjectProfileCode AS ProjectProfileCode,
  A.EngagementProjectType AS EngagementProjectType,
  A.EngmntProjectHeaderCompanyCode AS EngmntProjectHeaderCompanyCode,
  A.EngagementProjectCostCenter AS EngagementProjectCostCenter,
  A.ProfitCenter AS ProfitCenter,
  A.IsMyProject AS IsMyProject,
  A.ControllingArea AS ControllingArea,
  A.LastChangeDateTime AS LastChangeDateTime,
  B._EngagementProject AS _EngagementProject,
  B._EngagementProjectResource AS _EngagementProjectResource,
  B._EngagementProjectServiceOrg AS _EngagementProjectServiceOrg,
  B._EngagementProjFinancialPlan AS _EngagementProjFinancialPlan,
  B._EngmntProjResourceType AS _EngmntProjResourceType,
  B._EngmtProjFinPlanVersion AS _EngmtProjFinPlanVersion,
  B._UnitOfMeasure AS _UnitOfMeasure,
  B._WorkPackage AS _WorkPackage
FROM I_EngmntProjAssgmtToSessionUsr AS A
INNER JOIN I_EngmntProjectUnitDataVersion AS B ON /* join condition not captured in parsed metadata */
;