I_ListedSubstanceVariant

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_ListedSubstanceVariant.
-- 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: ILISUVAR

CREATE VIEW I_ListedSubstanceVariant AS
SELECT
  ListSub.ListedSubstanceUUID AS ListedSubstanceVariantUUID,
  ListSub.ListedSubstance AS ListedSubstanceVariant,
  ListSub.ListedSubstanceReference AS ListedSubstanceReference,
  ListSubRef.ListedSubstanceUUID AS ListedSubstanceUUID,
  ListSub.ListedSubstanceCndn AS ListedSubstanceCndn,
  ListSub.ContentProvider AS ContentProvider,
  ListSub.CASNumber AS CASNumber,
  ListSub.ECNumber AS ECNumber,
  ListSub.MolecularFormula AS MolecularFormula,
  ListSub.CreatedByUser AS CreatedByUser,
  ListSub.CreationDateTime AS CreationDateTime,
  ListSub.LastChangeDateTime AS LastChangeDateTime,
  ListSub.LastChangedByUser AS LastChangedByUser
FROM I_LstdSubstWthVarAndGrp AS ListSub
INNER JOIN I_LstdSubstWthVarAndGrp AS ListSubRef ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ListedSubstanceCndnText AS _ConditionText ON ListedSubstanceCndn = _ConditionText.ListedSubstanceCndn  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_ListedSubstanceNameText AS _Text ON ListedSubstanceVariantUUID = _Text.ListedSubstanceUUID  -- association [0..*]
LEFT OUTER JOIN I_ListedSubstanceDefaultName AS _DefaultName ON ListedSubstanceVariant = _DefaultName.ListedSubstance AND ListedSubstanceVariantUUID = _DefaultName.ListedSubstanceUUID  -- association [0..1]
;