Atov_Col_Cart

DDL: ATOV_COL_CART SQL: ATO_V_COL_CART Type: view Package: S_ATO_COL_CORE

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. Part of development package S_ATO_COL_CORE.

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

}

Learn More