SAP table USR01 (User master record (runtime data))

SAP table USR01 has 2 primary key fields being MANDT,BNAME.

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 * MANDT
BNAME User Name in User Master Record CHAR 12 0 * XUBNAME
STCOD Start menu (old, replaced by XUSTART) CHAR 20 0 * XUSTCOD
SPLD Spool: Output device CHAR 4 0 TSP03 RSPOPNAME
SPLG Print parameter 1 CHAR 1 0 XUSPLG
SPDB Print parameter 2 CHAR 1 0 XUSPDB
SPDA Print parameter 3 CHAR 1 0 XUSPDA
DATFM Date format CHAR 1 0 XUDATFM
1 DD.MM.YYYY (Gregorian Date)
2 MM/DD/YYYY (Gregorian Date)
3 MM-DD-YYYY (Gregorian Date)
4 YYYY.MM.DD (Gregorian Date)
5 YYYY/MM/DD (Gregorian Date)
6 YYYY-MM-DD (Gregorian Date, ISO 8601)
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 CHAR 1 0 XUDCPFM
1.234.567,89
X 1,234,567.89
Y 1 234 567,89
HDEST Host destination CHAR 8 0 XUHDEST
HMAND Default host client CLNT 3 0 * XUHMAND
HNAME Default host user name CHAR 12 0 XUHNAME
MENON Automatic Start CHAR 1 0 XUMENON
MENUE Menu name CHAR 20 0 XUMENUE
STRTT Start menu (old, replaced by XUSTART) CHAR 20 0 * XUSTCOD
LANGU Logon Language LANG 1 0 XULANGU
CATTKENNZ CATT: Test Status CHAR 1 0 XUCATT
TIMEFM Time Format (12-/24-Hour Specification) CHAR 1 0 XUTIMEFM
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 Check Table Check Field
0 USR01 SPLD TSP03 Spool: Printer declaration PADEST