ATOV_Cl

DDL: ATOV_CL SQL: ATO_V_CL Type: view

Changelist

ATOV_Cl is a CDS View that provides data about "Changelist" in SAP S/4HANA. It reads from 1 data source (ATOV_Cl_FINAL) and exposes 8 fields. It has 4 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
ATOV_Cl_FINAL Change_List from

Associations (4)

CardinalityTargetAliasCondition
[1] ATOV_COL_VER_CL_MAX Latest_Change_List Latest_Change_List.collection_id = Change_List.collection_id and Latest_Change_List.collection_version = Change_List.collection_version
[*] ATOV_CL_ITEM Change_List_Items Change_List_Items.changelist_id = Change_List.changelist_id
[1] ATOV_COL_VER Related_Collection_Version Related_Collection_Version.collection_id = Change_List.collection_id and Related_Collection_Version.collection_version = Change_List.collection_version
[*] ATOV_TEXT_DOWNTIME_REQUIRED Downtime_Required_Texts Downtime_Required_Texts.code = Change_List.downtimer_required

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Changelist view

Fields (8)

KeyFieldSource TableSource FieldDescription
exported_at ATOV_Cl_FINAL exported_at
created_by ATOV_Cl_FINAL created_by
created_at ATOV_Cl_FINAL created_at
transport ATOV_Cl_FINAL transport
status ATOV_Cl_FINAL status
Change_List_Items Change_List_Items
Related_Collection_Version Related_Collection_Version
Downtime_Required_Texts Downtime_Required_Texts 
@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