EITV_EXP_CL_EXP_MAX_DETAILS

DDL: EITV_EXP_CL_EXP_MAX_DETAILS SQL: EIT_V_EXP_CL_MAD Type: view

Template max Exported At

EITV_EXP_CL_EXP_MAX_DETAILS is a CDS View that provides data about "Template max Exported At" in SAP S/4HANA. It reads from 2 data sources (ato_changelists, EITV_EXP_CL_EXP_MAX) and exposes 2 fields with key field template_id.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
ato_changelists ChangeList inner
EITV_EXP_CL_EXP_MAX max_export from

Annotations (4)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY template_id ato_changelists collection_id
exported_at ato_changelists exported_at 
@AbapCatalog.sqlViewName: 'EIT_V_EXP_CL_MAD'
@ClientHandling:{ type: #CLIENT_INDEPENDENT  }
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Template max Exported At'
define view EITV_EXP_CL_EXP_MAX_DETAILS as select from EITV_EXP_CL_EXP_MAX as max_export 
inner join ato_changelists as ChangeList on
  ChangeList.collection_id   = max_export.template_id and
  ChangeList.exported_at     = max_export.exported_at and
  ChangeList.changelist_type = 'T'                    and
  ChangeList.status          = 'ED'
  {
key    ChangeList.collection_id    as template_id,
       ChangeList.changelist_id,
       ChangeList.exported_at as exported_at  
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EITV_EXP_CL_EXP_MAX",
"ATO_CHANGELISTS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More