I_ProjDmndAndWorkPackageStatus

DDL: I_PROJDMNDANDWORKPACKAGESTATUS SQL: IPROJDMNDWPSTAT Type: view COMPOSITE
9 Fields 1 Data Sources 2 Associations

Project Demand and Work Package Status

I_ProjDmndAndWorkPackageStatus is a Composite CDS View that provides data about "Project Demand and Work Package Status" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemand) and exposes 9 fields with key field ProjectDemandUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemand R_ProjectDemand from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EnterpriseProjectElement _WorkPackage $projection.ReferencedObjectUUID = _WorkPackage.ProjectElementUUID
[0..1] I_EnterpriseProject _Project $projection.ReferencedObjectUUID = _Project.ProjectSummaryTaskUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPROJDMNDWPSTAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.uniqueIdField ProjectDemandFormattedName view
EndUserText.label Project Demand and Work Package Status view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandUUID ProjectDemandUUID Entity GUID
ProjectDemand ProjectDemand Project Demand
ProjectDemandStatus ProjectDemandStatus Project Demand Status
ProjectDemandFormattedName
ReferencedObjectUUID ReferencedObjectUUID Referenced Object
ProcessingStatusendasProcessingStatus Work Package Status
ProjectendasProjectElement Work Package
_WorkPackage _WorkPackage
_Project _Project

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_ProjDmndAndWorkPackageStatus.
-- 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.
-- SQL view name: IPROJDMNDWPSTAT

CREATE VIEW I_ProjDmndAndWorkPackageStatus AS
SELECT
  ProjectDemandUUID,
  ProjectDemand,
  ProjectDemandStatus,
  bintohex(ProjectDemandUUID) AS ProjectDemandFormattedName,
  ReferencedObjectUUID,
  case when ReferencedObjectUUID = _WorkPackage.ProjectElementUUID then _WorkPackage.ProcessingStatus when ReferencedObjectUUID = _Project.ProjectSummaryTaskUUID then _Project.ProcessingStatus end as ProcessingStatus AS ProcessingStatusendasProcessingStatus,
  case when ReferencedObjectUUID = _WorkPackage.ProjectElementUUID then _WorkPackage.ProjectElement when ReferencedObjectUUID = _Project.ProjectSummaryTaskUUID then _Project.Project end as ProjectElement AS ProjectendasProjectElement
FROM R_ProjectDemand
LEFT OUTER JOIN I_EnterpriseProjectElement AS _WorkPackage ON ReferencedObjectUUID = _WorkPackage.ProjectElementUUID  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseProject AS _Project ON ReferencedObjectUUID = _Project.ProjectSummaryTaskUUID  -- association [0..1]
;

Learn More