≡ Menu

SAP Security Tables AGR

SAP Security Tables AGR

The following are the important tables are used in SAP that starts with AGR. In our previous training tutorials we have learnt about tables of user master record.

You can view tables in SAP by using transaction code “SE16”.

Table AGR 1251

Table AGR_1251 is used to check the authorization data of roles. It provides the details of role name, menu id for BIW, authorization object in user maser maintenance, authorization name in user master record, variant for profile, field name of an authorization, High and low authorization values, object status, note id , etc.

SAP AGR_1251

TABlE AGR_1252

It is used to view the details of organization data for roles. It provides the details of role name, menu id, profile generator of organization levels and authorization values.

SAP table AGR 1252

SAP table AGR_USERS

This table is used to view the roles assigned to users. It provides various details of role name, user name in master record, user validity period, assignment that comes form hr organization management, assignment from composite role. etc.

SAP AGR_USERS

SAP Table- AGR_PROF

This table is used to view the profile that defined for roles. It provides the details of role name, profile name, profile text in user master record.

SAP tables AGR Prof

SAP Table AGR _HIER

This table provides details of menu for a role. It contain the fields of role name, object is, parent id, Customized (‘C’) or standard menu (‘S’) flag, Counter for Menu ID, Report type and program name.

SAP table AGR HIER

Table AGR_TIME

The table agr_time provides the details of change of date and time for a role, it contains the fields of role name, time stamp for role, user name, last date and time change and changed by.

SAP tables AGR time

and there are some important tables like AGR_AGRA, AGR Define, AGR OBJ, AGR_PROF, AGR_TCDTXT and so on.