C_EHSRisksForIdentifyRisks

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 C_EHSRisksForIdentifyRisks.
-- 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: CEHSRSKFORIDRSK

CREATE VIEW C_EHSRisksForIdentifyRisks AS
SELECT
  EHSRiskUUID,
  EHSRiskRevisionUUID,
  EHSRiskUUIDHex,
  EHSLocationUUID,
  EHSJobUUID,
  EHSJobStep,
  _EHSJobAtLocation.EHSJobAtLocationUUID AS EHSJobAtLocationUUID,
  Hazard,
  EHSAgentUUID,
  ChemicalUUID,
  AirborneAgentUUID,
  PhysicalAgentUUID,
  cast ( OperationalStatus as ehhss_opstatus_code_nc preserving type ) AS OperationalStatus,
  MethodOfUse,
  EHSRiskLevel,
  EHSRiskStatus,
  _EHSControlsCount.NumberOfEHSControls AS NumberOfEHSControls,
  cast( '' as text1024 ) AS EHSRiskImageURL,
  _EHSRiskLevel.EHSRiskLevelCriticality AS EHSRiskLevelCriticality,
  EHSRiskCommentUUID,
  C_EHSRisk.EHSRiskAssessmentType AS EHSRiskAssessmentType
FROM C_EHSRisk
LEFT OUTER JOIN I_EHSMethodOfUseText AS _MethodOfUseText ON MethodOfUse = _MethodOfUseText.MethodOfUse  -- association [0..*]
LEFT OUTER JOIN I_Hazard AS _Hazard ON Hazard = _Hazard.Hazard  -- association [1..1]
LEFT OUTER JOIN I_HazardText AS _HazardText ON Hazard = _HazardText.Hazard  -- association [0..*]
LEFT OUTER JOIN I_EHSOperationalStatusText AS _OperationalStatusText ON OperationalStatus = _OperationalStatusText.OperationalStatus  -- association [0..*]
LEFT OUTER JOIN I_EHSRiskLevelText AS _EHSRiskLevelText ON EHSRiskLevel = _EHSRiskLevelText.EHSRiskLevel  -- association [0..*]
LEFT OUTER JOIN I_EHSRiskStatusText AS _EHSRiskStatusText ON EHSRiskStatus = _EHSRiskStatusText.EHSRiskStatus  -- association [0..*]
LEFT OUTER JOIN P_EHSControlsCount AS _EHSControlsCount ON EHSRiskRevisionUUID = _EHSControlsCount.EHSRiskRevisionUUID  -- association [0..1]
LEFT OUTER JOIN C_AdhocEHSCtrlForIdentifyRisks AS _AdhocEHSControls ON EHSRiskRevisionUUID = _AdhocEHSControls.EHSRiskRevisionUUID  -- association [0..*]
LEFT OUTER JOIN C_StdEHSCtrlForIdentifyRisks AS _StandardEHSControls ON EHSRiskRevisionUUID = _StandardEHSControls.EHSRiskRevisionUUID  -- association [0..*]
LEFT OUTER JOIN I_CurrentEHSLocationNameText AS _EHSLocationName ON EHSLocationUUID = _EHSLocationName.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_HazardImpact AS _HazardImpact ON Hazard = _HazardImpact.Hazard  -- association [0..*]
LEFT OUTER JOIN I_HazardControl AS _HazardControl ON Hazard = _HazardControl.Hazard  -- association [0..*]
LEFT OUTER JOIN C_EHSRiskWithAssessmentProfile AS _EHSRiskWithAssessmentProfile ON EHSRiskUUID = _EHSRiskWithAssessmentProfile.EHSRiskUUID  -- association [1..1]
LEFT OUTER JOIN I_ChemicalNameText AS _ChemicalNameText ON ChemicalUUID = _ChemicalNameText.ChemicalUUID AND _ChemicalNameText.RevisionEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_AirborneAgentNameText AS _AirborneAgentNameText ON AirborneAgentUUID = _AirborneAgentNameText.AirborneAgentUUID AND _AirborneAgentNameText.RevisionEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_PhysicalAgentNameText AS _PhysicalAgentNameText ON PhysicalAgentUUID = _PhysicalAgentNameText.PhysicalAgentUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSJobAtLocation AS _EHSJobAtLocation ON EHSLocationUUID = _EHSJobAtLocation.EHSLocationUUID AND EHSJobUUID = _EHSJobAtLocation.EHSJobUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSJobStepForJobAtLocation AS _EHSJobStepForJobAtLocation ON EHSJobAtLocationUUID = _EHSJobStepForJobAtLocation.EHSJobAtLocationUUID AND EHSJobStep = _EHSJobStepForJobAtLocation.EHSJobStep  -- association [0..1]
;