S_SCRL_User

DDL: S_SCRL_USER SQL: S_V_SCRL_USER Type: view

Wrapper view for usr21

S_SCRL_User is a CDS View that provides data about "Wrapper view for usr21" in SAP S/4HANA. It reads from 1 data source (usr21) and exposes 1 field with key field Name.

Data Sources (1)

SourceAliasJoin Type
usr21 usr21 from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName S_V_SCRL_USER view
EndUserText.label Wrapper view for usr21 view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.dataCategory #TEXT view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY Name bname
@AbapCatalog.sqlViewName: 'S_V_SCRL_USER'
@EndUserText.label: 'Wrapper view for usr21'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.dataCategory: #TEXT
define view S_SCRL_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":
[],
"VERSION":0
}
}*/