I_ProjDmndSourceOfSupply

DDL: I_PROJDMNDSOURCEOFSUPPLY Type: view_entity BASIC

Resource Assignment Source for Proj Dmnds

I_ProjDmndSourceOfSupply (Basic)

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

Project Demand Source of Supply · R&D Engineering

I_ProjDmndSourceOfSupply is a Basic CDS View that provides data about "Resource Assignment Source for Proj Dmnds" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field ProjectDemandSourceOfSupply. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Project Demand
StatusReleased
Purpose
This CDS view can only be used to retrieve resource assignment sources for 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
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view can only be used to retrieve resource assignment sources for 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
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProjDmndSourceOfSupplyText _SourceOfSupplyText

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey ProjectDemandSourceOfSupply view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.sapObjectNodeType.name ProjectDemandSourceOfSupply view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Resource Assignment Source for Proj Dmnds view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandSourceOfSupply Source of a Resource Assignment
DomainValue dd07l domvalue_l Values for Domains: Single Value/Lower Limit
_SourceOfSupplyText _SourceOfSupplyText

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_ProjDmndSourceOfSupply.
-- 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_ProjDmndSourceOfSupply AS
SELECT
  cast( substring(domvalue_l, 1, 2 ) as tv_proj_dmnd_source_of_supply ) AS ProjectDemandSourceOfSupply,
  dd07l.domvalue_l AS DomainValue
FROM dd07l
LEFT OUTER JOIN I_ProjDmndSourceOfSupplyText AS _SourceOfSupplyText ON /* condition not available in parsed metadata */  -- association [0..*]
;