atov_st_late_col_ver_no_import

@AbapCatalog.sqlViewName: 'ATO_V_ST_LAT_CVI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Latest collection version is not imported'

define view atov_st_late_col_ver_no_import
  as select from atov_st_latest_col_version  as latest_version
    inner join   ato_col_versions            as version     on  version.collection_id = latest_version.collection_id
                                                            and version.version       = latest_version.version
                                                            and version.timestamp     = 0
    inner join   ato_cols                    as col         on col.collection_id = version.collection_id     
                                                            
    inner join   atov_text_collection_status as status_text on status_text.code = version.status


{

  key version.collection_id    as collection_id,
      version.version          as version,
      col.description_text     as collection_description,
      version.status           as status,   
      status_text.description  as status_description
}
  
// Invalid states

where
  (
       col.category      = #ATO_COLLECTION_CATEGORY.' ' 
    or col.category      = #ATO_COLLECTION_CATEGORY.'D'
  )
  and
  (
       version.status = #ato_collection_status.'R'  // Ready for Import

    or version.status = #ato_collection_status.'P'  // Partially Imported

    or version.status = #ato_collection_status.'J'  // Imported, Manual Postprocessing Required ???? ToDo

    or version.status = #ato_collection_status.'T'  // Ready for Import, Manual Postprocessing Required

    or version.status = #ato_collection_status.'Z'  // Importing

    or version.status = #ato_collection_status.'K'  // Imported with Errors

    or version.status = #ato_collection_status.'S'  // Import Scheduled

    or version.status = #ato_collection_status.'DI' // Discarded

    or version.status = #ato_collection_status.'DE' // Discarded after Errors

    or version.status = #ato_collection_status.'FI' // Forwarded after Incomplete Import

    or version.status = #ato_collection_status.'NF' // Forwarded without Import

    or version.status = #ato_collection_status.'NX' // Not Imported, Forwarding Failed

    or version.status = #ato_collection_status.'IC' // Automation Import Validation Failed

    or version.status = #ato_collection_status.'XI' // Forwarding Failed after Incomplete Import

    or version.status = #ato_collection_status.'Q'  // Outdated after Partial Import

  )

// Valid states

//where

//      version.status <> #ato_collection_status.'I'  // Imported

//    or version.status = #ato_collection_status.'O'  // Outdated

//    or version.status = #ato_collection_status.'Q'  // Outdated after Partial Import

//  and version.status <> #ato_collection_status.'F'  // Imported and Forward

//  and version.status <> #ato_collection_status.'G'  // Imported Successfully, Forwarding Failed

//  and version.status <> #ato_collection_status.'U'  // Imported Successfully, Postprocessing Failed

//  and version.status <> #ato_collection_status.'SI' // Set as Imported

//  and version.status <> #ato_collection_status.'FP' // Postprocessing Failed and Forwarded

//  and version.status <> #ato_collection_status.'XP' // Postprocessing Failed, Forwarding Failed

  
// Not Relevant

////D In Development

////E Exported

////C Changes Exist

////N No Changes Exist

////X Checking

////Y Exporting

////M Merged

////L Export Locked

////A All Changes Locked