ATOV_CL_EXP_FAILED

DDL: ATOV_CL_EXP_FAILED SQL: ATO_V_CL_EXP_F Type: view

Get changelists still in status ER

ATOV_CL_EXP_FAILED is a CDS View that provides data about "Get changelists still in status ER" in SAP S/4HANA. It reads from 2 data sources (ato_changelists, ATOV_COL_VER_BASE).

2 data source(s)

Data Sources (2)

SourceAliasJoin Type
ato_changelists changelists from
ATOV_COL_VER_BASE collection_version left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CL_EXP_F view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Get changelists still in status ER view 
@AbapCatalog.sqlViewName: 'ATO_V_CL_EXP_F'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Get changelists still in status ER'
define view ATOV_CL_EXP_FAILED as select from ato_changelists as changelists

left outer join ATOV_COL_VER_BASE as collection_version on
collection_version.collection_id      = changelists.collection_id       and
collection_version.collection_version = changelists.collection_version
{
  changelists.changelist_id, 
  changelists.collection_id, 
  changelists.collection_version
}

where changelists.status = 'ER' and 
      collection_version.status <> 'R' and
    ( changelists.changelist_type = ' '   or // historical

      changelists.changelist_type = 'F'   or // full Import and Export

      changelists.changelist_type = 'D' )// delta Import and Export

      // no Merge; Move; Template or BC      

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

Learn More