C_PackagedDangerousGood

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_PackagedDangerousGood.
-- 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: CPPDG

CREATE VIEW C_PackagedDangerousGood AS
SELECT
  ChemicalComplianceInfo.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  cast( '' as ehfnd_boolean preserving type ) AS IsEditable,
  cast( bintohex(ChemicalComplianceInfo.ChmlCmplncInfoUUID) as sit_de_ancobjkey ) AS SitnInstceAnchorObjectKey,
  cast (PrimaryMaterial.Material as productnumber preserving type ) AS Product,
  cast (PrimaryMaterial.Material as ehfnd_cci_raw_material preserving type ) AS RawMaterial,
  _Product.ProductGroup AS ProductGroup,
  _PckgdDngrsGoodEnclosureDets.DescriptionOfDngrsGdsPckg AS DescriptionOfDngrsGdsPckg,
  _PckgdDngrsGoodEnclosureDets.PackagingIsTankOrBulkFilling AS PackagingIsTankOrBulkFilling,
  _PckgdDngrsGoodEnclosureDets.DescOfDngrsGdsPckgName AS DescOfDngrsGdsPckgName,
  _PckgdDngrsGoodEnclosureDets.DangerousGoodsPackagingCode AS DangerousGoodsPackagingCode,
  _PckgdDngrsGoodEnclosureDets.DangerousGoodsEnclosureQty AS DangerousGoodsEnclosureQty,
  _PckgdDngrsGoodEnclosureDets.DangerousGoodsEnclosureUnit AS DangerousGoodsEnclosureUnit,
  _PckgdDngrsGoodEnclosureDets.DngrsGdsEnclrNmbrOfInnerPckgs AS DngrsGdsEnclrNmbrOfInnerPckgs,
  _PckgdDngrsGoodEnclosureDets.DescOfDngrsGdsInnerPackgg AS DescOfDngrsGdsInnerPackgg,
  _PckgdDngrsGoodEnclosureDets.DescOfDngrsGdsInnerPackggName AS DescOfDngrsGdsInnerPackggName,
  _PckgdDngrsGoodEnclosureDets.DngrsGdsEnclrInnerPackageQty AS DngrsGdsEnclrInnerPackageQty,
  _PckgdDngrsGoodEnclosureDets.DngrsGdsEnclrInnerPackageUnit AS DngrsGdsEnclrInnerPackageUnit,
  _PckgdDngrsGoodEnclosureDets.DangerousGoodsControlTemp AS DangerousGoodsControlTemp,
  _PckgdDngrsGoodEnclosureDets.DangerousGoodsControlTempUnit AS DangerousGoodsControlTempUnit,
  _PckgdDngrsGoodEnclosureDets.DangerousGoodsEmergencyTemp AS DangerousGoodsEmergencyTemp,
  _PckgdDngrsGoodEnclosureDets.DangerousGoodsEmgyTempUnit AS DangerousGoodsEmgyTempUnit,
  cast( coalesce( ProductText.ProductName, ChemicalComplianceInfo.ChmlCmplncInternalName ) as ehfnd_cci_pp ) AS ChmlCmplncInfoCombinedName,
  ChemicalComplianceInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  ProductText.ProductName AS ProductName,
  ProductAssignment.ChmlCmplncProdUUID AS ChmlCmplncProdUUID,
  ProductAssignment.ChmlCmplncProdUUID AS ChmlCmplncInfoNavgnLink,
  _AnlytlCmpstn.ChmlCompositionReleasedUUID AS AnalyticCmpstnNavgnLinkUUID,
  _MatlBsdCmpstn.ChmlCompositionReleasedUUID AS MatlBsdCmpstnNavgnLinkUUID,
  _PCPhysProperty.PCPrptyNavgnLinkUUID AS PCPhysPrptyNavgnLinkUUID,
  cast( coalesce( UPProductText.ProductName, UnpackagedProduct.ChmlCmplncInternalName) as ehfnd_cci_up ) AS ChmlCmplncInfoUnpckgdProdName,
  cast( coalesce( UPProductText.ProductName, UnpackagedProduct.ChmlCmplncInternalName ) as ehfnd_cci_raw_material_name ) AS ChmlCmplncInfoRawMaterialName,
  ChemicalComplianceInfo.DngrsGdsRespUnit AS DngrsGdsRespUnit,
  ChemicalComplianceInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  ChemicalComplianceInfo.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  ChemicalComplianceInfo.MaterialIsSold AS MaterialIsSold,
  ChemicalComplianceInfo.MaterialIsTransported AS MaterialIsTransported,
  ChemicalComplianceInfo.MaterialIsSourced AS MaterialIsSourced,
  ChemicalComplianceInfo.MaterialIsProduced AS MaterialIsProduced,
  _PckgdDngrsGoodEnclosureDets._EnclosureUnitOfMeasureText AS _EnclosureUnitOfMeasureText,
  _PckgdDngrsGoodEnclosureDets._InnerPackageUnitOfMeasureText AS _InnerPackageUnitOfMeasureText,
  _PckgdDngrsGoodEnclosureDets._EmgyTempUnitOfMeasureText AS _EmgyTempUnitOfMeasureText,
  _PckgdDngrsGoodEnclosureDets._ControlTempUnitOfMeasureText AS _ControlTempUnitOfMeasureText
FROM I_ChmlCmplncInfo AS ChemicalComplianceInfo
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductGroupText_2 AS _ProductGroupText ON productgroup = _ProductGroupText.ProductGroup  -- association [0..*]
LEFT OUTER JOIN C_PackagedDangerousGoodClfn AS _PackagedDangerousGoodClfn ON ChmlCmplncInfoUUID = _PackagedDangerousGoodClfn.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_PckgdDngrsGoodEnclosureDets AS _PckgdDngrsGoodEnclosureDets ON ChmlCmplncInfoUUID = _PckgdDngrsGoodEnclosureDets.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN C_PckgdDngrsGoodHzdNote AS _PckgdDngrsGoodHzdNote ON ChmlCmplncInfoUUID = _PckgdDngrsGoodHzdNote.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN P_AssociatedAnlytlReldCmpstn AS _AnlytlCmpstn ON _AnlytlCmpstn.ChmlCmplncInfoUUID = UnpackagedProduct.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_AssociatedMatlReldCmpstn AS _MatlBsdCmpstn ON _MatlBsdCmpstn.ChmlCmplncInfoUUID = UnpackagedProduct.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplncInfoAssgdPCPhys AS _PCPhysProperty ON _PCPhysProperty.ChmlCmplncInfoUUID = UnpackagedProduct.ChmlCmplncInfoUUID AND _PCPhysProperty.PCPrptyRootType = 'EHFNDD_PHYSCHEM' AND ( _PCPhysProperty.PCPrptyInProcProcgSts = 'IP' OR _PCPhysProperty.PCPrptyReldProcgSts = 'RE' )  -- association [0..1]
;