SAIS_USER_F4

DDL: SAIS_USER_F4 Type: view_entity Package: SAIS_TOOLS

BC-SEC Value Help for Users

SAIS_USER_F4 is a CDS View that provides data about "BC-SEC Value Help for Users" in SAP S/4HANA. It reads from 6 data sources and exposes 13 fields with key field UserID. It has 2 associations to related views. Part of development package SAIS_TOOLS.

6 data source(s) 13 fields

Data Sources (6)

SourceAliasJoin Type
usr21 _usr21 inner
usr21 _usr21 inner
P_UserAddress002 adr inner
P_UserAddress002 adr inner
SAIS_GAF_USER_F4_X x from
SAIS_GAF_USER_F4_X x union

Associations (2)

CardinalityTargetAliasCondition
[0..1] usrefus usref usref.bname = x.bname
[0..1] usr02 us02 us02.bname = x.bname

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label BC-SEC Value Help for Users view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY UserID SAIS_GAF_USER_F4_X bname
UserDescription
UserAlias
FullName P_UserAddress002 NAME_TEXTC
EMail P_UserAddress002 smtp_addr
AddressType P_UserAddress002 idadtype
bnameasUserID
UserDescription
UserAlias
FullName P_UserAddress002 NAME_TEXTC
EMail P_UserAddress002 smtp_addr
AddressType P_UserAddress002 idadtype
UserGroup us02 class 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'BC-SEC Value Help for Users'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity SAIS_USER_F4
  as select from SAIS_GAF_USER_F4_X as x 
   // restricted user list for GAF in systems where security audit log recording

   // is configured with special profile PC_SECUR

    inner join P_UserAddress002 as adr on ( adr.bname = x.bname )
    inner join usr21 as _usr21 on _usr21.bname = x.bname
    association [0..1] to usrefus as usref  on usref.bname = x.bname
    association [0..1] to usr02 as us02 on us02.bname = x.bname
   {
     @Semantics.user.id: true
     key x.bname as UserID,
     cast( _usr21.techdesc as vdm_userdescription preserving type ) as UserDescription,
      coalesce( usref.useralias, '') as UserAlias,
      @Consumption.semanticObject: 'BusinessPartner'
      @Semantics.name.fullName: true  
      adr.NAME_TEXTC                 as FullName,
      @Semantics.eMail.address: true
      @Semantics.eMail.type:  [#WORK]
      adr.smtp_addr                  as EMail,
      adr.idadtype                   as AddressType,
      us02.class                     as UserGroup
   } where x.op_mode = 'IS_SAAS'  and x.bname like 'CB%' or x.bname like 'CC%' or x.bname like 'ZCB%' or x.bname like 'ZCC%'

 // user list for GAF in systems where security audit log recording

 // is NOT configured with special profile PC_SECUR

 union select from SAIS_GAF_USER_F4_X as x
   inner join P_UserAddress002 as adr on ( adr.bname = x.bname )
   inner join usr21 as _usr21 on _usr21.bname = x.bname
   association [0..1] to usrefus as usref  on usref.bname = x.bname
   association [0..1] to usr02 as us02 on us02.bname = x.bname
   {
     key x.bname as UserID,
     cast( _usr21.techdesc as vdm_userdescription preserving type ) as UserDescription,
      coalesce( usref.useralias, '') as UserAlias,
   
      adr.NAME_TEXTC                 as FullName,
      adr.smtp_addr                  as EMail,
      adr.idadtype                   as AddressType,
       us02.class                    as UserGroup
   } where x.op_mode = ''

Learn More