Atov_Col_Cart

DDL: ATOV_COL_CART SQL: ATO_V_COL_CART Type: view

Collection Cart

Atov_Col_Cart is a CDS View that provides data about "Collection Cart" in SAP S/4HANA. It reads from 2 data sources (ato_col_cart, Atov_Col_Latest_Item) and exposes 9 fields with key fields item_type, item_id.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
ato_col_cart Cart from
Atov_Col_Latest_Item Item inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_COL_CART view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Collection Cart view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY item_type Atov_Col_Latest_Item item_type
KEY item_id Atov_Col_Latest_Item item_id
changed_by Atov_Col_Latest_Item changed_by
changed_at Atov_Col_Latest_Item changed_at
item_status Atov_Col_Latest_Item item_status
Adaptation_Type_Texts Atov_Col_Latest_Item Adaptation_Type_Texts
Changed_By_Description Atov_Col_Latest_Item Changed_By_Description
Item_Status_Texts Atov_Col_Latest_Item Item_Status_Texts
sap_icon 
@AbapCatalog.sqlViewName: 'ATO_V_COL_CART'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Collection Cart'
define view Atov_Col_Cart
  as select from ato_col_cart         as Cart

    inner join   Atov_Col_Latest_Item as Item on  Item.collection_id = Cart.collection_id
                                              and Item.item_type     = Cart.item_type
                                              and Item.item_id       = Cart.item_id

{

  key Cart.collection_id,
  key Item.item_type,
  key Item.item_id,
      Item.item_description,

      Item.changed_by,
      Item.changed_at,
      Item.item_status,

      Item.Adaptation_Type_Texts,
      Item.Changed_By_Description,
      Item.Item_Status_Texts,
      Item.Adaptation_Type.sap_icon

} 
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_ADAPTATION_TYPE",
"ATOV_COL_LATEST_ITEM",
"ATO_COL_CART"
],
"ASSOCIATED":
[
"ATOV_TEXT_ADAPTATION_TYPE",
"ATOV_TEXT_COL_ITEM_STATUS",
"ATOV_USER"
],
"BASE":
[
"ATOV_COL_LATEST_ITEM"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More