P_EngmntProjWrkPckgUnitKPI

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_EngmntProjWrkPckgUnitKPI.
-- 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: PEPWPUNITKPI

CREATE VIEW P_EngmntProjWrkPckgUnitKPI AS
SELECT
  A.EngagementProject AS EngagementProject,
  WorkPackage,
  A.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  WorkPackageUUID,
  EngmtProjFinPlanVersion,
  EngagementProjectResourceType,
  EngagementProjectResource AS WorkPackageUnit,
  ResourceDemandUUID,
  BillingControlCategory,
  A.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  A.Customer AS Customer,
  A.EngmntProjReviewYearPeriod AS EngmntProjReviewYearPeriod,
  A.EngagementProjectReviewStatus AS EngagementProjectReviewStatus,
  A.EngagementProjectStage AS EngagementProjectStage,
  A.EngagementProjectType AS EngagementProjectType,
  A.EngagementProjectCategory AS EngagementProjectCategory,
  A.IsMyProject AS IsMyProject,
  A.ProjManagerUserID AS ProjectManager,
  A.ProjectManagerName AS ProjectManagerName,
  A.ProjectManagerExternalID AS ProjectManagerExternalID,
  A.ProjAccountantUserID AS ProjectAccountant,
  A.ProjectAccountantName AS ProjectAccountantName,
  A.ProjectAccountantExternalID AS ProjectAccountantExternalID,
  A.ProjControllerUserID AS ProjectController,
  A.ProjectControllerName AS ProjectControllerName,
  A.ProjectControllerExternalID AS ProjectControllerExternalID,
  A.ProjPartnerUserID AS Projectpartner,
  A.ProjectPartnerName AS ProjectPartnerName,
  A.ProjectPartnerExternalID AS ProjectPartnerExternalID,
  A.Currency AS Currency,
  UnitOfMeasure AS WorkPackageUnitUoM,
  sum (PlndEffortQty) AS PlanUnitQuantity,
  EngmntProjPlanLineType,
  Ledger.Ledger AS Ledger,
  A.ProjectVisibility AS ProjectVisibility,
  A.ProjectProfileCode AS ProjectProfileCode,
  A.EngmntProjectHeaderCompanyCode AS EngmntProjectHeaderCompanyCode,
  A.EngagementProjectCostCenter AS EngagementProjectCostCenter,
  A.ProfitCenter AS ProfitCenter
FROM I_EngmntProjAssgmtToSessionUsr AS A
INNER JOIN I_EngmntProjectUnitDataVersion AS B ON /* join condition not captured in parsed metadata */
INNER JOIN I_Ledger AS Ledger ON /* join condition not captured in parsed metadata */
;