SAP Users Tables (for Personal, Logon, and Address Data)

SAP Users Tables

SAP user tables will cover the most important standard Tables in SAP storing all the data for SAP User.

First, we will start with the most used SAP users Tables, then you will get the full list of the tables for users.

In the middle, we will set a useful scenario to retrieve address data for SAP users.

The Most User SAP Users Tables

Let’s start this part with the Main SAP Users Tables name :

USR01/3User master / address data
USR02Logon data (including Lock status)
USR04/5Authorizations / Parameter ID
USR10Authorization profiles
USR12Authorization values
USR21Assign user address key [ADRP]
USR41User logon data (sm04)
UST04SAP User Profile Table
V_ADDR_USRSelection of all internal user address data

Find the source of the following tables’ list.

SAP User Data and Address from Table

Link between SAP User Master Tables and SAP user Address

The Link between SAP Users Tables and its Address including SAP userName, SAP user Last Name, email, telephone … starts with the SAP user Table USR21.

The main Keys for USR21 is BNAME (Username in User Master Record).
The USR21 links the SURNAME and :

Username in User Master Record

  • PERSNUMBER: Person number
  • ADDRNUMBER: Address number

Once you go the SAP User’s Personal Number and the Address Number, the next step is to retrieve Master Data and Address Data.

Main SAP Address Tables

The main list of SAP Address Tables are:

ADRCAddresses (Business Address Services)
ADRPPersons (Business Address Services)
ADR2Telephone Numbers (Business Address Services)
ADR3Fax Numbers (Business Address Services)
ADR6E-Mail Addresses (Business Address Services)
ADR7Remote Mail Addresses ( SAP – Communication; BAS)
ADR8X.400 Numbers (Business Address Services)
ADR9RFC Destinations (Business Address Services)
ADR10Printer (Business Address Services)
ADR12FTP and URL (Business Address Services)

Check also SAP Address : Important Tables and BAPI

Retrieve SAP username for SAP Users Tables

For example, if you want to retrieve the SAP username, use the table ADRP.

The ADRP-NAME_FIRST and ADRP-NAME_LAST store the first name and the last name of the SAP user. Hence, T=the full SAP username can be found in the ADRP-NAME_TEXT.

So SAP username Tables and Fields are:

  • ADRP-NAME_FIRST: First name
  • ADRP-NAME_LAST: Last Name
  • ADRP-NAME_TEXT : Full SAP username

Alternatively, you can check this standard BAPI BAPI_USER_GET_DETAIL to retrieve the SAP username from the user id

SAP User Email Table

In order to retrieve SAP User Email, get the personal number and the Address number from SAP User Table USR21.

Then with both of these keys, make a select on table ADR6.
The SAP User Email field is ADR6-SMTP_ADDR.

An alternative is to use the SAP Function Module to get user email address:

Check also Full ABAP Program How to Delete Customer Address in SAP

Full list of User’s Tables in SAP

Here the list of all Related SAP Users Tables:

SAP User USR* Tables

The SAP Tables USR* stores the SAP User Data such as Address, logon …

Let’s start with the main important, the SAP user USRNN tables:

USR01User master record (runtime data)
USR02Logon Data (Kernel-Side Use)
USR03User address data
USR04User master authorizations
USR05User Master Parameter ID
USR06Additional Data per User
USR06SYSSystem-Specific User Classification (License-Related)
USR07Object/values of last authorization check that failed
USR08Table for user menu entries
USR09Entries for user menus (work areas)
USR10User master authorization profiles
USR11User Master Texts for Profiles (USR10)
USR12User Master Authorization Values
USR13Short Texts for Authorizations
USR14Surchargeable Language Versions per User
USR15External User Name (Replaced By Table USRACL)
USR16Values for Variables for User Authorizations
USR20Date of last user master reorganization
USR21Assign user name address key
USR21SShadow table: Assignment of user name to address key
USR22Logon data without kernel access
USR30Additional Information for User Menu
USR40Table for illegal passwords
USR41User master: Additional data
USR41_MLDTransaction Data for USR41


Some interesting data for SAP User can be found in the following tables:

USRACL Tables: store the SNC Data. In the other hand, for example the

SAP USRBF* Fast RFC Logon Tables

SAP USRBF* Tables contain the User Buffer Data or Fast RFC Logon.

USRBFUser Buffer Contents for Fast RFC Logon
USRBF2User buffer content for fast RFC logon – new
USRBF3User Buffer Content for Fast RFC Logon – New


The SAP USRCD* Tables store the Change Documents structures by user.

USRCDStructure for Change Documents Display in RSUSR100
USRCDTStructure for Change Documents (Technical View)
USRCD_NStructure for Change Documents (Horizontal Status History)
USRCD_TStructure for Change Documents (Technical View)
USRCD_WStructure for Change Documents (Vertical Status History)


Here the list of SAP Users Tables starting with USRA*, USRD* and USRF*

USRACCNTVGenerated Table for View USRACCNTV
USRACLEXTExtended SNC Access Control List (ACL) for Users
USRARCSTATReloaded Archiving Runs
USRATTRAdditional Attributes for Users
USRCERTENTRY_SStructure with elements of a certificate entry
USRCOMBCritical Combinations of Authorizations
USRCOMBTShort Texts for Critical Combinations of Authorizations
USRCRCOMBPart List of Variants for Critical Combinations of Auths
USRDFLTUser Settings Field/Value Combination
USRDFLT_KEYKey for User Settings
USRDFLT_PERS_ALVUser Settings – ALV Display
USREFTransfer structure for cross-reference function modules
USREFLANGUTransfer structure for cross-reference function modules
USREFUSReference user for internet applications
USREFUSVARAssignment of Reference User Variabe to Reference User

SAP Users Tables USREL*

In you are looking for some User Administration Data and Relationship, check USREL Tables:

USREL_2User Administration: Relationship Between Two Objects
USREL_3User Administration: Relationship Between Three Objects
USREL_ATUser Administration: User in Relationship (with Time)
USREL_SAGUM: Assignment of Role/Position to System (Type)
USREL_UAGUM: Assignment of Role to User
USREL_USGUM: Assignment of User (Group) to System (Type)
USREL_USAUser Administration: User System Activity Group
USREL_UTUser Administration: User in Relationship (with Time)
USREL__AUser Administration: System – Activity Group
USREL__SUser Administration: System in Relationships
USREL__UUser Administration: User in Relationship

Other USR* SAP Users Tables

Here the missing part of SAP User Tables:

USREXTIDAssignment of External ID to Users
USREXTIDHExternal ID (Access Using Hash Value)
USREXTIDMAPAssignment of External ID to Users
USREXTIDTValues Table for External ID Type
USREXTIDTTValues Table for External ID Type (Texts)
USREXTID_IDMTable for Provisioning of USREXTID Data from IDM
USRFIELDCentral user maintenance: Field maintenance allowed or not
USRFLDCUA: Definition of Logical Fields
USRFLDDEFCUA: Definition of Logical Field Names of ALE Distrib. Users
USRFLDGRPCUA: Field Selection Groups
USRFLDSELCUA: Field Attributes
USRFLDTCUA: Text Table to Define Logical Fields
USRFLDTSELSelection of fields
USRFLDVALCUA: Selection Criteria for Field Attributes
USRGENPRSTable for General Workplace Personalization Data
USRGETFTRTransfer Structure
USRGETSTRCStructure for user transfer
USRINFOExtended User Info for SM04
USRINKONSReference table for FMs for determining inconsistencies
USRMETHODMethod to be called when distributing users
USRSTAMPTime Stamp for all Changes to the User
USRSYSACTCUA: Roles in Distributed Systems
USRSYSACTTCUA: Roles in Distributed Systems
USRSYSLNGUser’s Language in a System
USRSYSPRFCUA: Profiles in Distributed Systems
USRSYSPRFTCUA: Profile Text in Distributed Systems
USRSYSUPLCUA: Price Lists in SAP System
USRSYSUPPLCUA: Assignment of User Types to Price Lists
USRSYSUTPACUA: System Measurement: User Types with Attributes
USRSYSUTYPCUA: Texts for User Types in SAP System
USRSYSUZUSCUA: Texts for Special Versions
USRTREECOLUser-Specific Column Permutations per Array Type
USRURLPRSTable for Personalization of Services
USRURLSVRLogical Web Servers for Logical Systems (User-Specific)
USRVARVariants for Critical Authorizations
USRVARCOMVariants of Critical Combinations of Authorizations
USRVARCOMTShort Texts for Variants of Critical Combs of Authorizations
USRVARIDPart List of Variants for Critical Authorizations
USRVARTShort Texts for Variants of Critical Authorizations
USRVIEWCOLUser-Specific Column View
USRVIEWTABUser-specific Tabstrip View
USR_CUSTCustomizing Settings for Users / Authorizations
USR_FLAGSVarious Flags for Authorization Programs
USR_FLGNTPersonal User Settings / Without Transport
USR_LISTGenerated Table for View USR_LIST
USR_VALUESTransfer structure for selection acc. to auth. values

SAP UST* Tables

SAP UST* User tables are mainly for User Masters and User Administration:

UST04User masters
UST10CUser master: Composite profiles
UST10SUser master: Single profiles
UST12User master: Authorizations
USTABSETTransfer structure for internal table tabset
USTABSETAMTransfer Structure for Internal Table Tabset (Active- Maint)
USTCDTransfer Structure for Transaction Codes
USTLISTList of Transactions for SE97
USTRAUTHStructure to Display All Authorizations in Class
USTREEAGRUser Administration: Tree Structure Users/User Groups
USTREESYSUser Administration: Tree Structure Users/User Groups
USTREEUSERUser Administration: Tree Structure Users/User Groups
USTSTCAPGenerated Table for View USTSTCAP