R_DngrsGdsBasicClassfctnDetTP

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 R_DngrsGdsBasicClassfctnDetTP.
-- 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.

CREATE VIEW R_DngrsGdsBasicClassfctnDetTP AS
SELECT
  DngrsGdsBscClassfctnDetails.CmplRqRsltDngrsGdsBscDetsUUID AS CmplRqRsltDngrsGdsBscDetsUUID,
  DngrsGdsBscClassfctnDetails.CmplRqRsltUUID AS CmplRqRsltUUID,
  DngrsGdsBscClassfctnDetails.CmplRqVersUUID AS CmplRqVersUUID,
  DngrsGdsBscClassfctnDetails.CreationDateTime AS CreationDateTime,
  DngrsGdsBscClassfctnDetails.CreatedByUser AS CreatedByUser,
  DngrsGdsBscClassfctnDetails.LastChangeDateTime AS LastChangeDateTime,
  DngrsGdsBscClassfctnDetails.LastChangedByUser AS LastChangedByUser,
  DngrsGdsBscClassfctnDetails.ClassifiedAsDangerousGood AS ClassifiedAsDangerousGood,
  DngrsGdsBscClassfctnDetails.DangerousGoodsIdnNumberType AS ProdCmplncDngrsGdsIdnNmbrType,
  DngrsGdsBscClassfctnDetails.DangerousGoodsIdnNumber AS ProdCmplncDngrsGdsIdnNmbr,
  DngrsGdsBscClassfctnDetails.DangerousGoodsClass AS DangerousGoodsClass,
  DngrsGdsBscClassfctnDetails.DangerousGoodsPackingGroup AS DangerousGoodsPackingGroup,
  DngrsGdsBscClassfctnDetails.PackingInstruction AS DngrsGdsPackingInstructionText,
  DngrsGoodDescForDocsTmplText,
  DangerousGoodsListItemVariant,
  DngrsGdsQualifgWordPrefix,
  DngrsGdsQualifgWordSuffix,
  DngrsGdsTechName1SubstUUID,
  DngrsGdsTechName2SubstUUID,
  DngrsGdsTechName3SubstUUID,
  DngrsGdsTechName1PosOnSrce,
  DngrsGdsTechName2PosOnSrce,
  DngrsGdsTechName3PosOnSrce,
  ProdIsEnvironmentalHazardous,
  DngrsGdsMarnPlltnt1SubstUUID,
  DngrsGdsMarnPlltnt2SubstUUID,
  ProductIsMarinePollutant,
  ProductIsToxicByInhalation,
  DngrsGdsRptblQty1SubstUUID,
  DngrsGdsRptblQty2SubstUUID,
  ReportableQtyIsPrintedOnDoc,
  ToxicByInhalationHazardZone
FROM I_CmplRqRsltDngrsGdsBscDets AS DngrsGdsBscClassfctnDetails
LEFT OUTER JOIN I_ClassifiedAsDangerousGood AS _ClassifiedAsDangerousGood ON _ClassifiedAsDangerousGood.ClassifiedAsDangerousGood = ClassifiedAsDangerousGood  -- association [0..1]
LEFT OUTER JOIN I_DangerousGdsClassOrDivision AS _DangerousGdsClassOrDivision ON _DangerousGdsClassOrDivision.DangerousGoodsClass = DangerousGoodsClass  -- association [0..1]
LEFT OUTER JOIN I_DangerousGoodsPackingGroup AS _DangerousGoodsPackingGroup ON _DangerousGoodsPackingGroup.DangerousGoodsPackingGroup = DangerousGoodsPackingGroup  -- association [0..1]
LEFT OUTER JOIN I_CmplRqVersDngrsGdsPart1Item AS _CmplRqVersDngrsGdsPart1Item ON ProdCmplncDngrsGdsIdnNmbr = _CmplRqVersDngrsGdsPart1Item.DangerousGoodsIdnNumber AND ProdCmplncDngrsGdsIdnNmbrType = _CmplRqVersDngrsGdsPart1Item.DangerousGoodsIdnNumberType AND DangerousGoodsPackingGroup = _CmplRqVersDngrsGdsPart1Item.DangerousGoodsPackingGroup AND DangerousGoodsListItemVariant = _CmplRqVersDngrsGdsPart1Item.DangerousGoodsListItemVariant AND CmplRqVersUUID = _CmplRqVersDngrsGdsPart1Item.CmplRqVersUUID  -- association [0..1]
LEFT OUTER JOIN I_Substance AS _DngrsGdsTechName1Substance ON DngrsGdsTechName1SubstUUID = _DngrsGdsTechName1Substance.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_Substance AS _DngrsGdsTechName2Substance ON DngrsGdsTechName2SubstUUID = _DngrsGdsTechName2Substance.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_Substance AS _DngrsGdsTechName3Substance ON DngrsGdsTechName3SubstUUID = _DngrsGdsTechName3Substance.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_Substance AS _DngrsGdsMarnPlltnt1Substance ON DngrsGdsMarnPlltnt1SubstUUID = _DngrsGdsMarnPlltnt1Substance.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_Substance AS _DngrsGdsMarnPlltnt2Substance ON DngrsGdsMarnPlltnt2SubstUUID = _DngrsGdsMarnPlltnt2Substance.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_Substance AS _DngrsGdsRptblQty1Substance ON DngrsGdsRptblQty1SubstUUID = _DngrsGdsRptblQty1Substance.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_Substance AS _DngrsGdsRptblQty2Substance ON DngrsGdsRptblQty2SubstUUID = _DngrsGdsRptblQty2Substance.SubstanceUUID  -- association [0..1]
;