C_UpaDaGdsClfnTechNameAll

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_UpaDaGdsClfnTechNameAll.
-- 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: IUPDGTECHNAMALL
-- Parameters: P_CmplRqVersUUID : sysuuid_x, P_DangerousGoodsIdnNumber : ehdgm_dangerous_good_idn, P_DangerousGoodsIdnNumberType : ehdgm_dangerous_good_idn_type

CREATE VIEW C_UpaDaGdsClfnTechNameAll AS
SELECT
  SubstanceUUID,
  _SubstIsOnOrganicPrxdList.CmplRqVersOrganicPrxdUUID AS CmplRqVersOrganicPrxdUUID,
  _SubstIsOnSelfReactvSubstList.CmplRqVersSelfReactvSubstUUID AS CmplRqVersSelfReactvSubstUUID,
  case when _SubstIsOnOrganicPrxdList.SubstanceUUID is not null then _SubstIsOnOrganicPrxdList.DngrsGdsOrganicPrxdName when _SubstIsOnSelfReactvSubstList.SubstanceUUID is not null then _SubstIsOnSelfReactvSubstList.DngrsGdsSelfReactvName else _SubstNameFallbackLogonLang.SubstanceName end as SubstanceName AS SubstanceNameendasSubstanceName,
  _ListedSubstance.CASNumber AS CASNumber,
  _ListedSubstance.ECNumber AS ECNumber,
  ResponsibleUnit
FROM I_Substance
LEFT OUTER JOIN P_SubstNameFallbackLogonLang AS _SubstNameFallbackLogonLang ON _SubstNameFallbackLogonLang.SubstanceUUID = SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN P_SubstIsOnOrganicPrxdList AS _SubstIsOnOrganicPrxdList ON _SubstIsOnOrganicPrxdList.SubstanceUUID = SubstanceUUID AND _SubstIsOnOrganicPrxdList.CmplRqVersUUID = $parameters.P_CmplRqVersUUID AND _SubstIsOnOrganicPrxdList.ProdCmplncDngrsGdsIdnNmbrType = $parameters.P_DangerousGoodsIdnNumberType AND _SubstIsOnOrganicPrxdList.ProdCmplncDngrsGdsIdnNmbr = $parameters.P_DangerousGoodsIdnNumber  -- association [0..1]
LEFT OUTER JOIN P_SubstIsOnSelfReactvSubstList AS _SubstIsOnSelfReactvSubstList ON _SubstIsOnSelfReactvSubstList.SubstanceUUID = SubstanceUUID AND _SubstIsOnSelfReactvSubstList.CmplRqVersUUID = $parameters.P_CmplRqVersUUID AND _SubstIsOnSelfReactvSubstList.ProdCmplncDngrsGdsIdnNmbrType = $parameters.P_DangerousGoodsIdnNumberType AND _SubstIsOnSelfReactvSubstList.ProdCmplncDngrsGdsIdnNmbr = $parameters.P_DangerousGoodsIdnNumber  -- association [0..1]
;