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.
Table of Contents
The Most User SAP Users Tables
Let’s start this part with the Main SAP Users Tables name :
| Table | MAIN SAP USERS TABLE |
|---|---|
| USR01/3 | User master / address data |
| USR02 | Logon data (including Lock status) |
| USR04/5 | Authorizations / Parameter ID |
| USR10 | Authorization profiles |
| UST12 | Authorizations |
| USR12 | Authorization values |
| USR21 | Assign user address key [ADRP] |
| USR41 | User logon data (sm04) |
| UST04 | SAP User Profile Table |
| V_ADDR_USR | Selection 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:
| SAP ADDRESS TABLE | DESCRIPTION |
|---|---|
| ADRC | Addresses (Business Address Services) |
| ADRP | Persons (Business Address Services) |
| ADR2 | Telephone Numbers (Business Address Services) |
| ADR3 | Fax Numbers (Business Address Services) |
| ADR6 | E-Mail Addresses (Business Address Services) |
| ADR7 | Remote Mail Addresses ( SAP – Communication; BAS) |
| ADR8 | X.400 Numbers (Business Address Services) |
| ADR9 | RFC Destinations (Business Address Services) |
| ADR10 | Printer (Business Address Services) |
| ADR12 | FTP 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:
HR_FBN_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:
| SAP USERS TABLE | DESCRIPTION |
|---|---|
| USR01 | User master record (runtime data) |
| USR02 | Logon Data (Kernel-Side Use) |
| USR03 | User address data |
| USR04 | User master authorizations |
| USR05 | User Master Parameter ID |
| USR06 | Additional Data per User |
| USR06SYS | System-Specific User Classification (License-Related) |
| USR07 | Object/values of last authorization check that failed |
| USR08 | Table for user menu entries |
| USR09 | Entries for user menus (work areas) |
| USR10 | User master authorization profiles |
| USR11 | User Master Texts for Profiles (USR10) |
| USR12 | User Master Authorization Values |
| USR13 | Short Texts for Authorizations |
| USR14 | Surchargeable Language Versions per User |
| USR15 | External User Name (Replaced By Table USRACL) |
| USR16 | Values for Variables for User Authorizations |
| USR20 | Date of last user master reorganization |
| USR21 | Assign user name address key |
| USR21S | Shadow table: Assignment of user name to address key |
| USR22 | Logon data without kernel access |
| USR30 | Additional Information for User Menu |
| USR40 | Table for illegal passwords |
| USR41 | User master: Additional data |
| USR41_MLD | Transaction Data for USR41 |
SAP USRA*, USRC*, USRD*, USRF* Tables
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.
| USRBF* | Description |
|---|---|
| USRBF | User Buffer Contents for Fast RFC Logon |
| USRBF2 | User buffer content for fast RFC logon – new |
| USRBF3 | User Buffer Content for Fast RFC Logon – New |
SAP USRCD* Tables
The SAP USRCD* Tables store the Change Documents structures by user.
| USRCD* | Description |
|---|---|
| USRCD | Structure for Change Documents Display in RSUSR100 |
| USRCDT | Structure for Change Documents (Technical View) |
| USRCD_N | Structure for Change Documents (Horizontal Status History) |
| USRCD_T | Structure for Change Documents (Technical View) |
| USRCD_W | Structure for Change Documents (Vertical Status History) |
SAP USRD*, USRF* Tables
Here the list of SAP Users Tables starting with USRA*, USRD* and USRF*
| SAP USERS TABLE | DESCRIPTION |
|---|---|
| USRACCNTV | Generated Table for View USRACCNTV |
| USRACLEXT | Extended SNC Access Control List (ACL) for Users |
| USRARCSTAT | Reloaded Archiving Runs |
| USRATTR | Additional Attributes for Users |
| USRCERTENTRY_S | Structure with elements of a certificate entry |
| USRCOMB | Critical Combinations of Authorizations |
| USRCOMBT | Short Texts for Critical Combinations of Authorizations |
| USRCRCOMB | Part List of Variants for Critical Combinations of Auths |
| USRDFLT | User Settings Field/Value Combination |
| USRDFLT_KEY | Key for User Settings |
| USRDFLT_PERS | User Settings |
| USRDFLT_PERS_ALV | User Settings – ALV Display |
| USREF | Transfer structure for cross-reference function modules |
| USREFLANGU | Transfer structure for cross-reference function modules |
| USREFUS | Reference user for internet applications |
| USREFUSVAR | Assignment 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:
| SAP USERS TABLE | DESCRIPTION |
|---|---|
| USREL_2 | User Administration: Relationship Between Two Objects |
| USREL_3 | User Administration: Relationship Between Three Objects |
| USREL_AT | User Administration: User in Relationship (with Time) |
| USREL_SA | GUM: Assignment of Role/Position to System (Type) |
| USREL_UA | GUM: Assignment of Role to User |
| USREL_US | GUM: Assignment of User (Group) to System (Type) |
| USREL_USA | User Administration: User System Activity Group |
| USREL_UT | User Administration: User in Relationship (with Time) |
| USREL__A | User Administration: System – Activity Group |
| USREL__S | User Administration: System in Relationships |
| USREL__U | User Administration: User in Relationship |
Other USR* SAP Users Tables
Here the missing part of SAP User Tables:
| SAP USERS TABLE | DESCRIPTION |
|---|---|
| USREXTID | Assignment of External ID to Users |
| USREXTIDH | External ID (Access Using Hash Value) |
| USREXTIDMAP | Assignment of External ID to Users |
| USREXTIDT | Values Table for External ID Type |
| USREXTIDTT | Values Table for External ID Type (Texts) |
| USREXTID_IDM | Table for Provisioning of USREXTID Data from IDM |
| USRFIELD | Central user maintenance: Field maintenance allowed or not |
| USRFLD | CUA: Definition of Logical Fields |
| USRFLDDEF | CUA: Definition of Logical Field Names of ALE Distrib. Users |
| USRFLDGRP | CUA: Field Selection Groups |
| USRFLDSEL | CUA: Field Attributes |
| USRFLDT | CUA: Text Table to Define Logical Fields |
| USRFLDTSEL | Selection of fields |
| USRFLDVAL | CUA: Selection Criteria for Field Attributes |
| USRGENPRS | Table for General Workplace Personalization Data |
| USRGETFTR | Transfer Structure |
| USRGETSTRC | Structure for user transfer |
| USRINFO | Extended User Info for SM04 |
| USRINKONS | Reference table for FMs for determining inconsistencies |
| USRMETHOD | Method to be called when distributing users |
| USRPWDHISTORY | Password History |
| USRSTAMP | Time Stamp for all Changes to the User |
| USRSYSACT | CUA: Roles in Distributed Systems |
| USRSYSACTT | CUA: Roles in Distributed Systems |
| USRSYSLNG | User’s Language in a System |
| USRSYSPRF | CUA: Profiles in Distributed Systems |
| USRSYSPRFT | CUA: Profile Text in Distributed Systems |
| USRSYSUPL | CUA: Price Lists in SAP System |
| USRSYSUPPL | CUA: Assignment of User Types to Price Lists |
| USRSYSUTPA | CUA: System Measurement: User Types with Attributes |
| USRSYSUTYP | CUA: Texts for User Types in SAP System |
| USRSYSUZUS | CUA: Texts for Special Versions |
| USRSYSVTYP | Generated Table for View USRSYSVTYP |
| USRTREECOL | User-Specific Column Permutations per Array Type |
| USRURLPRS | Table for Personalization of Services |
| USRURLSVR | Logical Web Servers for Logical Systems (User-Specific) |
| USRVAR | Variants for Critical Authorizations |
| USRVARCOM | Variants of Critical Combinations of Authorizations |
| USRVARCOMT | Short Texts for Variants of Critical Combs of Authorizations |
| USRVARID | Part List of Variants for Critical Authorizations |
| USRVART | Short Texts for Variants of Critical Authorizations |
| USRVIEWCOL | User-Specific Column View |
| USRVIEWTAB | User-specific Tabstrip View |
| USR_CUST | Customizing Settings for Users / Authorizations |
| USR_FLAGS | Various Flags for Authorization Programs |
| USR_FLGNT | Personal User Settings / Without Transport |
| USR_LIST | Generated Table for View USR_LIST |
| USR_TXT | User |
| USR_VALUES | Transfer structure for selection acc. to auth. values |
SAP UST* Tables
SAP UST* User tables are mainly for User Masters and User Administration:
| SAP USERS TABLE | DESCRIPTION |
|---|---|
| UST04 | User masters |
| UST10C | User master: Composite profiles |
| UST10S | User master: Single profiles |
| UST12 | User master: Authorizations |
| USTABSET | Transfer structure for internal table tabset |
| USTABSETAM | Transfer Structure for Internal Table Tabset (Active- Maint) |
| USTCD | Transfer Structure for Transaction Codes |
| USTLIST | List of Transactions for SE97 |
| USTRAUTH | Structure to Display All Authorizations in Class |
| USTREEAGR | User Administration: Tree Structure Users/User Groups |
| USTREESYS | User Administration: Tree Structure Users/User Groups |
| USTREEUSER | User Administration: Tree Structure Users/User Groups |
| USTSTCAP | Generated Table for View USTSTCAP |
| USTUD | Students |
