N_SCLG_USER

DDL: N_SCLG_USER SQL: N_SCLG_USER_V Type: view

CLG: User

N_SCLG_USER is a CDS View that provides data about "CLG: User" in SAP S/4HANA. It reads from 1 data source (usr21) and exposes 1 field with key field name.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
usr21 usr21 from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName N_SCLG_USER_V view
EndUserText.label CLG: User view
ClientDependent false view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY name bname 
@AbapCatalog.sqlViewName: 'N_SCLG_USER_V'
@EndUserText.label: 'CLG: User'
@ClientDependent: false
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

define view N_SCLG_USER
  as select from usr21
{
  key bname as name,
      @Semantics.text: true
      case techdesc
        when '' then bname
        else techdesc
      end   as description
}
where
  mandt = $session.client
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"USR21"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More