C_ChemicalRiskReportQ

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_ChemicalRiskReportQ.
-- 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: CCHMRISKREPORTQ

CREATE VIEW C_ChemicalRiskReportQ AS
SELECT
  EHSLocationUUID,
  ChemicalUUID,
  Material,
  cast( ListedSubstanceUUID as ehfnd_haz_ing_ref_key preserving type ) AS ListedSubstanceUUID,
  GHSHazardClassCategory,
  ECDangerCategory,
  EHSLocationType,
  Plant,
  CompanyCode,
  BusinessArea,
  CostCenter,
  OrganizationalUnit,
  StorageLocation,
  ChemicalType,
  MethodOfUse,
  OperationalStatus,
  Hazard,
  HazardCategory,
  EHSRiskType,
  EHSRiskLevel,
  EHSRiskValue,
  EHSJobUUID,
  cast( 1 as ehhss_number_of_risks ) AS NumberOfEHSRisks,
  cast( 1 as ehfnd_number_of_chemicals ) AS NumberOfChemicals
FROM I_ChemicalRiskReportC
;