ATOV_COL_VER_STATUS

DDL: ATOV_COL_VER_STATUS SQL: ATO_V_COL_STATUS Type: view

Collection import status

ATOV_COL_VER_STATUS is a CDS View that provides data about "Collection import status" in SAP S/4HANA. It reads from 2 data sources (ato_changelists, ato_col_v_status) and exposes 2 fields with key field transport.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
ato_changelists Changelists from
ato_col_v_status Import_Schema left_outer

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_COL_STATUS view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Collection import status view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY transport ato_changelists transport
IthenIelseXendasrequest_status 
@AbapCatalog.sqlViewName: 'ATO_V_COL_STATUS'
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@EndUserText.label: 'Collection import status'
define view ATOV_COL_VER_STATUS
  as select from    ato_changelists  as Changelists
    left outer join ato_col_v_status as Import_Schema on  Import_Schema.collection_id = Changelists.collection_id
                                                      and Import_Schema.version       = Changelists.collection_version
                                                      and Import_Schema.status_schema = 'I'

  //  association [0..1] to ato_col_v_status as Forward_Schema on  Col.collection_id            = Forward_Schema.collection_id

  //                                                           and Col.version                  = Forward_Schema.version

  //                                                           and Forward_Schema.status_schema = 'F'

{
  key Changelists.transport,
      Changelists.collection_id,
      Changelists.collection_version,
      case
      //      when Forward_Schema.status = #ato_collection_status.'FS'

      //        then 'F' //Forwarded

      when  Import_Schema.status is null
         then '' //Not available

      when Import_Schema.status = #ato_collection_status.'Z' or
           Import_Schema.status = #ato_collection_status.'S'  or
           Import_Schema.status = #ato_collection_status.'R' or
           Import_Schema.status = #ato_collection_status.'T' or
           Import_Schema.status = #ato_collection_status.'P'
        then 'R' //Ready for import (Not completely imported)

      when Import_Schema.status = #ato_collection_status.'PP' or
           Import_Schema.status = #ato_collection_status.'PS' or
           Import_Schema.status = #ato_collection_status.'J' or
           Import_Schema.status = #ato_collection_status.'SI' or
           Import_Schema.status = #ato_collection_status.'U' or
           Import_Schema.status = #ato_collection_status.'I'
        then 'I' // Imported (Successfully imported except postprocessing failed, Set as Imported)

      else 'X' // Ignore (Imported with errors, discarded, outdated)


      end as request_status
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_CHANGELISTS",
"ATO_COL_V_STATUS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More