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

CREATE VIEW C_EHSControlImpl AS
SELECT
  EHSControlInstanceUUID,
  EHSControlUUID,
  EHSRiskUUID,
  EHSRiskRevisionUUID,
  EHSRiskAssessmentUUID,
  EHSControlImplStatus,
  EHSControlRefCategory,
  I_EHSControlImpl.ResponsiblePerson AS ResponsiblePerson,
  DesiredEHSControlEffect,
  EHSControlTarget,
  EHSControlObjective,
  FunctionalLocation,
  Equipment,
  MaintenanceObject,
  TechObjIsEquipOrFuncnlLoc,
  Material,
  Hazard,
  EHSControlCatalog,
  EHSLocationUUID,
  EHSRiskStatus,
  EHSRiskLevel,
  EHSControlRemarkUUID,
  EHSControlTaskStatus,
  EHSTaskDueDate,
  EHSActnDuUTCDteTmeCriticality,
  EHSControlAdhocTitle,
  EHSControlIsAdhoc
FROM I_EHSControlImpl
LEFT OUTER JOIN C_EHSRisk AS _EHSRisk ON EHSRiskUUID = _EHSRisk.EHSRiskUUID  -- association [1..1]
LEFT OUTER JOIN C_EHSRiskAssessment AS _EHSRiskAssessment ON EHSRiskAssessmentUUID = _EHSRiskAssessment.EHSRiskAssessmentUUID  -- association [0..1]
LEFT OUTER JOIN C_EHSLocation AS _EHSLocation ON EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [1..1]
LEFT OUTER JOIN I_EHSCtrlTaskStatus AS _EHSControlTaskStatus ON EHSControlTaskStatus = _EHSControlTaskStatus.EHSControlTaskStatus  -- association [1..1]
LEFT OUTER JOIN I_EHSControl AS _EHSControl ON EHSControlUUID = _EHSControl.EHSControlUUID  -- association [1..1]
LEFT OUTER JOIN C_EHSCtrlImplmtnRespCntctCard AS _ResponsibleContactCard ON EHSControlInstanceUUID = _ResponsibleContactCard.EHSControlInstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
;