Atov_Conti_Item_Key

DDL: ATOV_CONTI_ITEM_KEY SQL: ATO_V_CO_KEY Type: view

Item Keys of the Continouse BOM

Atov_Conti_Item_Key is a CDS View that provides data about "Item Keys of the Continouse BOM" in SAP S/4HANA. It reads from 1 data source (ato_conti_bom) and exposes 2 fields with key fields item_type, item_id.

Data Sources (1)

SourceAliasJoin Type
ato_conti_bom conti_ItemKey from

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CO_KEY view
ClientDependent false view
EndUserText.label Item Keys of the Continouse BOM view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY item_type ato_conti_bom item_type
KEY item_id ato_conti_bom item_id
@AbapCatalog.sqlViewName: 'ATO_V_CO_KEY'
@ClientDependent: false
@EndUserText.label: 'Item Keys of the Continouse BOM'
define view Atov_Conti_Item_Key as 
  select from ato_conti_bom as conti_ItemKey
  {
    key conti_ItemKey.item_type as item_type,
    key conti_ItemKey.item_id as item_id,
    max(conti_ItemKey.updated_at) as last_updated_at
  }
  group by
    item_type,
    item_id           
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_CONTI_BOM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/