I_ChemicalAttributesC

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_ChemicalAttributesC.
-- 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: ICHMATTRIBC
-- Parameters: P_KeyDate : sydatum

CREATE VIEW I_ChemicalAttributesC AS
SELECT
  ChemicalUUID,
  _ChemicalMaterial.Material AS Material,
  _ChemicalMaterial._Material AS _Material,
  _ChemicalHzdsIngredients.ListedSubstanceUUID AS ListedSubstanceUUID,
  _ChemicalHazardClassEC.ECDangerCategory AS ECDangerCategory,
  _ChemicalHazardClassEC._ECDangerCategory AS _ECDangerCategory,
  _ChemicalGHSHazardClass.GHSHazardClassCategory AS GHSHazardClassCategory,
  _ChemicalGHSHazardClass._GHSHazardClassCategory AS _GHSHazardClassCategory,
  ChemicalRevisionUUID,
  _ChemicalRoot.ChemicalType AS ChemicalType,
  _ChemicalRoot._ChemicalType AS _ChemicalType,
  cast (1 as ehhss_number_of_risks) AS NumberOfChemicals
FROM I_ChemicalRevision
LEFT OUTER JOIN I_Chemical AS _Chemical ON ChemicalUUID = _Chemical.ChemicalUUID AND ChemicalRevisionUUID = _Chemical.ChemicalRevisionUUID  -- association [1..1]
LEFT OUTER JOIN I_CurrentChemicalNameText AS _CurrentChemicalNameText ON ChemicalUUID = _CurrentChemicalNameText.ChemicalUUID  -- association [0..*]
LEFT OUTER JOIN I_LstdSubstPrimNameTxt AS _LstdSubstPrimNameTxt ON listedsubstanceuuid = _LstdSubstPrimNameTxt.ListedSubstanceUUID  -- association [0..*]
;