ATOV_BC_OPEN_MANUAL_POSTPROC

DDL: ATOV_BC_OPEN_MANUAL_POSTPROC SQL: ATO_V_BC_MP Type: view

BC manual postprocessing not finished

ATOV_BC_OPEN_MANUAL_POSTPROC is a CDS View that provides data about "BC manual postprocessing not finished" 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 2 fields.

4 data source(s) 2 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_BC_MP view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label BC manual postprocessing not finished view

Fields (2)

KeyFieldSource TableSource FieldDescription
timestamp ato_col_versions timestamp
transport ato_changelists transport 
@AbapCatalog.sqlViewName: 'ATO_V_BC_MP'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'BC manual postprocessing  not finished'
define view ATOV_BC_OPEN_MANUAL_POSTPROC 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
                                                  and Changelist.status              <> 'I'
                                                                                                                  
{
  key Collection_Version_Key.collection_id,
  key Collection_Version_Key.version as   collection_version,
      Collection_Version_Key.timestamp,
      Changelist.transport,
      Collection_Version_Detail.manual_postprocessing_required,
      Collection_Version_Detail.manual_postprocessing_status          
           
}
where Collection.category = 'B' //BC only

    and 
      Collection_Version_Detail.manual_postprocessing_required = 'X'
    and 
      Collection_Version_Detail.manual_postprocessing_status <> 'S'
    and
      Collection_Version_Key.timestamp = 0  


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_BC_COL_VER_STATE_BASE",
"ATO_CHANGELISTS",
"ATO_COLS",
"ATO_COL_VERSIONS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More