faa_comp_code_nriv

@AbapCatalog.sqlViewName: 'FAAV_BUKRSN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Asset Company Codes with Number Range SubObject'
define view faa_comp_code_nriv
  as select from    faav_comp_code_n as cmp_faa // all BUKRS in Switch-ON case

    left outer join faac_cmp0        as cmp_nriv    on cmp_faa.comp_code = cmp_nriv.comp_code
    left outer join faac_cmp0        as cmp_generic on cmp_generic.comp_code = '*'
{
  key cmp_faa.client    as client,
  key cmp_faa.comp_code as comp_code,
      case
      when cmp_nriv.comp_code_nriv is not null    --- specific entry for company code ---
       and cmp_nriv.comp_code_nriv <> ''          --- explicit value for COMP_CODE_NRIV
      then cmp_nriv.comp_code_nriv

      // when cmp_nriv.comp_code_nriv is not null --- specific entry for company code ---

      //  and cmp_nriv.comp_code_nriv = ''        --- no value for COMP_CODE_NRIV => take over COMP_CODE

      // then cmp_faa.comp_code

      //

      // when cmp_nriv.comp_code_nriv is null     --- NO specific entry for company code => use generic entry ---

      //  and cmp_generic.comp_code_nriv = ''     --- NO explicit value for COMP_CODE_NRIV in GENERIC entry

      // then cmp_faa.comp_code


      when cmp_nriv.comp_code_nriv is null        --- NO specific entry for company code => use generic entry ---
       and cmp_generic.comp_code_nriv <> ''       --- explicit value for COMP_CODE_NRIV in GENERIC entry
      then cmp_generic.comp_code_nriv

      //--- all other cases (incl commented cases above!)

      else cmp_faa.comp_code
      end               as comp_code_nriv
}

union all select from faav_comp_code_o as t093c // all BUKRS in Switch-OFF case

{
  key t093c.client             as client,
  key t093c.comp_code          as comp_code,
      t093c.comp_code_nriv     as comp_code_nriv
}