ATOV_COL_ITEM_IMPORT_STATUS

CDS View

Item version with col import status

ATOV_COL_ITEM_IMPORT_STATUS is a CDS View in S/4HANA. Item version with col import status. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
atov_cl_missing_outdated_dep view left_outer Missing Dep On Items from Outdated CLs 
@AbapCatalog.sqlViewName: 'ATO_V_CIIS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Item version with col import status'
define view ATOV_COL_ITEM_IMPORT_STATUS
  as

  select from  ato_changelists        as ChangeList

    inner join ato_changel_item       as CLItem     on ChangeList.changelist_id = CLItem.changelist_id

    inner join ATOV_COL_VER_IMP_BASE1 as ColVersion on  ChangeList.collection_id      = ColVersion.collection_id
                                                    and ChangeList.collection_version = ColVersion.collection_version

{
  key ChangeList.changelist_id         as changelist_id,
  key CLItem.item_type                 as item_type,
  key CLItem.item_id                   as item_id,
      ChangeList.collection_id         as collection_id,
      ChangeList.collection_version    as collection_version,
      ChangeList.exported_at           as exported_at,
      ColVersion.status                as col_version_status,
      CLItem.item_last_notification    as item_last_notification,
      CLItem.item_last_notification_by as item_last_notification_by

}
where
  ChangeList.status != 'I'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_COL_VER_IMP_BASE1",
"ATO_CHANGELISTS",
"ATO_CHANGEL_ITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More