ATOV_ST_RELEVANT_ITEMS

CDS View

Latest relevant items

ATOV_ST_RELEVANT_ITEMS is a CDS View in S/4HANA. Latest relevant items. 5 CDS views read from this table.

Used by 5 CDS view(s)

CDS Views using this table (5)

ViewTypeJoinVDMDescription
ATOV_ST_CURRENT_COL_ITEM_BOMS view from Current collection item boms
ATOV_ST_CURRENT_COL_ITEM_CBOM view from Current collection conti boms
ATOV_ST_CURRENT_COL_ITEM_DEP view from Current collection item dependencies
ATOV_ST_CURRENT_COL_ITEMS view from Current collection items
ATOV_ST_CURRENT_COL_VERSIONS view from Current collection versions 
@AbapCatalog.sqlViewName: 'ATO_V_ST_ITMLRL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Latest relevant items'

define view ATOV_ST_RELEVANT_ITEMS
  as select from ATOV_ST_ITEM_LATEST_IMP_CHANGL as item
    inner join   ato_changel_item               as state on  state.changelist_id = item.changelist_id
                                                         and state.item_id       = item.item_id
                                                         and state.item_type     = item.item_type
{

  key item.item_type     as item_type,
  key item.item_id       as item_id,
      item.changelist_id as changelist_id

}
where
  (
       state.item_import_status = #ato_item_import_status.'C'
    or state.item_import_status = #ato_item_import_status.'N'
    or state.item_import_status = #ato_item_import_status.'U'
  )

Learn More