I_EHSRiskOverviewC

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 I_EHSRiskOverviewC.
-- 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: IEHSRSKOVERVIEWC
-- Parameters: P_Language : sylangu, P_KeyDate : sydatum

CREATE VIEW I_EHSRiskOverviewC AS
SELECT
  I_EHSRisk.EHSRiskUUID AS EHSRiskUUID,
  _EHSRiskRoot.Hazard AS Hazard,
  _EHSRiskRoot._Hazard AS _Hazard,
  _EHSRiskRoot.HazardCategory AS HazardCategory,
  _EHSRiskRoot._HazardCategory AS _HazardCategory,
  _EHSRiskRoot.EHSRiskLevel AS EHSRiskLevel,
  _EHSRiskRoot._EHSRiskLevel AS _EHSRiskLevel,
  _EHSRiskRoot.EHSJobUUID AS EHSJobUUID,
  _EHSRiskRoot._EHSJob AS _EHSJob,
  EHSRiskAssessmentUUID,
  I_EHSRisk.EHSRiskStatus AS EHSRiskStatus,
  I_EHSRisk.EHSLocationUUID AS EHSLocationUUID,
  cast (1 as ehhss_number_of_risks) AS NumberOfEHSRisks,
  I_EHSRisk._EHSRiskRoot AS _EHSRiskRoot
FROM I_EHSRisk
INNER JOIN I_MyEHSLocationExpanded ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSAgent AS _Agent ON EHSAgentUUID = _Agent.EHSAgentUUID  -- association [0..*]
LEFT OUTER JOIN I_RatedEHSRiskLevel AS _RatedEHSRiskLevel ON _RatedEHSRiskLevel.LinkFlagIsOne = 1  -- association [1..1]
;