CDS_SUI_TA_SELECT

DDL: CDS_SUI_TA_SELECT SQL: SUI_TA_SELECT_V Type: view

Multiselect for transactions

CDS_SUI_TA_SELECT is a CDS View that provides data about "Multiselect for transactions" in SAP S/4HANA. It reads from 6 data sources and exposes 6 fields with key field tcode.

6 data source(s) 6 fields

Data Sources (6)

SourceAliasJoin Type
df14l df14l left_outer
df14t df14t left_outer
tadir tadir inner
tdevc tdevc left_outer
tstct tstct left_outer
tstct tstct_original left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SUI_TA_SELECT_V view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Multiselect for transactions view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY tcode tstc tcode
ttext
devclass tadir devclass
ps_posid df14l ps_posid
name df14t name
pgmna tstc pgmna 
@AbapCatalog.sqlViewName: 'SUI_TA_SELECT_V'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Multiselect for transactions'
define view CDS_SUI_TA_SELECT 
( tcode, ttext, devclass, component, component_text, program_name
)
as select distinct from tstc
      inner join tadir
         on tstc.tcode = tadir.obj_name and
            tadir.pgmid  = 'R3TR' and
            tadir.object = 'TRAN' 
      left outer join tstct
        on tstc.tcode = tstct.tcode and
           tstct.sprsl = $session.system_language 
      left outer join tstct as tstct_original
        on tstc.tcode = tstct_original.tcode and
           tstct_original.sprsl = tadir.masterlang 
      left outer join tdevc
        on tadir.devclass = tdevc.devclass
      left outer join df14l
        on tdevc.component = df14l.fctr_id
      left outer join df14t
        on df14l.fctr_id = df14t.fctr_id
       and df14l.as4local = df14t.as4local 
       and df14t.langu = $session.system_language                                            
{ key tstc.tcode,
   coalesce(tstct.ttext, tstct_original.ttext) as ttext, 
   tadir.devclass,
   df14l.ps_posid,
   df14t.name,
   tstc.pgmna
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DF14L",
"DF14T",
"TADIR",
"TDEVC",
"TSTC",
"TSTCT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More