P_USR_TO_GLOBALUID

DDL: P_USR_TO_GLOBALUID SQL: PUSRTOGLOBALUID Type: view BASIC Package: SUSR_IDENTITY

User UUID

P_USR_TO_GLOBALUID is a Basic CDS View that provides data about "User UUID" in SAP S/4HANA. It reads from 2 data sources (usr_to_globaluid, usr02) and exposes 3 fields with key field bname. Part of development package SUSR_IDENTITY.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
usr_to_globaluid _usr_to_globaluid from
usr02 _usr02 inner

Annotations (7)

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

Fields (3)

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

// Read User UUID for UserID with authorization check


define view P_USR_TO_GLOBALUID 
  as select from    usr_to_globaluid as _usr_to_globaluid
    inner join      usr02            as _usr02              on  _usr_to_globaluid.bname = _usr02.bname
{
  key _usr02.bname,
      _usr02.class,
      _usr_to_globaluid.sap_uid            
}

Learn More