I_PackagedDangerousGood

DDL: I_PACKAGEDDANGEROUSGOOD SQL: PPDG Type: view COMPOSITE

Packaged Dangerous Good

I_PackagedDangerousGood is a Composite CDS View that provides data about "Packaged Dangerous Good" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 26 fields with key field ChmlCmplncInfoUUID.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfo ChemicalComplianceInfo from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPDG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Packaged Dangerous Good view
VDM.viewType #COMPOSITE view
Metadata.allowExtensions false view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID
CreationUTCDateTime CreationUTCDateTime
CreatedByUser CreatedByUser
LastChangeUTCDateTime LastChangeUTCDateTime
LastChangedByUser LastChangedByUser
ProdStewardshipRespUnit ProdStewardshipRespUnit
DngrsGdsRespUnit DngrsGdsRespUnit
ChmlCmplncInfoType ChmlCmplncInfoType
ChmlCmplncInternalName ChmlCmplncInternalName
MaterialIsBaseProduct MaterialIsBaseProduct
MaterialIsSold MaterialIsSold
MaterialIsTransported MaterialIsTransported
MaterialIsSourced MaterialIsSourced
MaterialIsProduced MaterialIsProduced
_Application _Application
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_MarketCoverage _MarketCoverage
_MarketRequest _MarketRequest
_MaterialAssignment _MaterialAssignment
_PrimaryMaterial _PrimaryMaterial
_ProductAssignment _ProductAssignment
_PurposeAssignment _PurposeAssignment
_RespUnitForDangerousGoods _RespUnitForDangerousGoods
_RespUnitForProductStewardship _RespUnitForProductStewardship
_SuplrMatlAssignment _SuplrMatlAssignment 
@AbapCatalog.sqlViewName: 'PPDG'
@AbapCatalog.compiler.compareFilter: true

@AccessControl:
{
  authorizationCheck: #MANDATORY,
  personalData.blocking: #NOT_REQUIRED,
  privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]
}

@EndUserText.label: 'Packaged Dangerous Good'

@VDM.viewType: #COMPOSITE

@Metadata.allowExtensions: false

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #B
  }
}

define view I_PackagedDangerousGood
  as select from I_ChmlCmplncInfo as ChemicalComplianceInfo
{
  key ChmlCmplncInfoUUID,
      CreationUTCDateTime,
      CreatedByUser,
      LastChangeUTCDateTime,
      LastChangedByUser,
      ProdStewardshipRespUnit,
      DngrsGdsRespUnit,
      ChmlCmplncInfoType,
      ChmlCmplncInternalName,
      MaterialIsBaseProduct,
      MaterialIsSold,
      MaterialIsTransported,
      MaterialIsSourced,
      MaterialIsProduced,

      /* Associations */
      _Application,
      _CreatedByUser,
      _LastChangedByUser,
      _MarketCoverage,
      _MarketRequest,
      _MaterialAssignment,
      _PrimaryMaterial,
      _ProductAssignment,
      _PurposeAssignment,
      _RespUnitForDangerousGoods,
      _RespUnitForProductStewardship,
      _SuplrMatlAssignment
}
where
      ChemicalComplianceInfo.ChmlCmplncInfoType    = 'PP'
  and ChemicalComplianceInfo.MaterialIsTransported = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCINFO"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCAPPLASSGMT",
"I_CHMLCMPLNCMATLASSGMT",
"I_CHMLCMPLNCMKTCVRG",
"I_CHMLCMPLNCMKTREQ",
"I_CHMLCMPLNCPRODASSGMT",
"I_CHMLCMPLNCPRPSASSGMT",
"I_CHMLCMPLNCSUPLRMATLASSGMT",
"I_RESPONSIBLEUNIT",
"I_RESPONSIBLEUNITDNGRSGDS",
"I_USER"
],
"BASE":
[
"I_CHMLCMPLNCINFO"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More