atov_apj_cust_trans

@AbapCatalog.sqlViewName: 'ATO_V_CU_TR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Custom transports for ATO audit app'
define view atov_apj_cust_trans
  as select from atov_apj_import_timeframe   as import_timeframe
  //    Use last import attempt for administrative data (last_changed_at, last_changed_by).

    inner join      ato_col_versions              as col_versions           on  col_versions.collection_id = import_timeframe.collection_id
                                                                            and col_versions.version       = import_timeframe.version
                                                                            and col_versions.action        = import_timeframe.action
                                                                            and col_versions.timestamp     = import_timeframe.latest_start
    inner join      ato_cols                      as cols                   on cols.collection_id = col_versions.collection_id
    inner join      atov_changelist_minus_ignored as changelists            on  col_versions.collection_id = changelists.collection_id
                                                                            and col_versions.version       = changelists.collection_version

    left outer join ATOV_USER                     as changed_by_description on changed_by_description.name = col_versions.last_changed_by

{
  key col_versions.collection_id,
      col_versions.version,
      col_versions.resource_id,
      cols.description_text,
      col_versions.action,
      //    Use last import attempt for administrative data (last_changed_at, last_changed_by) based on DB ato_col_versions

      col_versions.timestamp,
      col_versions.last_changed_at,
      col_versions.last_changed_by,
      changelists.transport,
      cols.category,
      coalesce( changed_by_description.description, col_versions.last_changed_by ) as last_changed_by_description,
      //    Additional time window information about all import attempts based on DB ato_col_versions

      import_timeframe.earliest_start,
      import_timeframe.latest_start,
      import_timeframe.earliest_end,
      import_timeframe.latest_end


}
where
       cols.client           = $session.client
  and(
       cols.collection_type  = 'B' // changelist might not have the type for Plug-In Imports

    or cols.collection_type  = 'C' // changelist might not have the type for Plug-In Imports

  )
  and  changelists.transport is not initial
  and(
       changelists.status    = 'PI'
    or changelists.status    = 'ID'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_APJ_IMPORT_TIMEFRAME",
"ATOV_CHANGELIST_MINUS_IGNORED",
"ATOV_USER",
"ATO_COLS",
"ATO_COL_VERSIONS",
"T000"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/