C_UnpackagedDangerousGood

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_UnpackagedDangerousGood.
-- 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: CUPDG

CREATE VIEW C_UnpackagedDangerousGood AS
SELECT
  ChemicalComplianceInfo.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  cast (PrimaryMaterial.Material as productnumber preserving type ) AS Product,
  cast (PrimaryMaterial.Material as ehfnd_cci_raw_material preserving type ) AS RawMaterial,
  cast( bintohex(ChemicalComplianceInfo.ChmlCmplncInfoUUID) as sit_de_ancobjkey ) AS SitnInstceAnchorObjectKey,
  _Product.ProductGroup AS ProductGroup,
  ChemicalComplianceInfo.Specification AS Specification,
  cast( coalesce( ProductText.ProductName, ChemicalComplianceInfo.ChmlCmplncInternalName ) as ehfnd_cci_up ) AS ChmlCmplncInfoCombinedName,
  ChemicalComplianceInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  ProductText.ProductName AS ProductName,
  ReleasedAnalyticalComposition.ChmlCompositionReleasedUUID AS AnalyticCmpstnReleasedUUID,
  ReleasedAnalyticalComposition.ReleaseDateTime AS AnalyticCmpstnReleaseDateTime,
  cast( 'X' as char1 ) AS IsCloudSystem,
  ChemicalComplianceInfo.DngrsGdsRespUnit AS DngrsGdsRespUnit,
  _AnlytlCmpstn.ChmlCompositionReleasedUUID AS AnalyticCmpstnNavgnLinkUUID,
  _MatlBsdCmpstn.ChmlCompositionReleasedUUID AS MatlBsdCmpstnNavgnLinkUUID,
  _PCPhysProperty.PCPrptyNavgnLinkUUID AS PCPhysPrptyNavgnLinkUUID,
  ChemicalComplianceInfo.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  ChemicalComplianceInfo.MaterialIsSold AS MaterialIsSold,
  ChemicalComplianceInfo.MaterialIsTransported AS MaterialIsTransported,
  ChemicalComplianceInfo.MaterialIsSourced AS MaterialIsSourced,
  ChemicalComplianceInfo.MaterialIsProduced AS MaterialIsProduced,
  cast( '' as abap.char( 255 ) ) AS ChmlCmplncTypeImageURL
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_DngrsGdsAnlytlCmpstnComp AS _ChmlCompOfReldAnlytlCmpstn ON AnalyticCmpstnReleasedUUID = _ChmlCompOfReldAnlytlCmpstn.ChmlCompositionUUID  -- association [0..*]
LEFT OUTER JOIN C_UnpackagedDangerousGoodClfn AS _UnpackagedDangerousGoodClfn ON ChmlCmplncInfoUUID = _UnpackagedDangerousGoodClfn.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_UpaDaGdsClfnAssgdPckgdClfn AS _RelatedPackagedProduct ON ChmlCmplncInfoUUID = _RelatedPackagedProduct.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN P_AssociatedAnlytlReldCmpstn AS _AnlytlCmpstn ON _AnlytlCmpstn.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_AssociatedMatlReldCmpstn AS _MatlBsdCmpstn ON _MatlBsdCmpstn.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplncInfoAssgdPCPhys AS _PCPhysProperty ON _PCPhysProperty.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID AND _PCPhysProperty.PCPrptyRootType = 'EHFNDD_PHYSCHEM' AND ( _PCPhysProperty.PCPrptyInProcProcgSts = 'IP' OR _PCPhysProperty.PCPrptyReldProcgSts = 'RE' )  -- association [0..1]
;