C_UpaDaGdsClfnIMDGDetsTP

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_UpaDaGdsClfnIMDGDetsTP.
-- 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: CUPDGCLIMDGDETS

CREATE VIEW C_UpaDaGdsClfnIMDGDetsTP AS
SELECT
  CmplRqRsltDngrsGdsBscDetsUUID,
  CmplRqRsltUUID,
  CmplRqVersUUID,
  ComplianceRequirement,
  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,
  ProductIsMarinePollutant,
  DngrsGdsMarnPlltnt1SubstUUID,
  cast( '' as ehfnd_sub_substance_name_ltd ) AS DngrsGdsMarnPlltnt1SubstName,
  DngrsGdsMarnPlltnt2SubstUUID,
  cast( '' as ehfnd_sub_substance_name_ltd ) AS DngrsGdsMarnPlltnt2SubstName
FROM I_CmplRqRsltDngrsGdsBscDetsTP
LEFT OUTER JOIN C_UpaDaGdsClfnIMDGTP AS _CmplRqRslt ON CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID  -- association [1..1]
LEFT OUTER JOIN C_UpaDaGdsClfnIMDGSgrgtnGrpTP AS _CmplRqRsltDngrsGdsSgrgtn ON CmplRqRsltDngrsGdsBscDetsUUID = _CmplRqRsltDngrsGdsSgrgtn.CmplRqRsltDngrsGdsBscDetsUUID  -- association [0..*]
LEFT OUTER JOIN C_UpaDaGdsClfnIMDGSgrgtnCodeTP AS _CmplRqRsltSegregationCode ON CmplRqRsltDngrsGdsBscDetsUUID = _CmplRqRsltSegregationCode.CmplRqRsltDngrsGdsBscDetsUUID  -- association [0..*]
LEFT OUTER JOIN C_UpaDaGdsClfnRglnIMDG AS _UpaDaGdsClfnRglnVH ON CmplRqVersUUID = _UpaDaGdsClfnRglnVH.CmplRqVersUUID  -- association [1..*]
LEFT OUTER JOIN C_UpaDaGdsClfnRglnIMDG 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 C_AnlytlCmpstnMarnPlltntIMDG AS _AnlytlCmpstnMarnPlltnt ON CmplRqRsltDngrsGdsBscDetsUUID = _AnlytlCmpstnMarnPlltnt.cmplrqrsltdngrsgdsbscdetsuuid  -- association [0..*]
LEFT OUTER JOIN C_AllMarnPlltntIMDG AS _AllMarnPlltnt ON CmplRqVersUUID = _AllMarnPlltnt.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqVersSegregationGroupVH AS _SegregationGroupForProductVH ON CmplRqVersUUID = _SegregationGroupForProductVH.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN C_DngrsGdsSegregationCodeVH AS _SegregationCodeForProductVH ON ComplianceRequirement = _SegregationCodeForProductVH.ComplianceRequirement  -- association [0..*]
LEFT OUTER JOIN I_ClassifiedAsDangerousGoodTxt AS _ClassifiedAsDangerousGoodTxt ON ClassifiedAsDangerousGood = _ClassifiedAsDangerousGoodTxt.ClassifiedAsDangerousGood  -- association [0..*]
;