ATOV_PK_NAMESPACE

CDS View

onPrem Namespace

ATOV_PK_NAMESPACE is a CDS View in S/4HANA. onPrem Namespace. It contains 5 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 5 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
ATOV_NAMESPACE_SETTINGS view union ATO: Namespace Settings
ATOV_NAMESPACE_SETTINGS_PK view from ATO: NamespaceSettings PackageBased Syst
ATOV_PREFIX_ADAPT_TYPE_SUP_U view union Supported Adaptation Types per Namespace

Fields (5)

KeyField CDS FieldsUsed in Views
KEY prefix namespace 2
category category 2
dev_prefix namespace 1
last_changed_at created_at,last_changed_at 2
last_changed_by created_by,last_changed_by 2 
@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":""
}
}*/

Learn More