P_PPM_ObjectSeverityValues

DDL: P_PPM_OBJECTSEVERITYVALUES SQL: PPPMOBJSEVERVAL Type: view COMPOSITE Package: VDM_PPM_OBJECTS_COMMON

Retrieve severity for task, project, ... from database

P_PPM_ObjectSeverityValues is a Composite CDS View that provides data about "Retrieve severity for task, project, ... from database" in SAP S/4HANA. It reads from 3 data sources (I_PPM_SeverityValue, I_PPM_SeverityValue, I_PPM_Task) and exposes 3 fields with key field ReferencedObjectUUID. Part of development package VDM_PPM_OBJECTS_COMMON.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
I_PPM_SeverityValue aggregated_severity left_outer
I_PPM_SeverityValue manual_severity left_outer
I_PPM_Task Task from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPPMOBJSEVERVAL view
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality B view
ObjectModel.usageType.sizeCategory XL view
ObjectModel.usageType.dataClass MASTER view
ObjectModel.representativeKey ReferencedObjectUUID view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ReferencedObjectUUID I_PPM_Task TaskUUID
AggregatedSeverity
ManualSeverity 
@AbapCatalog.sqlViewName: 'PPPMOBJSEVERVAL'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.usageType.serviceQuality: 'B'
@ObjectModel.usageType.sizeCategory: 'XL'
@ObjectModel.usageType.dataClass: 'MASTER'

// @EndUserText.label: 'Retrieve severity for task, project or others from database'


@ObjectModel.representativeKey: 'ReferencedObjectUUID'

define view P_PPM_ObjectSeverityValues as select from I_PPM_Task as Task
// Aggregted severity

  left outer join I_PPM_SeverityValue as aggregated_severity
    on Task.TaskUUID = aggregated_severity.ReferencedObjectUUID
    and ( aggregated_severity.ViolationType = 'G' or aggregated_severity.ViolationType =  'A' )
// Manual Severity

  left outer join I_PPM_SeverityValue as manual_severity
    on Task.TaskUUID = manual_severity.ReferencedObjectUUID
    and ( manual_severity.ViolationType = 'M' )
 {
  
     key Task.TaskUUID as ReferencedObjectUUID,

     max( aggregated_severity.Severity ) as AggregatedSeverity,
     
     max( manual_severity.Severity ) as ManualSeverity
     
   }
   group by Task.TaskUUID, Task.TaskProcessingStatus;

Learn More