EITV_EXP_FILES

@AbapCatalog.sqlViewName: 'EIT_V_FILES'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Template Export Files'
define view EITV_EXP_FILES
  as

  select from  ATOV_COL_VER_KEY           as Collection_Version_Key
    inner join eit_exp_file               as file                       on  file.template_id      = Collection_Version_Key.collection_id // only existing files

                                                                        and file.template_version = Collection_Version_Key.collection_version

  association [1] to ato_col_versions     as Collection_Version_Detail  on  Collection_Version_Detail.collection_id = Collection_Version_Key.collection_id
                                                                        and Collection_Version_Detail.version       = Collection_Version_Key.collection_version
                                                                        and Collection_Version_Detail.timestamp     = Collection_Version_Key.timestamp

  association [1] to ATOV_USER            as Created_By_Description     on  Created_By_Description.name = $projection.created_by

  association [*] to EITV_EXP_FILES_ITEM  as Items                      on  Collection_Version_Key.collection_id      = Items.template_id
                                                                        and Collection_Version_Key.collection_version = Items.file_number
                                             
  association [0..1]    to ATOV_LOG       as Latest_Log                 on  Latest_Log.collection_id      = $projection.template_id
                                                                        and Latest_Log.collection_version = $projection.file_number
                                                                        and Latest_Log.ballog_handle      = $projection.ballog_handle
                                             
                                                                        
  association [*] to ATOV_LOG             as  Log                       on  Log.collection_id      = $projection.template_id
                                                                        and Log.collection_version = $projection.file_number
                                                                        and Log.is_outdated        = ''


  association [1]    to ATOV_COL_VER_COUNT_LOGS     as Log_Counter      on  Log_Counter.collection_id      = $projection.template_id
                                                                        and Log_Counter.collection_version = $projection.file_number
                                                                        and Log_Counter.is_outdated        = ''
                                                                        
                                                                        
{
  key Collection_Version_Key.collection_id      as template_id,
  key Collection_Version_Key.collection_version as file_number,
      Collection_Version_Key.timestamp,
      Collection_Version_Detail.last_changed_by as created_by,
      Collection_Version_Detail.last_changed_at as created_at,
      file.file_name,
      Collection_Version_Detail.ballog_handle   as ballog_handle,

      // ASSOCIATION

      Created_By_Description                    as _Created_By_Description,
      Items                                     as _Items,
      Latest_Log                                as _Latest_Log,        
      Log                                       as _Log,
      Log_Counter                               as _Log_Counter
}
where
  Collection_Version_Detail.action        = 'A'
  and // only successfully Assembleys

  Collection_Version_Detail.action_status = 'S'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_COL_VER_KEY",
"ATO_COL_VERSIONS",
"EIT_EXP_FILE"
],
"ASSOCIATED":
[
"ATOV_COL_VER_COUNT_LOGS",
"ATOV_LOG",
"ATOV_USER",
"EITV_EXP_FILES_ITEM",
"ATO_COL_VERSIONS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/