ATOV_CL

CDS View

Changelist

ATOV_CL is a CDS View in S/4HANA. Changelist. It contains 2 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 2 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
ATOV_CL_ITEM view inner Changelist items
ATOV_COL_VER_IMP_ITEM view inner Import-relevant collection version items
ATOV_COL_VER_IMP_ITEM_CNT_BASE view from Base for counter of Import Items
Atov_History view inner Counts Dependancies On others
Atov_Import_Forecast view inner Import Forecast for ATO Inventory

Fields (2)

KeyField CDS FieldsUsed in Views
KEY collection_id collection_id 2
KEY collection_version collection_version 2 
@AbapCatalog.sqlViewName: 'ATO_V_CL'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@EndUserText.label: 'Changelist'
define view ATOV_Cl as 
  
  select from ATOV_Cl_FINAL as Change_List
  
  association [1] to ATOV_COL_VER_CL_MAX as Latest_Change_List
    on Latest_Change_List.collection_id      = Change_List.collection_id and
       Latest_Change_List.collection_version = Change_List.collection_version
  
  association [*] to ATOV_CL_ITEM as Change_List_Items
    on Change_List_Items.changelist_id = Change_List.changelist_id
  
  association [1] to ATOV_COL_VER as Related_Collection_Version
    on Related_Collection_Version.collection_id      = Change_List.collection_id and
       Related_Collection_Version.collection_version = Change_List.collection_version    
    
  association [*] to ATOV_TEXT_DOWNTIME_REQUIRED as Downtime_Required_Texts
    on Downtime_Required_Texts.code = Change_List.downtimer_required
    
  {
    key Change_List.changelist_id, 
    Change_List.collection_id, 
    Change_List.collection_version, 
    Change_List.exported_at, 
    Change_List.created_by, 
    Change_List.created_at, 
    Change_List.transport, 
    Change_List.changelist_type, 
    Change_List.downtimer_required as downtime_required, 
    Change_List.status,
    case when Latest_Change_List.exported_at = Change_List.exported_at
      then 'X'
      else ''
    end as is_latest_change_list,
    /* Associations */
    Change_List_Items,
    Related_Collection_Version,
    Downtime_Required_Texts
  }                    
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CL_FINAL",
"ATOV_COL_VER_CL_MAX"
],
"ASSOCIATED":
[
"ATOV_CL_ITEM",
"ATOV_COL_VER",
"ATOV_COL_VER_CL_MAX",
"ATOV_TEXT_DOWNTIME_REQUIRED"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More