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.
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_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 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 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.
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.
and there are some important tables like AGR_AGRA, AGR Define, AGR OBJ, AGR_PROF, AGR_TCDTXT and so on.