P_EngmntProjPlanDataWithDraft

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_EngmntProjPlanDataWithDraft.
-- 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: PEPROJPLNWDFT

CREATE VIEW P_EngmntProjPlanDataWithDraft AS
SELECT
  B.ResourceDemandUUID AS ResourceDemandUUID,
  B.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  B.FiscalPeriod AS FiscalPeriod,
  B.FiscalYear AS FiscalYear,
  A.EngagementProject AS EngagementProject,
  B.WorkPackage AS WorkPackage,
  B.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  B.WorkPackageUUID AS WorkPackageUUID,
  B.EngagementProjectResourceType AS EngagementProjectResourceType,
  B.EngagementProjectResource AS EngagementProjectResource,
  B.EmploymentInternalID AS EmploymentInternalID,
  B.EngmtProjEmployeeIsStaffed AS EngmtProjEmployeeIsStaffed,
  B.WorkItem AS WorkItem,
  B.BillingControlCategory AS BillingControlCategory,
  B.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  A.EngagementProjectServiceOrg AS CustomerProjectServiceOrg,
  B.Currency AS Currency,
  B.UnitOfMeasure AS UnitOfMeasure,
  B.EngmntProjPlanLineType AS EngmntProjPlanLineType,
  B.ResourceDemand AS ResourceDemand,
  B.IsUnitBased AS IsUnitBased,
  A.IsMyProject AS IsMyProject,
  A.EngagementProjectCategory AS EngagementProjectCategory,
  A.EngagementProjectType AS EngagementProjectType,
  A.Customer AS Customer,
  A.ProjectVisibility AS ProjectVisibility,
  A.EngagementProjectStage AS EngagementProjectStage,
  A.EngagementProjectCostCenter AS EngagementProjectCostCenter,
  A.EngmntProjectHeaderCompanyCode AS EngmntProjectHeaderCompanyCode,
  A.ProfitCenter AS ProfitCenter,
  A.ProjectProfileCode AS ProjectProfileCode,
  A.ControllingArea AS ControllingArea,
  A.LastChangeDateTime AS LastChangeDateTime,
  sum(B.PlndCostAmt) AS PlndCostAmt,
  sum(B.PlndEffortQty) AS PlndEffortQty,
  sum(B.PlndRevnAmt) AS PlndRevnAmt,
  sum(B.ActualPlanDeviationCost) AS ActualPlanDeviationCost,
  sum(B.ActualPlanDeviationEffort) AS ActualPlanDeviationEffort,
  sum(B.ActualPlanDeviationRevenue) AS ActualPlanDeviationRevenue
FROM I_EngmntProjAssgmtToSessionUsr AS A
INNER JOIN I_EngmntProjPlanDataWithDraft AS B ON /* join condition not captured in parsed metadata */
;