C_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 C_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: CEHSRAS

CREATE VIEW C_EHSRiskAssessment AS
SELECT
  I_EHSRiskAssessment.EHSRiskAssessmentUUID AS EHSRiskAssessmentUUID,
  bintohex(I_EHSRiskAssessment.EHSRiskAssessmentUUID) AS EHSRiskAssessmentUUIDHex,
  I_EHSRiskAssessment.EHSRiskAssessmentTitle AS EHSRiskAssessmentTitle,
  I_EHSRiskAssessment.EHSRiskAssessmentID AS EHSRiskAssessmentID,
  I_EHSRiskAssessment.EHSRiskAssessmentType AS EHSRiskAssessmentType,
  I_EHSRiskAssessment._EHSRiskAssessmentType AS _EHSRiskAssessmentType,
  cast( substring(cast( I_EHSRiskAssessment.CreationDateTime as abap.char( 17 ) ), 1, 8 ) as ehfnd_date ) AS CreationDateTime,
  count( distinct _ActiveEHSRisk.EHSRiskUUID ) AS NumberOfEHSRisks,
  I_EHSRiskAssessment.EHSRiskAssessmentStatus AS EHSRiskAssessmentStatus,
  I_EHSRiskAssessment._EHSRiskAssessmentStatus AS _EHSRiskAssessmentStatus,
  EHSJobUUID,
  I_EHSRiskAssessment._EHSRiskAssessmentLead AS _EHSRiskAssessmentLead,
  I_EHSRiskAssessment.EHSLocationUUID AS EHSLocationUUID,
  I_EHSRiskAssessment.OperationalStatus AS OperationalStatus,
  EHSLocationUUIDHex
FROM I_EHSRiskAssessment
LEFT OUTER JOIN C_EHSRisk AS _EHSRisk ON EHSRiskAssessmentUUID = _EHSRisk.EHSRiskAssessmentUUID  -- association [0..*]
LEFT OUTER JOIN C_EHSRisk AS _ActiveEHSRisk ON EHSRiskAssessmentUUID = _ActiveEHSRisk.EHSRiskAssessmentUUID AND _ActiveEHSRisk.EHSRiskStatus = '02'  -- association [0..*]
;