I_ChmlComponentOfReldCmpstn

--Label of view
@EndUserText.label: 'Component of Chemical Composition in Status Released'

@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'ICCMPRELCMPSTN',

  --If it's true, the filter conditions are compared and, if they match, the associated join expression is evaluated only once
  compiler.compareFilter: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #CHECK
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #COMPOSITE

@ObjectModel:
{
  --Performance Annotations
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #S,
    serviceQuality: #C
  }
}

define view I_ChmlComponentOfReldCmpstn
  --Select data from basic view 'Chemical Component'
  as select from           I_ChmlComponent   as ChemicalComponent

  --Join data from composition
    left outer to one join I_ChmlComposition as CompositionReleased on ChemicalComponent.ChmlCompositionUUID = CompositionReleased.ChmlCompositionUUID
{
      --UUID of component
      @ObjectModel.readOnly: true
  key ChemicalComponent.ChmlCompUUID,

      --UUID of chemical composition
      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompositionUUID,

      --UUID of chemical compliance information
      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCmplncInfoUUID,
      
      --UUID of Substance
      @ObjectModel.readOnly: true
      ChemicalComponent.SubstanceUUID,

      --Component Type
      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompType,
      
      --Concentration of component
      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompQty,
      
      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompQtyAsText,

      --Unit of measurment of concentration
      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompQtyUnit,

      --Operator for lower limit of concentration
      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompOperatorLowerLimit,

      --Lower limit of concentration
      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompQtyLowerLimit,

      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompQtyLowerLimitAsText,

      --Operator for upper limit of concentration
      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompOperatorUpperLimit,

      --Upper limit of concentration
      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompQtyUpperLimit,

      @ObjectModel.readOnly: true
      ChemicalComponent.ChmlCompQtyUpperLimitAsText,

      --Composition Type
      @ObjectModel.readOnly: true
      CompositionReleased.ChmlCompositionType,
      
      --Composition Status
      @ObjectModel.readOnly: true
      CompositionReleased.ChmlCompositionStatus,

      /* Associations */
      ChemicalComponent._ChemicalComposition,
      ChemicalComponent._ChmlCmplncInfo,
      ChemicalComponent._Substance,
      ChemicalComponent._ComponentType,
      ChemicalComponent._UnitOfMeasure,
      ChemicalComponent._OperatorLowerLimit,
      ChemicalComponent._OperatorUpperLimit,
      CompositionReleased._CompositionStatus,
      CompositionReleased._CompositionType
}
where CompositionReleased.ChmlCompositionStatus = 'RE'