ATOV_Cl_FINAL

DDL: ATOV_CL_FINAL SQL: ATO_V_CLF Type: view

Final changelists (non-preliminary)

ATOV_Cl_FINAL is a CDS View that provides data about "Final changelists (non-preliminary)" in SAP S/4HANA. It reads from 1 data source (ato_changelists) and exposes 5 fields.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
ato_changelists ChangeList from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CLF view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Final changelists (non-preliminary) view

Fields (5)

KeyFieldSource TableSource FieldDescription
exported_at ato_changelists exported_at
created_by ato_changelists created_by
created_at ato_changelists created_at
transport ato_changelists transport
status ato_changelists status 
@AbapCatalog.sqlViewName: 'ATO_V_CLF'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@EndUserText.label: 'Final changelists (non-preliminary)'
define view ATOV_Cl_FINAL as
  
  select from ato_changelists as ChangeList
  {
    ChangeList.changelist_id, 
    ChangeList.collection_id, 
    ChangeList.collection_version, 
    ChangeList.exported_at, 
    ChangeList.created_by, 
    ChangeList.created_at, 
    ChangeList.transport, 
    ChangeList.changelist_type, 
    ChangeList.downtimer_required, 
    ChangeList.status
    
  }
  where
    ChangeList.status <> 'ER' and // Changelists which are currently created

    ChangeList.status <> 'I'  and // Ignore Changelists

    ( ChangeList.changelist_type = ' '   or // historical

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

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

      // no Merge; Move; Template or BC

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

Learn More