P_RSHStaffingRequestList

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_RSHStaffingRequestList.
-- 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: PRSHSTAFFREQLIST

CREATE VIEW P_RSHStaffingRequestList AS
SELECT
  ResourceDemandUUID,
  Request.EngagementProjectUUID AS EngagementProjectUUID,
  Request.WorkPackageUUID AS WorkPackageUUID,
  Request.WorkItem AS WorkItem,
  Request.ServiceOrganization AS ServiceOrganization,
  Request.EngagementProjectResource AS EngagementProjectResource,
  Request.EngagementProjectResourceType AS EngagementProjectResourceType,
  Request.EmployeeRequestIsStaffed AS EmployeeRequestIsStaffed,
  Request.EngagementProject AS EngagementProject,
  Request.EngagementProjectCategory AS EngagementProjectCategory,
  Request.EmployeeRequestDelivOrg AS EmployeeRequestDelivOrg,
  Request.ProjAssignmentStartDate AS ProjAssignmentStartDate,
  Request.ProjAssignmentEndDate AS ProjAssignmentEndDate,
  Request.Currency AS Currency,
  Request.PlndRevAmt AS PlndRevAmt,
  Request.EngagementProjectName AS EngagementProjectName,
  Request.WorkPackageName AS WorkPackageName,
  Request.ProjectManager AS ProjectManager,
  Request.WorkPackage AS WorkPackage,
  Request.BillingControlCategory AS BillingControlCategory,
  Request.EmploymentInternalID AS EmploymentInternalID,
  Request.StartDate AS StartDate,
  Request.EndDate AS EndDate,
  Request.UnitOfMeasure AS UnitOfMeasure,
  cast(Request.EmployeeRequestDuration as rsh_ps_employeerequestduration) AS EmployeeRequestDuration,
  Request.EmployeeRequestAssignDuration AS EmployeeRequestAssignDuration,
  Request.EmployeeRequestOpenDuration AS EmployeeRequestOpenDuration,
  Request.EmployeeReqPrfrdEmplymtIntID AS EmployeeReqPrfrdEmplymtIntID,
  Request.ProjectVisibility AS ProjectVisibility,
  Request.EngagementProjectStage AS EngagementProjectStage,
  Request.Customer AS Customer,
  Request._Role AS _Role,
  Request._Customer AS _Customer,
  Request._WorkPackage AS _WorkPackage,
  Request._WorkItem AS _WorkItem,
  Request._Project AS _Project,
  EmployeeRequestAuthorized,
  EmployeeRequestHdrSrvOrg,
  EmployeeRequestHdrCostCenter,
  ControllingArea,
  IsBusPrpsCmpltdCustomer,
  CustomerAuthznGrp,
  IsBusPrpsCmpltdProjectManager,
  ProjectManagerAuthznGrp,
  case when Request.AssignmentCount is null then 0 else Request.AssignmentCount end as AssignmentCount AS AssignmentCountendasAssignmentCount,
  bintohex(ResourceDemandUUID) AS SitnInstceAnchorObjectKey
FROM P_RSHStaffingRequest AS Request
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _ProjectManager ON _ProjectManager.PersonWorkAgreement = ProjectManager  -- association [0..*]
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _StaffedResource ON _StaffedResource.PersonWorkAgreement = EmploymentInternalID  -- association [0..*]
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PreferredResource ON _PreferredResource.PersonWorkAgreement = EmployeeReqPrfrdEmplymtIntID  -- association [0..*]
;