AGR1251 Authorization data for the activity group AGR1252 Organizational elements for authorizations AGRAGRS Roles in Composite Roles. Table: AGR1251; Role: Z. Object: STCODE; Copy data into another worksheet (role data) In a new column concatenate the role name and transaction using the ‘&’ operator. Also add a new column next to the above with just ‘X’ – This will be the value placed in the matrix. AGR1252 is a standard SAP Table which is used to store Organizational elements for authorizations data and is available within R/3 SAP systems depending on the version and release level. Below is the standard documentation available and a few details of the fields which make up this Table. AGR1251 Authorization data for the activity group; AGR1252 Organizational elements for authorizations. ADR6 E-mail addresses of sap user; Other Tables.

USR Tables:

• USR01 User master record (run time data)
• USR02 Logon data (Kernel-side use)
• USR03 User address data
• USR04 User master authorizations
• USR05 User master parameter ID
• USR06 Additional data per user
• USR06SYS System Specific User classification
• USR07 Object/value of last authorization check
• USR08 Table for user menu entries
• USR09 Entries for user menu (work areas)
• USR10 User master authorization profiles
• USR11 User master texts for authorization profiles(USR10)
• USR12 User master authorization values
• USR13 Short texts for authorizations
• USR14 Sur-chargeable Language Versions per user
• USR15
• USR16 Values for variable for user authorizations
• USR20 Date of last user master reorganization
• USR21 Assign user name address key
• USR40 Table for illegal passwords
• USR41 User master additional data
• USRVAR Variants for critical authorizations
• USH02 Change history for Logon data
• USGRP User groups
• USER_ADDR Address data for users
• USOBT Relation transaction to authorization object(SAP)
• USOBX Check table for USOBT
• USOBT_C Relation transaction to authorization object(Customer)
• USOBX_C Check table for USOBT_C

AGR Tables (Related to roles):

• AGR_1250 Authorization data for the activity group
• AGR_1251 Authorization data for the activity group
• AGR_1252 Organizational elements for authorizations
• AGR_USERS Assignment of roles to users
• AGR_TCODES Assignment of roles to t-codes
• AGR_AGRS Roles in the composite roles
• AGR_DEFINE Role definition/single and derived roles
• AGR_1016 Name of the activity group profile
• AGR_PROF Profile name for role
• AGR_OBJ Assignment of Menu nodes to role
• AGR_TIME Time stamp for role (including profile)

Developer Key Table:

• DEVACCESS Table for development users – developer keys

Transport Requests:

• E070 Change & transport system: Header of requests/tasks
• E071 System: Object entries of requests/tasks

Email id for users:

• ADR6 E-mail addresses of sap user

Other Tables:

• TDDAT Table authorization group to Table relation
• TBRG Table authorization groups
• TRDIR Program to authorization group relation
• T000 List of defined clients
• TSTC List of t-codes
• TPARA List of parameter ids
• TOBJ Authorization objects
• TACT Available activities in SAP system
• RFCDES Remote function call destinations
• DBTABLOG Log records of table changes

Symptom

You notice that when adding given authorization value to some of the fields in the authorization data of your role, this value is replaced by another one. Here's an example, showing the authorization values range added to a role for authorization field V_VBAK_AAT-AUART, and these very values stored within table AGR_1251 (Authorization data for role). You'll see the difference highlighted in red:

Read more...

Agr_1251 Table In Sap Stand

Environment

Product

Keywords

To Value, TO_VALUE, SPRAS, Wrong, Error, Incorrect, Bug, Auth.value, Auth.field, Fld, AUART_SPR, Konvertierungsexit, Tabelle, CONVERSION_EXIT_AUART_OUTPUT, SUSR_FIELD_CONVERT, SAPLSUSC, SUPRN_CONVERT_VALUES, SAPLSUPRN, SUPRN_MAINTAIN_VALUES, PFLEGEN_BER SAPLSUPRN, AUTHORITY-CHECK , KBA , BC-SEC-AUT-PFC , ABAP Authorization and Role Administration , SD-SLS-GF , Basic Functions , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Agr_1251 Table In Sap Table

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.