I_PPM_ObjectSeverity

DDL: I_PPM_OBJECTSEVERITY SQL: IPPMOBJSEVERITY Type: view COMPOSITE

Aggregated severity from Objects like Projects or Tasks

I_PPM_ObjectSeverity is a Composite CDS View that provides data about "Aggregated severity from Objects like Projects or Tasks" in SAP S/4HANA. It reads from 3 data sources (P_PPM_ActualObjectSeverity, I_PPM_Severity, I_PPM_SeverityText) and exposes 5 fields with key field ReferencedObjectUUID. It has 1 association to related views.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
P_PPM_ActualObjectSeverity Severity from
I_PPM_Severity SeveritySettings left_outer
I_PPM_SeverityText SeverityText left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PPM_SeverityText _SeverityText ( _SeverityText.Severity = $projection.Severity ) and ( _SeverityText.EvaluationEngineApplication = 'CPROJECTS' )

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName IPPMOBJSEVERITY view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Aggregated severity from Objects like Projects or Tasks view
Search.searchable true view
ObjectModel.representativeKey ReferencedObjectUUID view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ReferencedObjectUUID ReferencedObjectUUID
SeverityText I_PPM_SeverityText SeverityText
Severity P_PPM_ActualObjectSeverity Severity
CriticalityCode I_PPM_Severity CriticalityCode
_SeverityText _SeverityText 
@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
     
   }

                                                                                                 
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_SEVERITY",
"I_PPM_SEVERITYTEXT",
"P_PPM_ACTUALOBJECTSEVERITY"
],
"ASSOCIATED":
[
"I_PPM_SEVERITYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More