ATOV_ST_CURRENT_COL_ITEM_DEP

DDL: ATOV_ST_CURRENT_COL_ITEM_DEP SQL: ATO_V_ST_CLDEP Type: view Package: S_ATO_SYSTEM_TRANSFER

Current collection item dependencies

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

4 data source(s) 2 fields

Data Sources (4)

SourceAliasJoin Type
ato_changel_dep dep inner
ato_changel_item item inner
ATOV_ST_RELEVANT_ITEMS latest_item_cl from
ato_changelists list inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_ST_CLDEP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Current collection item dependencies view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY item_type ato_changel_dep item_type
KEY item_id ato_changel_dep item_id 
@AbapCatalog.sqlViewName: 'ATO_V_ST_CLDEP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Current collection item dependencies'

define view ATOV_ST_CURRENT_COL_ITEM_DEP
  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 = latest_item_cl.changelist_id
                                                and item.item_id       = latest_item_cl.item_id
                                                and item.item_type     = latest_item_cl.item_type
    inner join   ato_changel_dep        as dep  on  dep.changelist_id = item.changelist_id
                                                and dep.item_id       = item.item_id
                                                and dep.item_type     = item.item_type
{


  key dep.changelist_id                  as changelist_id,
  key dep.item_type                      as item_type,
  key dep.item_id                        as item_id,
  key dep.depending_on_item_type         as depending_on_item_type,
  key dep.depending_on_item_id           as depending_on_item_id,
      dep.depending_on_last_notification as depending_on_last_notification,
      dep.non_exp_relevant               as non_exp_relevant,
      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