I_LstdSubstWthVarAndGrp

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_LstdSubstWthVarAndGrp.
-- 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: ILISU

CREATE VIEW I_LstdSubstWthVarAndGrp AS
SELECT
  cast( db_key as ehfnd_lisu_key_nce preserving type ) AS ListedSubstanceUUID,
  listsub_id AS ListedSubstance,
  cast(cas_number as ehfnd_chm_cas_no preserving type ) AS CASNumber,
  ec_number AS ECNumber,
  mol_formula AS MolecularFormula,
  cast(condition_code as ehfnd_lisu_cond_code_plain preserving type ) AS ListedSubstanceCndn,
  cast(listsub_id_root as ehfnd_regbaslst_sub_ref preserving type) AS ListedSubstanceReference,
  is_group_ind AS ListedSubstanceIsGroup,
  cast(datetime_ch as timestamp preserving type) AS LastChangeDateTime,
  cast(datetime_cr as timestamp preserving type) AS CreationDateTime,
  user_id_ch AS LastChangedByUser,
  user_id_cr AS CreatedByUser,
  bco_key AS ListedSubstanceCharUUID,
  content_provider AS ContentProvider
FROM ehfndd_lisu_rt
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 ListedSubstanceUUID = _Text.ListedSubstanceUUID  -- association [0..*]
LEFT OUTER JOIN I_ListedSubstanceDefaultName AS _DefaultName ON ListedSubstance = _DefaultName.ListedSubstance AND ListedSubstanceUUID = _DefaultName.ListedSubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_ListedSubstanceCndnText AS _SubstanceCndnText ON ListedSubstanceCndn = _SubstanceCndnText.ListedSubstanceCndn AND _SubstanceCndnText.Language = $session.system_language  -- association [0..1]
;