ATOV_PK_NAMESPACE

@AbapCatalog.sqlViewName: 'ATO_V_PK_NSP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type:  #CLIENT_DEPENDENT
@ClientHandling.algorithm: #AUTOMATED
@EndUserText.label: 'onPrem Namespace'
define view ATOV_PK_NAMESPACE as  
  select from ATOV_PK_HIST_NAMESPACE as min_hist 
   left outer join ato_setup_hist as hist on hist.last_changed_at = min_hist.created_at 
   left outer join ato_setup as setup on hist.dev_namespace = setup.dev_namespace    // client handling comes from current setup  

  {
    key hist.dev_namespace as prefix,
      'K' as category,
      ''  as is_default_prefix,
      hist.last_changed_at as last_changed_at,        
      case when hist.client = $session.client 
           then hist.last_changed_by
           else ''
      end as last_changed_by 
    }    
  where  setup.setup_type is null  // exclude the current setup in this part of the union    

  union select from ato_setup as setup
    {
      key dev_namespace as prefix,  
      'K' as category,
      'X' as is_default_prefix,
      setup.last_changed_at as last_changed_at,
      setup.last_changed_by as last_changed_by       
      } 
  where setup_type = 'P'  and //only on Prem

        dev_namespace  <> ''  //read only use case might be initial   

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_PK_HIST_NAMESPACE",
"ATO_SETUP",
"ATO_SETUP_HIST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/