What is I_ProjectDemand in SAP S/4HANA?

I_ProjectDemand is a basic CDS view in SAP S/4HANA. Project Demand It contains 47 fields.

Which tables does I_ProjectDemand read from?

I_ProjectDemand reads data from: R_ProjectDemand.

What VDM layer is I_ProjectDemand?

I_ProjectDemand is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ProjectDemand

DDL: I_PROJECTDEMAND Type: view BASIC

47 Fields 1 Data Sources 7 Associations

Project Demand

I_ProjectDemand (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_ProjectDemand is a Basic CDS View that provides data about "Project Demand" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemand) and exposes 47 fields with key field ProjectDemandUUID. It has 7 associations to related views.

SAP Help Documentation

Category	CDS Views for Project Demand
Status	Released

Purpose
This CDS view can only be used to retrieve data of 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

State	C1
Line of Business	R&D Engineering
Application Component	PPM-SCL-DMN
Capabilities	Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction
Package	R&D Engineering for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view can only be used to retrieve data of 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

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
R_ProjectDemand	R_ProjectDemand	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..1]	I_ProjectDemandMaterial	_Material	`_Material.ProjectDemandUUID = $projection.ProjectDemandUUID`
[0..1]	I_ProjectDemandService	_Service	`_Service.ProjectDemandUUID = $projection.ProjectDemandUUID`
[0..1]	I_ProjectDemandWork	_Work	`_Work.ProjectDemandUUID = $projection.ProjectDemandUUID`
[0..1]	I_ProjectDemandExpense	_Expense	`_Expense.ProjectDemandUUID = $projection.ProjectDemandUUID`
[1..1]	E_ProjectDemand	_ProjectDemandExtension	`$projection.ProjectDemandUUID = _ProjectDemandExtension.ProjectDemandUUID`
[0..1]	I_UnitOfMeasure	_ProjDmndQuantityUnit	`$projection.ProjDmndRequestedQuantityUnit = _ProjDmndQuantityUnit.UnitOfMeasure`
[0..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`

Annotations (19)

Name	Value	Level
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	IPROJECTDEMAND	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.dataMaintenance	#RESTRICTED	view
AbapCatalog.preserveKey	true	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.representativeKey	ProjectDemandUUID	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
Search.searchable	true	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Project Demand	view

Fields (47)

Key	Field	Source Field	Description
KEY	ProjectDemandUUID	ProjectDemandUUID	Global Identification of a Project Demand
	ProjectDemand	ProjectDemand	External ID of a Project Demand
	ProjectDemandName	ProjectDemandName	Project Demand Name
	ProjectDemandDescription	ProjectDemandDescription	Description of a Project Demand
	ProjectDemandCategory	ProjectDemandCategory	Project Demand Category
	ProjectDemandType	ProjectDemandType	Project Demand Type
	ReferencedObjectUUID	ReferencedObjectUUID	UUID of the Object to Which a Demand Is Related
	ProjectDemandStatus	ProjectDemandStatus	Project Demand Status
	ProjectDemandDateMaintenance	ProjectDemandDateMaintenance	Alignment of Project Demand Dates with WBS Element Dates
	ProjectDemandStartDate	ProjectDemandStartDate	Start Date of the Demand
	ProjectDemandEndDate	ProjectDemandEndDate	End Date of the Demand
	ProjectDemandReleasedDateTime	ProjectDemandReleasedDateTime	Timestamp of Demand Status Change to "Requested"
	ProjDmndActualSupplyDate	ProjDmndActualSupplyDate	Delivery Date of the Demand
	ProjectDemandPerUnitAmount	ProjectDemandPerUnitAmount	Price Per Unit
	ProjectDemandRequestCurrency	ProjectDemandRequestCurrency	Project Demand Currency
	ProjectDemandRequestNetAmount	ProjectDemandRequestNetAmount	Estimated Net Value of the Project Demand
	ProjDmndReqNetAmountCurrency	ProjDmndReqNetAmountCurrency	Project Demand Currency
	ProjectDemandOverallAmount	ProjectDemandOverallAmount	Overall Limit
	ProjDmndRequestedQuantity	ProjDmndRequestedQuantity	Required Quantity
	ProjDmndRequestedQuantityUnit	ProjDmndRequestedQuantityUnit	Unit of Measure for the Required Quantity
	PriceUnitQty	PriceUnitQty	Price unit
	Plant	Plant	Valuation Area
	PurchasingGroup	PurchasingGroup	Purchasing Group
	PurchasingOrganization	PurchasingOrganization	Purchasing Organization
	CreatedByUser	CreatedByUser	Name of the Person Who Created the Object
	CreationDateTime	CreationDateTime	Timestamp of Object Creation
	LastChangedByUser	LastChangedByUser	Last Changed By User
	LastChangeDateTime	LastChangeDateTime	Last Change Date Time
	ProjectDemandLastChangedByUser	ProjectDemandLastChangedByUser	User Who Last Changed a Demand (Sub-Entities Included)
	ProjDemandLastChangeDateTime	ProjDemandLastChangeDateTime	Timestamp of Last Change to a Demand (Sub-Entities Included)
	ProjectUUID	ProjectUUID	Global ID of the Project to Which a Demand is Related
	_Material	_Material
	_Service	_Service
	_Work	_Work
	_Expense	_Expense
	_ProjectDemandCategory	_ProjectDemandCategory
	_ProjectDemandType	_ProjectDemandType
	_WorkPackage	_WorkPackage
	_ProjectDemandStatus	_ProjectDemandStatus
	_ProjectDemandCurrency	_ProjectDemandCurrency
	_ProjectDemandNetCurrency	_ProjectDemandNetCurrency
	_ProjDmndQuantityUnit	_ProjDmndQuantityUnit
	_Plant	_Plant
	_PurchasingGroup	_PurchasingGroup
	_PurchasingOrganisation	_PurchasingOrganisation
	_Project	_Project
	_EnterpriseProjectForUser	_EnterpriseProjectForUser

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_ProjectDemand.
-- 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_ProjectDemand AS
SELECT
  ProjectDemandUUID,
  ProjectDemand,
  ProjectDemandName,
  ProjectDemandDescription,
  ProjectDemandCategory,
  ProjectDemandType,
  ReferencedObjectUUID,
  ProjectDemandStatus,
  ProjectDemandDateMaintenance,
  ProjectDemandStartDate,
  ProjectDemandEndDate,
  ProjectDemandReleasedDateTime,
  ProjDmndActualSupplyDate,
  ProjectDemandPerUnitAmount,
  ProjectDemandRequestCurrency,
  ProjectDemandRequestNetAmount,
  ProjDmndReqNetAmountCurrency,
  ProjectDemandOverallAmount,
  ProjDmndRequestedQuantity,
  ProjDmndRequestedQuantityUnit,
  PriceUnitQty,
  Plant,
  PurchasingGroup,
  PurchasingOrganization,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  ProjectDemandLastChangedByUser,
  ProjDemandLastChangeDateTime,
  ProjectUUID
FROM R_ProjectDemand
LEFT OUTER JOIN I_ProjectDemandMaterial AS _Material ON _Material.ProjectDemandUUID = ProjectDemandUUID  -- association [0..1]
LEFT OUTER JOIN I_ProjectDemandService AS _Service ON _Service.ProjectDemandUUID = ProjectDemandUUID  -- association [0..1]
LEFT OUTER JOIN I_ProjectDemandWork AS _Work ON _Work.ProjectDemandUUID = ProjectDemandUUID  -- association [0..1]
LEFT OUTER JOIN I_ProjectDemandExpense AS _Expense ON _Expense.ProjectDemandUUID = ProjectDemandUUID  -- association [0..1]
LEFT OUTER JOIN E_ProjectDemand AS _ProjectDemandExtension ON ProjectDemandUUID = _ProjectDemandExtension.ProjectDemandUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProjDmndQuantityUnit ON ProjDmndRequestedQuantityUnit = _ProjDmndQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;

Depth:

I_ProjectDemand view

R_ProjectDemand view_entity

I_AssgdWrkPckgForConcurPostgTP view_entity