SAP table USR12 (User Master Authorization Values)

SAP table USR12 has 4 primary key fields being MANDT,OBJCT,AUTH,AKTPS.

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 CLNT 3 0 * MANDT
OBJCT Authorization Object CHAR 10 0 TOBJ XUOBJECT
AUTH Authorization name in user master maintenance CHAR 12 0 XUAUTH
AKTPS Active or maintenance version CHAR 1 0 XUAKTPAS
MODDA Modification date DATS 8 0 XUMODDATE
MODTI Modification time TIMS 6 0 XUMODTIME
MODBE Last Changed By CHAR 12 0 XUMODIFIER
TYP Type of Profile (Composite or Single) CHAR 1 0 XUTYP
C Composite Profile
G Generates Profile
S Single profile
LNG Length of value string in bytes INT2 5 0 XULNG
VALS Authorization values LCHR 3750 0 XUVALS

USR12 foreign key relationships

Table Field Check Table Check Field
0 USR12 OBJCT TOBJ Authorization Objects OBJCT