P_BPUsrDetail

DDL: P_BPUSRDETAIL SQL: PBPUSRDETAIL Type: view BASIC

Business User - User Detail

P_BPUsrDetail is a Basic CDS View that provides data about "Business User - User Detail" in SAP S/4HANA. It reads from 4 data sources (usr01, usr02, usr21, usrefus) and exposes 13 fields with key field BusinessPartnerUUID. It has 1 association to related views.

4 data source(s) 13 fields

Data Sources (4)

SourceAliasJoin Type
usr01 usr01 inner
usr02 usr02 inner
usr21 usr21 from
usrefus usrefus inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] P_USR_BY_GLOBALUID _UserBySAPUserUUID $projection.UserID = _UserBySAPUserUUID.bname

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PBPUSRDETAIL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business User - User Detail view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.representativeKey BusinessPartnerUUID view
VDM.private true view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID usr21 bpperson
UserID
UserName usrefus useralias
UserDescription
LogonLanguageCode usr01 langu
TimeFormatCode usr01 timefm
TimeZoneCode usr02 tzone
DateFormatCode usr01 datfm
DecimalFormatCode usr01 dcpfm
UserGroup usr02 class
ValidFrom usr02 gltgv
ValidTo usr02 gltgb
_UserBySAPUserUUID _UserBySAPUserUUID 
@AbapCatalog.sqlViewName: 'PBPUSRDETAIL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Business User - User Detail'
@ClientHandling.type: #CLIENT_DEPENDENT
@ObjectModel.representativeKey: 'BusinessPartnerUUID'
@VDM.private: true
@VDM.viewType: #BASIC
define view P_BPUsrDetail
  as select from usr21
    inner join   usr01   on usr01.bname = usr21.bname
    inner join   usr02   on usr02.bname = usr21.bname
    inner join   usrefus on usrefus.bname = usr21.bname
  association [0..*] to P_USR_BY_GLOBALUID as _UserBySAPUserUUID on $projection.UserID = _UserBySAPUserUUID.bname
{
  key usr21.bpperson                                                as BusinessPartnerUUID,
      cast( usr21.bname as vdm_userid preserving type )             as UserID,
      usrefus.useralias                                             as UserName,
      cast( usr21.techdesc as vdm_userdescription preserving type ) as UserDescription,
      case usr02.uflag
         when 32 then 'X'
         when 64 then 'X'
         when 96 then 'X'
         else ' '  end                                              as LockedIndicator, //ByteCoded: 32, 64 and 96 represents locks

      usr01.langu                                                   as LogonLanguageCode,
      usr01.timefm                                                  as TimeFormatCode,
      usr02.tzone                                                   as TimeZoneCode,
      usr01.datfm                                                   as DateFormatCode,
      usr01.dcpfm                                                   as DecimalFormatCode,
      usr02.class                                                   as UserGroup,
      usr02.gltgv                                                   as ValidFrom,
      usr02.gltgb                                                   as ValidTo, 
      _UserBySAPUserUUID      
}
where
     usr21.idadtype = '02'
  or usr21.idadtype = '04'

Learn More