I_HazardControl

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_HazardControl.
-- 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: IHAZARDCONTROL

CREATE VIEW I_HazardControl AS
SELECT
  HazardControlCatalog.Hazard AS Hazard,
  EHSControl.EHSControlUUID AS EHSControlUUID,
  EHSControl.EHSControlImageURL AS EHSControlImageURL,
  HazardControlCatalog.EHSControlCatalog AS EHSControlCatalog,
  HazardControlCatalog._EHSControlCatalog.EHSControlType AS EHSControlType,
  HazardControlCatalog._EHSControlCatalog.EHSControlSubtype AS EHSControlSubtype,
  HazardControlCatalog._Hazard AS _Hazard
FROM I_EHSControl AS EHSControl
LEFT OUTER JOIN I_EHSCtrlTitleText AS _EHSCtrlTitleTxt ON EHSControlUUID = _EHSCtrlTitleTxt.EHSControlUUID  -- association [1..*]
LEFT OUTER JOIN I_EHSCtrlCatalogText AS _EHSControlCatalogText ON EHSControlCatalog = _EHSControlCatalogText.EHSControlCatalog  -- association [0..*]
LEFT OUTER JOIN I_EHSCtrlTypeText AS _EHSControlTypeText ON ehscontroltype = _EHSControlTypeText.EHSControlType  -- association [0..*]
LEFT OUTER JOIN I_EHSCtrlSubtypeText AS _EHSControlSubtypeText ON ehscontrolsubtype = _EHSControlSubtypeText.EHSControlSubtype  -- association [0..*]
;