I_PPM_SEVERITYVALUE

CDS View

Severity Value

I_PPM_SEVERITYVALUE is a CDS View in S/4HANA. Severity Value. It contains 6 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 6 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_PPM_CollectedSeverityForTask view left_outer COMPOSITE Collected Severity For Task
P_PPM_AggregatedSeverity view from COMPOSITE
P_PPM_ChcklstItmSeverityValues view left_outer BASIC
P_PPM_ObjectSeverityValues view left_outer COMPOSITE
P_PPM_TaskRelatedSeverity view from COMPOSITE

Fields (6)

KeyField CDS FieldsUsed in Views
KEY ViolationUUID ViolationUUID 2
ProjectSummaryTaskUUID ProjectSummaryTaskUUID 2
ReferencedObjectUUID ReferencedObjectUUID 1
Severity Severity 2
Threshold Threshold 1
ViolationType ViolationType 2 
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IPPMSEVERITYVAL'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory:  #M
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Severity Value'
@ObjectModel.representativeKey: 'ViolationUUID'
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_PPM_SeverityValue
  as select from eve_threshold_vl as thresh_val
  inner join cgpl_hierarchy as hier on hier.guid = thresh_val.root_object_guid
  association [0..1] to I_PPM_Severity       as _Severity  on  $projection.EvaluationEngineApplication = _Severity.EvaluationEngineApplication
                                                           and $projection.Severity                    = _Severity.Severity
  association [0..1] to I_PPM_ThresholdIssue as _Threshold on  $projection.EvaluationEngineApplication = _Threshold.EvaluationEngineApplication
                                                           and $projection.Threshold                   = _Threshold.Threshold
{
  key thresh_val.th_guid          as ViolationUUID,
      thresh_val.application      as EvaluationEngineApplication,
      thresh_val.threshold        as Threshold,
      thresh_val.severity         as Severity,
      thresh_val.violation_type   as ViolationType,
      thresh_val.object_guid      as ReferencedObjectUUID,
      case
      when hier.up > hextobin('00000000000000000000000000000000') then hier.up
      else thresh_val.root_object_guid end as ProjectSummaryTaskUUID,
      _Severity,
      _Threshold
}           
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"CGPL_HIERARCHY",
"EVE_THRESHOLD_VL"
],
"ASSOCIATED":
[
"I_PPM_SEVERITY",
"I_PPM_THRESHOLDISSUE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More