C_PckgdDngrsGoodMarkingOvw

DDL: C_PCKGDDNGRSGOODMARKINGOVW Type: view_entity CONSUMPTION Package: EHFND_OBSOLETE

Packaged Dangerous Good Marking Overview

C_PckgdDngrsGoodMarkingOvw is a Consumption CDS View that provides data about "Packaged Dangerous Good Marking Overview" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRslt) and exposes 9 fields with key fields ChmlCmplncInfoUUID, CmplRqRsltUUID, Language. It has 1 association to related views. Part of development package EHFND_OBSOLETE.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt crr from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_LanguageText _LanguageText motDesc.Language = _LanguageText.LanguageCode

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Packaged Dangerous Good Marking Overview view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.dataCategory #TEXT view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_CmplRqRslt ChmlCmplncInfoUUID
KEY CmplRqRsltUUID I_CmplRqRslt CmplRqRsltUUID
KEY Language motDesc Language
CmplRqVersName
ComplianceRequirement I_CmplRqRslt ComplianceRequirement
CmplRqRsltProcessingStatus I_CmplRqRslt CmplRqRsltProcessingStatus
DngrsGoodMarkingLabelText motDesc DngrsGoodMarkingLabelText
_CmplRqRsltProcessingStatus I_CmplRqRslt _CmplRqRsltProcessingStatus
_LanguageText _LanguageText 
@AccessControl:
{
  authorizationCheck: #MANDATORY,
  personalData.blocking: #NOT_REQUIRED
}

@EndUserText.label: 'Packaged Dangerous Good Marking Overview'

@Metadata.allowExtensions: true

@VDM.viewType: #CONSUMPTION

//@ClientHandling.algorithm: #SESSION_VARIABLE


@ObjectModel:
{
  semanticKey: [ 'ComplianceRequirement' ],
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #L, // < 10.000.000

    serviceQuality: #C // <= 15 msec

  },
  dataCategory: #TEXT
}
define view entity C_PckgdDngrsGoodMarkingOvw
  as select from I_CmplRqRslt as crr
    join         P_MoOfTrDesc as motDesc on motDesc.CmplRqRsltUUID = crr.CmplRqRsltUUID
  // left outer to many join P_MoOfTrDesc as motDesc on motDesc.CmplRqRsltUUID = crr.CmplRqRsltUUID // JBH: BASE SHOULD NOT EXTENDED BUT MODIFIED THEREFORE USE INNER JOIN


  // JBH: SLOWER THAN CRR AS BASE VIEW

  // as select from P_MoOfTrDesc as motDesc

  //   left outer to many join I_CmplRqRslt as crr on motDesc.CmplRqRsltUUID = crr.CmplRqRsltUUID


  // JBH: NO PERF BOOST WHEN EXTRACT CmplRqVersName FROM I_CmplRqVersEnhanced

  // association [0..1] to I_CmplRqVersName as _CmplRqVersNames on  _CmplRqVersNames.CmplRqVersUUID             = crr.CmplRqVersUUID

  //                                                            and _CmplRqVersNames.CmplRqApplicationComponent = 'DG'


  // JBH: WRONG RESULT WITH ASSO

  // association [0..*] to P_MoOfTrDesc   as motDesc       on  motDesc.CmplRqRsltUUID            =  crr.CmplRqRsltUUID

  //                                                       and motDesc.DngrsGoodMarkingLabelText <> ''

  association [0..*] to I_LanguageText as _LanguageText on motDesc.Language = _LanguageText.LanguageCode
{
  key crr.ChmlCmplncInfoUUID,
  key crr.CmplRqRsltUUID,

      @ObjectModel.readOnly: true
      @ObjectModel.text.association: '_LanguageText'
      @ObjectModel.filter.enabled: false
      @Semantics.language: true
  key motDesc.Language,

      @ObjectModel.filter.enabled: false
      //      _CmplRqVersNames.CmplRqVersName,

      cast (crr._CmplRqVers.CmplRqVersName as ehdgm_regulation_name preserving type) as CmplRqVersName,

      crr.ComplianceRequirement, // used for DCL


      @ObjectModel.readOnly: true
      crr.CmplRqRsltProcessingStatus,


      @ObjectModel.filter.enabled: false
      motDesc.DngrsGoodMarkingLabelText,

      // Associations

      crr._CmplRqRsltProcessingStatus,
      _LanguageText

}
where
  //       motDesc.DngrsGoodMarkingLabelText <> ''

  //  and(

     crr.CmplRqRsltProcessingStatus = 'IP'
  or crr.CmplRqRsltProcessingStatus = 'RE'
//  )

Learn More