SAP ABAP Table GRAC_S_USER_DETAIL (User Details)
Hierarchy
☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC-AC (Application Component) Access Control
     ⤷ GRAC_ADAPTORS (Package) Access Control GRC Calls for Plag-in's and WSDL
Basic Data
Table Category INTTAB    Structure 
Structure GRAC_S_USER_DETAIL   Table Relationship Diagram
Short Description User Details    
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 PARAMETER0 GRAC_T_USER_PARAMETER   TTYP 0   0    
2 PROFILES GRAC_T_USER_PROFILES   TTYP 0   0    
3 ROLES GRAC_T_USER_ROLE   TTYP 0   0    
4 ADDTEL GRAC_T_USER_ADDTEL   TTYP 0   0    
5 ADDFAX GRAC_T_USER_ADDFAX   TTYP 0   0    
6 ADDTTX GRAC_T_USER_ADDTTX   TTYP 0   0    
7 ADDTLX GRAC_T_USER_ADDTLX   TTYP 0   0    
8 ADDSMTP GRAC_T_USER_ADDSMTP   TTYP 0   0    
9 ADDRML GRAC_T_USER_ADRML   TTYP 0   0    
10 ADDX400 GRAC_T_USER_ADX400   TTYP 0   0    
11 ADDRFC GRAC_T_USER_ADDRFC   TTYP 0   0    
12 ADDPRT GRAC_T_USER_ADPRT   TTYP 0   0    
13 ADDSSF GRAC_T_USER_ADSSF   TTYP 0   0    
14 ADDURI GRAC_T_USER_ADURI   TTYP 0   0    
15 ADDPAG GRAC_T_USER_ADPAG   TTYP 0   0    
16 ADDCOMREM GRAC_T_USER_ADDCOMREM   TTYP 0   0    
17 PARAMETER1 GRAC_T_USER_PARAMETER1   TTYP 0   0    
18 GROUPS GRAC_T_USER_GROUPS   TTYP 0   0    
19 UCLASSSYS GRAC_T_USER_UCLASSSYS   TTYP 0   0    
20 EXTIDHEAD GRAC_T_USER_EXTIDHEAD   TTYP 0   0    
21 EXTIDPART GRAC_T_USER_EXTIDPART   TTYP 0   0    
22 SYSTEMS GRAC_T_USER_SYSTEMS   TTYP 0   0    
23 LOGONDATA GRAC_S_USER_LOGONDATA   STRU 0   0    
24 GLTGV XUGLTGV DATUM DATS 8   0   User valid from  
25 GLTGB XUGLTGB DATUM DATS 8   0   User valid to  
26 USTYP XUUSTYP XUUSTYP CHAR 1   0   User Type  
27 CLASS XUCLASS XUCLASS CHAR 12   0   User group in user master maintenance  
28 ACCNT XUACCNT XUACCNT CHAR 12   0   Account ID  
29 TZONE TZNZONE TZNZONE CHAR 6   0   Time Zone  
30 LTIME XULTIME UZEIT TIMS 6   0   Last Logon Time  
31 BCODE XUCODE XUCODE RAW 8   0   Password Hash Key  
32 CODVN XUCODEVERS XUCODEVERS CHAR 1   0   Code Version of Password Hash Algorithm (Old Systems)  
33 PASSCODE PWD_SHA1 SHA1_HASH RAW 20   0   Password Hash Value (SHA1, 160 Bit)  
34 CODVC XUCODEVER2 XUCODEVER2 CHAR 1   0   Code Version of Password Hash Algorithm (New Systems)  
35 KOSTL XUKOSTL CHAR8 CHAR 8   0   Cost center  
36 DEFAULTS GRAC_S_USER_DEFAULTS   STRU 0   0    
37 STCOD XUSTCOD TCODE CHAR 20   0   Start menu (old, replaced by XUSTART)  
38 SPLD RSPOPNAME RSPOPNAME CHAR 4   0   Spool: Output device  
39 SPLG XUSPLG XUSPLG CHAR 1   0   Print parameter 1  
40 SPDB XUSPDB XUSPDB CHAR 1   0   Print parameter 2  
41 SPDA XUSPDA XUSPDA CHAR 1   0   Print parameter 3  
42 DATFM XUDATFM XUDATFM CHAR 1   0   Date format  
43 DCPFM XUDCPFM XUDCPFM CHAR 1   0   Decimal Format  
44 LANGU XULANGU LANG LANG 1   0   Logon Language  
45 CATTKENNZ XUCATT XUBUTTON CHAR 1   0   CATT: Test Status  
46 KOSTL XUKOSTL CHAR8 CHAR 8   0   Cost center  
47 START_MENU XUSTART SYCHAR30 CHAR 30   0   Start menu  
48 ADDRESS GRAC_S_USER_ADDRESS   STRU 0   0    
49 PERS_NO AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number  
50 ADDR_NO AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
51 TITLE_P AD_TITLETX TEXT30 CHAR 30   0   Title text  
52 FIRSTNAME AD_NAMEFIR TEXT40 CHAR 40   0   First name  
53 LASTNAME AD_NAMELAS TEXT40 CHAR 40   0   Last name  
54 BIRTH_NAME AD_NAME2_P TEXT40 CHAR 40   0   Name of person at birth  
55 MIDDLENAME AD_NAMEMID TEXT40 CHAR 40   0   Middle name or second forename of a person  
56 SECONDNAME AD_NAMLAS2 TEXT40 CHAR 40   0   Second surname of a person  
57 FULLNAME AD_NAMTEXT TEXT80 CHAR 80   0   Full Name of Person  
58 FULLNAME_X AD_NAMCONV AD_NAMCONV CHAR 1   0   Status of Field 'Full Name' NAME_TEXT  
59 TITLE_ACA1 AD_TITLE1T TEXT20 CHAR 20   0   Academic Title: Written Form  
60 TITLE_ACA2 AD_TITLE2T TEXT20 CHAR 20   0   2nd academic title: written form  
61 PREFIX1 AD_PREFIXT TEXT20 CHAR 20   0   Name prefix  
62 PREFIX2 AD_PREFX2T TEXT20 CHAR 20   0   2nd name prefix  
63 TITLE_SPPL AD_TITLEST TEXT20 CHAR 20   0   Name supplement, e.g. noble title (written form)  
64 NICKNAME AD_NICKNAM TEXT40 CHAR 40   0   Nickname or name used  
65 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
66 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format  
67 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule  
68 LANGU_P SPRAS SPRAS LANG 1   0   Language Key  
69 LANGUP_ISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
70 SORT1_P AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
71 SORT2_P AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
72 DEPARTMENT AD_DPRTMNT TEXT40 CHAR 40   0   Department  
73 FUNCTION AD_FNCTN TEXT40 CHAR 40   0   Function  
74 BUILDING_P AD_BLDNG_P TEXT10 CHAR 10   0   Building (number or code)  
75 FLOOR_P AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
76 ROOM_NO_P AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
77 INITS_SIG AD_ID_CODE TEXT10 CHAR 10   0   Short name for correspondence  
78 INHOUSE_ML AD_IH_MAIL TEXT10 CHAR 10   0   Int. mail postal code  
79 COMM_TYPE AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services)  
80 TITLE AD_TITLETX TEXT30 CHAR 30   0   Title text  
81 NAME AD_NAME1 TEXT40 CHAR 40   0   Name 1  
82 NAME_2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
83 NAME_3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
84 NAME_4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
85 C_O_NAME AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
86 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
87 DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
88 CITY_NO AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file  
89 DISTRCT_NO AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file  
90 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
91 POSTL_COD1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
92 POSTL_COD2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
93 POSTL_COD3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
94 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
95 PO_BOX_CIT AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
96 PBOXCIT_NO AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file)  
97 DELIV_DIS AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
98 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered  
99 STREET AD_STREET TEXT60 CHAR 60   0   Street  
100 STREET_NO AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File  
101 STR_ABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name  
102 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
103 HOUSE_NO2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
104 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
105 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
106 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
107 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
108 BUILDING AD_BLD_OLD TEXT10 CHAR 10   0   old: building (no. or abbreviation)  
109 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
110 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
111 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key  
112 COUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
113 LANGU SPRAS SPRAS LANG 1   0   Language Key  
114 LANGU_ISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
115 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County)  
116 SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
117 SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
118 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone  
119 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
120 ADR_NOTES AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
121 TEL1_NUMBR AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
122 TEL1_EXT AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
123 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
124 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
125 E_MAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
126 BUILD_LONG AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
127 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping  
128 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
129 HOMECITYNO AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file  
130 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
131 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
132 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
133 PO_W_O_NO AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
134 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...)  
135 POBOX_CTRY AD_POBXCTY LAND1 CHAR 3   0   PO box country  
136 PO_CTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
137 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag  
138 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag  
139 HOUSE_NO3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
140 LANGU_CR_P AD_LANGUCR SPRAS LANG 1   0   Address record creation original language  
141 LANGUCPISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
142 SAP_USER_ID GRAC_USER GRAC_USER CHAR 50   0   User ID  
143 COMPANY GRAC_S_USER_COMPANY   STRU 0   0    
144 COMPANY USCOMP USCOMP CHAR 42   0   Company address, cross-system key  
145 SNC GRAC_S_USER_SNC   STRU 0   0    
146 GUIFLAG SNC_GUIFLG CHAR1_X CHAR 1   0   Permit Password Logon for SAP GUI (User-Specific)  
147 PNAME SNC_PNAME SNC_PNAME CHAR 255   0   SNC: Printable name  
148 REF_USER GRAC_S_USER_REF_USER   STRU 0   0    
149 REF_USER XUBNAME XUBNAME CHAR 12   0   User Name in User Master Record  
150 ALIAS0 GRAC_S_USER_ALIAS   STRU 0   0    
151 USERALIAS USALIAS USALIAS CHAR 40   0   Internet user alias  
152 UCLASS GRAC_S_USER_UCLASS   STRU 0   0    
153 LIC_TYPE USERTYPEN USERTYP CHAR 2   0   ID for the User Types of the SAP System  
154 SPEC_VERS VERSIONZU VERSIONZU CHAR 2   0   Assignment to special version  
155 COUNTRY_SURCHARGE USMM_DEC3 USMM_DEC3 DEC 3   0   System Measurement: Country Surcharge (3 Characters)  
156 SUBSTITUTE_FROM XVONDAT DATUM DATS 8   0   Substitute 'from date'  
157 SUBSTITUTE_UNTIL XBISDAT DATUM DATS 8   0   Substitute 'to date'  
158 SYSID SYSYSID SYCHAR08 CHAR 8   0   Name of SAP System  
159 CLIENT MANDT MANDT CLNT 3   0   Client  
160 BNAME_CHARGEABLE XANAME XUBNAME CHAR 12   0   Chargeable User  
161 LASTMODIFIED GRAC_S_USER_LASTMODIFIED   STRU 0   0    
162 MODDATE XUMODDATE DATUM DATS 8   0   Modification date  
163 MODTIME XUMODTIME UZEIT TIMS 6   0   Modification time  
164 ISLOCKED GRAC_S_USER_ISLOCKED   STRU 0   0    
165 WRNG_LOGON BAPIUSLOCK BAPIUSLOCK CHAR 1   0   Status of User Lock  
166 LOCAL_LOCK BAPIUSLOCK BAPIUSLOCK CHAR 1   0   Status of User Lock  
167 GLOB_LOCK BAPIUSLOCK BAPIUSLOCK CHAR 1   0   Status of User Lock  
168 NO_USER_PW BAPIUSLOCK BAPIUSLOCK CHAR 1   0   Status of User Lock  
169 MANAGER_ID GRAC_USER GRAC_USER CHAR 50   0   User ID  
170 ISHRDATA GRAC_S_HR_DATA   STRU 0   0    
171 BNAME XUBNAME XUBNAME CHAR 12   0   User Name in User Master Record  
172 PERNR NUM8 NUM8 NUMC 8   0   Eight-digit numeric value  
173 NAME_FIRST CHAR25 CHAR25 CHAR 25   0   User field for cluster PC (national)  
174 NAME_LAST CHAR25 CHAR25 CHAR 25   0   User field for cluster PC (national)  
175 EMAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
176 NATIONALITY NATIONAL LAND1 CHAR 3   0   Country Key for Country-Specific Infotype  
177 PERS_AREA PERSA PERSA CHAR 4   0   Personnel Area  
178 STELEPHONE SYSID CHAR30 CHAR 30   0   Communication Identification/Number  
179 TELEPHONE SYSID CHAR30 CHAR 30   0   Communication Identification/Number  
180 FAX SYSID CHAR30 CHAR 30   0   Communication Identification/Number  
181 VALID_FROM BEGDA DATUM DATS 8   0   Start Date  
182 VALID_TO ENDDA DATUM DATS 8   0   End Date  
183 COST_CENTER KOSTL KOSTL CHAR 10   0   Cost Center  
184 ORG_UNIT HROBJID HROBJID NUMC 8   0   Object ID  
185 ORG_DESC STEXT TEXT40 CHAR 40   0   Object Name  
186 POSITION HROBJID HROBJID NUMC 8   0   Object ID  
187 JOB HROBJID HROBJID NUMC 8   0   Object ID  
188 EMP_GROUP CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
189 BUS_AREA BUKRS BUKRS CHAR 4   0   Company Code  
190 COMP_CODE BUKRS BUKRS CHAR 4   0   Company Code  
191 PERS_AREA_DESC PBTXT TEXT30 CHAR 30   0   Personnel Area Text  
192 MPERNR NUM8 NUM8 NUMC 8   0   Eight-digit numeric value  
193 MBNAME XUBNAME XUBNAME CHAR 12   0   User Name in User Master Record  
194 MFNAME AD_NAMEFIR TEXT40 CHAR 40   0   First name  
195 MLNAME AD_NAMELAS TEXT40 CHAR 40   0   Last name  
196 MEMAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
197 MSTELEPHONE SYSID CHAR30 CHAR 30   0   Communication Identification/Number  
198 MTELEPHONE SYSID CHAR30 CHAR 30   0   Communication Identification/Number  
199 SPRAS LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
200 IS_CUSTOM_FIELD GRAC_S_CUSTOM_FIELD   STRU 0   0    
201 .INCLUDE       0   0    
202 CUSTOM_FIELD GRAC_BOOLEAN GRFN_BOOLEAN CHAR 1   0   Boolean  
203 IS_ADDITIONAL_DATA GRAC_S_USER_ADDITIONAL_DETAIL   STRU 0   0    
204 BUSINESS_AREA GRAC_FUNAREA GRAC_FUNAREA CHAR 10   0   Functional Area  
205 BUSS_PROC GRAC_BPROC GRACBPROC CHAR 10   0   Business Process  
206 EMPLOYEE_TYPE GRAC_EMPTYPE GRAC_EMPTYPE NUMC 3   0   Employee Type  
207 FUNCTIONAL_AREA GRAC_FUNAREA GRAC_FUNAREA CHAR 10   0   Functional Area  
208 JOB GRAC_EMPJOB GRAC_EMPJOB CHAR 12   0   Job  
209 MANAGERID GRAC_USER GRAC_USER CHAR 50   0   User ID  
210 MANAGER_EMAIL GRAC_EMAIL GRAC_EMAIL CHAR 255   0   E-Mail Address  
211 MANAGER_FIRSTNAME GRAC_FNAME GRAC_FNAME CHAR 100   0   First Name  
212 MANAGER_LASTNAME GRAC_LNAME GRAC_LNAME CHAR 100   0   Last Name  
213 MANAGER_TELEPHONE GRAC_TELNUMBER GRAC_TELNUMBER CHAR 32   0   Telephone Number  
214 ORGUNIT GRAC_ORGUNIT GRAC_ORGUNIT CHAR 12   0   Org Unit  
215 PERSONNEL_NUMBER GRAC_PERSONNELNO GRAC_PERSONNELNO CHAR 20   0   Personnel Number  
216 POSITION GRAC_POSITION GRAC_POSITION NUMC 3   0   Position  
217 REQREASON GRAC_REQJUSTIFICATION GRAC_LONG_DESCN CHAR 255   0   Request Justification  
218 REQUESTORID GRFN_API_OBJECT_ID CHAR50 CHAR 50   0   Object ID  
219 REQUESTOR_EMAIL GRAC_EMAIL GRAC_EMAIL CHAR 255   0   E-Mail Address  
220 REQUESTOR_FIRSTNAME GRAC_FNAME GRAC_FNAME CHAR 100   0   First Name  
221 REQUESTOR_LASTNAME GRAC_LNAME GRAC_LNAME CHAR 100   0   Last Name  
222 REQUESTOR_TELEPHONE GRAC_TELNUMBER GRAC_TELNUMBER CHAR 32   0   Telephone Number  
223 REQUEST_CATEGORY GRAC_CATEGORY GRAC_CATEGORY CHAR 1   0   Connection Category  
224 UNSECURE_SNCLOGON CHAR10 CHAR10 CHAR 10   0   Character Field Length = 10  
History
Last changed by/on SAP  20141106 
SAP Release Created in 600