I_EHSControlImpl

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_EHSControlImpl.
-- 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: IEHSRISKCTRLIMP

CREATE VIEW I_EHSControlImpl AS
SELECT
  EHSControlInstanceUUID,
  EHSControlInstanceUUIDHex,
  EHSControlUUID,
  EHSControlIsAdhoc,
  EHSControlAdhocTitle,
  EHSRiskUUID,
  EHSRiskRevisionUUID,
  ResponsiblePerson,
  FunctionalLocation,
  Equipment,
  Material,
  Hazard,
  MaintenanceObject,
  TechObjIsEquipOrFuncnlLoc,
  EHSControlImplStatus,
  EHSControlRefCategory,
  DesiredEHSControlEffect,
  EHSControlTarget,
  EHSControlObjective,
  _EHSControl.EHSControlCatalog AS EHSControlCatalog,
  _EHSControl._EHSCatalog AS _EHSCatalog,
  _RiskRoot.EHSLocationUUID AS EHSLocationUUID,
  _RiskRevision.EHSRiskStatus AS EHSRiskStatus,
  _RiskRevision._EHSRiskStatus AS _EHSRiskStatus,
  _RiskRoot.EHSRiskLevel AS EHSRiskLevel,
  _RiskRoot._EHSRiskLevel AS _EHSRiskLevel,
  _RiskRevision.EHSRiskAssessmentUUID AS EHSRiskAssessmentUUID,
  I_EHSRiskControl.EHSControlRemarkUUID AS EHSControlRemarkUUID,
  _MinDuDteOfOpnActnInstances.EHSTaskDueDate AS EHSTaskDueDate
FROM I_EHSRiskControl
LEFT OUTER JOIN I_EHSRiskRoot AS _RiskRoot ON EHSRiskUUID = _RiskRoot.EHSRiskUUID  -- association [1..1]
LEFT OUTER JOIN I_EHSRiskRevision AS _RiskRevision ON EHSRiskRevisionUUID = _RiskRevision.EHSRiskRevisionUUID  -- association [1..1]
LEFT OUTER JOIN I_EHSCtrlEffect AS _EHSCtrlEffect ON DesiredEHSControlEffect = _EHSCtrlEffect.DesiredEHSControlEffect  -- association [0..1]
LEFT OUTER JOIN I_EHSCtrlGoalTar AS _EHSGoalTarget ON EHSControlTarget = _EHSGoalTarget.EHSControlTarget  -- association [0..1]
LEFT OUTER JOIN P_MinDuDteOfOpnActnInstances AS _MinDuDteOfOpnActnInstances ON EHSControlInstanceUUIDHex = _MinDuDteOfOpnActnInstances.EHSTaskHostObjectInstance  -- association [0..1]
LEFT OUTER JOIN P_NmbrOfEHSTskDefAndInstce AS _NmbrOfEHSTskDefAndInstce ON EHSControlInstanceUUIDHex = _NmbrOfEHSTskDefAndInstce.EHSTaskHostObjectInstance  -- association [0..1]
LEFT OUTER JOIN P_NmbrOfOpenEHSTskDefAndInstce AS _NmbrOfOpenEHSTskDefAndInstce ON EHSControlInstanceUUIDHex = _NmbrOfOpenEHSTskDefAndInstce.EHSTaskHostObjectInstance  -- association [0..1]
;