R_EHSRskAssmt2TP

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 R_EHSRskAssmt2TP.
-- 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.

CREATE VIEW R_EHSRskAssmt2TP AS
SELECT
  EHSRiskAssessmentUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  EHSRiskAssessment2Id,
  EHSRiskAssessment2Status,
  EHSRiskAssessmentTitle,
  EHSRiskAssessmentRevision,
  EHSRiskAssessmentType,
  EHSRiskAssessmentDescription,
  EHSRiskAssessmentNote,
  EHSRskAssmtApproveDateTime,
  EHSRskAssmtApprovedByUser,
  EHSRiskAssessmentAuthznGrp,
  NumberOfEHSRisksInProcess,
  NumberOfEHSRisksReleased,
  Plant,
  BusinessArea,
  EHSRskAssmtSetHistDateTime,
  EHSRskAssmtSetHistByUser,
  EHSRiskAssessmentHasJob,
  EHSRiskAssessmentIsBlocked,
  EHSRiskMatrix,
  EHSRiskAssessmentReminderDate,
  EHSRiskAssessmentReasonNote,
  cast('EHSRiskAssessment' as sap_object_node_type_raw ) AS SAPObjectNodeType,
  cast( bintohex( EHSRiskAssessmentUUID ) as linkedsapobjectkey ) AS EHSRiskAssessmentAttachmentKey
FROM I_EHSRskAssmt2
LEFT OUTER JOIN I_HDMRelationTP AS _HDMRelation ON EHSRiskAssessmentAttachmentKey = _HDMRelation.LinkedSAPObjectKey AND SAPObjectNodeType = _HDMRelation.SAPObjectNodeType  -- association [0..*]
LEFT OUTER JOIN I_EHSRiskAssessmentType AS _RiskAssessmentType ON EHSRiskAssessmentType = _RiskAssessmentType.EHSRiskAssessmentType  -- association [1..1]
LEFT OUTER JOIN I_EHSRskAssmt2Status AS _RiskAssessmentStatus ON EHSRiskAssessment2Status = _RiskAssessmentStatus.EHSRiskAssessmentStatus  -- association [1..1]
LEFT OUTER JOIN I_EHSRskAssmtAuthznGrp AS _RskAssmtAuthznGrp ON EHSRiskAssessmentAuthznGrp = _RskAssmtAuthznGrp.EHSRiskAssessmentAuthznGrp  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN R_EHSRskAssmt2RiskTP AS _Risk ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_EHSRskAssmt2StakeholderTP AS _Stakeholder ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_EHSRskAssmt2LocationTP AS _Location ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_EHSRskAssmt2RsnReltdObjectTP AS _ReasonRelatedObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_EHSRskAssmt2JobInfoTP AS _JobInfo ON /* condition not available in parsed metadata */  -- association [0..1]
;