C_MX_UpaDaGdsClfnNOMDetsTP

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_MX_UpaDaGdsClfnNOMDetsTP.
-- 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: CUPDGCLFNNOMDETS

CREATE VIEW C_MX_UpaDaGdsClfnNOMDetsTP AS
SELECT
  CmplRqRsltDngrsGdsBscDetsUUID,
  CmplRqRsltUUID,
  CmplRqVersUUID,
  CreatedByUser,
  LastChangedByUser,
  ClassifiedAsDangerousGood,
  DangerousGoodsIdnNumber AS ProdCmplncDngrsGdsIdnNmbr,
  DangerousGoodsIdnNumberType AS ProdCmplncDngrsGdsIdnNmbrType,
  DangerousGoodsPackingGroup AS ProdCmplncDngrsGdsPackingGroup,
  DangerousGoodsIdnNumber,
  DangerousGoodsIdnNumberType,
  DangerousGoodsPackingGroup,
  DangerousGoodsListItemVariant,
  cast( ' ' as boolean preserving type ) AS IdnNmbrIsOnOrganicPrxdList,
  cast( ' ' as boolean preserving type ) AS IdnNmbrIsOnSelfReactvSubstList,
  DngrsGdsQualifgWordPrefix,
  _UpaDaGdsClfnWordPrefix.DngrsGdsQualifgWordPrefixText AS DngrsGdsQualifgWordPrefixText,
  DngrsGdsQualifgWordSuffix,
  _UpaDaGdsClfnWordSuffix.DngrsGdsQualifgWordSuffixText AS DngrsGdsQualifgWordSuffixText,
  DngrsGdsTechName1SubstUUID,
  cast( '' as ehfnd_sub_substance_name_ltd ) AS DngrsGdsTechName1SubstName,
  DngrsGdsTechName2SubstUUID,
  cast( '' as ehfnd_sub_substance_name_ltd ) AS DngrsGdsTechName2SubstName,
  DngrsGdsTechName3SubstUUID,
  cast( '' as ehfnd_sub_substance_name_ltd ) AS DngrsGdsTechName3SubstName,
  DngrsGdsTechName1PosOnSrce,
  DngrsGdsTechName2PosOnSrce,
  DngrsGdsTechName3PosOnSrce,
  ProdIsEnvironmentalHazardous
FROM I_CmplRqRsltDngrsGdsBscDetsTP
LEFT OUTER JOIN C_MX_UpaDaGdsClfnNOMTP AS _CmplRqRslt ON CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID  -- association [1..1]
LEFT OUTER JOIN C_MX_UpaDaGdsClfnRglnNOM AS _UpaDaGdsClfnRglnVH ON CmplRqVersUUID = _UpaDaGdsClfnRglnVH.CmplRqVersUUID  -- association [1..*]
LEFT OUTER JOIN C_MX_UpaDaGdsClfnRglnNOM AS _UpaDaGdsClfnRgln ON ProdCmplncDngrsGdsIdnNmbr = _UpaDaGdsClfnRgln.ProdCmplncDngrsGdsIdnNmbr AND ProdCmplncDngrsGdsIdnNmbrType = _UpaDaGdsClfnRgln.ProdCmplncDngrsGdsIdnNmbrType AND ProdCmplncDngrsGdsPackingGroup = _UpaDaGdsClfnRgln.ProdCmplncDngrsGdsPackingGroup AND DangerousGoodsListItemVariant = _UpaDaGdsClfnRgln.DangerousGoodsListItemVariant AND CmplRqVersUUID = _UpaDaGdsClfnRgln.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN C_UpaDaGdsClfnWordPrefix AS _UpaDaGdsClfnWordPrefixVH ON CmplRqVersUUID = _UpaDaGdsClfnWordPrefixVH.CmplRqVersUUID  -- association [1..*]
LEFT OUTER JOIN C_UpaDaGdsClfnWordPrefix AS _UpaDaGdsClfnWordPrefix ON CmplRqVersUUID = _UpaDaGdsClfnWordPrefix.CmplRqVersUUID AND DngrsGdsQualifgWordPrefix = _UpaDaGdsClfnWordPrefix.DngrsGdsQualifgWordPrefix  -- association [0..1]
LEFT OUTER JOIN C_UpaDaGdsClfnWordSuffix AS _UpaDaGdsClfnWordSuffixVH ON CmplRqVersUUID = _UpaDaGdsClfnWordSuffixVH.CmplRqVersUUID  -- association [1..*]
LEFT OUTER JOIN C_UpaDaGdsClfnWordSuffix AS _UpaDaGdsClfnWordSuffix ON CmplRqVersUUID = _UpaDaGdsClfnWordSuffix.CmplRqVersUUID AND DngrsGdsQualifgWordSuffix = _UpaDaGdsClfnWordSuffix.DngrsGdsQualifgWordSuffix  -- association [0..1]
LEFT OUTER JOIN I_ClassifiedAsDangerousGoodTxt AS _ClassifiedAsDangerousGoodTxt ON ClassifiedAsDangerousGood = _ClassifiedAsDangerousGoodTxt.ClassifiedAsDangerousGood  -- association [0..*]
;