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

SAP user Tables will cover the most important standard Tables in SAP sotring 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 user. In the middle, we will set an usefull scenario to retrieve Address data for SAP user.

The Most User SAP Users Tables

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

Main SAP Users Table Description
USR01/3 User master / address data
USR02Logon data (including “Lock status”)
USR04/5 Authorizations / Parameter ID
USR10Authorization profiles
UST12Authorizations
USR12Authorization values
USR21Assign user address key [ADRP]
USR41User logon data (sm04)
UST04SAP User Profile Table
V_ADDR_USR Selection of all internal user address data

The source of the following table.

SAP UserData and Address from Table

Link between SAP User Master Tables and SAP user Address

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

The main Keys for USR21 isBNAME (User Name in User Master Record).
The USR21 links the SAPNAME and :

User Name 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
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 – 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 alsoSAP Address :important Tables and BAPI

Retrieve SAP user Name for SAP Users Tables

For example, if you want to retrieve the SAP user Name, 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 user name can be found in the ADRP-NAME_TEXT.

So SAP user Name Tables and Fields are:

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

Alternatively, you can check this standard BAPIBAPI_USER_GET_DETAIL to retrieve the SAP user Name from the userid

SAP User Email Table

In order to retrive 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 SAPFunction Module to get user email address:
HR_FBN_GET_USER_EMAIL_ADDRESS

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

Full list of User’s Tables in SAP

SAP Users Tables

SAP Users Table Description
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
USRACCNTVGenerated Table for View USRACCNTV
USRACLSNC Access Control List (ACL): User
USRACLEXTExtended SNC Access Control List (ACL) for Users
USRARCSTATReloaded Archiving Runs
USRATTRAdditional Attributes for Users
USRBFUser Buffer Contents for Fast RFC Logon
USRBF2User buffer content for fast RFC logon – new
USRBF3User Buffer Content for Fast RFC Logon – New
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)
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_PERSUser 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
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
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
USRPWDHISTORYPassword History
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
USRSYSVTYPGenerated Table for View USRSYSVTYP
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_TXTUser
USR_VALUESTransfer structure for selection acc. to auth. values
UST04 User masters
UST10C User master: Composite profiles
UST10S User master: Single profiles
UST12User 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

SAP and SAP logo are registered trademarks of SAP AG. Sap4tech.net is not associated with SAP AG.
We have made every effort to make sure provide relevant search results, use the content on this site at your own risk.

We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.