SAP AGR_USERT Assignment of roles to users Table

Overview

AGR_USERT is a standard SAP S/4HANA table that stores Assignment of roles to users data. There are total 11 fields in the AGR_USERT table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AGR_USERT belongs to ABAP Authorization and Role Management (BC-SEC-AUT-PFC) module and is located in the package ABAP Role Administration (Profile Generator) (S_PROFGEN).

In addition, following links provide an overview of foreign key relationships, if any, that link AGR_USERT to other SAP tables and standard CDS views available based on AGR_USERT table in S/4HANA 2020.

Techincal Settings of AGR_USERT

Below are technical details of the table AGR_USERT

  • Buffering switched on
  • Full buffering as specified by generic key
  • Storage type is Column Store

List of AGR_USERT Fields

The following table gives you an overview of the fields available in AGR_USERT

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClient IDSYMANDTCLNT3
AGR_NAMERole NameAGR_NAMECHAR30
UNAMEUser NameSYUNAMECHAR12
FROM_DATDate of validityAGR_FDATEDATS8
TO_DATDate of validityAGR_TDATEDATS8
EXCLUDEExclusiveAGR_EXCLCHAR1
CHANGE_DATDate of menu generationMENU_DATEDATS8
CHANGE_TIMTime when the menu was generated lastMENU_TIMETIMS6
CHANGE_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)RSTIMESTMPDEC15
ORG_FLAGFlag: Assignment Comes From HR Organization ManagementAGR_ORGCHAR1
COL_FLAGFlag: Assignment from composite roleAGR_COLCHAR1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AGR_USERT

Other References