CDS_SUI_TM_MM_TCODE

DDL: CDS_SUI_TM_MM_TCODE SQL: SUI_TM_MM_APP_V2 Type: view

CDS View for Transaction Codes (which are used in an LADI)

CDS_SUI_TM_MM_TCODE is a CDS View that provides data about "CDS View for Transaction Codes (which are used in an LADI)" in SAP S/4HANA. It reads from 7 data sources and exposes 13 fields with key field app_id.

7 data source(s) 13 fields

Data Sources (7)

SourceAliasJoin Type
dd07t dd07t left_outer
sui_tm_mm_app sui_tm_mm_app from
sui_tm_mm_appt sui_tm_mm_appt left_outer
t002t t002t left_outer
tadir tadir left_outer
tstc tstc left_outer
tstct tstct left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SUI_TM_MM_APP_V2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS View for Transaction Codes (which are used in an LADI) view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY app_id sui_tm_mm_app app_id
tcode sui_tm_mm_app tcode
ttext tstct ttext
cat_id sui_tm_mm_app cat_id
sem_obj sui_tm_mm_app sem_obj
sem_act sui_tm_mm_app sem_act
app_type sui_tm_mm_app app_type
app_subtype sui_tm_mm_app app_subtype
fiori_id_db sui_tm_mm_app fiori_id
Author tadir author
CreatedOn tadir created_on
Devclass tadir devclass
langu_txt t002t sptxt 
@AbapCatalog.sqlViewName: 'SUI_TM_MM_APP_V2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@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, created_on, devclass, original_lang, langu_txt)
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 on tadir.pgmid  = 'R3TR'      
                         and tadir.object = 'TRAN'      
                         and tadir.obj_name = sui_tm_mm_app.tcode   
left outer join t002t on t002t.spras = $session.system_language
                         and t002t.sprsl = tadir.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 on  sui_tm_mm_app.app_type = dd07t.domvalue_l
                      and dd07t.domname = '/UI2/AD_MM_APP_TYPE' 
                      and dd07t.ddlanguage =  $session.system_language                                   
{ 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 dd07t.ddtext 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.author as Author,
tadir.created_on as CreatedOn,
tadir.devclass as Devclass,
tadir.masterlang as original_lang,
t002t.sptxt as langu_txt
}
where sui_tm_mm_app.tcode <> ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T",
"SUI_TM_MM_APP",
"SUI_TM_MM_APPT",
"T002T",
"TADIR",
"TSTC",
"TSTCT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More