P_DangerousGoodsClassification

DDL: P_DANGEROUSGOODSCLASSIFICATION SQL: PDGCLFN Type: view COMPOSITE Package: EHDGM_CNS_UNPACKAGED_PRODUCT

Combination of information from CRR and DG Details

P_DangerousGoodsClassification is a Composite CDS View that provides data about "Combination of information from CRR and DG Details" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRslt) and exposes 11 fields with key field CmplRqRsltUUID. Part of development package EHDGM_CNS_UNPACKAGED_PRODUCT.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt CmplRqRslt from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PDGCLFN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID I_CmplRqRslt CmplRqRsltUUID
ComplianceRequirement I_CmplRqRslt ComplianceRequirement
ChmlCmplncInfoUUID I_CmplRqRslt ChmlCmplncInfoUUID
CmplRqVersUUID I_CmplRqRslt CmplRqVersUUID
CmplRqRsltProcessingStatus I_CmplRqRslt CmplRqRsltProcessingStatus
CmplRqRsltManualStatus I_CmplRqRslt CmplRqRsltManualStatus
CmplRqRsltReldCmplncSts I_CmplRqRslt CmplRqRsltReldCmplncSts
CmplRqRsltDngrsGdsBscDetsUUID CmplRqRsltDngrsGdsBscDets CmplRqRsltDngrsGdsBscDetsUUID
ClassifiedAsDangerousGood CmplRqRsltDngrsGdsBscDets ClassifiedAsDangerousGood
DangerousGoodsPackingGroup CmplRqRsltDngrsGdsBscDets DangerousGoodsPackingGroup
DangerousGoodsIdnNumber 
@AbapCatalog.sqlViewName: 'PDGCLFN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_DangerousGoodsClassification
  as select from I_CmplRqRslt                as CmplRqRslt
    join         I_CmplRqRsltDngrsGdsBscDets as CmplRqRsltDngrsGdsBscDets on CmplRqRslt.CmplRqRsltUUID = CmplRqRsltDngrsGdsBscDets.CmplRqRsltUUID
{
  key CmplRqRslt.CmplRqRsltUUID,
      CmplRqRslt.ComplianceRequirement,
      CmplRqRslt.ChmlCmplncInfoUUID,
      CmplRqRslt.CmplRqVersUUID,
      CmplRqRslt.CmplRqRsltProcessingStatus,
      CmplRqRslt.CmplRqRsltManualStatus,
      CmplRqRslt.CmplRqRsltReldCmplncSts,
      CmplRqRsltDngrsGdsBscDets.CmplRqRsltDngrsGdsBscDetsUUID,
      CmplRqRsltDngrsGdsBscDets.ClassifiedAsDangerousGood,
      CmplRqRsltDngrsGdsBscDets.DangerousGoodsPackingGroup,
      cast( concat( DangerousGoodsIdnNumberType, DangerousGoodsIdnNumber ) as ehdgm_dangerous_good_idn_comb ) as DangerousGoodsIdnNumber
}

Learn More