P_ENGMNTPROJRSCEDMND

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_ENGMNTPROJRSCEDMND.
-- 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: PEPRSCEDEMAND

CREATE VIEW P_ENGMNTPROJRSCEDMND AS
SELECT
  WorkPackage,
  ResourceDemand,
  EngmtProjFinPlanVersion AS Version,
  EngagementProject,
  ResourceDemandUUID,
  EngagementProjectType,
  EngagementProjectCategory,
  EngagementProjectServiceOrg,
  ProjectVisibility,
  ProjectProfileCode,
  EngmntProjectHeaderCompanyCode,
  EngagementProjectCostCenter,
  ProfitCenter,
  WorkItem,
  BillingControlCategory,
  DeliveryOrganization,
  EngagementProjectResourceType,
  EngagementProjectResource,
  cast ( '' as wfd_user_id ) AS WorkforcePersonUserID,
  cast( '' as wfd_country ) AS Country2DigitISOCode,
  cast( '00000000' as datum) AS KeyDate,
  EmploymentInternalID,
  EngmtProjEmployeeIsStaffed AS ResourceSupplyIsConfirmed,
  EngmntProjPlanLineType,
  Currency,
  UnitOfMeasure,
  sum(PlndCostAmt) AS DemandCostAmt,
  sum(PlndEffortQty) AS Quantity,
  sum(PlndRevnAmt) AS DemandRevAmt
FROM I_EngmntProjDmndSup
;