C_AnlytlCmpstnMarnPlltntIMDG

@AbapCatalog.sqlViewName: 'CDGMARNPOLIMDG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Marine Pollutants for Analytical Composition for IMDG'
@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  --Performance Annotations
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
  },
  resultSet.sizeCategory: #XS
}

define view C_AnlytlCmpstnMarnPlltntIMDG

  as select from I_CmplRqRsltDngrsGdsBscDets
    inner join   I_CmplRqRslt                  on I_CmplRqRslt.CmplRqRsltUUID = I_CmplRqRsltDngrsGdsBscDets.CmplRqRsltUUID
    inner join   P_UpaDaGdsClfnTechName        on P_UpaDaGdsClfnTechName.ChmlCmplncInfoUUID = I_CmplRqRslt.ChmlCmplncInfoUUID // we can reuse the 'technical name' view here, since it is just based on the analytical composition of the CCI

    inner join   P_MarnPlltntNameLogonLangIMDG on  P_MarnPlltntNameLogonLangIMDG.SubstanceUUID  = P_UpaDaGdsClfnTechName.SubstanceUUID
                                               and P_MarnPlltntNameLogonLangIMDG.CmplRqVersUUID = I_CmplRqRsltDngrsGdsBscDets.CmplRqVersUUID

{
  key I_CmplRqRsltDngrsGdsBscDets.CmplRqRsltDngrsGdsBscDetsUUID,
  key P_UpaDaGdsClfnTechName.SubstanceUUID,

      I_CmplRqRsltDngrsGdsBscDets.CmplRqVersUUID,
      P_MarnPlltntNameLogonLangIMDG.SubstanceName,
      P_MarnPlltntNameLogonLangIMDG.SubstanceHasNameOnList , // On Marine Pollutant List

      ECNumber,
      CASNumber,
      P_MarnPlltntNameLogonLangIMDG.ListedSubstanceGroupName as ListedSubstanceGroupName, 
      I_CmplRqRslt.ChmlCmplncInfoUUID,
      P_UpaDaGdsClfnTechName._Substance,
      // Required for DCL

      I_CmplRqRslt._ChmlCmplncInfo

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLT",
"I_CMPLRQRSLTDNGRSGDSBSCDETS",
"P_MARNPLLTNTNAMELOGONLANGIMDG",
"P_UPADAGDSCLFNTECHNAME"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"I_SUBSTANCEENHANCED"
],
"BASE":
[
"I_CMPLRQRSLT",
"P_UPADAGDSCLFNTECHNAME"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/