A_EHSControlForSafetyInfo

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_EHSControlForSafetyInfo.
-- 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: AEHSCTRLFORSRI

CREATE VIEW A_EHSControlForSafetyInfo AS
SELECT
  EHSRiskControl.EHSControlUUID AS EHSControlUUID,
  _EHSRiskRoot.EHSLocationUUID AS EHSLocationUUID,
  _EHSRiskRoot.EHSJobUUID AS EHSJobUUID,
  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,
  cast('03'as ehhss_ctrl_impl_status_nc) AS EHSControlImplStatus,
  bintohex(_EHSRiskRoot.EHSJobUUID) AS EHSJobUUIDHex,
  ResponsiblePerson
LEFT OUTER JOIN A_EHSLocationForSafetyInfo AS _EHSLocationForSafetyInfo ON ehslocationuuid = _EHSLocationForSafetyInfo.EHSLocationUUID  -- association [1..1]
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..*]
LEFT OUTER JOIN A_EHSJobForSafetyInfo AS _EHSJobForSafetyInfo ON ehsjobuuid = _EHSJobForSafetyInfo.EHSJobUUID AND ehslocationuuid = _EHSJobForSafetyInfo.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN A_EHSJobNameText AS _EHSJobNameText ON ehsjobuuid = _EHSJobNameText.EHSJobUUID  -- association [0..*]
;