P_ChmlCompositionCriticality

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

  --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: #NOT_REQUIRED
}

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

--VDM view type
@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view P_ChmlCompositionCriticality
  --Select data from chemical composition
  as 
  select from I_ChmlComposition as ChemcialComposition
  association [1..1] to P_CChmlCmplConstants           as _Constants on _Constants.Constant1 = _Constants.Constant1  
{
      --UUID of Chemcial Composition
  key ChemcialComposition.ChmlCompositionUUID,

      --Determine the criticaliyt by status
      case ChemcialComposition.ChmlCompositionStatus
        when 'IP' then _Constants[inner].Constant1
        when 'RE' then _Constants[inner].Constant3
        else _Constants[inner].Constant1
      end as ChmlCompositionStsCriticality
}