I_ProjectDemandService

DDL: I_PROJECTDEMANDSERVICE Type: view BASIC
18 Fields 1 Data Sources 5 Associations

Project Demand for Service

I_ProjectDemandService (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_ProjectDemandService is a Basic CDS View that provides data about "Project Demand for Service" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemandService) and exposes 18 fields with key field ProjectDemandServiceUUID. It has 5 associations to related views.

SAP Help Documentation

CategoryCDS Views for Project Demand
StatusReleased
Purpose
This CDS view can only be used to retrieve demand data specific to service demands of enterprise projects with 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 demand data specific to service demands of enterprise projects with 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_ProjectDemandService R_ProjectDemandService from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_ProjectDemandServiceSupply _ServiceSupply _ServiceSupply.ProjectDemandUUID = $projection.ProjectDemandUUID
[1..1] I_ProjectDemand _RootTP $projection.ProjectDemandUUID = _RootTP.ProjectDemandUUID
[0..1] I_Product _Material $projection.Material = _Material.Product
[0..1] I_ProductGroup_2 _MaterialGroup $projection.MaterialGroup = _MaterialGroup.ProductGroup
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (16)

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 #BLOCKED_DATA_EXCLUDED view
AbapCatalog.sqlViewName IPROJDMNDSERVICE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ProjectDemandServiceUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Project Demand for Service view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandServiceUUID ProjectDemandServiceUUID Global Identification for Service Demand
ProjectDemandUUID ProjectDemandUUID Global Identification of a Project Demand
Material Material Material Number
MaterialGroup MaterialGroup Material Group
Supplier Supplier Desired Supplier for Project Demand
PurchasingInfoRecord PurchasingInfoRecord Info Record for Project Demand
PurchaseContract PurchaseContract Purchasing Document Number
PurchaseContractItem PurchaseContractItem Item Number of Purchasing Document
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn Planned Delivery Time in Days
CreatedByUser CreatedByUser Created By User
CreationDateTime CreationDateTime Creation Date Time
LastChangedByUser LastChangedByUser Last Changed By User
LastChangeDateTime LastChangeDateTime Last Change Date Time
_RootTP _RootTP
_ServiceSupply _ServiceSupply
_Material _Material
_MaterialGroup _MaterialGroup
_Supplier _Supplier

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_ProjectDemandService.
-- 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_ProjectDemandService AS
SELECT
  ProjectDemandServiceUUID,
  ProjectDemandUUID,
  Material,
  MaterialGroup,
  Supplier,
  PurchasingInfoRecord,
  PurchaseContract,
  PurchaseContractItem,
  MaterialPlannedDeliveryDurn,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_ProjectDemandService
LEFT OUTER JOIN I_ProjectDemandServiceSupply AS _ServiceSupply ON _ServiceSupply.ProjectDemandUUID = ProjectDemandUUID  -- association [0..1]
LEFT OUTER JOIN I_ProjectDemand AS _RootTP ON ProjectDemandUUID = _RootTP.ProjectDemandUUID  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _MaterialGroup ON MaterialGroup = _MaterialGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;

Learn More