I_ProjectDemandResourceRequest

DDL: I_PROJECTDEMANDRESOURCEREQUEST Type: view BASIC Package: PS_DMND_VDM_WORK
13 Fields 1 Data Sources 4 Associations

Resource Request for Resource Demand

I_ProjectDemandResourceRequest (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

DemandResourceRequest · R&D Engineering

I_ProjectDemandResourceRequest is a Basic CDS View that provides data about "Resource Request for Resource Demand" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemandResourceRequest) and exposes 13 fields with key field ProjDmndResourceRequestUUID. It has 4 associations to related views. Part of development package PS_DMND_VDM_WORK.

SAP Help Documentation

CategoryCDS Views for Project Logistics Control
Purpose
This CDS view retrieves the data of resource requests for resource demands. It is relevant for resource demands of type Team Resource and Additional Resource only. This CDS view provides the data to answer the following business questions: Which resource is requested for a demand? Which requests exist for a particular resource? Note You cannot request a resource for a resource demand of type Additional Resource . For this reason, the resource request as such is not relevant for resource demands of this type. However, you can retrieve the resource quantities planned for specific calendar months using its child entity Resource Request Distribution . To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have one of the following business catalogs assigned: Enterprise Project – Project Demand ( SAP_PS_BC_PROJ_DEMAND_MC ) Development – API Test – Project Demand ( SAP_A4C_BC_DEV_TST_PPM_DM0_PC ) This business catalog is assigned to the Developer ( SAP_BR_DEVELOPER ) business role template. Both business catalogs can be used to grant read and write access to project demand data. However, only read access is needed to use the CDS view.

Structure
Fields Used for Filtering All fields of this CDS view can be used for filtering. The main filter is the following: ProjectDemandRequestedResource : This field is used to specify the personnel number of the workforce person that is requested as resource for a demand of type Team Resource . If a resource has several work agreements or employments, the personnel number indicates the one relevant for the demand. It is not relevant for resource demands of type Additional Resource . Further Important Fields Important fields in this view include the following: Field Name Description ProjDmndResourceRequestUUID Global identification of a resource request ProjectDemandWorkUUID Global identification of a resource demand ProjectDemandUUID Global identification of a project demand ProjDmndStfngInstructionText Staffing instruction (only relevant for resource demands of type Team Resource )

Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Delta (change data capture)

Constraints
This CDS view can only be used to retrieve resource request data related to project demands of professional services projects in SAP S/4HANA Cloud Public Edition . It is not intended for use in SAP S/4HANA .

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessR&D Engineering
Application ComponentPPM-SCL-DMN
CapabilitiesData Source for Data Extraction,Data Source for Defining CDS Entities,Data Source in SQL Select,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageR&D/Engineering for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view retrieves the data of resource requests for resource demands. It is relevant for resource demands of type Team Resource and Additional Resource only.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li> <p>Which resource is requested for a demand?</p> </li> <li> <p>Which requests exist for a particular resource?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemandResourceRequest R_ProjectDemandResourceRequest from

Associations (4)

CardinalityTargetAliasCondition
[1] I_ProjectDemand _Root $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
[1] I_ProjectDemandWork _Work $projection.ProjectDemandWorkUUID = _Work.ProjectDemandWorkUUID
[0..*] I_ProjDmndRsceReqDistribution _ProjDmndRsceReqDistr $projection.ProjDmndResourceRequestUUID = _ProjDmndRsceReqDistr.ProjDmndResourceRequestUUID
[1] I_PersonWorkAgreement_1 _PersonWorkAgrmt $projection.ProjectDemandRequestedResource = _PersonWorkAgrmt.PersonWorkAgreement

Annotations (18)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName IPROJDMNDRSCER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ProjDmndResourceRequestUUID view
ObjectModel.sapObjectNodeType.name DemandResourceRequest view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Resource Request for Resource Demand view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ProjDmndResourceRequestUUID ProjDmndResourceRequestUUID Global Identification of a Resource Request
ProjectDemandWorkUUID ProjectDemandWorkUUID Global Identification of a Resource Demand
ProjectDemandUUID ProjectDemandUUID Global Identification of a Project Demand
ProjectDemandRequestedResource ProjectDemandRequestedResource Personnel Number of a Resource
ProjDmndStfngInstructionText ProjDmndStfngInstructionText Staffing Instruction for a Resource Demand
CreatedByUser CreatedByUser Created By User
CreationDateTime CreationDateTime Creation Date Time
LastChangedByUser LastChangedByUser Last Changed By User
LastChangeDateTime LastChangeDateTime Last Change Date Time
_Root _Root
_Work _Work
_ProjDmndRsceReqDistr _ProjDmndRsceReqDistr
_PersonWorkAgrmt _PersonWorkAgrmt

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 I_ProjectDemandResourceRequest.
-- 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.

CREATE VIEW I_ProjectDemandResourceRequest AS
SELECT
  ProjDmndResourceRequestUUID,
  ProjectDemandWorkUUID,
  ProjectDemandUUID,
  ProjectDemandRequestedResource,
  ProjDmndStfngInstructionText,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_ProjectDemandResourceRequest
LEFT OUTER JOIN I_ProjectDemand AS _Root ON ProjectDemandUUID = _Root.ProjectDemandUUID  -- association [1]
LEFT OUTER JOIN I_ProjectDemandWork AS _Work ON ProjectDemandWorkUUID = _Work.ProjectDemandWorkUUID  -- association [1]
LEFT OUTER JOIN I_ProjDmndRsceReqDistribution AS _ProjDmndRsceReqDistr ON ProjDmndResourceRequestUUID = _ProjDmndRsceReqDistr.ProjDmndResourceRequestUUID  -- association [0..*]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgrmt ON ProjectDemandRequestedResource = _PersonWorkAgrmt.PersonWorkAgreement  -- association [1]
;

Learn More