SAP table AGR_1251 (Authorization data for the activity group)

SAP table AGR_1251 has 3 primary key fields being MANDT,AGR_NAME,COUNTER.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client ID CLNT 3 0 T000 SYMANDT
AGR_NAME Role Name CHAR 30 0 AGR_DEFINE AGR_NAME
COUNTER Menu ID for BIW NUMC 6 0 MENU_NUM_6
OBJECT Auth. Object in User Master Maintenance CHAR 10 0 * AGOBJECT
AUTH Authorization name in user master maintenance CHAR 12 0 * AGAUTH
VARIANT Variants for Profile Generator CHAR 4 0 TPR_VARI
FIELD Field name of an authorization CHAR 10 0 AGRFIELD
LOW Authorization value CHAR 40 0 * AGVAL
HIGH Authorization value CHAR 40 0 * AGVAL
MODIFIED Object status CHAR 1 0 TPR_ST_MOD
? ???
G Maintained
M Modified
S Standard
U Manual
DELETED ID whether object is deleted CHAR 1 0 TPR_ST_DEL
COPIED ID whether object is copied CHAR 1 0 TPR_ST_COP
NEU ID whether object is new CHAR 1 0 TPR_ST_NEW
N Object - new
O Object - old
NODE Internal: Node ID NUMC 6 0 SEU_ID

AGR_1251 foreign key relationships

Table Field Check Table Check Field
0 AGR_1251 AGR_NAME AGR_DEFINE Role definition MANDT
0 AGR_1251 AGR_NAME AGR_DEFINE Role definition AGR_NAME
1 AGR_1251 MANDT T000 Clients MANDT