P_RSHResourcePerRequest

DDL: P_RSHRESOURCEPERREQUEST SQL: PRSHRESPERREQ Type: view COMPOSITE
31 Fields 1 Data Sources

P_RSHResourcePerRequest is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RSHStaffingRequestList) and exposes 31 fields with key fields ResourceDemandUUID, EmploymentInternalID.

Data Sources (1)

SourceAliasJoin Type
P_RSHStaffingRequestList StaffReq from

Parameters (3)

NameTypeDefault
P_StartDate syst_datum
P_EndDate syst_datum
P_EmploymentInternalID persno

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PRSHRESPERREQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ResourceDemandUUID P_RSHStaffingRequestList ResourceDemandUUID Demand Key
KEY EmploymentInternalID Resource EmploymentInternalID WorkForce Assgmt ID
EngagementProjectUUID P_RSHStaffingRequestList EngagementProjectUUID Engmnt Project UUID
EngagementProject P_RSHStaffingRequestList EngagementProject Engmnt Project ID
WorkPackageUUID P_RSHStaffingRequestList WorkPackageUUID Work Package UUID
WorkItem P_RSHStaffingRequestList WorkItem Work Item ID
ServiceOrganization P_RSHStaffingRequestList ServiceOrganization
EngagementProjectResource P_RSHStaffingRequestList EngagementProjectResource Resource ID
EmployeeRequestIsStaffed P_RSHStaffingRequestList EmployeeRequestIsStaffed
CostCenter Resource CostCenter Cost Center
CompanyCode Resource CompanyCode Receiver Company Code
EmployeeRequestDelivOrg P_RSHStaffingRequestList EmployeeRequestDelivOrg
StartDate P_RSHStaffingRequestList StartDate Valid From
EndDate P_RSHStaffingRequestList EndDate Term to
EmployeeRequestDuration P_RSHStaffingRequestList EmployeeRequestDuration
EmployeeRequestOpenDuration P_RSHStaffingRequestList EmployeeRequestOpenDuration Remaining Required Hours
UnitOfMeasure P_RSHStaffingRequestList UnitOfMeasure Unit Protected Qty
EmployeeRequestStatus P_RSHStaffingRequestList EmployeeRequestStatus
EngagementProjectResourceType P_RSHStaffingRequestList EngagementProjectResourceType ResourceTypeID
WorkPackageName
ProjectVisibility P_RSHStaffingRequestList ProjectVisibility
_Skilltags P_RSHStaffingRequestList _Skilltags
_Role P_RSHStaffingRequestList _Role
_Project P_RSHStaffingRequestList _Project
_serviceorg Resource _serviceorg
AuthorizationGroup Resource AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted Resource IsBusinessPurposeCompleted Purpose Completed
IsBusPrpsCmpltdCustomer IsBusPrpsCmpltdCustomer
CustomerAuthznGrp CustomerAuthznGrp
IsBusPrpsCmpltdProjectManager IsBusPrpsCmpltdProjectManager
ProjectManagerAuthznGrp ProjectManagerAuthznGrp

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_RSHResourcePerRequest.
-- 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: PRSHRESPERREQ
-- Parameters: P_StartDate : syst_datum, P_EndDate : syst_datum, P_EmploymentInternalID : persno

CREATE VIEW P_RSHResourcePerRequest AS
SELECT
  StaffReq.ResourceDemandUUID AS ResourceDemandUUID,
  Resource.EmploymentInternalID AS EmploymentInternalID,
  StaffReq.EngagementProjectUUID AS EngagementProjectUUID,
  StaffReq.EngagementProject AS EngagementProject,
  StaffReq.WorkPackageUUID AS WorkPackageUUID,
  StaffReq.WorkItem AS WorkItem,
  StaffReq.ServiceOrganization AS ServiceOrganization,
  StaffReq.EngagementProjectResource AS EngagementProjectResource,
  StaffReq.EmployeeRequestIsStaffed AS EmployeeRequestIsStaffed,
  Resource.CostCenter AS CostCenter,
  Resource.CompanyCode AS CompanyCode,
  StaffReq.EmployeeRequestDelivOrg AS EmployeeRequestDelivOrg,
  StaffReq.StartDate AS StartDate,
  StaffReq.EndDate AS EndDate,
  StaffReq.EmployeeRequestDuration AS EmployeeRequestDuration,
  StaffReq.EmployeeRequestOpenDuration AS EmployeeRequestOpenDuration,
  StaffReq.UnitOfMeasure AS UnitOfMeasure,
  StaffReq.EmployeeRequestStatus AS EmployeeRequestStatus,
  StaffReq.EngagementProjectResourceType AS EngagementProjectResourceType,
  cast(StaffReq._WorkPackage.WorkPackageName as rsh_ps_project_workpkg_name preserving type ) AS WorkPackageName,
  StaffReq.ProjectVisibility AS ProjectVisibility,
  StaffReq._Skilltags AS _Skilltags,
  StaffReq._Role AS _Role,
  StaffReq._Project AS _Project,
  Resource._serviceorg AS _serviceorg,
  Resource.AuthorizationGroup AS AuthorizationGroup,
  Resource.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  IsBusPrpsCmpltdCustomer,
  CustomerAuthznGrp,
  IsBusPrpsCmpltdProjectManager,
  ProjectManagerAuthznGrp
FROM P_RSHStaffingRequestList AS StaffReq
;

Learn More