I_HazardControl

DDL: I_HAZARDCONTROL SQL: IHAZARDCONTROL Type: view COMPOSITE

Hazard Control

I_HazardControl is a Composite CDS View that provides data about "Hazard Control" in SAP S/4HANA. It reads from 1 data source (I_EHSControl) and exposes 11 fields with key fields Hazard, EHSControlUUID. It has 4 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_EHSControl EHSControl from

Associations (4)

CardinalityTargetAliasCondition
[1..*] I_EHSCtrlTitleText _EHSCtrlTitleTxt $projection.EHSControlUUID = _EHSCtrlTitleTxt.EHSControlUUID
[0..*] I_EHSCtrlCatalogText _EHSControlCatalogText $projection.EHSControlCatalog = _EHSControlCatalogText.EHSControlCatalog
[0..*] I_EHSCtrlTypeText _EHSControlTypeText $projection.ehscontroltype = _EHSControlTypeText.EHSControlType
[0..*] I_EHSCtrlSubtypeText _EHSControlSubtypeText $projection.ehscontrolsubtype = _EHSControlSubtypeText.EHSControlSubtype

Annotations (10)

NameValueLevelField
EndUserText.label Hazard Control view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IHAZARDCONTROL 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 #CUSTOMIZING view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Hazard HazardControlCatalog Hazard
KEY EHSControlUUID I_EHSControl EHSControlUUID
_EHSCtrlTitleTxt _EHSCtrlTitleTxt
EHSControlImageURL I_EHSControl EHSControlImageURL
EHSControlCatalog HazardControlCatalog EHSControlCatalog
_EHSControlCatalogText _EHSControlCatalogText
EHSControlType
_EHSControlTypeText _EHSControlTypeText
EHSControlSubtype
_EHSControlSubtypeText _EHSControlSubtypeText
_Hazard HazardControlCatalog _Hazard 

@EndUserText.label: 'Hazard Control'
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: ['Hazard','EHSControlUUID']
@AccessControl.authorizationCheck: #CHECK

@AbapCatalog.sqlViewName: 'IHAZARDCONTROL'
@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: #CUSTOMIZING } 

define view I_HazardControl as select from I_EHSControl as EHSControl
  join I_HazardControlCatalog as HazardControlCatalog on EHSControl.EHSControlCatalog = HazardControlCatalog.EHSControlCatalog 
  association [1..*] to I_EHSCtrlTitleText   as _EHSCtrlTitleTxt on $projection.EHSControlUUID = _EHSCtrlTitleTxt.EHSControlUUID
  association [0..*] to I_EHSCtrlCatalogText as _EHSControlCatalogText on $projection.EHSControlCatalog = _EHSControlCatalogText.EHSControlCatalog 
  association [0..*] to I_EHSCtrlTypeText    as _EHSControlTypeText on $projection.ehscontroltype = _EHSControlTypeText.EHSControlType 
  association [0..*] to I_EHSCtrlSubtypeText as _EHSControlSubtypeText on $projection.ehscontrolsubtype = _EHSControlSubtypeText.EHSControlSubtype
{
  @ObjectModel.foreignKey.association: '_Hazard'
  key HazardControlCatalog.Hazard,
  
  @ObjectModel.text.association: '_EHSCtrlTitleTxt'
  key EHSControl.EHSControlUUID,
  _EHSCtrlTitleTxt,
  
  @Semantics.imageUrl 
  EHSControl.EHSControlImageURL,
  
  @ObjectModel.text.association: '_EHSControlCatalogText'
  HazardControlCatalog.EHSControlCatalog,
  _EHSControlCatalogText,
  
  @ObjectModel.text.association: '_EHSControlTypeText'
  HazardControlCatalog._EHSControlCatalog.EHSControlType,
  _EHSControlTypeText,
  
  @ObjectModel.text.association: '_EHSControlSubtypeText'
  HazardControlCatalog._EHSControlCatalog.EHSControlSubtype,
  _EHSControlSubtypeText,
  
  HazardControlCatalog._Hazard
  
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EHSCONTROL",
"I_EHSCTRLCATALOG",
"I_HAZARDCONTROLCATALOG"
],
"ASSOCIATED":
[
"I_EHSCTRLCATALOGTEXT",
"I_EHSCTRLSUBTYPETEXT",
"I_EHSCTRLTITLETEXT",
"I_EHSCTRLTYPETEXT",
"I_HAZARD"
],
"BASE":
[
"I_HAZARDCONTROLCATALOG"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More