1. Home
  2. Resources
  3. SAP Tables
  4. USER001 - User Data Relevant at Runtime

SAP Table USER001

User Data Relevant at Runtime

USER001 (User Data Relevant at Runtime) 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 USER001 to other SAP tables.

USER001 table fields

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

USER001 foreign key relationships

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