ATOV_PLUGIN_IMPORT_STATUS

DDL: ATOV_PLUGIN_IMPORT_STATUS SQL: ATO_V_PLUG_IMPS Type: view Package: S_ATO_COL_IMPORT_PLUGIN

Plugin Import Status

ATOV_PLUGIN_IMPORT_STATUS is a CDS View that provides data about "Plugin Import Status" in SAP S/4HANA. It reads from 4 data sources (ato_changelists, ato_cols, ATOV_BC_COL_VER_STATE_BASE, ato_col_versions) and exposes 6 fields. Part of development package S_ATO_COL_IMPORT_PLUGIN.

4 data source(s) 6 fields

Data Sources (4)

SourceAliasJoin Type
ato_changelists Changelist left_outer
ato_cols Collection left_outer
ATOV_BC_COL_VER_STATE_BASE Collection_Version_Detail left_outer
ato_col_versions Collection_Version_Key from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_PLUG_IMPS view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Plugin Import Status view

Fields (6)

KeyFieldSource TableSource FieldDescription
timestamp ato_col_versions timestamp
transport ato_changelists transport
exported_at ato_changelists exported_at
action_statuselsePendastransport_status
statusHthenXelseendashidden
category ato_cols category 
@AbapCatalog.sqlViewName: 'ATO_V_PLUG_IMPS'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Plugin Import Status'
define view ATOV_PLUGIN_IMPORT_STATUS as select from ato_col_versions as Collection_Version_Key


  left outer join ato_cols          as Collection     on  Collection.collection_id = Collection_Version_Key.collection_id

  left outer join ATOV_BC_COL_VER_STATE_BASE      as Collection_Version_Detail     
                                                  on  Collection_Version_Detail.collection_id = Collection_Version_Key.collection_id
                                                  and Collection_Version_Detail.version       = Collection_Version_Key.version
                                                                                                                                     
  left outer join  ato_changelists  as Changelist on  Changelist.collection_id       =  Collection_Version_Key.collection_id
                                                  and Changelist.collection_version  =  Collection_Version_Key.version                             
                                                                                    
{
  key Collection_Version_Key.collection_id,
  key Collection_Version_Key.version as collection_version,
      Collection_Version_Key.timestamp,
      // transport =>  if only open transports are relevant use ATOV_BC_OPEN_MANUAL_POSTPROC (for Performance)

      Changelist.changelist_id,
      Changelist.transport                      as transport,
      Changelist.exported_at                    as exported_at, 
      Changelist.status                         as changelist_status,                 
      case when ( Collection_Version_Detail.action =  'I' )
         then Collection_Version_Detail.action_status
         else 'P' //Prepared

      end                                       as transport_status,
      Collection_Version_Detail.action_status   as transport_status_db,
      // manual postprocessing =>  if only open manual postprocessing is relevant use ATOV_BC_OPEN_IMPORTS (for Performance)

      Collection_Version_Detail.manual_postprocessing_required,
      Collection_Version_Detail.manual_postprocessing_status, 
      Collection_Version_Detail.persisted_substate,
      Collection_Version_Detail.status          as collection_version_status,
            
      case when Collection.status = 'H' 
       then 'X'
       else ''
      end                                       as hidden,
      Collection.category        
           
}
where Collection_Version_Key.timestamp = 0
// no where clause here as all registered transports are relevant in ready for import to separate new and existing

Learn More