You can use SQVI or SE16 to get data from these tables.

Table Description 
AGR_1016 Name of the activity group profile 
AGR_1016B Name of the activity group profile 
AGR_1250 Authorization data for the activity group 
AGR_1251 Authorization data for the activity group 
AGR_1252 Organizational elements for authorizations 
AGR_AGRS Roles in Composite Roles 
AGR_DEFINE Role definition 
AGR_HIER2 Menu structure information - Customer vers 
AGR_HIERT Role menu texts 
AGR_OBJ Assignment of Menu Nodes to Role 
AGR_PROF Profile name for role 
AGR_TCDTXT Assignment of roles to Tcodes 
AGR_TEXTS File Structure for Hierarchical Menu - Cus 
AGR_TIME Time Stamp for Role: Including profile 
AGR_USERS Assignment of roles to users 
USER_ADDR Address Data for users 
USGRP User groups 
USGRPT Text table for USGRP 
USH02 Change history for logon data 
USOBT Relation transaction to authorization object (SAP) 
USOBT_C Relation Transaction to Auth. Object (Customer) 
USOBX Check table for table USOBT 
USOBX_C Check Table for Table USOBT_C 
USOBXFLAGS Temporary table for storing USOBX/T* chang 
USR01 User Master Data (runtime data) 
USR02 Logon data (password,user name, validity date etc..) 
USR04 User master authorization (one row per user) 
USR06 License data 
USR10 Authorisation profiles (i.e. &_SAP_ALL) 
USR11 Text for authorisation profiles 
USR12 Authorisation values 
USR13 Short text for authorisation 
USR40 Table for illegal passwords ( never enter * in this table) 
UST04 User profiles (multiple rows per user) 
UST10C Composit profiles (i.e. profile has sub profile) 

This is the vast list of USR, USH & AGR tables

Table name Description 
AGRR2 R2 transfer structure 
AGRR2T R2 roles transfer structure - Texts 
AGR_1016 Name of the activity group profile 
AGR_1016B Name of the activity group profile 
AGR_1250 Authorization data for the activity group 
AGR_1251 Authorization data for the activity group 
AGR_1252 Organizational elements for authorizations 
AGR_1253 Authorization Data for Activity Group - Static Objects 
AGR_AGRS Roles in Composite Roles 
AGR_AGRS2 Role definition 
AGR_ATTS Role attributes 
AGR_BOR_DTL Extended BOR Details for Menu Nodes 
AGR_BUFFI Internet Links for a Role 
AGR_BUFFI2 Internet links table - Customer version of SAP roles 
AGR_BUFFI3 Internet links table - SAP versions of SAP roles 
AGR_CATS Transfer structure for categories/PFCG start 
AGR_CUSTOM Role Customizing objects 
AGR_DATEU Personal settings for roles 
AGR_DEFINE Role definition 
AGR_EXT_DTL Extended Details for Menu Nodes 
AGR_FAVOS Personal settings for PFCG 
AGR_FILT Transfer table filter for PRGN_TREE_START 
AGR_FLAGS Role attributes 
AGR_FLAGSB Role attributes 
AGR_HIER Table for Structure Information for Menu 
AGR_HIER2 Menu structure information - Customer version of SAP roles 
AGR_HIER3 Menu structure information - SAP version of SAP roles 
AGR_HIERT Role menu texts 
AGR_HIERT2 Role menu texts - Customer version of SAP objects 
AGR_HIERT3 Role menu texts - SAP Original 
AGR_HIER_BOR Table for Object-Oriented Navigation (OBN) 
AGR_HPAGE Role Home Page 
AGR_HPAGET Description of the Home Page for a Role 
AGR_ICON Display the status icon in the Profile Generator 
AGR_INFO Filter Values from Generation Run 
AGR_LOGSYS Logical system 
AGR_LSD Role attributes 
AGR_MAP MiniApp and Text 
AGR_MAPP MiniApps in Role 
AGR_MAP_KNUMA Conversion Table AG_GUID CRM <> KNUMA 
AGR_MARK Table for report SAPPROFC_NEW 
AGR_MEM_INITIAL Agreements: Buffer for Intial Upload 
AGR_MINI MiniApps in Role 
AGR_MINI2 MiniApps in Role 
AGR_MINIT Role mini-appl texts 
AGR_MINIT2 Role mini-application texts 
AGR_NSPCE Namespace 
AGR_NUMBER Internal Counter for Assigning Profile Names 
AGR_NUM_2 Internal Counter for Assigning Profile Names 
AGR_OBJ Assignment of Menu Nodes to Role 
AGR_POPUP Structure for dialog box 
AGR_POPUP2 Structure for transaction assignment 
AGR_POPUP3 Auxiliary structure to input authorization objects 
AGR_PROF Profile name for role 
AGR_REL_KNUMA_CM Assignment: Agreement --> Campaign 
AGR_SELECT Assignment of roles to Tcodes 
AGR_SHIER Structure for the Drag and Drop Tool 
AGR_SHIERT Structure for the Drag and Drop Tool 
AGR_SHIER_BOR Structure for Additional Details with no STRING Field 
AGR_SMENU Transfer structure for role maintenance 
AGR_SPRTXT Structure for the Drag and Drop Tool 
AGR_START Start Role Maintenance: Structure for Tree 
AGR_STRING Structure for the Drag and Drop Tool 
AGR_STRUC Structure to transfer Tcodes into the Profile Generator 
AGR_ST_NAME Role Name 
AGR_TAB PFCG start tree transfer structure 
AGR_TCDTXT Assignment of roles to Tcodes 
AGR_TCODE3 Assignment of roles to Tcodes 
AGR_TCODES Assignment of roles to Tcodes 
AGR_TCODES_TEXTS Transaction Codes with Texts from AGRs 
AGR_TEXTS File Structure for Hierarchical Menu - Customer 
AGR_TIME Time Stamp for Role (Menu, Profile, Authorizations) 
AGR_TIMEB Time Stamp for Role (Profile Generation) 
AGR_TIMEC Time Stamp for Role (User Assignment) 
AGR_TIMED Time Stamp for Role (Profile Comparison, RFC Distribution) 
AGR_TRAN Transport modules of external personalization objects 
AGR_TRANS Help Structure for Translation 
AGR_TXT Role and Text 
AGR_UPLO Stucture for upload node types 
AGR_UPLT Stucture for upload node types 
AGR_UPLTX Stucture for upload description text 
AGR_USERS Assignment of roles to users 
AGR_USERT Assignment of roles to users 
USH02 Change history for logon data 
USH02_ARC_TMP Change History for Logon Data: Last Entries from Archive 
USH04 Change history for authorizations 
USH04_ARC_TMP Authorizations Change History: Last Entries from Archive 
USH10 Change history for authorization profiles 
USH10_ARC_TMP Change History for Profile Data: Last Entries from Archive 
USH12 Change history for authorization values 
USH12_ARC_TMP Change History for Authorizations: Last Archive Entries 
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) 
USRCOBJ Object Filters for Exploding Product Structures 
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 
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) 
USREXTIDT Values Table for External ID Type 
USREXTIDTT Values Table for External ID Type (Texts) 
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 
USRGIFAV iPPE Interface: Favorite 
USRGIFOL iPPE Interface: Folder 
USRGIPROFIL User Assignment to an iPPE Profile 
USRGIPROFIL_DYNP Dialog Structure: User Assignment - iPPE Workbench 
USRGIPROFIL_WTY Assign User Profile 
USRGISETTINGS User Settings for the iPPE Workbench 
USRGISTACK iPPE Workbench: Stack 
USRINFO Extended User Info for SM04 
USRINKONS Reference table for FMs for determining inconsistencies 
USRLISTPROFILE Variable List Definition in PDM Environment 
USRLUIPROFILE User Assignments to Profiles in the iPPE Workbench Express 
USRLUIPROFILE_DYNP User Assignments to Profiles 
USRLUISETTINGS User-Specific Settings of the iPPE Workbench Express 
USRLUISETTINGS_DYNP User-Specific Settings for Profile 
USRM0 Material Master User Settings: Screen Reference "User" 
USRM1 Material Master User Settings: Organizational Levels 
USRM2 User Settings for the Material Master: Logical Screens 
USRM3 Material Master User Settings: Retail Organizational Levels 
USRMETHOD Method to be called when distributing users 
USRMM User settings: material master 
USROBJECTS Table of Previous Initial Object in Structure Overview 
USRPDM User-Specific Data in the PDM Environment 
USRPWDHISTORY Password History 
USRSETTINGS_DYNP User Settings: Navigation Tree - Dialog Structure 
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 
USRTICLASS Class Assignment for Tabular Maintenance of iPPE 
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_AUFK User-Defined Fields of AUFK 
USR_FLAGS Various Flags for Authorization Programs 
USR_FLGNT Personal User Settings / Without Transport 
USR_LIST Generated Table for View USR_LIST 
USR_QUERY BW Query 
USR_TREESNODE Node Structure of a Simple Tree (Report SAPTREX3) 
USR_VALUES Transfer structure for selection acc. to auth. values 

SAP BC

SAP Basis Reference Books:
SAP Basis Components, System Administration, Security, ALE and iDoc Books

SAP Table Tips:
SAP Database Table Hints and Tips

Back to Basis Menu:
SAP BC (Basis Components) Hints and Tips

Return to :-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips