@AbapCatalog.sqlViewName: 'SUI_TM_MM_APPATA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS View for Tiles - reduced view'
define view CDS_SUI_TM_MM_APPAT_A
( app_id, tile_id, tile_type, custom_tile_type, default_tile,
// tile_config_string, tile_icon, tile_parameters,
// service_base_url, service_path,
// refresh_interval,
// display_number_unit,
use_sem_obj_nav, reuse_text,
langu,
// tile_title, tile_subtitle, tile_keywords, tile_information,
app_type,
// app_subtype,
app_type_comb, app_component, cat_id, sem_obj, sem_act, tcode, wd_appl_id, wd_conf_id, wcf_target_id, ui5_app_id, target_url, fiori_id,
// icf_path, system_alias, tm_parameters,
// tm_information,
app_langu, app_title, app_subtitle, devclass,
// app_smart_link_title,
// cat_langu, catalog_title,
cust_smart_link_title, cust_mod_smart_link_title, merged_smart_link_title,
cust_tm_information, cust_mod_tm_information, merged_tm_information,
// cust_tile_icon, cust_mod_tile_icon,
cust_refresh_interval, cust_mod_refresh_interval, merged_refresh_interval,
cust_tile_title, cust_mod_tile_title, merged_tile_title,
cust_tile_subtitle, cust_mod_tile_subtitle, merged_tile_subtitle,
cust_tile_keywords, cust_mod_tile_keywords, merged_tile_keywords,
cust_tile_information, cust_mod_tile_information, merged_tile_information,
uiad_is_adapted
)
as select from sui_tm_mm_appat
left outer join sui_tm_mm_appatt on sui_tm_mm_appat.app_id = sui_tm_mm_appatt.app_id
and sui_tm_mm_appat.tile_id = sui_tm_mm_appatt.tile_id
and sui_tm_mm_appatt.langu = $session.system_language
left outer join sui_tm_mm_app on sui_tm_mm_appat.app_id = sui_tm_mm_app.app_id
left outer join sui_tm_mm_appt on sui_tm_mm_appat.app_id = sui_tm_mm_appt.app_id
and sui_tm_mm_appt.langu = $session.system_language
// left outer join sui_tm_mm_catt on sui_tm_mm_app.cat_id = sui_tm_mm_catt.id
// and sui_tm_mm_catt.langu = $session.system_language
left outer join sui_uiaa on sui_uiaa.app_id = sui_tm_mm_appat.app_id
left outer join sui_uiaat on sui_uiaat.app_id = sui_tm_mm_appat.app_id
and sui_uiaat.langu = $session.system_language
left outer join sui_uiaa_tile on sui_uiaa_tile.app_id = sui_tm_mm_appat.app_id
and sui_uiaa_tile.tile_id = sui_tm_mm_appat.tile_id
left outer join sui_uiaa_tilet on sui_uiaa_tilet.app_id = sui_tm_mm_appat.app_id
and sui_uiaa_tilet.tile_id = sui_tm_mm_appat.tile_id
and sui_uiaa_tilet.langu = $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 tadir on tadir.pgmid = 'R3TR'
and tadir.object = 'UIAD'
and tadir.obj_name = sui_tm_mm_app.app_id
{ key sui_tm_mm_appat.app_id,
key sui_tm_mm_appat.tile_id,
sui_tm_mm_appat.tile_type,
cast( sui_tm_mm_appat.custom_tile_type as abap.char(30) ) as custom_tile_type,
sui_tm_mm_appat.default_tile,
// sui_tm_mm_appat.tile_config_string,
// sui_tm_mm_appat.tile_icon,
// sui_tm_mm_appat.tile_parameters,
// sui_tm_mm_appat.service_base_url,
// sui_tm_mm_appat.service_path,
// sui_tm_mm_appat.refresh_intervall,
// sui_tm_mm_appat.display_number_unit,
sui_tm_mm_appat.use_sem_obj_nav,
sui_tm_mm_appat.reuse_text,
sui_tm_mm_appatt.langu,
// sui_tm_mm_appatt.tile_title,
// sui_tm_mm_appatt.tile_subtitle,
// sui_tm_mm_appatt.tile_keywords,
// sui_tm_mm_appatt.tile_information,
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_app.ach_component,
sui_tm_mm_app.cat_id,
sui_tm_mm_app.sem_obj,
sui_tm_mm_app.sem_act,
sui_tm_mm_app.tcode,
sui_tm_mm_app.wd_appl_id,
sui_tm_mm_app.wd_conf_id,
sui_tm_mm_app.wcf_target_id,
sui_tm_mm_app.ui5_app_id,
sui_tm_mm_app.target_url as target_url,
sui_tm_mm_app.fiori_id,
// sui_tm_mm_app.icf_path,
// sui_tm_mm_app.system_alias,
// sui_tm_mm_app.parameters,
// cast( sui_tm_mm_app.tm_information as abap.char(50) ) as app_tm_information,
sui_tm_mm_appt.langu,
cast( sui_tm_mm_appt.tile_title as abap.char(50) ) as app_title,
cast( sui_tm_mm_appt.tile_subtitle as abap.char(50) ) as app_subtitle,
tadir.devclass,
// cast ( sui_tm_mm_appt.alt_smart_link_title as abap.char(50) ) as app_smart_link_title,
// sui_tm_mm_catt.langu,
// sui_tm_mm_catt.title,
//
// adaptation fields
sui_uiaat.alt_smart_link_title,
sui_uiaa.mod_alt_smart_link_title,
cast ( case when sui_uiaa.mod_alt_smart_link_title = 'X' then sui_uiaat.alt_smart_link_title else sui_tm_mm_appt.alt_smart_link_title end as abap.char(100) ) as merged_smart_link_title,
sui_uiaa.tm_information,
sui_uiaa.mod_tm_information,
cast ( case when sui_uiaa.mod_tm_information = 'X' then sui_uiaa.tm_information else sui_tm_mm_app.tm_information end as abap.char(100) ) as merged_tm_information,
//sui_uiaa_tile.tile_icon,
//sui_uiaa_tile.mod_tile_icon,
// tile icon has invalid type 'string' case when sui_uiaa_tile.mod_tile_icon = 'X' then sui_uiaa_tile.tile_icon else ' ' end as cust_tile_icon,
sui_uiaa_tile.refresh_intervall,
sui_uiaa_tile.mod_refresh_intervall,
case when sui_uiaa_tile.mod_refresh_intervall = 'X' then sui_uiaa_tile.refresh_intervall else sui_tm_mm_app.refresh_intervall end as merged_refresh_interval,
sui_uiaa_tilet.tile_title,
sui_uiaa_tile.mod_tile_title,
cast( case when sui_uiaa_tile.mod_tile_title = 'X' then sui_uiaa_tilet.tile_title else sui_tm_mm_appt.tile_title end as abap.char(130) ) as merged_tile_title,
sui_uiaa_tilet.tile_subtitle,
sui_uiaa_tile.mod_tile_subtitle,
cast( case when sui_uiaa_tile.mod_tile_subtitle = 'X' then sui_uiaa_tilet.tile_subtitle else sui_tm_mm_appt.tile_subtitle end as abap.char(130) ) as merged_tile_subtitle,
sui_uiaa_tilet.tile_keywords,
sui_uiaa_tile.mod_tile_keywords,
cast( case when sui_uiaa_tile.mod_tile_keywords = 'X' then sui_uiaa_tilet.tile_keywords else sui_tm_mm_appt.tile_keywords end as abap.char(150) ) as merged_tile_keywords,
sui_uiaa_tilet.tile_information,
sui_uiaa_tile.mod_tile_information,
cast( case when sui_uiaa_tile.mod_tile_information = 'X' then sui_uiaa_tilet.tile_information else sui_tm_mm_appt.tile_information end as abap.char(150) ) as merged_tile_information,
cast( case when (sui_uiaa.app_id is not null)
// ( sui_uiaa.form_factor_desktop = 'X' or sui_uiaa.form_factor_tablet = 'X' or sui_uiaa.form_factor_phone = 'X' or
// sui_uiaa.mod_alt_smart_link_title = 'X' or sui_uiaa_tile.mod_refresh_intervall = 'X' or sui_uiaa_tile.mod_tile_title = 'X' or sui_uiaa_tile.mod_tile_subtitle = 'X' )
then 'X'
else ' '
end as sui_uiad_is_adapted ) as uiad_is_adapted
}