R_UnpackagedDangerousGoodTP

DDL: R_UNPACKAGEDDANGEROUSGOODTP Type: view_entity TRANSACTIONAL
23 Fields 1 Data Sources 6 Associations

Unpackaged Dangerous Good - TP

R_UnpackagedDangerousGoodTP is a Transactional CDS View that provides data about "Unpackaged Dangerous Good - TP" in SAP S/4HANA. It reads from 1 data source (I_UnpackagedDangerousGood) and exposes 23 fields with key field ChmlCmplncInfoUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_UnpackagedDangerousGood UnpackagedDangerousGood from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_UpaDaGdDescForReldRegulation _DescForReldRegulation $projection.ChmlCmplncInfoUUID = _DescForReldRegulation.ChmlCmplncInfoUUID
[0..1] I_DngrsGoodReldClassfctnCount _ReleasedClassificationCount $projection.ChmlCmplncInfoUUID = _ReleasedClassificationCount.ChmlCmplncInfoUUID
[0..1] I_ChmlComposition _ReleasedAnalyticalComposition _ReleasedAnalyticalComposition.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID and _ReleasedAnalyticalComposition.ChmlCompositionStatus = 'RE' and _ReleasedAnalyticalComposition.ChmlCompositionType = 'ANALYTIC1'
[0..*] R_UnpckgdDngrsGoodClassfctnTP _Classification
[0..*] R_UnpckgdDngrsGoodPckgdProdTP _PackagedProduct

Annotations (10)

NameValueLevelField
EndUserText.label Unpackaged Dangerous Good - TP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name UnpackagedDangerousGood view
ObjectModel.representativeKey ChmlCmplncInfoUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_UnpackagedDangerousGood ChmlCmplncInfoUUID Chemical Compliance Information PP
CreationUTCDateTime I_UnpackagedDangerousGood CreationUTCDateTime Time Stamp
CreatedByUser I_UnpackagedDangerousGood CreatedByUser User Name
LastChangeUTCDateTime I_UnpackagedDangerousGood LastChangeUTCDateTime Time Stamp
LastChangedByUser I_UnpackagedDangerousGood LastChangedByUser User Name
DngrsGdsRespUnit I_UnpackagedDangerousGood DngrsGdsRespUnit Responsible Unit for Dangerous Goods
ChmlCmplncInternalName I_UnpackagedDangerousGood ChmlCmplncInternalName Internal Name
ChemicalComplianceInfo ChemicalComplianceInfo Internal Number
Product
ChmlCmplncInfoType I_UnpackagedDangerousGood ChmlCmplncInfoType Type of Chemical Compliance Information
ChmlCmplncProdIsResearched I_UnpackagedDangerousGood ChmlCmplncProdIsResearched R&D Sample
MaterialIsSold I_UnpackagedDangerousGood MaterialIsSold Is Sold
MaterialIsTransported I_UnpackagedDangerousGood MaterialIsTransported Is Transported
MaterialIsSourced I_UnpackagedDangerousGood MaterialIsSourced Is Purchased
MaterialIsProduced I_UnpackagedDangerousGood MaterialIsProduced Is Produced
_Classification _Classification
_PackagedProduct _PackagedProduct
_Product _Product
_DescForReldRegulation _DescForReldRegulation
_ReleasedClassificationCount _ReleasedClassificationCount
_ReleasedAnalyticalComposition _ReleasedAnalyticalComposition
_CreatedByUser I_UnpackagedDangerousGood _CreatedByUser
_LastChangedByUser I_UnpackagedDangerousGood _LastChangedByUser

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_UnpackagedDangerousGoodTP.
-- 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_UnpackagedDangerousGoodTP AS
SELECT
  UnpackagedDangerousGood.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  UnpackagedDangerousGood.CreationUTCDateTime AS CreationUTCDateTime,
  UnpackagedDangerousGood.CreatedByUser AS CreatedByUser,
  UnpackagedDangerousGood.LastChangeUTCDateTime AS LastChangeUTCDateTime,
  UnpackagedDangerousGood.LastChangedByUser AS LastChangedByUser,
  UnpackagedDangerousGood.DngrsGdsRespUnit AS DngrsGdsRespUnit,
  UnpackagedDangerousGood.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  ChemicalComplianceInfo,
  cast( UnpackagedDangerousGood._PrimaryMaterial.Material as productnumber preserving type ) AS Product,
  UnpackagedDangerousGood.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  UnpackagedDangerousGood.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  UnpackagedDangerousGood.MaterialIsSold AS MaterialIsSold,
  UnpackagedDangerousGood.MaterialIsTransported AS MaterialIsTransported,
  UnpackagedDangerousGood.MaterialIsSourced AS MaterialIsSourced,
  UnpackagedDangerousGood.MaterialIsProduced AS MaterialIsProduced,
  UnpackagedDangerousGood._CreatedByUser AS _CreatedByUser,
  UnpackagedDangerousGood._LastChangedByUser AS _LastChangedByUser
FROM I_UnpackagedDangerousGood AS UnpackagedDangerousGood
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_UpaDaGdDescForReldRegulation AS _DescForReldRegulation ON ChmlCmplncInfoUUID = _DescForReldRegulation.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_DngrsGoodReldClassfctnCount AS _ReleasedClassificationCount ON ChmlCmplncInfoUUID = _ReleasedClassificationCount.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlComposition AS _ReleasedAnalyticalComposition ON _ReleasedAnalyticalComposition.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID AND _ReleasedAnalyticalComposition.ChmlCompositionStatus = 'RE' AND _ReleasedAnalyticalComposition.ChmlCompositionType = 'ANALYTIC1'  -- association [0..1]
LEFT OUTER JOIN R_UnpckgdDngrsGoodClassfctnTP AS _Classification ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_UnpckgdDngrsGoodPckgdProdTP AS _PackagedProduct ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More