P_USR_BY_GLOBALUID

DDL: P_USR_BY_GLOBALUID SQL: PUSRBYGLOBALUID Type: view BASIC

User UUID

P_USR_BY_GLOBALUID is a Basic CDS View that provides data about "User UUID" in SAP S/4HANA. It reads from 2 data sources (usr_by_globaluid, usr02) and exposes 4 fields with key field sap_uid.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
usr_by_globaluid _usr_by_globaluid from
usr02 _usr02 inner

Annotations (7)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PUSRBYGLOBALUID view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label User UUID view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY sap_uid usr_by_globaluid sap_uid
bname usr02 bname
class usr02 class
active usr_by_globaluid active 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PUSRBYGLOBALUID'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'User UUID'
@VDM.viewType: #BASIC

// Read UserID for User UUID with authorization check for CL_IDENTITY_FACTORY=>SEARCH


define view P_USR_BY_GLOBALUID 
  as select from    usr_by_globaluid as _usr_by_globaluid
    inner join      usr02            as _usr02              on  _usr_by_globaluid.bname = _usr02.bname
{
  key _usr_by_globaluid.sap_uid,
      _usr02.bname,
      _usr02.class,
      _usr_by_globaluid.active
}

Learn More