ATOV_CMN_GET_ALL_PENDINGS

DDL: ATOV_CMN_GET_ALL_PENDINGS SQL: ATO_V_PEND_COL Type: view

Get all pending collections

ATOV_CMN_GET_ALL_PENDINGS is a CDS View that provides data about "Get all pending collections" in SAP S/4HANA. It reads from 2 data sources (ato_cols, ATOV_COL_VER_PENDING) and exposes 1 field with key field version.

2 data source(s) 1 fields

Data Sources (2)

SourceAliasJoin Type
ato_cols collections inner
ATOV_COL_VER_PENDING pending from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_PEND_COL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Get all pending collections view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY version ATOV_COL_VER_PENDING version 
@AbapCatalog.sqlViewName: 'ATO_V_PEND_COL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Get all pending collections'

define view ATOV_CMN_GET_ALL_PENDINGS
  as select from ATOV_COL_VER_PENDING as pending 
    inner join   ato_cols             as collections on collections.collection_id = pending.collection_id
{
  key pending.collection_id,
  key pending.version,
      import_pending,
      forward_pending,
       case
        when  ts_seconds_between_as_curr > 2592000 // 30 days in seconds: 60 * 60 * 24 * 30

        then 'X'
        else ''
      end as is_old_col_ver 
}



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

Learn More