P_ExtSrvcProjWrkPckgDemdByPerd

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_ExtSrvcProjWrkPckgDemdByPerd.
-- 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: PEXTWPDEMBYPRD

CREATE VIEW P_ExtSrvcProjWrkPckgDemdByPerd AS
SELECT
  PlanData.EngagementProject AS EngagementProject,
  PlanData.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  PlanData.WorkPackage AS WorkPackage,
  PlanData.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  PlanData.BillingControlCategory AS BillingControlCategory,
  PlanData.WorkItem AS WorkItem,
  PlanData.Currency AS Currency,
  PlanData.EngagementProjectResource AS EngagementProjectResource,
  PlanData.EngagementProjectResourceType AS EngagementProjectResourceType,
  PlanData.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  PlanData.EmploymentInternalID AS EmploymentInternalID,
  PlanData.EngmtProjEmployeeIsStaffed AS Confirmed,
  sum(PlanData.PlndEffortQty) AS PlndEffortQty,
  sum(PlanData.PlndCostAmt) AS PlndCostAmt,
  sum(PlanData.PlndRevnAmt) AS PlndRevnAmt,
  sum(PlanData.ActualPlanDeviationCost ) AS ActualPlanDeviationCost,
  sum(PlanData.ActualPlanDeviationEffort) AS ActualPlanDeviationEffort,
  PlanData.FiscalYear AS FiscalYear,
  PlanData.FiscalPeriod AS FiscalPeriod,
  PlanData.UnitOfMeasure AS UnitOfMeasure,
  PlanData.EngmntProjPlanLineType AS EngmntProjPlanLineType
FROM I_EngmntProjectPlnDataVersion AS PlanData
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreementDet ON EmploymentInternalID = _PersonWorkAgreementDet.PersonWorkAgreement  -- association [0..*]
;