CDS_SUI_TM_MM_TCODE

@AbapCatalog.sqlViewName: 'SUI_TM_MM_APP_V2'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'CDS View for Transaction Codes (which are used in an LADI)'
define view CDS_SUI_TM_MM_TCODE 
( app_id, tcode, tcode_text, cat_id, sem_obj, sem_act, app_type, app_subtype, app_type_comb, title, 
  wd_appl_id_DB, wd_conf_id_DB, wcf_target_id_DB, target_url_DB, ui5_app_id_DB, fiori_id_DB, system_alias_DB,
  author_trans, created_on_trans, devclass_trans, original_lang_trans, langu_txt, okflag, devclass, life_cycle_status_uiad
   )
as select from sui_tm_mm_app
left outer join sui_tm_mm_appt on  sui_tm_mm_app.app_id = sui_tm_mm_appt.app_id 
                               and sui_tm_mm_appt.langu = $session.system_language   
left outer join tadir as tadir_trans 
                          on tadir_trans.pgmid  = 'R3TR'      
                         and tadir_trans.object = 'TRAN'      
                         and tadir_trans.obj_name = sui_tm_mm_app.tcode   
left outer join t002t on t002t.spras = $session.system_language
                         and t002t.sprsl = tadir_trans.masterlang                    
left outer join tstc on tstc.tcode = sui_tm_mm_app.tcode
left outer join tstct on tstct.tcode = sui_tm_mm_app.tcode
                      and tstct.sprsl = $session.system_language 
left outer join dd07t as dd07t_sy
                      on  sui_tm_mm_app.app_type = dd07t_sy.domvalue_l
                      and dd07t_sy.domname = '/UI2/AD_MM_APP_TYPE' 
                      and dd07t_sy.ddlanguage =  $session.system_language   
left outer join dd07t as dd07t_en
                      on  sui_tm_mm_app.app_type = dd07t_en.domvalue_l
                      and dd07t_en.domname = '/UI2/AD_MM_APP_TYPE' 
                      and dd07t_en.ddlanguage = 'E'      
left outer join usob_sm on sui_tm_mm_app.tcode = usob_sm.name
                        and usob_sm.type = 'TR'  
left outer join tadir as tadir_uiad
                         on tadir_uiad.pgmid  = 'R3TR'
                        and tadir_uiad.object = 'UIAD'
                        and tadir_uiad.obj_name = sui_tm_mm_app.app_id     
left outer join sui_tm_mm_appdep 
                         on sui_tm_mm_appdep.app_id = sui_tm_mm_app.app_id                                                
{ key sui_tm_mm_app.app_id,
sui_tm_mm_app.tcode,
tstct.ttext,
sui_tm_mm_app.cat_id,
sui_tm_mm_app.sem_obj,
sui_tm_mm_app.sem_act,
sui_tm_mm_app.app_type,
sui_tm_mm_app.app_subtype,
case when sui_tm_mm_app.app_subtype <> ' ' then sui_tm_mm_app.app_subtype 
                                           else ( case when dd07t_sy.ddtext is null then dd07t_en.ddtext
                                                                                    else dd07t_sy.ddtext end )
                                           end as app_type_comb,
sui_tm_mm_appt.alt_smart_link_title,
sui_tm_mm_app.wd_appl_id as wd_appl_id_db,
sui_tm_mm_app.wd_conf_id as wd_conf_id_db, 
sui_tm_mm_app.wcf_target_id as wcf_target_id_db,
sui_tm_mm_app.target_url as target_url_db, 
sui_tm_mm_app.ui5_app_id as ui5_app_id_db, 
sui_tm_mm_app.fiori_id as fiori_id_db, 
sui_tm_mm_app.system_alias as system_alias_db,
tadir_trans.author as Author_trans,
tadir_trans.created_on as CreatedOn_trans,
tadir_trans.devclass as Devclass_trans,
tadir_trans.masterlang as original_lang_trans,
t002t.sptxt as langu_txt,
usob_sm.okflag as okflag,
tadir_uiad.devclass as devclass,
sui_tm_mm_appdep.deprecated as life_cycle_status_uiad
}
where sui_tm_mm_app.tcode <> ' '