I_EHSRiskAssessment

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_EHSRiskAssessment.
-- 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: IEHSRASROOT

CREATE VIEW I_EHSRiskAssessment AS
SELECT
  cast( db_key as ehhss_ras_uuid_ref preserving type ) AS EHSRiskAssessmentUUID,
  cast(datetime_cr as timestamp preserving type) AS CreationDateTime,
  user_id_cr AS CreatedByUser,
  cast(datetime_ch as timestamp preserving type) AS LastChangeDateTime,
  user_id_ch AS LastChangedByUser,
  id AS EHSRiskAssessmentID,
  cast(type as ehhss_ras_type_code_nc preserving type) AS EHSRiskAssessmentType,
  title AS EHSRiskAssessmentTitle,
  cast( job_root_key_ref as ehhss_job_uuid_ref preserving type ) AS EHSJobUUID,
  cast( loc_key_ref as ehfnd_location_uuid_ref preserving type ) AS EHSLocationUUID,
  cast(op_status_code as ehhss_opstatus_code_nc preserving type) AS OperationalStatus,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].EHSLocationAuthorizationGroup AS EHSLocationAuthorizationGroup,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSLocationAuthGroup AS _EHSLocationAuthGroup,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].BusinessArea AS BusinessArea,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._BusinessArea AS _BusinessArea,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].Plant AS Plant,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._Plant AS _Plant,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].CostCenter AS CostCenter,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].CompanyCode AS CompanyCode,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._CompanyCode AS _CompanyCode,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].ControllingArea AS ControllingArea,
  _EHSLoc[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._ControllingArea AS _ControllingArea,
  bintohex(loc_key_ref) AS EHSLocationUUIDHex,
  is_simulated AS IsSimulatedEHSRiskAssessment,
  status AS EHSRiskAssessmentStatus
FROM ehhssd_ras_root
LEFT OUTER JOIN I_EHSRiskAssessmentType AS _EHSRiskAssessmentType ON EHSRiskAssessmentType = _EHSRiskAssessmentType.EHSRiskAssessmentType  -- association [1..1]
LEFT OUTER JOIN I_EHSJob AS _EHSJob ON EHSJobUUID = _EHSJob.EHSJobUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSRiskAssessmentRisk AS _Risk ON EHSRiskAssessmentUUID = _Risk.EHSRiskAssessmentUUID  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationRevision AS _EHSLoc ON EHSLocationUUID = _EHSLoc.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSRiskAssessmentStatus AS _EHSRiskAssessmentStatus ON EHSRiskAssessmentStatus = _EHSRiskAssessmentStatus.EHSRiskAssessmentStatus  -- association [1..1]
LEFT OUTER JOIN I_EHSRiskAssessmentLead AS _EHSRiskAssessmentLead ON EHSRiskAssessmentUUID = _EHSRiskAssessmentLead.EHSRiskAssessmentUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSOperationalStatus AS _OperationalStatus ON OperationalStatus = _OperationalStatus.OperationalStatus  -- association [0..1]
;