A_EHSRiskForSafetyInfo

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_EHSRiskForSafetyInfo.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: AEHSRISKFORSRI

CREATE VIEW A_EHSRiskForSafetyInfo AS
SELECT
  EHSRiskUUID,
  EHSLocationUUID,
  Hazard,
  EHSRiskAssessmentType,
  _EHSRiskRoot.EHSAgentUUID AS EHSAgentUUID,
  EHSRisk._EHSRiskRoot.MethodOfUse AS MethodOfUse,
  _EHSRiskRoot.EHSRiskLevel AS EHSRiskLevel,
  EHSRiskStatus,
  _EHSRiskRoot.OperationalStatus AS OperationalStatus,
  HazardCategory,
  _HazardCategory.EHSAgentType AS EHSAgentType,
  _EHSRiskRoot.EHSJobUUID AS EHSJobUUID,
  bintohex(EHSRisk._EHSRiskRoot.EHSJobUUID) AS EHSJobUUIDHex,
  EHSRiskAssessmentUUID,
  _EHSRiskRoot.EHSLocationAuthorizationGroup AS EHSLocationAuthorizationGroup,
  _EHSRiskRoot.Plant AS Plant,
  _EHSRiskRoot.CostCenter AS CostCenter,
  _EHSRiskRoot.CompanyCode AS CompanyCode,
  _EHSRiskRoot.BusinessArea AS BusinessArea
FROM I_EHSRisk AS EHSRisk
LEFT OUTER JOIN A_EHSRiskControlForSafetyInfo AS _EHSRiskControls ON EHSRiskUUID = _EHSRiskControls.EHSRiskUUID  -- association [0..*]
LEFT OUTER JOIN A_HazardText AS _HazardText ON Hazard = _HazardText.Hazard  -- association [1..*]
LEFT OUTER JOIN A_EHSRiskAssessmentTypeText AS _EHSRiskAssessmentTypeText ON EHSRiskAssessmentType = _EHSRiskAssessmentTypeText.EHSRiskAssessmentType  -- association [0..*]
LEFT OUTER JOIN A_CurrentEHSAgentNameText AS _CurrentEHSAgentNameText ON ehsagentuuid = _CurrentEHSAgentNameText.EHSAgentUUID  -- association [0..*]
LEFT OUTER JOIN A_EHSMethodOfUseText AS _EHSMethodOfUseText ON MethodOfUse = _EHSMethodOfUseText.MethodOfUse  -- association [0..*]
LEFT OUTER JOIN A_EHSRiskLevelText AS _EHSRiskLevelText ON ehsrisklevel = _EHSRiskLevelText.EHSRiskLevel  -- association [0..*]
LEFT OUTER JOIN A_EHSRiskStatusText AS _EHSRiskStatusText ON EHSRiskStatus = _EHSRiskStatusText.EHSRiskStatus  -- association [0..*]
LEFT OUTER JOIN A_EHSOperationalStatusText AS _EHSOperationalStatusText ON operationalstatus = _EHSOperationalStatusText.OperationalStatus  -- association [0..*]
LEFT OUTER JOIN A_EHSAgentTypeText AS _EHSAgentTypeText ON ehsagenttype = _EHSAgentTypeText.EHSAgentType  -- association [0..*]
LEFT OUTER JOIN A_HazardCategoryText AS _HazardCategoryText ON HazardCategory = _HazardCategoryText.HazardCategory  -- association [0..*]
LEFT OUTER JOIN A_EHSJobNameText AS _EHSJobNameText ON ehsjobuuid = _EHSJobNameText.EHSJobUUID  -- association [0..*]
LEFT OUTER JOIN A_CurrentEHSLocationNameText AS _CurrentEHSLocationNameText ON EHSLocationUUID = _CurrentEHSLocationNameText.EHSLocationUUID  -- association [0..*]
;