I_PPM_OBJECTSEVERITY

CDS View

Aggregated severity from Objects like Projects or Tasks

I_PPM_OBJECTSEVERITY is a CDS View in S/4HANA. Aggregated severity from Objects like Projects or Tasks. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PPM_MostCriticalProject view left_outer COMPOSITE My Projects - Critical
I_PPM_ProjectCopilot view left_outer COMPOSITE Project header info for Copilot

Fields (4)

KeyField CDS FieldsUsed in Views
_SeverityText _SeverityText 1
CriticalityCode CriticalityCode 1
Severity Severity 2
SeverityText SeverityText 1 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'IPPMOBJSEVERITY'
@VDM.viewType: #COMPOSITE

@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Aggregated severity from Objects like Projects or Tasks'
@Search.searchable: true
@ObjectModel.representativeKey: 'ReferencedObjectUUID'
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_PPM_ObjectSeverity as select from P_PPM_ActualObjectSeverity as Severity
    left outer join I_PPM_SeverityText as SeverityText
         on SeverityText.Severity              = Severity.Severity
        and SeverityText.EvaluationEngineApplication    = 'CPROJECTS'
        and SeverityText.LanguageCode                   = $session.system_language
    left outer join I_PPM_Severity as SeveritySettings
         on SeveritySettings.Severity = Severity.Severity
    association [0..*] to I_PPM_SeverityText as _SeverityText 
            on ( _SeverityText.Severity             = $projection.Severity )
           and ( _SeverityText.EvaluationEngineApplication   = 'CPROJECTS' )
    {
      
    key ReferencedObjectUUID,
     
     @Search.defaultSearchElement: true
     SeverityText.SeverityText,

     @ObjectModel.foreignKey.association: '_SeverityText'
     @ObjectModel.text.association: '_SeverityText'      
     Severity.Severity,     
     SeveritySettings.CriticalityCode   as CriticalityCode     
     , _SeverityText
     
   }

Learn More