EITV_EXP_CL_EXP_MAX

DDL: EITV_EXP_CL_EXP_MAX SQL: EIT_V_EXP_CL_MAX Type: view

Template max Exported At

EITV_EXP_CL_EXP_MAX is a CDS View that provides data about "Template max Exported At" in SAP S/4HANA. It reads from 1 data source (ato_changelists) and exposes 2 fields.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
ato_changelists ChangeList from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName EIT_V_EXP_CL_MAX view
ClientHandling.type #CLIENT_INDEPENDENT view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Template max Exported At view

Fields (2)

KeyFieldSource TableSource FieldDescription
template_id ato_changelists collection_id
exported_at 
@AbapCatalog.sqlViewName: 'EIT_V_EXP_CL_MAX'
@ClientHandling:{ type: #CLIENT_INDEPENDENT  }
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Template max Exported At'
define view EITV_EXP_CL_EXP_MAX as select from ato_changelists as ChangeList
  {
    ChangeList.collection_id    as template_id,
    max(ChangeList.exported_at) as exported_at  
} 
where status          = 'ED' // only successfull exported

  and changelist_type = 'T'  // TEMPLATEES

group by collection_id
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_CHANGELISTS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More