A_EHSRiskControlForSafetyInfo

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_EHSRiskControlForSafetyInfo.
-- 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: AEHSRSKCTRLSRI

CREATE VIEW A_EHSRiskControlForSafetyInfo AS
SELECT
  EHSControlInstanceUUID,
  cast( EHSRiskUUID as ehhss_risk_uuid_ref preserving type ) AS EHSRiskUUID,
  EHSRiskControl.EHSControlUUID AS EHSControlUUID,
  cast( _EHSControl.EHSControlCatalog as ehfnd_control_code_nc preserving type ) AS EHSControlCatalog,
  cast( _EHSControl._EHSCatalog.EHSControlType as ehhss_control_type_code preserving type ) AS EHSControlType,
  cast ( _EHSControl._EHSCatalog.EHSControlSubtype as ehhss_control_subtype_code preserving type ) AS EHSControlSubtype,
  EHSControlImplStatus,
  ResponsiblePerson
FROM I_EHSRiskControl AS EHSRiskControl
LEFT OUTER JOIN A_EHSCtrlTitleText AS _EHSCtrlTitleText ON EHSControlUUID = _EHSCtrlTitleText.EHSControlUUID  -- association [1..*]
LEFT OUTER JOIN A_EHSCtrlCatalogText AS _EHSCtrlCatalogText ON EHSControlCatalog = _EHSCtrlCatalogText.EHSControlCatalog  -- association [1..*]
LEFT OUTER JOIN A_EHSCtrlTypeText AS _EHSCtrlTypeText ON EHSControlType = _EHSCtrlTypeText.EHSControlType  -- association [0..*]
LEFT OUTER JOIN A_EHSCtrlSubtypeText AS _EHSCtrlSubtypeText ON EHSControlSubtype = _EHSCtrlSubtypeText.EHSControlSubtype  -- association [0..*]
LEFT OUTER JOIN A_EHSCtrlImplmtnStatusText AS _EHSCtrlImplmtnStatusText ON EHSControlImplStatus = _EHSCtrlImplmtnStatusText.EHSControlImplStatus  -- association [0..*]
;