SAP ABAP Table AGR_USERS (Assignment of roles to users)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SEC-AUT-PFC (Application Component) ABAP Authorization and Role Management
     ⤷ S_PROFGEN (Package) ABAP Role Administration (Profile Generator)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AGR_USERS	Table Relationship Diagram
Short Description	Assignment of roles to users

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	SYMANDT	MANDT	CLNT	3	0	Client ID	T000
2	AGR_NAME	☑	AGR_NAME	AGR_NAME	CHAR	30	0	Role Name	AGR_DEFINE
3	UNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
4	FROM_DAT	☑	AGR_FDATE	DATS	DATS	8	0	Date of validity
5	TO_DAT	☑	AGR_TDATE	DATS	DATS	8	0	Date of validity
6	EXCLUDE	☐	AGR_EXCL	CHAR1	CHAR	1	0	Exclusive
7	CHANGE_DAT	☐	MENU_DATE	DATS	DATS	8	0	Date of menu generation
8	CHANGE_TIM	☐	MENU_TIME	TIMES	TIMS	6	0	Time when the menu was generated last
9	CHANGE_TST	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
10	ORG_FLAG	☐	AGR_ORG	CHAR1	CHAR	1	0	Flag: Assignment Comes From HR Organization Management
11	COL_FLAG	☐	AGR_COL	CHAR1_X	CHAR	1	0	Flag: Assignment from composite role

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AGR_USERS	AGR_NAME	AGR_DEFINE	AGR_NAME	KEY	1	CN
2	AGR_USERS	MANDT	T000	MANDT	KEY	1	CN
3	AGR_USERS	UNAME	USR02	BNAME	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in