R_DangerousGoodsClassfctnDetTP

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_DangerousGoodsClassfctnDetTP.
-- 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_DangerousGoodsClassfctnDetTP AS
SELECT
  DangerousGoodsClassfctnDetail.CmplRqRsltDngrsGdsBscDetsUUID AS CmplRqRsltDngrsGdsBscDetsUUID,
  DangerousGoodsClassfctnDetail.CmplRqRsltUUID AS CmplRqRsltUUID,
  DangerousGoodsClassfctnDetail.CmplRqVersUUID AS CmplRqVersUUID,
  DangerousGoodsClassfctnDetail.ClassifiedAsDangerousGood AS ClassifiedAsDangerousGood,
  DangerousGoodsClassfctnDetail.DangerousGoodsIdnNumberType AS ProdCmplncDngrsGdsIdnNmbrType,
  DangerousGoodsClassfctnDetail.DangerousGoodsIdnNumber AS ProdCmplncDngrsGdsIdnNmbr,
  DangerousGoodsClassfctnDetail.DangerousGoodsClass AS DangerousGoodsClass,
  DangerousGoodsClassfctnDetail.DangerousGoodsPackingGroup AS DangerousGoodsPackingGroup,
  DangerousGoodsClassfctnDetail.PackingInstruction AS DngrsGdsPackingInstructionText,
  DngrsGoodDescForDocsTmplText,
  DangerousGoodsListItemVariant,
  DngrsGdsQualifgWordPrefix,
  DngrsGdsQualifgWordSuffix,
  DngrsGdsTechName1SubstUUID,
  DngrsGdsTechName2SubstUUID,
  DngrsGdsTechName3SubstUUID,
  DngrsGdsTechName1PosOnSrce,
  DngrsGdsTechName2PosOnSrce,
  DngrsGdsTechName3PosOnSrce,
  ProdIsEnvironmentalHazardous,
  DngrsGdsMarnPlltnt1SubstUUID,
  DngrsGdsMarnPlltnt2SubstUUID,
  ProductIsMarinePollutant,
  ProductIsToxicByInhalation,
  DngrsGdsRptblQty1SubstUUID,
  DngrsGdsRptblQty2SubstUUID,
  ReportableQtyIsPrintedOnDoc,
  ToxicByInhalationHazardZone,
  BasicClassfctnIsOverwritten,
  DngrsGdsDescTmplIsOverwritten,
  EnclosureVariant,
  SpecialProvisionOrExemptionTxt,
  DngrsGdsIsIgnoredLblFrmRgln,
  AddlPlcdIsIgnoredLblFrmRgln
FROM I_CmplRqRsltDngrsGdsBscDets AS DangerousGoodsClassfctnDetail
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]
;