SUIM_2X_APPL_TYPE_HT

DDL: SUIM_2X_APPL_TYPE_HT SQL: SUIM2X_TYP_HT Type: view

SU2X Application Types (TADIR Services)

SUIM_2X_APPL_TYPE_HT is a CDS View that provides data about "SU2X Application Types (TADIR Services)" in SAP S/4HANA. It reads from 1 data source (tadir) and exposes 4 fields with key fields type, pgmid, object.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
tadir wbo inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SUIM2X_TYP_HT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SU2X Application Types (TADIR Services) view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY type master type
KEY pgmid tadir pgmid
KEY object tadir object
ddtext 
@AbapCatalog.sqlViewName: 'SUIM2X_TYP_HT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'SU2X Application Types (TADIR Services)'
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
define view SUIM_2X_APPL_TYPE_HT
  as select distinct from usobhash as master
    inner join            tadir    as wbo on(
      wbo.pgmid        = master.pgmid
      and wbo.object   = master.object
      and wbo.obj_name = master.obj_name
    )

  association [0..1] to objt as _tx_obj    on( _tx_obj.language     = $session.system_language   and _tx_obj.objectname = master.object    and _tx_obj.objecttype = 'L'       )
  association [0..1] to objt as _tx_obj_en on( _tx_obj_en.language  = 'E'                        and _tx_obj_en.objectname = master.object and _tx_obj_en.objecttype = 'L'    )


{
  key master.type                                   as type,
  key wbo.pgmid                                     as pgmid,
  key wbo.object                                    as object,
      coalesce( coalesce( _tx_obj.ddtext, _tx_obj_en.ddtext ), cast( wbo.object as ddtext) )  as ddtext
}
where
      master.type =  'HT'
  and wbo.pgmid   =  'R3TR'
  and wbo.object  <> 'TRAN'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"OBJT",
"TADIR",
"USOBHASH"
],
"ASSOCIATED":
[
"OBJT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More