ATOV_CURRENT_COLLECTION_OF_ITM

DDL: ATOV_CURRENT_COLLECTION_OF_ITM SQL: ATO_V_CURRCOLITM Type: view Package: S_ATO_PUBLIC

Current Collection of Item

ATOV_CURRENT_COLLECTION_OF_ITM is a CDS View that provides data about "Current Collection of Item" in SAP S/4HANA. It reads from 2 data sources (ato_cols, ato_col_items) and exposes 2 fields with key fields item_type, item_id. Part of development package S_ATO_PUBLIC.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
ato_cols collection inner
ato_col_items item from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CURRCOLITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Current Collection of Item view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY item_type ato_col_items item_type
KEY item_id ato_col_items item_id 
@AbapCatalog.sqlViewName: 'ATO_V_CURRCOLITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Current Collection of Item'
define view ATOV_CURRENT_COLLECTION_OF_ITM

  as select from ato_col_items as item
    inner join   ato_cols      as collection on collection.collection_id = item.collection_id
{
  key item.item_type,
  key item.item_id,
      collection.collection_id,
      collection.description_text
}
where
      collection.category        <> 'L'
  and collection.category        <> 'B'
  and collection.category        <> 'T'
  and // no templates

      collection.status          <> 'H'
  and collection.status          <> 'M'
  and collection.collection_type =  'E'
  and item.timestamp             =  0
// TODO Implement WHERE Clause with current client

// TODO Implement UNION with ATO_XC_ITEMS

Learn More