ATOV_BC_OPEN_TRANSPORTS

DDL: ATOV_BC_OPEN_TRANSPORTS SQL: ATO_V_BCOTP Type: view

BC Transports not sucessfully imported

ATOV_BC_OPEN_TRANSPORTS is a CDS View that provides data about "BC Transports not sucessfully imported" in SAP S/4HANA. It reads from 4 data sources (ato_changelists, ato_cols, ato_col_versions, ATOV_COL_VER_KEY) and exposes 4 fields.

4 data source(s) 4 fields

Data Sources (4)

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

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_BCOTP view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label BC Transports not sucessfully imported view

Fields (4)

KeyFieldSource TableSource FieldDescription
timestamp ATOV_COL_VER_KEY timestamp
transport ato_changelists transport
exported_at ato_changelists exported_at
action_statuselsePendasTransport_Status 
@AbapCatalog.sqlViewName: 'ATO_V_BCOTP'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'BC Transports not sucessfully imported'
define view ATOV_BC_OPEN_TRANSPORTS as select from ATOV_COL_VER_KEY as Collection_Version_Key


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

  left outer join 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
                                                                                   
  left outer join  ato_changelists  as Changelist on  Changelist.collection_id       =  Collection_Version_Key.collection_id
                                                  and Changelist.collection_version  =  Collection_Version_Key.collection_version
                                                  and Changelist.status              <> 'I'
                                                                                                                
{
  key Collection_Version_Key.collection_id,
  key Collection_Version_Key.collection_version,
      Collection_Version_Key.timestamp,
      Changelist.changelist_id,
      Changelist.transport                      as transport,
      Changelist.exported_at                    as exported_at,
      case when ( Collection_Version_Detail.action =  'I' or  Collection_Version_Detail.action =  'M' )
         then Collection_Version_Detail.action_status
         else 'P' //Prepared

      end                                       as Transport_Status        
           
}
where Collection.category = 'B' //BC only

    and (                         // only persisted Status

    (  Collection_Version_Detail.action  =  'I' and Collection_Version_Detail.action_status <> 'S')
    or // I:Imported and not successfull

      Collection_Version_Detail.status   =  'R'
    or // R:Ready for Import

    (  Collection_Version_Detail.action  =  'M' and Collection_Version_Detail.action_status <> 'S')
    or // A:Automatically Imported

      Collection_Version_Detail.status   =  'S'
  )    // S:Import Scheduled

Learn More