P_RSHStaffingRequest

Staffing Request incl. consolidations | view: PRSHSTAFFREQ | Extraction: Not supported | Component: Resource Scheduling for Project-based Service
Column Name Description
ResourceDemandUUID Demand Key
Column Name Description
💲 Plan Currency (Currency):
PlndRevAmt Planned Revenue
Column Name Description
Column Name Description
EndDate Request End
StartDate Request Start
ProjAssignmentEndDate null
ProjAssignmentStartDate null
Column Name Description
EmployeeRequestAuthorized Authorization for project navigation Show values
EngagementProjectCategory Project Type Show values
ProjectVisibility Public Project Show values
IsBusPrpsCmpltdCustomer Business Purpose Completed Flag Show values
IsBusPrpsCmpltdProjectManager Business Purpose Completed Flag Show values
EmployeeRequestStaffStatus Staffing Status of Resource Request Show values
Column Name Description Domain name
EngagementProjectUUID Engagement Project UUID /BOBF/CONF_KEY
WorkPackageUUID Work Package UUID /BOBF/CONF_KEY
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
ServiceOrganization Service Organization ID /CPD/PWS_WS_ORG_UNIT_ID
EngagementProjectResource Resource ID /CPD/PFP_RESOURCE_ID
EmployeeRequestIsStaffed null
EmployeeRequestDelivOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
EmployeeRequestDuration Hours Required by Resource Request
EmployeeRequestHdrSrvOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
EmployeeRequestHdrCostCenter Organization Unit Key /CPD/PWS_WS_ORG_UNIT_KEY
EngagementProject Engagement Project ID /CPD/MP_ID
EngagementProjectResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
EngagementProjectName Customer Project Name /CPD/SHORT_TEXT
ProjectManager Project Manager ID
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
WorkPackageName Plan Item Description /CPD/PLAN_ITEM_NAME
BillingControlCategory null
EmployeeReqPrfrdEmplymtIntID Object ID HROBJID
AssignmentCount null
EmployeeRequestAssignDuration Staffed Hours
EmploymentInternalID null
CustomerAuthznGrp Authorization Group BRGRU
EmployeeRequestOpenDuration Remaining Required Hours
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Controlling area
  • Client
  • Controlling area for the project
  • P_RSHSTAFFINGREQUEST.MANDT == TKA01.MANDT
  • P_RSHSTAFFINGREQUEST.CONTROLLINGAREA == TKA01.KOKRS
Authorization Group
  • Authorization Group
  • ?
  • Client
  • P_RSHSTAFFINGREQUEST.PROJECTMANAGERAUTHZNGRP == TB037.AUGRP
  • P_RSHSTAFFINGREQUEST.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • P_RSHSTAFFINGREQUEST.MANDT == TB037.CLIENT