C_EHSRisk

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 C_EHSRisk.
-- 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: CEHSRSK

CREATE VIEW C_EHSRisk AS
SELECT
  I_EHSRisk.EHSRiskUUID AS EHSRiskUUID,
  I_EHSRisk.EHSRiskRevisionUUID AS EHSRiskRevisionUUID,
  bintohex(I_EHSRisk.EHSRiskUUID) AS EHSRiskUUIDHex,
  EHSRiskID,
  _OTRText[1: OnlnTxtRpstryConceptID = '005056AB02261ED2899A901A8ED6DE96'].Text AS EHSRiskDisplayDetailsText,
  I_EHSRisk.Hazard AS Hazard,
  I_EHSRisk.HazardCategory AS HazardCategory,
  I_EHSRisk.ChemicalUUID AS ChemicalUUID,
  I_EHSRisk.AirborneAgentUUID AS AirborneAgentUUID,
  I_EHSRisk.PhysicalAgentUUID AS PhysicalAgentUUID,
  I_EHSRisk.EHSLocationUUID AS EHSLocationUUID,
  I_EHSRisk.EHSJobUUID AS EHSJobUUID,
  I_EHSRisk.EHSJobStep AS EHSJobStep,
  I_EHSRisk.EHSRiskAssessmentUUID AS EHSRiskAssessmentUUID,
  bintohex(I_EHSRisk.EHSRiskAssessmentUUID) AS EHSRiskAssessmentUUIDHex,
  EHSRiskAssessmentType,
  I_EHSRisk.EHSRiskLevel AS EHSRiskLevel,
  I_EHSRisk.EHSRiskStatus AS EHSRiskStatus,
  I_EHSRisk._EHSRiskStatus AS _EHSRiskStatus,
  I_EHSRisk.OperationalStatus AS OperationalStatus,
  I_EHSRisk._EHSOperationalStatus AS _EHSOperationalStatus,
  I_EHSRisk.MethodOfUse AS MethodOfUse,
  I_EHSRisk._EHSMethodOfUse AS _EHSMethodOfUse,
  EHSRiskCommentUUID,
  _EHSLocation.StorageLocation AS StorageLocation,
  _EHSLocation._StorageLocation AS _StorageLocation,
  _EHSLocation.EHSLocationAuthorizationGroup AS EHSLocationAuthorizationGroup,
  _EHSLocation._EHSLocationAuthGroup AS _EHSLocationAuthGroup,
  _EHSLocation.BusinessArea AS BusinessArea,
  _EHSLocation._BusinessArea AS _BusinessArea,
  _EHSLocation.Plant AS Plant,
  _EHSLocation._Plant AS _Plant,
  _EHSLocation.CostCenter AS CostCenter,
  _EHSLocation.CompanyCode AS CompanyCode,
  _EHSLocation._CompanyCode AS _CompanyCode,
  _EHSLocation.ControllingArea AS ControllingArea,
  _EHSLocation._ControllingArea AS _ControllingArea,
  _EHSLocation.OrganizationalUnit AS OrganizationalUnit,
  _EHSLocation._OrganizationalUnit AS _OrganizationalUnit
FROM I_EHSRisk
LEFT OUTER JOIN C_EHSRiskAssessment AS _EHSRiskAssessment ON EHSRiskAssessmentUUID = _EHSRiskAssessment.EHSRiskAssessmentUUID  -- association [1..1]
LEFT OUTER JOIN C_EHSAgent AS _EHSAgent ON EHSAgentUUID = _EHSAgent.EHSAgentUUID  -- association [0..1]
LEFT OUTER JOIN C_Hazard_InputHelp AS _Hazard ON Hazard = _Hazard.Hazard  -- association [0..1]
LEFT OUTER JOIN C_HazardCategoryValueHelp AS _HazardCategory ON HazardCategory = _HazardCategory.HazardCategory  -- association [0..1]
LEFT OUTER JOIN C_EHSRiskLevel AS _EHSRiskLevel ON EHSRiskLevel = _EHSRiskLevel.EHSRiskLevel  -- association [0..1]
LEFT OUTER JOIN I_EHSJob AS _EHSJob ON EHSJobUUID = _EHSJob.EHSJobUUID  -- association [0..1]
LEFT OUTER JOIN C_EHSLocation AS _EHSLocation ON EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [1..1]
LEFT OUTER JOIN I_OTRText AS _OTRText ON _OTRText.Language = $session.system_language  -- association [0..*]
;