SAP Table USR01

User master record (runtime data)

USR01 (User master record (runtime data)) 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 USR01 to other SAP tables.

USR01 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BNAME User Name in User Master Record XUBNAME CHAR 12 0
STCOD Start menu (old, replaced by XUSTART) XUSTCOD CHAR 20 0
SPLD Spool: Output device RSPOPNAME TSP03 CHAR 4 0
SPLG Print parameter 1 XUSPLG CHAR 1 0
SPDB Print parameter 2 XUSPDB CHAR 1 0
SPDA Print parameter 3 XUSPDA CHAR 1 0
DATFM Date format XUDATFM CHAR 1 0
1 DD.MM.YYYY
2 MM/DD/YYYY
3 MM-DD-YYYY
4 YYYY.MM.DD
5 YYYY/MM/DD
6 YYYY-MM-DD
7 GYY.MM.DD (Japanese Date)
8 GYY/MM/DD (Japanese Date)
9 GYY-MM-DD (Japanese Date)
A YYYY/MM/DD (Islamic Date 1)
B YYYY/MM/DD (Islamic Date 2)
C YYYY/MM/DD (Iranian Date)
DCPFM Decimal Format XUDCPFM CHAR 1 0
NULL 1.234.567,89
X 1,234,567.89
Y 1 234 567,89
HDEST Host destination XUHDEST CHAR 8 0
HMAND Default host client XUHMAND CLNT 3 0
HNAME Default host user name XUHNAME CHAR 12 0
MENON Automatic Start XUMENON CHAR 1 0
MENUE Menu name XUMENUE CHAR 20 0
STRTT Start menu (old, replaced by XUSTART) XUSTCOD CHAR 20 0
LANGU Logon Language XULANGU LANG 1 0
CATTKENNZ CATT: Test Status XUCATT CHAR 1 0
X
NULL
.
TIMEFM Time Format (12-/24-Hour Specification) XUTIMEFM CHAR 1 0
0 24 Hour Format (Example: 12:05:10)
1 12 Hour Format (Example: 12:05:10 PM)
2 12 Hour Format (Example: 12:05:10 pm)
3 Hours from 0 to 11 (Example: 00:05:10 PM)
4 Hours from 0 to 11 (Example: 00:05:10 pm)

USR01 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
USR01 SPLD USR01 SPLD TSP03 Spool: Printer declaration PADEST