SAP Table USRACL

SNC Access Control List (ACL): User

USRACL (SNC Access Control List (ACL): User) 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 USRACL to other SAP tables.

USRACL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BNAME User Name in User Master Record XUBNAME USR02 CHAR 12 0
SNC_SID Identification of the external security system SNC_SID CHAR 8 0
GUIFLAG Permit Password Logon for SAP GUI (User-Specific) SNC_GUIFLG CHAR 1 0
NULL Not Selected
X Selected
PNAME SNC: Printable name SNC_PNAME CHAR 255 0
HNAME SNC: Hash value for canonical names SNC_HNAME CHAR 32 0
CNAME User Name in User Master Record XUBNAME CHAR 12 0
CDATE Modification date XUMODDATE DATS 8 0
CTIME Modification time XUMODTIME TIMS 6 0
MNAME Last Changed By XUMODIFIER CHAR 12 0
MDATE Modification date XUMODDATE DATS 8 0
MTIME Modification time XUMODTIME TIMS 6 0
CHKVERSION INT1 3 0
CHKVAL RAW 16 0
RESERVE CHAR 8 0
KNAMELEN Length of an LCHR or LRAW field in the database LONG_LEN INT2 5 0
KNAME SNC: Canonical name SNC_KNAME LRAW 1024 0

USRACL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
USRACL BNAME USRACL MANDT USR02 Logon Data (Kernel-Side Use) MANDT
USRACL BNAME USRACL BNAME USR02 Logon Data (Kernel-Side Use) BNAME
USRACL MANDT USRACL MANDT T000 Clients MANDT