SAP ABAP Table VUSER001 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure VUSER001   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client  
2 BNAME XUBNAME XUBNAME CHAR 12   0   User Name in User Master Record  
3 STCOD XUSTCOD TCODE CHAR 20   0   Start menu (old, replaced by XUSTART)  
4 SPLD RSPOPNAME RSPOPNAME CHAR 4   0   Spool: Output device TSP03
5 SPLG XUSPLG XUSPLG CHAR 1   0   Print parameter 1  
6 SPDB XUSPDB XUSPDB CHAR 1   0   Print parameter 2  
7 SPDA XUSPDA XUSPDA CHAR 1   0   Print parameter 3  
8 DATFM XUDATFM XUDATFM CHAR 1   0   Date format  
9 DCPFM XUDCPFM XUDCPFM CHAR 1   0   Decimal Format  
10 HDEST XUHDEST XUHDEST CHAR 8   0   Host destination  
11 HMAND XUHMAND MANDT CLNT 3   0   Default host client  
12 HNAME XUHNAME BNAME CHAR 12   0   Default host user name  
13 MENON XUMENON XUMENON CHAR 1   0   Automatic Start  
14 MENUE XUMENUE XUMENUE CHAR 20   0   Menu name  
15 STRTT XUSTCOD TCODE CHAR 20   0   Start menu (old, replaced by XUSTART)  
16 LANGU XULANGU LANG LANG 1   0   Logon Language  
17 CATTKENNZ XUCATT XUBUTTON CHAR 1   0   CATT: Test Status  
18 BCODE XUCODE XUCODE RAW 8   0   Password Hash Key  
19 GLTGV XUGLTGV DATUM DATS 8   0   User valid from  
20 GLTGB XUGLTGB DATUM DATS 8   0   User valid to  
21 USTYP XUUSTYP XUUSTYP CHAR 1   0   User Type  
22 CLASS XUCLASS XUCLASS CHAR 12   0   User group in user master maintenance USGRP
23 LOCNT XULOCNT XULOCNT INT1 3   0   Number of failed logon attempts  
24 UFLAG XUUFLAG XUUFLAG INT1 3   0   User Lock Status  
25 ACCNT XUACCNT XUACCNT CHAR 12   0   Account ID  
26 ANAME XUANAME BNAME CHAR 12   0   Creator of the User Master Record  
27 ERDAT XUERDAT DATUM DATS 8   0   Creation Date of the User Master Record  
28 TRDAT XULDATE DATUM DATS 8   0   Last Logon Date  
29 LTIME XULTIME UZEIT TIMS 6   0   Last Logon Time  
30 OCOD1 XUCODE XUCODE RAW 8   0   Password Hash Key  
31 BCDA1 XUBCDAT DATUM DATS 8   0   Date of Last Password Change  
32 CODV1 XUCODEVERS XUCODEVERS CHAR 1   0   Code Version of Password Hash Algorithm (Old Systems)  
33 OCOD2 XUCODE XUCODE RAW 8   0   Password Hash Key  
34 BCDA2 XUBCDAT DATUM DATS 8   0   Date of Last Password Change  
35 CODV2 XUCODEVERS XUCODEVERS CHAR 1   0   Code Version of Password Hash Algorithm (Old Systems)  
36 OCOD3 XUCODE XUCODE RAW 8   0   Password Hash Key  
37 BCDA3 XUBCDAT DATUM DATS 8   0   Date of Last Password Change  
38 CODV3 XUCODEVERS XUCODEVERS CHAR 1   0   Code Version of Password Hash Algorithm (Old Systems)  
39 OCOD4 XUCODE XUCODE RAW 8   0   Password Hash Key  
40 BCDA4 XUBCDAT DATUM DATS 8   0   Date of Last Password Change  
41 CODV4 XUCODEVERS XUCODEVERS CHAR 1   0   Code Version of Password Hash Algorithm (Old Systems)  
42 OCOD5 XUCODE XUCODE RAW 8   0   Password Hash Key  
43 BCDA5 XUBCDAT DATUM DATS 8   0   Date of Last Password Change  
44 CODV5 XUCODEVERS XUCODEVERS CHAR 1   0   Code Version of Password Hash Algorithm (Old Systems)  
45 VERSN XUVERSION XUVERSION CHAR 3   0   User master record version  
46 CODVN XUCODEVER2 XUCODEVER2 CHAR 1   0   Code Version of Password Hash Algorithm (New Systems)  
47 NAME1 XUNAME1 XUNAME1 CHAR 30   0   Name of user within the company  
48 NAME2 XUNAME1 XUNAME1 CHAR 30   0   Name of user within the company  
49 NAME3 XUNAME1 XUNAME1 CHAR 30   0   Name of user within the company  
50 NAME4 XUNAME1 XUNAME1 CHAR 30   0   Name of user within the company  
51 SALUT XUSALUT XUSALUT CHAR 15   0   Form of address for letters  
52 ABTLG XUABTEI ABTEI CHAR 12   0   Department  
53 KOSTL XUKOSTL CHAR8 CHAR 8   0   Cost center  
54 BUINR XUBUINR XUBUINR CHAR 6   0   Building number  
55 ROONR XUROONR XUROONR CHAR 6   0   Room number  
56 STRAS XUSTRAS TEXT30 CHAR 30   0   Street and House Number  
57 PFACH XUPFACH XUPFACH CHAR 10   0   PO box  
58 PSTLZ XUPSTLZ XUPSTLZ CHAR 10   0   Postal code  
59 ORT01 XUORT01 TEXT25 CHAR 25   0   Location  
60 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
61 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
62 SPRAS XUSPRAS SPRAS LANG 1   0   Language Key T002
63 TELPR XUTELPR XUTELNR CHAR 16   0   Telephone number (private)  
64 TELNR XUTELNR XUTELNR CHAR 16   0   Telephone number (work)  
65 TEL01 XUTEL01 TEL01 CHAR 5   0   Telephone number  
66 TEL02 XUTEL01 TEL01 CHAR 5   0   Telephone number  
67 TELX1 XUTELX1 TEXT30 CHAR 30   0   Telex number  
68 TELFX XUTELFX TEXT31 CHAR 31   0   Fax Number  
69 TELTX XUTELTX TEXT30 CHAR 30   0   Teletex number  
70 ORT02 XUORT02 TEXT25 CHAR 25   0   Location  
71 PSTL2 XUPSTL2 XUPSTLZ CHAR 10   0   District Postal Code  
72 TZONE TZNZONE TZNZONE CHAR 6   0   Time Zone TTZZ
73 PROFILE XUPROFILE XUPROFILE CHAR 12   0   Profile name  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VUSER001 CLASS USGRP USERGROUP    
2 VUSER001 LAND1 T005 LAND1    
3 VUSER001 REGIO T005S BLAND    
4 VUSER001 SPLD TSP03 PADEST KEY 1 CN
5 VUSER001 SPRAS T002 SPRAS KEY 1 CN
6 VUSER001 TZONE TTZZ TZONE    
History
Last changed by/on SAP  20130604 
SAP Release Created in