ATOV_COL_LATEST_ITEM

CDS View

Items in Latest Collection Version

ATOV_COL_LATEST_ITEM is a CDS View in S/4HANA. Items in Latest Collection Version. It contains 10 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 10 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
Atov_Col_Cart view inner Collection Cart
ATOV_COL_LATEST_ITEM_4ABAP view from to be consumed in ABAP (no Association)

Fields (10)

KeyField CDS FieldsUsed in Views
KEY item_id item_id 2
KEY item_type item_type 2
Adaptation_Type_Texts Adaptation_Type_Texts 1
changed_at changed_at 2
changed_by changed_by 2
Changed_By_Description Changed_By_Description 1
collection_id collection_id 1
item_description item_description 2
item_status item_status 2
Item_Status_Texts Item_Status_Texts 1 
@AbapCatalog.sqlViewName: 'ATO_V_COL_LTITEM'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Items in Latest Collection Version'
define view Atov_Col_Latest_Item
 as
// directly select from 0 version as there are no further infromation required

  select from  ATOV_COL_LATEST_ITEM_BASE as item

  association [1] to ATOV_ADAPTATION_TYPE as Adaptation_Type
                                          on Adaptation_Type.code = item.item_type
                                               
  association [*] to ATOV_TEXT_ADAPTATION_TYPE as Adaptation_Type_Texts
                                               on Adaptation_Type_Texts.code = item.item_type 
                                               
  association [1] to ATOV_USER as Changed_By_Description
                               on Changed_By_Description.name = item.changed_by 
                               
  association [*] to ATOV_TEXT_COL_ITEM_STATUS as Item_Status_Texts
                                               on Item_Status_Texts.code = item.item_status                               

{

  key item.collection_id,
  key item.item_type,
  key item.item_id,
      item.item_status,            

      item.item_description,
      item.changed_by,
      item.changed_at,   

      // associations

      Adaptation_Type,      
      Adaptation_Type_Texts,      
      Changed_By_Description,
      Item_Status_Texts

} where item.deleted_in_previouse_version <> 'X'
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_COL_LATEST_ITEM_BASE"
],
"ASSOCIATED":
[
"ATOV_ADAPTATION_TYPE",
"ATOV_TEXT_ADAPTATION_TYPE",
"ATOV_TEXT_COL_ITEM_STATUS",
"ATOV_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More