SAP Table USR12
User Master Authorization Values
USR12 (User Master Authorization Values) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link USR12 to other SAP tables.
USR12 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||
| OBJCT | Authorization Object | XUOBJECT | TOBJ | CHAR | 10 | 0 | ||||||||
| AUTH | Authorization name in user master maintenance | XUAUTH | CHAR | 12 | 0 | |||||||||
| AKTPS | Active or maintenance version | XUAKTPAS | CHAR | 1 | 0 | |||||||||
| MODDA | Modification date | XUMODDATE | DATS | 8 | 0 | |||||||||
| MODTI | Modification time | XUMODTIME | TIMS | 6 | 0 | |||||||||
| MODBE | Last Changed By | XUMODIFIER | CHAR | 12 | 0 | |||||||||
| TYP | Type of Profile (Composite or Single) | XUTYP | CHAR | 1 | 0 |
Possible values
|
||||||||
| LNG | Length of value string in bytes | XULNG | INT2 | 5 | 0 | |||||||||
| VALS | Authorization values | XUVALS | LCHR | 3750 | 0 | |||||||||
USR12 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| USR12 | OBJCT | USR12 | OBJCT | TOBJ | Authorization Objects | OBJCT |
