C_ChemicalOfHzdsSubstInvtryVH

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_ChemicalOfHzdsSubstInvtryVH.
-- 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 C_ChemicalOfHzdsSubstInvtryVH AS
SELECT
  I_Chemical.ChemicalUUID AS ChemicalUUID,
  HSIHeader.EHSLocationUUID AS EHSLocationUUID,
  HSIHeader.HzdsSubstInventoryUUID AS HzdsSubstInventoryUUID,
  HSIItems.HzdsSubstInventoryItemUUID AS HzdsSubstInventoryItemUUID,
  _Chemical._ChemicalBasicInfo._ChemicalName[1: Language = $session.system_language ].NameOfChemical AS NameOfChemical,
  HSIItems.FactoryJargonForSubstance AS FactoryJargonForSubstance,
  _ChemicalRoot.ChemicalID AS ChemicalID,
  _ChemicalBasicInfo.CASNumber AS CASNumber,
  I_Chemical.ChemicalRevisionUUID AS ChemicalRevisionUUID,
  I_Chemical.ChemicalBasicInfoUUID AS ChemicalBasicInfoUUID
FROM I_Chemical
INNER JOIN I_HzdsSubstInventoryItem AS HSIItems ON /* join condition not captured in parsed metadata */
INNER JOIN I_HzdsSubstInventory AS HSIHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_HzdsSubstInventoryTP AS _HzdsSubstInventory ON HzdsSubstInventoryUUID = _HzdsSubstInventory.HzdsSubstInventoryUUID  -- association [1..1]
;