C_PckgdDngrsGoodMarkingOvw

@AbapCatalog:{
  sqlViewName: 'CPDGMAROVW',
  compiler.compareFilter: true,
  preserveKey:true
}

@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 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,

      crr._CmplRqVers.CmplRqVersName,

      crr.ComplianceRequirement, // used for DCL


      crr.CmplRqRsltProcessingStatus,

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

      // Associations

      crr._CmplRqRsltProcessingStatus,
      _LanguageText

}
where
//       motDesc.DngrsGoodMarkingLabelText <> ''

//  and(

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

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLT",
"I_CMPLRQVERSENHANCED",
"P_MOOFTRDESC"
],
"ASSOCIATED":
[
"I_CMPLRQRSLTPROCESSINGSTATUS",
"I_LANGUAGETEXT"
],
"BASE":
[
"I_CMPLRQRSLT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/