C_PackagedDangerousGoodTP

DDL: C_PACKAGEDDANGEROUSGOODTP Type: view_entity CONSUMPTION
41 Fields 1 Data Sources 3 Associations

Packaged Dangerous Good - TP

C_PackagedDangerousGoodTP is a Consumption CDS View that provides data about "Packaged Dangerous Good - TP" in SAP S/4HANA. It reads from 1 data source (R_PackagedDangerousGoodTP) and exposes 41 fields with key field ChmlCmplncInfoUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_PackagedDangerousGoodTP R_PackagedDangerousGoodTP projection

Associations (3)

CardinalityTargetAliasCondition
[0..1] C_ChmlCmplncInfoQuickView _UnpckgdChmlCmplncInfoQuickVw $projection.UnpckgdChemicalComplianceInfo = _UnpckgdChmlCmplncInfoQuickVw.Specification
[0..1] C_ChmlCmplncInfoQuickView _ChmlCmplncInfoQuickVw $projection.ChemicalComplianceInfo = _ChmlCmplncInfoQuickVw.Specification
[0..*] C_PckgdDngrsGoodDescOvw _DescriptionOverview $projection.ChmlCmplncInfoUUID = _DescriptionOverview.ChmlCmplncInfoUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Packaged Dangerous Good - TP view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
DngrsGdsRespUnit DngrsGdsRespUnit Responsible Unit for Dangerous Goods
Product Product Product Sold
ProductName
ProductGroup _Product ProductGroup Product Sold Group
ProductGroupName
UnpackagedProduct UnpackagedProduct
RawMaterial RawMaterial Component
ChmlCmplncInternalName ChmlCmplncInternalName Internal Name
ChmlCmplncInfoUnpckgdProdName ChmlCmplncInfoUnpckgdProdName
UnpackagedUnpckgdChmlCmplncInfoUUID
UnpckgdChemicalComplianceInfo
ChmlCmplncInfoType ChmlCmplncInfoType Type of Chemical Compliance Information
MaterialIsSold MaterialIsSold Is Sold
MaterialIsTransported MaterialIsTransported Is Transported
MaterialIsSourced MaterialIsSourced Is Purchased
MaterialIsProduced MaterialIsProduced Is Produced
ChmlCmplncProdIsResearched ChmlCmplncProdIsResearched R&D Sample
char255
virtualSemanticObjectui2semantic_object
DescriptionOfDngrsGdsPckg
PackagingIsTankOrBulkFilling _EnclosureDetails PackagingIsTankOrBulkFilling
DngrsGoodIsPartiallyPackaged _EnclosureDetails DngrsGoodIsPartiallyPackaged
DescOfDngrsGdsPckgNamelocalized
DangerousGoodsPackagingCode
DangerousGoodsEnclosureQty _EnclosureDetails DangerousGoodsEnclosureQty Quantity of Dangerous Goods Package
DangerousGoodsEnclosureUnit _EnclosureDetails DangerousGoodsEnclosureUnit Enclosure Unit
DngrsGdsEnclrNmbrOfInnerPckgs _EnclosureDetails DngrsGdsEnclrNmbrOfInnerPckgs Number of Inner Packages
DescOfDngrsGdsInnerPackgg _EnclosureDetails DescOfDngrsGdsInnerPackgg Description of Inner Package
DngrsGdsEnclrInnerPackageQty _EnclosureDetails DngrsGdsEnclrInnerPackageQty Quantity of Inner Package
DngrsGdsEnclrInnerPackageUnit _EnclosureDetails DngrsGdsEnclrInnerPackageUnit Inner Package Unit
DangerousGoodsControlTemp _EnclosureDetails DangerousGoodsControlTemp Control Temperature
DangerousGoodsControlTempUnit _EnclosureDetails DangerousGoodsControlTempUnit Control Temperature Unit
DangerousGoodsEmergencyTemp _EnclosureDetails DangerousGoodsEmergencyTemp Emergency Temperature
DangerousGoodsEmgyTempUnit _EnclosureDetails DangerousGoodsEmgyTempUnit Emergency Temperature Unit
_ChmlCmplncInfoQuickVw _ChmlCmplncInfoQuickVw
_DescriptionOverview _DescriptionOverview

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_PackagedDangerousGoodTP.
-- 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 C_PackagedDangerousGoodTP AS
SELECT
  ChmlCmplncInfoUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  DngrsGdsRespUnit,
  Product,
  _Product._Text[1: Language = $session.system_language].ProductName AS ProductName,
  _Product.ProductGroup AS ProductGroup,
  _Product._ProductGroupText_2[1: Language = $session.system_language].ProductGroupName AS ProductGroupName,
  UnpackagedProduct,
  RawMaterial,
  ChmlCmplncInternalName,
  ChmlCmplncInfoUnpckgdProdName,
  cast(UnpckgdChemicalComplianceInfo as ehfnd_compliance_view_up preserving type) AS UnpckgdChemicalComplianceInfo,
  ChmlCmplncInfoType,
  MaterialIsSold,
  MaterialIsTransported,
  MaterialIsSourced,
  MaterialIsProduced,
  ChmlCmplncProdIsResearched,
  virtual ChmlCmplncTypeImageURL : abap.char(255) AS char255,
  virtual SemanticObject : /ui2/semantic_object AS virtualSemanticObjectui2semantic_object,
  _EnclosureDetails.PackagingIsTankOrBulkFilling AS PackagingIsTankOrBulkFilling,
  _EnclosureDetails.DngrsGoodIsPartiallyPackaged AS DngrsGoodIsPartiallyPackaged,
  _EnclosureDetails._DescOfDngrsGdsPckgText.DescOfDngrsGdsPckgName : localized AS DescOfDngrsGdsPckgNamelocalized,
  _EnclosureDetails._DescOfDngrsGdsPckg.DangerousGoodsPackagingCode AS DangerousGoodsPackagingCode,
  _EnclosureDetails.DangerousGoodsEnclosureQty AS DangerousGoodsEnclosureQty,
  _EnclosureDetails.DangerousGoodsEnclosureUnit AS DangerousGoodsEnclosureUnit,
  _EnclosureDetails.DngrsGdsEnclrNmbrOfInnerPckgs AS DngrsGdsEnclrNmbrOfInnerPckgs,
  _EnclosureDetails.DescOfDngrsGdsInnerPackgg AS DescOfDngrsGdsInnerPackgg,
  _EnclosureDetails.DngrsGdsEnclrInnerPackageQty AS DngrsGdsEnclrInnerPackageQty,
  _EnclosureDetails.DngrsGdsEnclrInnerPackageUnit AS DngrsGdsEnclrInnerPackageUnit,
  _EnclosureDetails.DangerousGoodsControlTemp AS DangerousGoodsControlTemp,
  _EnclosureDetails.DangerousGoodsControlTempUnit AS DangerousGoodsControlTempUnit,
  _EnclosureDetails.DangerousGoodsEmergencyTemp AS DangerousGoodsEmergencyTemp,
  _EnclosureDetails.DangerousGoodsEmgyTempUnit AS DangerousGoodsEmgyTempUnit
FROM R_PackagedDangerousGoodTP
LEFT OUTER JOIN C_ChmlCmplncInfoQuickView AS _UnpckgdChmlCmplncInfoQuickVw ON UnpckgdChemicalComplianceInfo = _UnpckgdChmlCmplncInfoQuickVw.Specification  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncInfoQuickView AS _ChmlCmplncInfoQuickVw ON ChemicalComplianceInfo = _ChmlCmplncInfoQuickVw.Specification  -- association [0..1]
LEFT OUTER JOIN C_PckgdDngrsGoodDescOvw AS _DescriptionOverview ON ChmlCmplncInfoUUID = _DescriptionOverview.ChmlCmplncInfoUUID  -- association [0..*]
;

Learn More