ATOV_BC_COL_VER_STATE_BASE

CDS View

Basic Collection Version Status View

ATOV_BC_COL_VER_STATE_BASE is a CDS View in S/4HANA. Basic Collection Version Status View. It contains 5 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 5 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
ATOV_BC_OPEN_MANUAL_POSTPROC view left_outer BC manual postprocessing not finished
ATOV_COL_VER_IMP view inner Import-relevant collection versions
ATOV_PLUGIN_IMPORT_STATUS view left_outer Plugin Import Status
ATOV_PLUGIN_OPEN_IMPORTS view left_outer Plugin Imports which are not finished

Fields (5)

KeyField CDS FieldsUsed in Views
action_status transport_status_db 1
manual_postprocessing_required manual_postprocessing_required 3
manual_postprocessing_status manual_postprocessing_status 3
persisted_substate persisted_substate 2
status collection_version_status 1 
@AbapCatalog.sqlViewName: 'ATO_V_BC_CVS'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Basic Collection Version Status View'

// should be just used ATO internaly

// should be named ATOC_PLUGIN_COL_VER_STATE_BASE

define view ATOV_BC_COL_VER_STATE_BASE as select from ato_col_versions as Collection_Version

  left outer join  ato_col_substate as Substate   on  Substate.collection_id       =  Collection_Version.collection_id
                                                  and Substate.version             =  Collection_Version.version                    
                                                  and Substate.action_phase        = 'MP'   
 {
  key Collection_Version.collection_id,
  key Collection_Version.version,
      Collection_Version.manual_postprocessing_required,
      Collection_Version.status,
      Collection_Version.action,
      Collection_Version.action_status,
  
      case when Collection_Version.manual_postprocessing_required = 'X'
           then COALESCE( Substate.action_phase_status, 'P' )
           else ''
      end                                       as manual_postprocessing_status,
      
      COALESCE( Substate.action_phase_status, '' ) as persisted_substate
}
where Collection_Version.timestamp = 0 // Current Version fits to Substate as it is always bound to current version

Learn More