C_UpaDaGdsClfnTechName

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_UpaDaGdsClfnTechName.
-- 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: CDGTECHNAM
-- Parameters: P_ChmlCmplncInfoUUID : sysuuid_x, P_CmplRqVersUUID : sysuuid_x, P_DangerousGoodsIdnNumber : ehdgm_dangerous_good_idn, P_DangerousGoodsIdnNumberType : ehdgm_dangerous_good_idn_type

CREATE VIEW C_UpaDaGdsClfnTechName AS
SELECT
  ChmlCompositionUUID,
  UpaDaGdsClfnTechName.SubstanceUUID AS SubstanceUUID,
  ChmlCmplncInfoUUID,
  _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,
  ECNumber,
  CASNumber
FROM P_UpaDaGdsClfnTechName AS UpaDaGdsClfnTechName
LEFT OUTER JOIN P_SubstNameFallbackLogonLang AS _SubstNameFallbackLogonLang ON SubstanceUUID = _SubstNameFallbackLogonLang.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]
;