AGR_USERS is a standard ABAP Authorization and Role Management Transparent Table in SAP Basis application, which stores Assignment of roles to users data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for AGR_USERS. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

AGR_USERS — Meta Data

Description: Assignment of roles to users
Main Category: Basis
Sub Category: ABAP Authorization and Role Management
Table type: Transparent Table (TRANSP)

AGR_USERS — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 AGR_NAME Role X CHAR 30 AGR_DEFINE
    3 UNAME User Name X CHAR 12 USR02
    4 FROM_DAT Date of menu generation X DATS 8
    5 TO_DAT Date of menu generation X DATS 8
    6 EXCLUDE System Measurement: Excluded User Flag CHAR 1
    7 CHANGE_DAT Changed On DATS 8
    8 CHANGE_TIM Changed At TIMS 6
    9 CHANGE_TST Time Stamp of Change Time DEC 15
    10 ORG_FLAG Indicator: Indirect Assignment of the User to the Role CHAR 1
    11 COL_FLAG Single-Character Flag CHAR 1

SAP Help, Wiki Resources, and Forum Discussions on AGR_USERS


Related Tables

TABLE Description Functional Area
AGR_1251 Authorization data for the activity group Basis - ABAP Authorization and Role Management
AGR_TCODES Assignment of roles to Tcodes Basis - ABAP Authorization and Role Management
USR02 Logon Data (Kernel-Side Use) Basis - Authentication and SSO
AGR_DEFINE Role definition Basis - ABAP Authorization and Role Management
AGR_1252 Organizational elements for authorizations Basis - ABAP Authorization and Role Management
AGR_AGRS Roles in Composite Roles Basis - ABAP Authorization and Role Management
AGR_TEXTS File Structure for Hierarchical Menu - Customer Basis - ABAP Authorization and Role Management

Transaction Codes for SAP Table AGR_USERS

FMs for SAP Table AGR_USERS

FM Description Functional Area
BAPI_USER_GET_DETAIL Read User Details Basis - User and Authorization Management
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
RFC_READ_TABLE External access to R/3 tables via RFC Basis - See Note 539477
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
SUSR_USER_AUTH_FOR_OBJ_GET Display authorizations (for a specified object) belonging to a user Basis - User and Authorization Management
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
USER_SETTINGS User settings Basis - Terminology/Glossary
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer

ABAP Reports for SAP Table AGR_USERS

ABAP REPORT Description Functional Area
RSUSR002 Users by Complex Selection Criteria Basis - User Information System
RSUSR010 Executable Transactions ( All Selection Options ) Basis - User Information System
RSUSR070 Roles by Complex Selection Criteria Basis - User Information System
SPRSL TEXT 630 - Workbench Tools: Editors
RSUSR100 Change Documents for Users Basis - User Information System
PFCG_TIME_DEPENDENCY Role time-dependency scheduling report Basis - ABAP Authorization and Role Management
PRGN_COMPRESS_TIMES Compression of Assignment User to Role Basis - ABAP Authorization and Role Management
RSUSR200 List of Users According to Logon Date and Password Change Basis - System Audit Information System

BW Datasources for SAP Table AGR_USERS

BW DATASOURCE Description Functional Area
0FI_AA_12 FI-AA: Posted Depreciations FI - Asset Accounting
0BWTC_C03 BW Statistics: Transact. Data OLAP, Detail Navigation Step -
0BWTC_C02 BW Statistics: Transaction Data OLAP -
0TCT_DS02 OLAP: Detailed Data -
0TCTAUTH Authorization (Technical Name) -
0FI_AA_11 FI-AA: Transactions FI - Asset Accounting
0TCTUSERNM BW Metadata: User -

Authorization Objects for SAP Table AGR_USERS

AUTHORIZATION OBJECT Description Functional Area
S_TCODE Transaction Code Check at Transaction Start
P_ORGIN HR: Master Data
M_EINK_FRG Release Code and Group (Purchasing)
P_TCODE HR: Transaction codes
S_DATASET Authorization for file access
F_BKPF_BUK Accounting Document: Authorization for Company Codes
S_RFC Authorization Check for RFC Access
S_TABU_DIS Table Maintenance (via standard tools such as SM30)