C_PckgdDngrsGoodHzdNote

DDL: C_PCKGDDNGRSGOODHZDNOTE SQL: CPDGHZDNOTE Type: view CONSUMPTION

Packaged DG Hazard Notes

C_PckgdDngrsGoodHzdNote is a Consumption CDS View that provides data about "Packaged DG Hazard Notes" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncHzdNote) and exposes 5 fields with key fields ChmlCmplncInfoUUID, DngrsGdsHazardNotePhrsUUID. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncHzdNote I_ChmlCmplncHzdNote from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_ProdCmplncPhrsTxtWthFallback _ProdCmplncPhrsTxt _ProdCmplncPhrsTxt.ProdCmplncPhrsUUID = $projection.DngrsGdsHazardNotePhrsUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPDGHZDNOTE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Packaged DG Hazard Notes view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID
KEY DngrsGdsHazardNotePhrsUUID DngrsGdsHazardNotePhrsUUID
ProdCmplncPhrsText _ProdCmplncPhrsTxt ProdCmplncPhrsText
DngrsGdsHazardNoteSequence DngrsGdsHazardNoteSequence
DngrsGdsRespUnit DngrsGdsRespUnit 
@AbapCatalog.sqlViewName: 'CPDGHZDNOTE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl:
{
  authorizationCheck: #MANDATORY,
  personalData.blocking: #NOT_REQUIRED
}
@EndUserText.label: 'Packaged DG Hazard Notes'

@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  semanticKey: ['DngrsGdsHazardNotePhrsUUID'],
  
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #C
  }
}

define view C_PckgdDngrsGoodHzdNote
  as select from I_ChmlCmplncHzdNote
  association [0..1] to C_ProdCmplncPhrsTxtWthFallback as _ProdCmplncPhrsTxt on _ProdCmplncPhrsTxt.ProdCmplncPhrsUUID = $projection.DngrsGdsHazardNotePhrsUUID
{
  key ChmlCmplncInfoUUID,
  key DngrsGdsHazardNotePhrsUUID,

      @ObjectModel.readOnly: true
      @Semantics.text: true
      _ProdCmplncPhrsTxt.ProdCmplncPhrsText as ProdCmplncPhrsText,

      DngrsGdsHazardNoteSequence,

      // DCL Fields

      @Consumption.hidden: true
      DngrsGdsRespUnit
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_PRODCMPLNCPHRSTXTWTHFALLBACK",
"I_CHMLCMPLNCHZDNOTE"
],
"ASSOCIATED":
[
"C_PRODCMPLNCPHRSTXTWTHFALLBACK"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More