SAP GRACUSER User Table Table data and field list

GRACUSER is a standard SAP Table which is used to store User Table data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The GRACUSER table consists of various fields, each holding specific information or linking keys about User Table data available in SAP. These include CONNECTOR (Connector Id), USER_ID (User ID), FIRST_NAME (User name), LAST_NAME (User name)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

GRACUSER table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP GRACUSER table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the GRACUSER table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
CONNECTOR	Connector Id	GRFN_CONNECTORID	CHAR	32	Assigned to domain		RFCDEST
USER_ID	User ID	GRAC_USER	CHAR	50			GRAC_USER
FIRST_NAME	User name	GRAC_USER_NAME	CHAR	50			GRAC_USER_NAME
LAST_NAME	User name	GRAC_USER_NAME	CHAR	50			GRAC_USER_NAME
EMAIL	E-Mail Address	AD_SMTPADR	CHAR	241		SXIDN	AD_SMTPADR
PHONE	Phone Number	GRAC_PHONE_NUMBER	CHAR	20			GRAC_PHONE_NUMBER
DEPARTMENT	Department	GRAC_DEPARTMENT	CHAR	100			GRAC_DEPARTMENT
UPDATED_ON	Time Stamp	GRFN_TIMESTAMP	DEC	15		TSTPS	GRFN_TIMESTAMP
MANAGER_ID	User ID	GRAC_USER	CHAR	50			GRAC_USER
EXCLUDED	Boolean Variable (X=True, -=False, Space=Unknown)	BOOLEAN	CHAR	1			BOOLEAN
PERSONNELNO	Personnel Number	GRAC_PERSONNELNO	CHAR	20			GRAC_PERSONNELNO
USER_HR_FNAME	User name	GRAC_USER_NAME	CHAR	50			GRAC_USER_NAME
USER_HR_LNAME	User name	GRAC_USER_NAME	CHAR	50			GRAC_USER_NAME
USER_HR_EMAIL	E-Mail Address	AD_SMTPADR	CHAR	241		SXIDN	AD_SMTPADR
FNAME_SH	User name	GRAC_USER_NAME	CHAR	50			GRAC_USER_NAME
LNAME_SH	User name	GRAC_USER_NAME	CHAR	50			GRAC_USER_NAME
EMAIL_SH	E-Mail Address	AD_SMTPADR	CHAR	241		SXIDN	AD_SMTPADR
USER_ID_SH	User ID Upper case only	GRAC_USER_UP	CHAR	50			GRAC_USER_UP

Key field

Non-key field

< GRACTASKEXECSTMP - Executed background jobs Table GRACUSERACTVL - User Action Violation Table >

How do I retrieve data from SAP table GRACUSER using ABAP code

The following ABAP code Example will allow you to do a basic selection on GRACUSER to SELECT all data from the table
DATA: WA_GRACUSER TYPE GRACUSER.

SELECT SINGLE *
FROM GRACUSER
INTO CORRESPONDING FIELDS OF WA_GRACUSER
WHERE...

How to access SAP table GRACUSER

Within an ECC or HANA version of SAP you can also view further information about GRACUSER and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).