SAP table USRACL (SNC Access Control List (ACL): User)
SAP table USRACL has 3 primary key fields being MANDT,BNAME,SNC_SID.
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 | T000 | MANDT | |
| BNAME | User Name in User Master Record | CHAR | 12 | 0 | USR02 | XUBNAME | |
| SNC_SID | Identification of the external security system | CHAR | 8 | 0 | SNC_SID | ||
| GUIFLAG | Allow password logon for SAP GUI (user-specific) | CHAR | 1 | 0 | SNC_GUIFLG | ||
| PNAME | SNC: Printable name | CHAR | 255 | 0 | SNC_PNAME | ||
| HNAME | SNC: Hash value for canonical names | CHAR | 32 | 0 | SNC_HNAME | ||
| CNAME | User Name in User Master Record | CHAR | 12 | 0 | * | XUBNAME | |
| CDATE | Modification date | DATS | 8 | 0 | XUMODDATE | ||
| CTIME | Modification time | TIMS | 6 | 0 | XUMODTIME | ||
| MNAME | Last Changed By | CHAR | 12 | 0 | XUMODIFIER | ||
| MDATE | Modification date | DATS | 8 | 0 | XUMODDATE | ||
| MTIME | Modification time | TIMS | 6 | 0 | XUMODTIME | ||
| CHKVERSION | INT1 | 3 | 0 | ||||
| CHKVAL | RAW | 16 | 0 | ||||
| RESERVE | CHAR | 8 | 0 | ||||
| KNAMELEN | Length of an LCHR or LRAW field in the database | INT2 | 5 | 0 | LONG_LEN | ||
| KNAME | SNC: Canonical name | LRAW | 1024 | 0 | SNC_KNAME |
USRACL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 USRACL | BNAME | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| 1 USRACL | MANDT | T000 | Clients | MANDT |