P_USER_LOGON

DDL: P_USER_LOGON SQL: PUSERLOGON Type: view BASIC

Suche nach Logondaten

P_USER_LOGON is a Basic CDS View that provides data about "Suche nach Logondaten" in SAP S/4HANA. It reads from 1 data source (usr02) and exposes 8 fields with key field bname. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
usr02 _usr02 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] usrefus _usrefus _usr02.bname = _usrefus.bname

Annotations (7)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PUSERLOGON view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Suche nach Logondaten view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY bname usr02 bname
gltgv usr02 gltgv
gltgb usr02 gltgb
ustyp usr02 ustyp
class usr02 class
accnt usr02 accnt
useralias _usrefus useralias
refuser _usrefus refuser 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PUSERLOGON'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Suche nach Logondaten'
@VDM.viewType: #BASIC

// F4 search help for Users

// This CDS view is used in the search help USER_LOGON.

// An authority check for S_USER_GRP with activity '03' might be added

// !!! Use this CDS_View in User Management only !!!


define view P_USER_LOGON
  as select from        usr02        as _usr02
  association [0..1] to usrefus      as _usrefus    on _usr02.bname      = _usrefus.bname
{  
  key _usr02.bname,
      _usr02.gltgv,
      _usr02.gltgb,
      _usr02.ustyp,
      _usr02.class,
      _usr02.accnt,
      _usrefus.useralias,
      _usrefus.refuser
}

Learn More