s_sclt_trace_user

DDL: S_SCLT_TRACE_USER SQL: S_V_SCLT_TRC_USR Type: view

Trace user

s_sclt_trace_user is a CDS View that provides data about "Trace user" in SAP S/4HANA. It reads from 2 data sources (I_User, s_sclt_customeruser_ddl) and exposes 3 fields with key field UserID.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_User I_User union
s_sclt_customeruser_ddl s_sclt_customeruser_ddl from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName S_V_SCLT_TRC_USR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Trace user view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY UserID UserID
UserDescription Description
UserDescription UserDescription 
@AbapCatalog.sqlViewName: 'S_V_SCLT_TRC_USR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Trace user'
define view s_sclt_trace_user
  as select from s_sclt_customeruser_ddl
{
  key UserID                 as UserID,
      Description            as UserDescription,
      cast ( case when UserID = $session.user
              then 'X'
              else ''
            end as boole_d ) as IsLoggedInUser
}
where
  UserGroupName = 'SAP_CUST_COM'
union select from I_User
{
  key UserID                 as UserID,
      UserDescription        as UserDescription,
      cast ( case when UserID = $session.user
              then 'X'
              else ''
            end as boole_d ) as IsLoggedInUser
}
where
     UserID = 'SAP_WFRT'
  or UserID = $session.user
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_USER",
"S_SCLT_CUSTOMERUSER_DDL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More