SAP Table USRACLEXT

Extended SNC Access Control List (ACL) for Users

USRACLEXT (Extended SNC Access Control List (ACL) for Users) 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 USRACLEXT to other SAP tables.

USRACLEXT 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
SEQNO Numc3, internal use NUMC3 NUMC 3 0
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

USRACLEXT foreign key relationships

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