A_DngrsGdsBasicClassification

DDL: A_DNGRSGDSBASICCLASSIFICATION Type: view_entity CONSUMPTION
33 Fields 1 Data Sources 1 OData Services

Dangerous Goods Basic Classification

A_DngrsGdsBasicClassification is a Consumption CDS View that provides data about "Dangerous Goods Basic Classification" in SAP S/4HANA. It reads from 1 data source (R_DngrsGdsBasicClassfctnTP) and exposes 33 fields with key field CmplRqRsltUUID. It is exposed through 1 OData service (API_DNGRSGDSBASICCLASSFCTN).

Data Sources (1)

SourceAliasJoin Type
R_DngrsGdsBasicClassfctnTP R_DngrsGdsBasicClassfctnTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Dangerous Goods Basic Classification view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name DngrsGoodsBasicClassification view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
OData.entityType.name DngrsGoodsBasicClassification_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_DNGRSGDSBASICCLASSFCTN API_DNGRSGDSBASICCLASSFCTN V4 C2 C1

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID CmplRqRsltUUID SDS Assessment
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
CmplRqVersUUID CmplRqVersUUID NodeID
ChemicalComplianceInfo
Product Product Product Sold
ComplianceRequirement ComplianceRequirement Compliance Requirement
CmplRqVers CmplRqVers Compliance Requirement
CmplRqVersName CmplRqVersName Compliance Requirement Name
ProductIsNoDangerousGood _Detail ProductIsNoDangerousGood
ProdCmplncDngrsGdsIdnNmbrType _Detail ProdCmplncDngrsGdsIdnNmbrType Number (Prefix)
ProdCmplncDngrsGdsIdnNmbr _Detail ProdCmplncDngrsGdsIdnNmbr Number
ProdCmplncDngrsGdsPackingGroup _Detail DangerousGoodsPackingGroup Packing Group
DangerousGoodsListItemVariant _Detail DangerousGoodsListItemVariant Variant
TransportIsAllowed TransportIsAllowed
DangerousGoodsClass
DangerousGoodsSubsidiaryRisk1
DangerousGoodsSubsidiaryRisk2
DangerousGoodsSubsidiaryRisk3
DngrsGdsQualifgWordPrefix _Detail DngrsGdsQualifgWordPrefix Prefix
DngrsGdsQualifgWordSuffix _Detail DngrsGdsQualifgWordSuffix Suffix
ProductIsMarinePollutant _Detail ProductIsMarinePollutant Product Is Marine Pollutant
ProdIsEnvironmentalHazardous _Detail ProdIsEnvironmentalHazardous Product is Environmentally Hazardous
DngrsGdsTechName1Substance
DngrsGdsTechName2Substance
DngrsGdsTechName3Substance
DngrsGdsMarinePollutant1Subst
DngrsGdsMarinePollutant2Subst
DngrsGdsReportableQty1Subst
DngrsGdsReportableQty2Subst
ProductIsToxicByInhalation _Detail ProductIsToxicByInhalation Product Is Toxic by Inhalation
ToxicByInhalationHazardZone _Detail ToxicByInhalationHazardZone Inhalation Hazard Zone
ReportableQtyIsPrintedOnDoc _Detail ReportableQtyIsPrintedOnDoc Print Reportable Quantity Names
_ChmlCmplncInfo _ChmlCmplncInfo

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 A_DngrsGdsBasicClassification.
-- 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 A_DngrsGdsBasicClassification AS
SELECT
  CmplRqRsltUUID,
  ChmlCmplncInfoUUID,
  CmplRqVersUUID,
  cast( _ChmlCmplncInfo.Specification as ehfnd_vdm_cci_internal_nr preserving type ) AS ChemicalComplianceInfo,
  Product,
  ComplianceRequirement,
  CmplRqVers,
  CmplRqVersName,
  _Detail.ProductIsNoDangerousGood AS ProductIsNoDangerousGood,
  _Detail.ProdCmplncDngrsGdsIdnNmbrType AS ProdCmplncDngrsGdsIdnNmbrType,
  _Detail.ProdCmplncDngrsGdsIdnNmbr AS ProdCmplncDngrsGdsIdnNmbr,
  _Detail.DangerousGoodsPackingGroup AS ProdCmplncDngrsGdsPackingGroup,
  _Detail.DangerousGoodsListItemVariant AS DangerousGoodsListItemVariant,
  TransportIsAllowed,
  _Detail._CmplRqVersDngrsGdsPart1Item.DangerousGoodsClass AS DangerousGoodsClass,
  _Detail._CmplRqVersDngrsGdsPart1Item.DangerousGoodsSubsidiaryRisk1 AS DangerousGoodsSubsidiaryRisk1,
  _Detail._CmplRqVersDngrsGdsPart1Item.DangerousGoodsSubsidiaryRisk2 AS DangerousGoodsSubsidiaryRisk2,
  _Detail._CmplRqVersDngrsGdsPart1Item.DangerousGoodsSubsidiaryRisk3 AS DangerousGoodsSubsidiaryRisk3,
  _Detail.DngrsGdsQualifgWordPrefix AS DngrsGdsQualifgWordPrefix,
  _Detail.DngrsGdsQualifgWordSuffix AS DngrsGdsQualifgWordSuffix,
  _Detail.ProductIsMarinePollutant AS ProductIsMarinePollutant,
  _Detail.ProdIsEnvironmentalHazardous AS ProdIsEnvironmentalHazardous,
  cast( _Detail._DngrsGdsTechName1Substance.Specification as dngrsgdstechname1substance preserving type ) AS DngrsGdsTechName1Substance,
  cast( _Detail._DngrsGdsTechName2Substance.Specification as dngrsgdstechname2substance preserving type ) AS DngrsGdsTechName2Substance,
  cast( _Detail._DngrsGdsTechName3Substance.Specification as dngrsgdstechname3substance preserving type ) AS DngrsGdsTechName3Substance,
  cast( _Detail._DngrsGdsMarnPlltnt1Substance.Specification as dngrsgdsmarinepollutant1subst preserving type ) AS DngrsGdsMarinePollutant1Subst,
  cast( _Detail._DngrsGdsMarnPlltnt2Substance.Specification as dngrsgdsmarinepollutant2subst preserving type ) AS DngrsGdsMarinePollutant2Subst,
  cast( _Detail._DngrsGdsRptblQty1Substance.Specification as dngrsgdsreportableqty1subst preserving type ) AS DngrsGdsReportableQty1Subst,
  cast( _Detail._DngrsGdsRptblQty2Substance.Specification as dngrsgdsreportableqty2subst preserving type ) AS DngrsGdsReportableQty2Subst,
  _Detail.ProductIsToxicByInhalation AS ProductIsToxicByInhalation,
  _Detail.ToxicByInhalationHazardZone AS ToxicByInhalationHazardZone,
  _Detail.ReportableQtyIsPrintedOnDoc AS ReportableQtyIsPrintedOnDoc
FROM R_DngrsGdsBasicClassfctnTP
;

Learn More