I_ProjDmndAssgmtStatus

DDL: I_PROJDMNDASSGMTSTATUS Type: view_entity BASIC

Assignment Status for Project Demands

I_ProjDmndAssgmtStatus (Basic)

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

Project Demand Assignment Status · R&D Engineering

I_ProjDmndAssgmtStatus is a Basic CDS View that provides data about "Assignment Status for Project Demands" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field ProjDmndAssgmtStatus. 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 assignment 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 .

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 assignment 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
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProjDmndAssgmtStatusText _AssignmentStatusText

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey ProjDmndAssgmtStatus view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.sapObjectNodeType.name ProjectDemandAssignmentStatus view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
EndUserText.label Assignment Status for Project Demands view
Search.searchable true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ProjDmndAssgmtStatus Assignment Status of a Resource Demand
DomainValue dd07l domvalue_l Values for Domains: Single Value/Lower Limit
_AssignmentStatusText _AssignmentStatusText

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