I_ProjectDemandStatusText

DDL: I_PROJECTDEMANDSTATUSTEXT Type: view BASIC
5 Fields 1 Data Sources 1 Associations

Project Demand Status - Text

I_ProjectDemandStatusText (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_ProjectDemandStatusText is a Basic CDS View that provides data about "Project Demand Status - Text" in SAP S/4HANA. It reads from 1 data source (dmnd_proj_stat_t) and exposes 5 fields with key fields ProjectDemandStatus, Language. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentPPM-SCL-DMN
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source 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 demand statuses 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
dmnd_proj_stat_t dmnd_proj_stat_t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (18)

NameValueLevelField
EndUserText.label Project Demand Status - Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.dataMaintenance #RESTRICTED view
AbapCatalog.sqlViewName IPRJDMNDSTATTXT view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.representativeKey ProjectDemandStatus view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.resultSet.sizeCategory #XS view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandStatus status Project Demand Status
KEY Language langu Primary lang.
ProjectDemandStatusText description Name of the Project Demand Status
_Status _Status
_Language _Language

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_ProjectDemandStatusText.
-- 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_ProjectDemandStatusText AS
SELECT
  status AS ProjectDemandStatus,
  langu AS Language,
  description AS ProjectDemandStatusText
FROM dmnd_proj_stat_t
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More