SAP table USER001 (User Data Relevant at Runtime)

Field Description Data Type Length Decimals Checktable Data Element
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
PARID Set/Get parameter ID CHAR 20 0 TPARA MEMORYID
PARVA Parameter value CHAR 40 0 XUVALUE
BCODE Password Hash Key RAW 8 0 XUCODE
GLTGV User valid from DATS 8 0 XUGLTGV
GLTGB User valid to DATS 8 0 XUGLTGB
USTYP User Type CHAR 1 0 XUUSTYP
A Dialog
B System
C Communications Data
L Reference (Logon not possible)
S Service
CLASS User group in user master maintenance CHAR 12 0 USGRP XUCLASS
LOCNT Number of failed logon attempts INT1 3 0 XULOCNT
UFLAG User Lock Status INT1 3 0 XUUFLAG
0 Not Locked
128 Locked Due To Incorrect Logons (Limited Term)
32 Locked Globally By Administrator
64 Locked Locally By Administrator
ACCNT Account ID CHAR 12 0 XUACCNT
ANAME Creator of the User Master Record CHAR 12 0 XUANAME
ERDAT Creation Date of the User Master Record DATS 8 0 XUERDAT
TRDAT Last Logon Date DATS 8 0 XULDATE
LTIME Last Logon Time TIMS 6 0 XULTIME
OCOD1 Password Hash Key RAW 8 0 XUCODE
BCDA1 Date of Last Password Change DATS 8 0 XUBCDAT
CODV1 Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
OCOD2 Password Hash Key RAW 8 0 XUCODE
BCDA2 Date of Last Password Change DATS 8 0 XUBCDAT
CODV2 Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
OCOD3 Password Hash Key RAW 8 0 XUCODE
BCDA3 Date of Last Password Change DATS 8 0 XUBCDAT
CODV3 Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
OCOD4 Password Hash Key RAW 8 0 XUCODE
BCDA4 Date of Last Password Change DATS 8 0 XUBCDAT
CODV4 Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
OCOD5 Password Hash Key RAW 8 0 XUCODE
BCDA5 Date of Last Password Change DATS 8 0 XUBCDAT
CODV5 Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
VERSN User master record version CHAR 3 0 XUVERSION
CODVN Code Version of Password Hash Algorithm (Old Systems) CHAR 1 0 XUCODEVERS
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
X Password Deactivated
NAME1 Name of user within the company CHAR 30 0 XUNAME1
NAME2 Name of user within the company CHAR 30 0 XUNAME1
NAME3 Name of user within the company CHAR 30 0 XUNAME1
NAME4 Name of user within the company CHAR 30 0 XUNAME1
SALUT Form of address for letters CHAR 15 0 XUSALUT
ABTLG Department CHAR 12 0 XUABTEI
KOSTL Cost center CHAR 8 0 XUKOSTL
BUINR Building number CHAR 6 0 XUBUINR
ROONR Room number CHAR 6 0 XUROONR
STRAS Street and House Number CHAR 30 0 XUSTRAS
PFACH PO box CHAR 10 0 XUPFACH
PSTLZ Postal code CHAR 10 0 XUPSTLZ
ORT01 Location CHAR 25 0 XUORT01
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
SPRAS Language Key LANG 1 0 T002 XUSPRAS
TELPR Telephone number (private) CHAR 16 0 XUTELPR
TELNR Telephone number (work) CHAR 16 0 XUTELNR
TEL01 Telephone number CHAR 5 0 XUTEL01
TEL02 Telephone number CHAR 5 0 XUTEL01
TELX1 Telex number CHAR 30 0 XUTELX1
TELFX Fax Number CHAR 31 0 XUTELFX
TELTX Teletex number CHAR 30 0 XUTELTX
ORT02 Location CHAR 25 0 XUORT02
PSTL2 District Postal Code CHAR 10 0 XUPSTL2
TZONE Time Zone CHAR 6 0 TTZZ TZNZONE
PROFILE Profile name CHAR 12 0 * XUPROFILE

USER001 foreign key relationships

Table Field Check Table Check Field
0 USER001 CLASS USGRP User Groups MANDT
0 USER001 CLASS USGRP User Groups USERGROUP
1 USER001 LAND1 T005 Countries MANDT
1 USER001 LAND1 T005 Countries LAND1
0 USER001 PARID TPARA Directory of Memory IDs PARAMID
1 USER001 REGIO T005S Taxes: Region (Province) Key LAND1
0 USER001 SPLD TSP03 Spool: Printer declaration PADEST
1 USER001 SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 USER001 TZONE TTZZ Time zones TZONE