SAP Users Tables, SAP user name and address

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
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

The source of the following table.

SAP User Data and Address from Table

Link between SAP User Master Tables and SAP user Address

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

The main Keys for USR21 is BNAME  (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
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 – 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   HTML Template in ABAP

Check also SAP 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 BAPI BAPI_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 SAP Function 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
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
USRACCNTV Generated Table for View USRACCNTV
USRACL SNC Access Control List (ACL): User
USRACLEXT Extended SNC Access Control List (ACL) for Users
USRARCSTAT Reloaded Archiving Runs
USRATTR Additional Attributes for Users
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
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)
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
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
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
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
Check also   CL_BCS : How to easily Send Email with ABAP

Leave a Reply

Your email address will not be published. Required fields are marked *