I_ProjectDemandWork

DDL: I_PROJECTDEMANDWORK Type: view BASIC
17 Fields 1 Data Sources 4 Associations

Project Demand for Resource

I_ProjectDemandWork (Basic)

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

R&D Engineering

I_ProjectDemandWork is a Basic CDS View that provides data about "Project Demand for Resource" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemandWork) and exposes 17 fields with key field ProjectDemandWorkUUID. It has 4 associations to related views.

SAP Help Documentation

CategoryCDS Views for Project Demand
StatusReleased
Purpose
This CDS view can only be used to retrieve resource demand data related to project demands of enterprise projects with the project category 6 ( Enterprise project ) or 7 ( Enterprise project – Professional Services ) 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

StateC1
Line of BusinessR&D Engineering
Application ComponentPPM-SCL-DMN
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view can only be used to retrieve resource demand data related to project demands of enterprise projects with the project category 6 (Enterprise project) or 7 (Enterprise project – Professional Services) in SAP S/4HANA Cloud Public Edition. It is not intended for use in SAP S/4HANA.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemandWork R_ProjectDemandWork from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ProjectDemand _Root $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
[0..*] I_ProjDmndResourceAssignment _ResourceAssignment $projection.ProjectDemandWorkUUID = _ResourceAssignment.ProjectDemandWorkUUID
[0..*] I_ProjectDemandResourceRequest _ProjDmndRsceReq $projection.ProjectDemandWorkUUID = _ProjDmndRsceReq.ProjectDemandWorkUUID
[0..*] I_CostCenter _CostCenter $projection.CostCenter = _CostCenter.CostCenter

Annotations (17)

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 IPROJDMNDWORK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ProjectDemandWorkUUID view
ObjectModel.usageType.serviceQuality #B 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 Project Demand for Resource view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandWorkUUID ProjectDemandWorkUUID Global Identification of a Resource Demand
ProjectDemandUUID ProjectDemandUUID Global Identification of a Project Demand
CostCenter CostCenter Cost Center
ActivityType ActivityType Activity Type
ProjDmndAssgmtStatus ProjDmndAssgmtStatus Assignment Status of a Resource Demand
ProjectElementWorkItem ProjectElementWorkItem ID of the Work Item to Which a Resource Demand is Related
ProjDmndBillingControlCategory ProjDmndBillingControlCategory Billing Control Category
ProjDmndRequestedDeliveryOrg ProjDmndRequestedDeliveryOrg Delivery Organization from Which a Resource is Required
CreatedByUser CreatedByUser Created By User
CreationDateTime CreationDateTime Creation Date Time
LastChangedByUser LastChangedByUser Last Changed By User
LastChangeDateTime LastChangeDateTime Last Change Date Time
_Root _Root
_ResourceAssignment _ResourceAssignment
_ProjDmndRsceReq _ProjDmndRsceReq
_CostCenterActType _CostCenterActType
_CostCenter _CostCenter

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_ProjectDemandWork.
-- 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_ProjectDemandWork AS
SELECT
  ProjectDemandWorkUUID,
  ProjectDemandUUID,
  CostCenter,
  ActivityType,
  ProjDmndAssgmtStatus,
  ProjectElementWorkItem,
  ProjDmndBillingControlCategory,
  ProjDmndRequestedDeliveryOrg,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_ProjectDemandWork
LEFT OUTER JOIN I_ProjectDemand AS _Root ON ProjectDemandUUID = _Root.ProjectDemandUUID  -- association [1..1]
LEFT OUTER JOIN I_ProjDmndResourceAssignment AS _ResourceAssignment ON ProjectDemandWorkUUID = _ResourceAssignment.ProjectDemandWorkUUID  -- association [0..*]
LEFT OUTER JOIN I_ProjectDemandResourceRequest AS _ProjDmndRsceReq ON ProjectDemandWorkUUID = _ProjDmndRsceReq.ProjectDemandWorkUUID  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter  -- association [0..*]
;

Learn More