I_EHSRiskAssessmentRisk

@EndUserText.label: 'EHS Risk Assessment Risk'
@VDM.viewType: #BASIC 
@ObjectModel.representativeKey: 'EHSRiskAssessmentRiskUUID'
@AccessControl.authorizationCheck: #CHECK

@AbapCatalog.sqlViewName: 'IEHSRASRISK'
@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:  #L,         // < 10.000.000

                         dataClass: #TRANSACTIONAL }
                         
define view I_EHSRiskAssessmentRisk as select from ehhssd_ras_risk   
  association [1..1] to I_EHSRiskRevision as _EHSRiskRevision on $projection.EHSRiskRevisionUUID = _EHSRiskRevision.EHSRiskRevisionUUID
  association [1..1] to I_EHSRiskRoot     as _EHSRiskRoot on $projection.EHSRiskUUID = _EHSRiskRoot.EHSRiskUUID   
  association [0..1] to I_User            as _CreatedByUser on $projection.CreatedByUser = _CreatedByUser.UserID 
  association [0..1] to I_User            as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.UserID    
{
  
  key db_key                                              as EHSRiskAssessmentRiskUUID,
  
  parent_key                                              as EHSRiskAssessmentUUID,

  @ObjectModel.foreignKey.association: '_EHSRiskRoot'
  cast( risk_key as ehhss_risk_uuid_ref preserving type ) as EHSRiskUUID,
  _EHSRiskRoot,
  
  cast(datetime_cr as timestamp preserving type)          as CreationDateTime,
  user_id_cr                                              as CreatedByUser,
  _CreatedByUser,
   
  cast(datetime_ch as timestamp preserving type)          as LastChangeDateTime,
  user_id_ch                                              as LastChangedByUser,
  _LastChangedByUser, 
  
  @ObjectModel.foreignKey.association: '_EHSRiskRevision'
  rev_risk_key                                            as EHSRiskRevisionUUID,
  _EHSRiskRevision
  
}                                                                     
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHHSSD_RAS_RISK"
],
"ASSOCIATED":
[
"I_EHSRISKREVISION",
"I_EHSRISKROOT",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/