I_RatedEHSRiskLevel

DDL: I_RATEDEHSRISKLEVEL SQL: IEHSRSKLVLRTD Type: view COMPOSITE

EHS Risk Level for priority

I_RatedEHSRiskLevel is a Composite CDS View (Dimension) that provides data about "EHS Risk Level for priority" in SAP S/4HANA. It reads from 1 data source (P_EHSRiskLevelPrio1) and exposes 7 fields with key field LinkFlagIsOne. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
P_EHSRiskLevelPrio1 P_EHSRiskLevelPrio1 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_EHSRiskLevelPrio2 _EHSRiskLevelPrio2 _EHSRiskLevelPrio2.LinkFlagIsOne = 1
[0..1] P_EHSRiskLevelPrio3 _EHSRiskLevelPrio3 _EHSRiskLevelPrio3.LinkFlagIsOne = 1

Annotations (13)

NameValueLevelField
EndUserText.label EHS Risk Level for priority view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey LinkFlagIsOne view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IEHSRSKLVLRTD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY LinkFlagIsOne 1
EHSRiskLevelPrio1 P_EHSRiskLevelPrio1 EHSRiskLevel
_EHSRiskLevelPrio1Text P_EHSRiskLevelPrio1 _Text
EHSRiskLevelPrio2 _EHSRiskLevelPrio2 EHSRiskLevel
_EHSRiskLevelPrio2Text _EHSRiskLevelPrio2 _Text
EHSRiskLevelPrio3 _EHSRiskLevelPrio3 EHSRiskLevel
_EHSRiskLevelPrio3Text _EHSRiskLevelPrio3 _Text 
@EndUserText.label: 'EHS Risk Level for priority'
@Analytics: { dataCategory:#DIMENSION , dataExtraction.enabled:true }
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'LinkFlagIsOne'
@AccessControl.authorizationCheck: #NOT_REQUIRED

@AbapCatalog.sqlViewName: 'IEHSRSKLVLRTD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
// Client handling by session 

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec   

                         sizeCategory:  #S,         // < 1.000

                         dataClass: #MIXED } 

define view I_RatedEHSRiskLevel
  as select from P_EHSRiskLevelPrio1
  association [0..1] to P_EHSRiskLevelPrio2 as _EHSRiskLevelPrio2 on _EHSRiskLevelPrio2.LinkFlagIsOne = 1
  association [0..1] to P_EHSRiskLevelPrio3 as _EHSRiskLevelPrio3 on _EHSRiskLevelPrio3.LinkFlagIsOne = 1
{
  key 1 as LinkFlagIsOne,
  @ObjectModel.text.association: '_EHSRiskLevelPrio1Text'
  P_EHSRiskLevelPrio1.EHSRiskLevel as EHSRiskLevelPrio1,
  @ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes:true
  P_EHSRiskLevelPrio1._Text as _EHSRiskLevelPrio1Text,
  @ObjectModel.text.association: '_EHSRiskLevelPrio2Text'
  _EHSRiskLevelPrio2.EHSRiskLevel as EHSRiskLevelPrio2,  
  @ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes:true
  _EHSRiskLevelPrio2._Text as _EHSRiskLevelPrio2Text,
  @ObjectModel.text.association: '_EHSRiskLevelPrio3Text'
  _EHSRiskLevelPrio3.EHSRiskLevel as EHSRiskLevelPrio3,
  @ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes:true
  _EHSRiskLevelPrio3._Text as _EHSRiskLevelPrio3Text
}   
               
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_EHSRISKLEVELPRIO1",
"P_EHSRISKLEVELPRIO2",
"P_EHSRISKLEVELPRIO3"
],
"ASSOCIATED":
[
"I_EHSRISKLEVELTEXT",
"P_EHSRISKLEVELPRIO2",
"P_EHSRISKLEVELPRIO3"
],
"BASE":
[
"P_EHSRISKLEVELPRIO1",
"P_EHSRISKLEVELPRIO2",
"P_EHSRISKLEVELPRIO3"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More