ATOV_ST_CURRENT_COL_ITEMS

DDL: ATOV_ST_CURRENT_COL_ITEMS SQL: ATO_V_ST_ITEMS Type: view Package: S_ATO_SYSTEM_TRANSFER

Current collection items

ATOV_ST_CURRENT_COL_ITEMS is a CDS View that provides data about "Current collection items" in SAP S/4HANA. It reads from 4 data sources (ato_changel_item, ato_item_header, ATOV_ST_RELEVANT_ITEMS, ato_changelists) and exposes 6 fields with key fields item_type, item_id. Part of development package S_ATO_SYSTEM_TRANSFER.

4 data source(s) 6 fields

Data Sources (4)

SourceAliasJoin Type
ato_changel_item item inner
ato_item_header item_header inner
ATOV_ST_RELEVANT_ITEMS latest_item_cl from
ato_changelists list inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_ST_ITEMS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Current collection items view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY item_type ato_changel_item item_type
KEY item_id ato_changel_item item_id
item_counter ato_changel_item item_counter
img_activity ato_changel_item img_activity
prefix ato_item_header prefix
prefix_short ato_item_header prefix_short 
@AbapCatalog.sqlViewName: 'ATO_V_ST_ITEMS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Current collection items'

define view ATOV_ST_CURRENT_COL_ITEMS
  as select from ATOV_ST_RELEVANT_ITEMS as latest_item_cl
    inner join   ato_changelists        as list        on list.changelist_id = latest_item_cl.changelist_id
    inner join   ato_changel_item       as item        on  item.changelist_id = list.changelist_id
                                                       and item.item_id       = latest_item_cl.item_id
                                                       and item.item_type     = latest_item_cl.item_type
    inner join   ato_item_header        as item_header on  item_header.item_id   = latest_item_cl.item_id
                                                       and item_header.item_type = latest_item_cl.item_type

{
  key item.item_type                 as item_type,
  key item.item_id                   as item_id,
      item.changelist_id             as changelist_id,
      item.item_counter              as item_counter,
      item.item_lifecycle_action     as item_lifecycle_action,
      item.item_description          as item_description,
      item.item_import_status        as item_import_status,
      item.item_last_notification    as item_last_notification,
      item.item_last_notification_by as item_last_notification_by,
      item.img_activity              as img_activity,
      item_header.prefix             as prefix,
      item_header.prefix_short       as prefix_short,
      list.collection_id             as collection_id,
      list.collection_version        as collection_version
}
where
     item.item_import_status = #ato_item_import_status.'C'
  or item.item_import_status = #ato_item_import_status.'N'
  or item.item_import_status = #ato_item_import_status.'U'

Learn More