C_US_UpaDaGdsClfnCFRDetsTP

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_US_UpaDaGdsClfnCFRDetsTP.
-- 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: CUPDGCLCFRDETS

CREATE VIEW C_US_UpaDaGdsClfnCFRDetsTP AS
SELECT
  CmplRqRsltDngrsGdsBscDetsUUID,
  CmplRqRsltUUID,
  CmplRqVersUUID,
  CreatedByUser,
  LastChangedByUser,
  ComplianceRequirement,
  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,
  DngrsGdsRptblQty1SubstUUID,
  cast( '' as ehfnd_sub_substance_name_ltd ) AS DngrsGdsRptblQty1SubstName,
  DngrsGdsRptblQty2SubstUUID,
  cast( '' as ehfnd_sub_substance_name_ltd ) AS DngrsGdsRptblQty2SubstName,
  cast ('' as dngrsgdsvesselstowageothertxt ) AS DngrsGdsVesselStowageOtherTxt,
  ReportableQtyIsPrintedOnDoc,
  ToxicByInhalationHazardZone
FROM I_CmplRqRsltDngrsGdsBscDetsTP
LEFT OUTER JOIN C_US_UpaDaGdsClfnCFRTP AS _CmplRqRslt ON CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID  -- association [1..1]
LEFT OUTER JOIN C_US_UpaDaGdsClfnCFRSgrgtnTP AS _CmplRqRsltDngrsGdsSgrgtn ON CmplRqRsltDngrsGdsBscDetsUUID = _CmplRqRsltDngrsGdsSgrgtn.CmplRqRsltDngrsGdsBscDetsUUID  -- association [0..*]
LEFT OUTER JOIN C_US_UpaDaGdClfnCFRVesselStwg AS _DngrsGdsBscClfnVesselStwg ON CmplRqRsltDngrsGdsBscDetsUUID = _DngrsGdsBscClfnVesselStwg.CmplRqRsltDngrsGdsBscDetsUUID  -- association [0..*]
LEFT OUTER JOIN C_US_UpaDaGdsClfnRglnCFR AS _UpaDaGdsClfnRglnVH ON CmplRqVersUUID = _UpaDaGdsClfnRglnVH.CmplRqVersUUID  -- association [1..*]
LEFT OUTER JOIN C_US_UpaDaGdsClfnRglnCFR 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_US_AnlytlCmpstnMarnPlltntCFR AS _AnlytlCmpstnMarnPlltnt ON CmplRqRsltDngrsGdsBscDetsUUID = _AnlytlCmpstnMarnPlltnt.CmplRqRsltDngrsGdsBscDetsUUID  -- association [0..*]
LEFT OUTER JOIN C_US_AllMarnPlltntCFR AS _AllMarnPlltnt ON CmplRqVersUUID = _AllMarnPlltnt.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqVersSegregationGroupVH AS _SegregationGroupForProductVH ON CmplRqVersUUID = _SegregationGroupForProductVH.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN I_DngrsGdsVesselStowageOtherVH AS _DngrsGdsVesselStowageOtherVH ON ComplianceRequirement = _DngrsGdsVesselStowageOtherVH.ComplianceRequirement  -- association [0..*]
LEFT OUTER JOIN C_US_AnlytlCmpstnRptblQtyCFR AS _AnlytlCmpstnRptblQty ON CmplRqRsltDngrsGdsBscDetsUUID = _AnlytlCmpstnRptblQty.CmplRqRsltDngrsGdsBscDetsUUID  -- association [0..*]
LEFT OUTER JOIN C_US_AllRptblQtyCFR AS _AllRptblQty ON CmplRqVersUUID = _AllRptblQty.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN I_ClassifiedAsDangerousGoodTxt AS _ClassifiedAsDangerousGoodTxt ON ClassifiedAsDangerousGood = _ClassifiedAsDangerousGoodTxt.ClassifiedAsDangerousGood  -- association [0..*]
LEFT OUTER JOIN I_UpaDaGdsClfnHazardZoneText AS _ToxicByInhalationHzdZoneTxt ON ToxicByInhalationHazardZone = _ToxicByInhalationHzdZoneTxt.ToxicByInhalationHazardZone  -- association [0..*]
;