SHSM_USR21

DDL: SHSM_USR21 SQL: SHSUSR21 Type: view Package: ODATA_CHECK_BOOKS

CDS replacing V_USR_NAME in search help

SHSM_USR21 is a CDS View that provides data about "CDS replacing V_USR_NAME in search help" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartner, /BSNAGT/I_USR21) and exposes 4 fields. Part of development package ODATA_CHECK_BOOKS.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner _BusinessPartner inner
/BSNAGT/I_USR21 _User from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SHSUSR21 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS replacing V_USR_NAME in search help view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
bname /BSNAGT/I_USR21 bname
name_text _UserInfo name_text
AuthorizationGroup I_BusinessPartner AuthorizationGroup
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted 
@AbapCatalog.sqlViewName: 'SHSUSR21'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS replacing V_USR_NAME in search help'
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #REQUIRED

define view SHSM_USR21 
  as select from           /BSNAGT/I_USR21             as _User

    inner join             I_BusinessPartner as _BusinessPartner on _BusinessPartner.PersonNumber = _User.persnumber
    left outer to one join adrp              as _UserInfo        on _UserInfo.persnumber = _User.persnumber

{
  _User.bname,

  @Semantics.name.givenName: true
  _UserInfo.name_text,

  //_PMContactCardEmployee.PersonnelNumber,

  @Consumption.hidden: true
  _BusinessPartner.AuthorizationGroup,
  @Consumption.hidden: true
  _BusinessPartner.IsBusinessPurposeCompleted
}
where
  _User.idadtype >= '02' and _User.persnumber is not initial
//where tb003t.spras = $session.system_language

Learn More