SAIS_APP_STAT_GET_ALL

@AbapCatalog.sqlViewName: 'SAISAPPSTATALL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'SAIS: Application Start Statistic - Simple'
define view SAIS_APP_STAT_GET_ALL
  as select from rsau_app_stat as stat
  
  left outer join SUIM_2X_APPL_TYPE as atype_tx on atype_tx.ident = stat.appl_type
  left outer  join P_UserAddress002 as user on user.bname = stat.bname

  association [0..1] to tstct as tran_tx on tran_tx.tcode = stat.appl_name and tran_tx.sprsl = $session.system_language
  association [0..1] to tstct as tran_tx_e on tran_tx_e.tcode = stat.appl_name and tran_tx_e.sprsl = 'E'

{
  key stat.bname     as bname, 
   stat.tstmp        as tstmp,
   stat.tstmp_to     as tstmp_to,
   stat.appl_type    as appl_type,
   stat.appl_name       as appl_name,
   user.NAME_TEXTC   as bname_tx,
   coalesce( tran_tx.ttext, tran_tx_e.ttext ) as appl_name_tx,
   atype_tx.ddtext   as appl_type_tx,
   stat.counter      as counter
//   stat.object       as object,

//   stat.obj_name     as obj_name

     
//      concat_with_space(  tstmp_to_dats( stat.tstmp    , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) ,

//                          tstmp_to_tims( stat.tstmp    , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' )  , 1 ) as intv_start,

//      concat_with_space(  tstmp_to_dats( stat.tstmp_to , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) ,

//                          tstmp_to_tims( stat.tstmp_to , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' )  , 1 ) as intv_end                        

}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_USERADDRESS002",
"SUIM_2X_APPL_TYPE",
"RSAU_APP_STAT",
"TSTCT"
],
"ASSOCIATED":
[
"TSTCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/