I_SafetyInstruction

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_SafetyInstruction.
-- 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 I_SafetyInstruction AS
SELECT
  SafetyInstructionUUID,
  SafetyInstruction,
  SafetyInstructionStatus,
  FactoryEHSLocationUUID,
  ChemicalUUID,
  ChmlCmplncInfoUUID,
  JobFreeText,
  FactoryAreaFreeText,
  Language,
  SafetyInstructionRelDate,
  ReleasedByUser,
  cast(creationutcdatetime as ehfnd_bo_crea_date_time preserving type ) AS CreationUTCDateTime,
  cast(createdbyuser as ehfnd_bo_crea_uname preserving type ) AS CreatedByUser,
  cast(lastchangeutcdatetime as ehfnd_bo_lchg_date_time preserving type ) AS LastChangeUTCDateTime,
  cast(lastchangedbyuser as ehfnd_bo_lchg_uname preserving type ) AS LastChangedByUser,
  SafetyInstructionType,
  SafetyInstructionSubType,
  SafetyInstructionSubjectDesc,
  SafetyInstructionIsTemplate,
  SafetyInstructionNote,
  SftyInstrnMigrationSource
FROM ehhssv_fsi_root
LEFT OUTER JOIN I_EHSLocation AS _EHSLocation ON FactoryEHSLocationUUID = _EHSLocation.EHSLocationUUID AND _EHSLocation.RevisionStartDate <= $session.system_date AND _EHSLocation.RevisionEndDate >= $session.system_date  -- association [1..1]
LEFT OUTER JOIN I_Chemical AS _Chemical ON ChemicalUUID = _Chemical.ChemicalUUID AND _Chemical.RevisionStartDate <= $session.system_date AND _Chemical.RevisionEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfo ON ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_SafetyInstructionChapter AS _SafetyInstructionChapter ON SafetyInstructionUUID = _SafetyInstructionChapter.SafetyInstructionUUID  -- association [1..*]
LEFT OUTER JOIN I_SafetyInstructionProduct AS _SafetyInstructionProduct ON SafetyInstructionUUID = _SafetyInstructionProduct.SafetyInstructionUUID  -- association [1..*]
LEFT OUTER JOIN I_SafetyInstructionBuilding AS _SafetyInstructionBuilding ON SafetyInstructionUUID = _SafetyInstructionBuilding.SafetyInstructionUUID  -- association [1..*]
LEFT OUTER JOIN I_SafetyInstructionJob AS _SafetyInstructionJob ON SafetyInstructionUUID = _SafetyInstructionJob.SafetyInstructionUUID  -- association [1..*]
LEFT OUTER JOIN I_SafetyInstrnFactoryArea AS _SafetyInstrnFactoryAreaTP ON SafetyInstructionUUID = _SafetyInstrnFactoryAreaTP.SafetyInstructionUUID  -- association [1..*]
LEFT OUTER JOIN I_SafetyInstructionEquipment AS _SafetyInstructionEquipment ON SafetyInstructionUUID = _SafetyInstructionEquipment.SafetyInstructionUUID  -- association [0..*]
;