ATOV_CMN_GET_ALL_IMPORTABLE

DDL: ATOV_CMN_GET_ALL_IMPORTABLE SQL: ATO_V_IMPORTABLE Type: view Package: S_ATO_COMMON_IMPORT

Common Import: Get all auto. rel. SWCs

ATOV_CMN_GET_ALL_IMPORTABLE is a CDS View that provides data about "Common Import: Get all auto. rel. SWCs" in SAP S/4HANA. It reads from 4 data sources (ato_col_versions, atov_changelist_minus_ignored, ato_cols, ATOV_COL_VER_PENDING_IMP) and exposes 1 field with key field version. Part of development package S_ATO_COMMON_IMPORT.

4 data source(s) 1 fields

Data Sources (4)

SourceAliasJoin Type
ato_col_versions all_importable from
atov_changelist_minus_ignored changelist left_outer
ato_cols collections inner
ATOV_COL_VER_PENDING_IMP import_pending inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_IMPORTABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Common Import: Get all auto. rel. SWCs view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY version ato_col_versions version 
@AbapCatalog.sqlViewName: 'ATO_V_IMPORTABLE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Common Import: Get all auto. rel. SWCs'

define view ATOV_CMN_GET_ALL_IMPORTABLE
  as select from    ato_col_versions              as all_importable
    inner join ato_cols as collections on collections.collection_id = all_importable.collection_id
  // first ready for import timestamp necessary, unique entry for each collection

    inner join ATOV_COL_VER_PENDING_IMP     as import_pending  on  all_importable.collection_id = import_pending.collection_id
                                                                    and all_importable.version       = import_pending.version  
 
    left outer join atov_changelist_minus_ignored as changelist   on      changelist.collection_id      = all_importable.collection_id
                                                                      and changelist.collection_version = all_importable.version

{
  key all_importable.collection_id,
  key all_importable.version,
      cast( tstmp_seconds_between( changelist.created_at, tstmp_current_utctimestamp(), 'NULL') as abap.curr( 15, 1 ) ) as ts_seconds_between_as_curr

}
where
          collections.client  = $session.client
  and
          all_importable.timestamp     = 0

Learn More