ATOV_NAMESPACE_ORIGIN_BY_ITEMS

DDL: ATOV_NAMESPACE_ORIGIN_BY_ITEMS SQL: ATO_V_NSP_OBI Type: view

Derive Namespace Origin from Items

ATOV_NAMESPACE_ORIGIN_BY_ITEMS is a CDS View that provides data about "Derive Namespace Origin from Items" in SAP S/4HANA. It reads from 3 data sources (ato_item_header, ato_col_items, ato_cols) and exposes 1 field with key field prefix.

3 data source(s) 1 fields

Data Sources (3)

SourceAliasJoin Type
ato_item_header ato_prefix inner
ato_col_items ColItem from
ato_cols Collection left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_NSP_OBI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Derive Namespace Origin from Items view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY prefix prefix 
@AbapCatalog.sqlViewName: 'ATO_V_NSP_OBI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Derive Namespace Origin from Items'
define view ATOV_NAMESPACE_ORIGIN_BY_ITEMS as  
  select from ato_col_items as ColItem
  
  left outer join ato_cols as Collection
    on Collection.collection_id  = ColItem.collection_id       
    
  inner join ato_item_header as ato_prefix
   on ato_prefix.item_type = ColItem.item_type and
      ato_prefix.item_id   = ColItem.item_id  

  {
    key prefix,
    key Collection.original_systname  
    
}    
where ColItem.timestamp = 0 and
      prefix <> ''          and
      original_systname <>''
group by prefix, original_systname
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_COLS",
"ATO_COL_ITEMS",
"ATO_ITEM_HEADER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More