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_EHSRiskRoot.
-- 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: IEHSRSKROOT
CREATE VIEW I_EHSRiskRoot AS
SELECT
cast( db_key as ehhss_risk_uuid_ref preserving type ) AS EHSRiskUUID,
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 EHSRiskID,
cast ( hazard as ehhss_hazard_code_nc preserving type ) AS Hazard,
cast( loc_root_key_ref as ehfnd_location_uuid_ref preserving type ) AS EHSLocationUUID,
cast( ras_type as ehhss_ras_type_code_nc preserving type ) AS EHSRiskAssessmentType,
cast( agent_key_ref as ehhss_agent_uuid_ref preserving type ) AS PhysicalAgentUUID,
cast( cma_key_ref as ehhss_cma_uuid_ref preserving type ) AS ChemicalUUID,
cast( abagt_key_ref as ehhss_abagt_uuid_ref preserving type ) AS AirborneAgentUUID,
cast (risk_level as ehhss_risk_level_code_nc preserving type ) AS EHSRiskLevel,
cast( job_key_ref as ehhss_job_uuid_ref preserving type ) AS EHSJobUUID,
step_id AS EHSJobStep,
cast( haz_cat as ehhss_haz_category_code_nc preserving type ) AS HazardCategory,
cast( meth_of_use_code as ehfnd_method_of_use_nc preserving type ) AS MethodOfUse,
cast( operation_status as ehhss_opstatus_code_nc preserving type ) AS OperationalStatus,
is_simulated AS IsSimulatedEHSRisk,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].EHSLocationAuthorizationGroup AS EHSLocationAuthorizationGroup,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSLocationAuthGroup AS _EHSLocationAuthGroup,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].Plant AS Plant,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._Plant AS _Plant,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].CostCenter AS CostCenter,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].CompanyCode AS CompanyCode,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._CompanyCode AS _CompanyCode,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].BusinessArea AS BusinessArea,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._BusinessArea AS _BusinessArea,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].ControllingArea AS ControllingArea,
_EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._ControllingArea AS _ControllingArea
FROM ehhssd_rsk_root
LEFT OUTER JOIN I_EHSRiskRevision AS _EHSRiskRevision ON EHSRiskUUID = _EHSRiskRevision.EHSRiskUUID -- association [1..*]
LEFT OUTER JOIN I_Hazard AS _Hazard ON Hazard = _Hazard.Hazard -- association [1..1]
LEFT OUTER JOIN I_EHSLocationRoot AS _EHSLocationRoot ON EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID -- association [1..1]
LEFT OUTER JOIN I_EHSLocationRevision AS _EHSLocationRevision ON EHSLocationUUID = _EHSLocationRevision.EHSLocationUUID -- association [1..*]
LEFT OUTER JOIN I_EHSRiskAssessmentType AS _EHSRiskAssessmentType ON EHSRiskAssessmentType = _EHSRiskAssessmentType.EHSRiskAssessmentType -- association [1..1]
LEFT OUTER JOIN I_PhysicalAgent AS _PhysicalAgent ON PhysicalAgentUUID = _PhysicalAgent.PhysicalAgentUUID -- association [0..1]
LEFT OUTER JOIN I_ChemicalRoot AS _ChemicalRoot ON ChemicalUUID = _ChemicalRoot.ChemicalUUID -- association [0..1]
LEFT OUTER JOIN I_AirborneAgentRoot AS _AirborneAgentRoot ON AirborneAgentUUID = _AirborneAgentRoot.AirborneAgentUUID -- association [0..1]
LEFT OUTER JOIN I_EHSJob AS _EHSJob ON EHSJobUUID = _EHSJob.EHSJobUUID -- association [0..1]
LEFT OUTER JOIN I_EHSRiskLevel AS _EHSRiskLevel ON EHSRiskLevel = _EHSRiskLevel.EHSRiskLevel -- association [0..1]
LEFT OUTER JOIN I_HazardCategory AS _HazardCategory ON HazardCategory = _HazardCategory.HazardCategory -- association [1..1]
LEFT OUTER JOIN I_EHSMethodOfUse AS _EHSMethodOfUse ON MethodOfUse = _EHSMethodOfUse.MethodOfUse -- association [0..1]
LEFT OUTER JOIN I_EHSOperationalStatus AS _EHSOperationalStatus ON OperationalStatus = _EHSOperationalStatus.OperationalStatus -- association [0..1]
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]
;