C_US_AnlytlCmpstnRptblQtyCFR

@AbapCatalog.sqlViewName: 'CDGRQCFR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Reportable Qunatity from Analytical Composition for 49 CFR'
@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@Consumption.dbHints: ['USE_HEX_PLAN']

define view C_US_AnlytlCmpstnRptblQtyCFR


  as select from I_CmplRqRsltDngrsGdsBscDets
    inner join   I_CmplRqRslt           on I_CmplRqRslt.CmplRqRsltUUID           = I_CmplRqRsltDngrsGdsBscDets.CmplRqRsltUUID
    inner join   I_ChmlComposition      on I_ChmlComposition.ChmlCmplncInfoUUID  = I_CmplRqRslt.ChmlCmplncInfoUUID
    inner join   I_ChmlComponent        on I_ChmlComposition.ChmlCompositionUUID = I_ChmlComponent.ChmlCompositionUUID
    inner join   C_US_AllRptblQtyCFR    on  C_US_AllRptblQtyCFR.CmplRqVersUUID   = I_CmplRqRsltDngrsGdsBscDets.CmplRqVersUUID
                                        and C_US_AllRptblQtyCFR.SubstanceUUID    = I_ChmlComponent.SubstanceUUID
                                        
  association [0..1] to I_UnitOfMeasure     as _UnitOfMeasure     on $projection.SubstanceListItmThresholdUoM = _UnitOfMeasure.UnitOfMeasure
  association [0..*] to I_UnitOfMeasureText as _UnitOfMeasureText on $projection.SubstanceListItmThresholdUoM = _UnitOfMeasureText.UnitOfMeasure

{
  key I_CmplRqRsltDngrsGdsBscDets.CmplRqRsltDngrsGdsBscDetsUUID,
  key I_ChmlComponent.SubstanceUUID,

      I_CmplRqRsltDngrsGdsBscDets.CmplRqVersUUID,

      C_US_AllRptblQtyCFR.SubstanceName,
      C_US_AllRptblQtyCFR.ListedSubstanceGroupName as ListedSubstanceGroupName,
      @Semantics.quantity.unitOfMeasure: 'SubstanceListItmThresholdUoM'
      C_US_AllRptblQtyCFR.SubstanceListItmThreshold,
      
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      @ObjectModel.text.association: '_UnitOfMeasureText'
      @Semantics.unitOfMeasure: true
      C_US_AllRptblQtyCFR.SubstanceListItmThresholdUoM,
      C_US_AllRptblQtyCFR.ECNumber,
      C_US_AllRptblQtyCFR.CASNumber,

      I_CmplRqRslt.ChmlCmplncInfoUUID,
      I_ChmlComponent._Substance,
      // Required for DCL

      I_CmplRqRslt._ChmlCmplncInfo,
      
      _UnitOfMeasure,
      _UnitOfMeasureText

}
where
      I_ChmlComposition.ChmlCompositionType     = 'ANALYTIC1'
  and I_ChmlComposition.ChmlCompositionStatus   = 'RE'