I_ProjDmndAndWorkPackageStatus

DDL: I_PROJDMNDANDWORKPACKAGESTATUS SQL: IPROJDMNDWPSTAT Type: view COMPOSITE Package: ODATA_PS_DMND_MAINTAIN

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. Part of development package ODATA_PS_DMND_MAINTAIN.

1 data source(s) 9 fields

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
ProjectDemand ProjectDemand Project Demand
ProjectDemandStatus ProjectDemandStatus Project Demand Status
ProjectDemandFormattedName
ReferencedObjectUUID ReferencedObjectUUID
ProcessingStatusendasProcessingStatus Work Package Status
ProjectendasProjectElement Work Package
_WorkPackage _WorkPackage
_Project _Project 
@AbapCatalog.sqlViewName: 'IPROJDMNDWPSTAT'
@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #COMPOSITE

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:{
                usageType:{
                            serviceQuality: #C,
                            sizeCategory: #M,
                            dataClass: #TRANSACTIONAL
                           },
                semanticKey:  ['ProjectElement', 'ProjectDemand'],
                uniqueIdField: 'ProjectDemandFormattedName'
             }

@EndUserText.label: 'Project Demand and Work Package Status'
define view I_ProjDmndAndWorkPackageStatus as select from R_ProjectDemand 
  
  association [0..1] to I_EnterpriseProjectElement as _WorkPackage on $projection.ReferencedObjectUUID = _WorkPackage.ProjectElementUUID
  
  association [0..1] to I_EnterpriseProject as _Project on $projection.ReferencedObjectUUID = _Project.ProjectSummaryTaskUUID
  
{
  @UI.hidden : true
  key ProjectDemandUUID,
     
      @EndUserText.label: 'Project Demand'
      ProjectDemand,
      
      @EndUserText.label: 'Project Demand Status'
      ProjectDemandStatus,
      
      @UI.hidden: true
      bintohex(ProjectDemandUUID) as ProjectDemandFormattedName,
   
      @UI.hidden : true
      ReferencedObjectUUID,
      
      @EndUserText.label: 'Work Package Status'
      case
        when ReferencedObjectUUID = _WorkPackage.ProjectElementUUID
          then _WorkPackage.ProcessingStatus
        
        when ReferencedObjectUUID = _Project.ProjectSummaryTaskUUID
          then _Project.ProcessingStatus
      
      end as ProcessingStatus,
      
      @EndUserText.label: 'Work Package'
      case
        when ReferencedObjectUUID = _WorkPackage.ProjectElementUUID
          then _WorkPackage.ProjectElement
        
        when ReferencedObjectUUID = _Project.ProjectSummaryTaskUUID
          then _Project.Project
      
      end as ProjectElement,
      
      _WorkPackage,
      
      _Project   
}

Learn More