ATOV_CL_FINAL

CDS View

Final changelists (non-preliminary)

ATOV_CL_FINAL is a CDS View in S/4HANA. Final changelists (non-preliminary). It contains 10 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 10 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
ATOV_Cl view from Changelist
ATOV_CL_ITEM_BOM_EXP view from Basis view for changelist objects
ATOV_CL_ITEM_EXP view from Basis view for changelist objects
ATOV_CL_ITEM_IMP view from Basis view for changelist items import
ATOV_COL_VER_CL_MAX view from Latest changelist of collection version
Atov_Inventory_Base view inner Base View for Main ATO Inventory View
ATOV_ITEM_EXPORTED_AT view inner Exported items

Fields (10)

KeyField CDS FieldsUsed in Views
KEY changelist_id changelist_id 4
KEY collection_id collection_id 5
KEY collection_version collection_version 5
KEY exported_at exported_at 5
changelist_type changelist_type 4
created_at created_at 4
created_by created_by 4
downtimer_required downtime_required,downtimer_required 4
status status 4
transport transport 4 
@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