SAP GRAC_S_API_USER_INFO User information Table data and field list

GRAC_S_API_USER_INFO is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "User information" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_GRAC_S_API_USER_INFO TYPE GRAC_S_API_USER_INFO.

The GRAC_S_API_USER_INFO table consists of various fields, each holding specific information or linking keys about User information data available in SAP. These include USERID (User ID), FNAME (First Name), LNAME (Last Name), PROVUSER (User ID)... 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. .

GRAC_S_API_USER_INFO structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP GRAC_S_API_USER_INFO structure 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 GRAC_S_API_USER_INFO 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
REQ_ID	Object ID	GRFN_API_OBJECT_ID	CHAR	50			CHAR50
USERID	User ID	GRAC_USER	CHAR	50			GRAC_USER
FNAME	First Name	GRAC_FNAME	CHAR	100			GRAC_FNAME
LNAME	Last Name	GRAC_LNAME	CHAR	100			GRAC_LNAME
PROVUSER	User ID	GRAC_PROVUSER	CHAR	50			GRAC_USER
SNC_NAME	SNC Name	GRAC_SNC_NAME	CHAR	255			GRAC_SNC_NAME
UNSEC_SNC	Unsecure Logon Allowed (SNC)	GRAC_UNSEC_SNC	CHAR	1			GRFN_BOOLEAN
ACCNO	Accounting Number	GRAC_ACCNO	CHAR	12			GRAC_ACCNO
VALID_FROM	Validity Start Date	GRAC_VALID_FROM	DATS	8			GRAC_DATE
VALID_TO	Validity End Date	GRAC_VALID_TO	DATS	8			GRAC_DATE
EMPPOSITION	HR Position	GRAC_EMPPOSITION	CHAR	12			GRAC_EMPPOSITION
EMPJOB	Job	GRAC_EMPJOB	CHAR	12			GRAC_EMPJOB
PERSONNELNO	Personnel Number	GRAC_PERSONNELNO	CHAR	20			GRAC_PERSONNELNO
PERSONNELAREA	Personnel Area	GRAC_PERSONNEL_AREA	CHAR	60			GRAC_PERSONNEL_AREA
EMAIL	E-Mail Address	GRAC_EMAIL	CHAR	255			GRAC_EMAIL
TELNUMBER	Telephone Number	GRAC_TELNUMBER	CHAR	32			GRAC_TELNUMBER
DEPARTMENT	Department	GRAC_DEPARTMENT	CHAR	100			GRAC_DEPARTMENT
COMPANY	Company	GRAC_COMPANY	CHAR	42			GRAC_COMPANY		GRAC_FDT_COMPANY
LOCATION	Location	GRAC_LOCATION	CHAR	100			GRAC_LOCATION
COSTCENTER	Cost Center	GRAC_COSTCENTER	CHAR	40			GRAC_COSTCENTER
PRINTER	Printer	GRAC_PRINTER	CHAR	200			GRAC_PRINTER
SECTELNUMBER	Telephone Number	GRAC_SECTELNUMBER	CHAR	32			GRAC_TELNUMBER
ORGUNIT	Org Unit	GRAC_ORGUNIT	CHAR	12			GRAC_ORGUNIT
EMPTYPE	Employee Type	GRAC_EMPTYPE	NUMC	3			GRAC_EMPTYPE		GRAC_EMPTYPE
FULLNAME	Full Name of the User	GRAC_FULLNAME	CHAR	80			GRAC_FULLNAME
BUSS_PROC	Business Process	GRAC_BPROC	CHAR	10	Assigned to domain		GRACBPROC
BUSINESS_AREA	Functional Area	GRAC_FUNAREA	CHAR	10	Assigned to domain		GRAC_FUNAREA
FUNCTIONAL_AREA	Functional Area	GRAC_FUNAREA	CHAR	10	Assigned to domain		GRAC_FUNAREA
BUILDING	Building	GRAC_BUILDING	CHAR	10			TEXT10
FLOOR	Floor	GRAC_FLOOR	CHAR	10			TEXT10
ROOM_NO	Room Number	GRAC_ROOMNO	CHAR	10			TEXT10
COMM_TYPE	Communication Type	GRAC_COMM_TYPE	CHAR	3	Assigned to domain		AD_COMM
ACADEMIC_TITLE	Academic Title	GRAC_ACA_TITLE	CHAR	20			TEXT20
USERALIAS	User Alias	GRAC_USER_ALIAS	CHAR	40			USALIAS
USER_TYPE	User Type	GRAC_USTYPE	CHAR	1			GRAC_USTYPE
TEL_EXTENSION	Telephone Number: Extension	GRAC_EXTENSION	CHAR	10			CHAR10
FAX_NUMBER	Fax Number	GRAC_FAXNUMBER	CHAR	30			GRAC_FAXNUMBER
USER_DEFAULT_ID	User Default ID	GRAC_USER_DEFAULT_ID	NUMC	3			GRAC_USER_DEFAULT_ID
START_MENU	Start Menu	GRAC_START_MENU	CHAR	30			SYCHAR30
LOGON_LANGU	Logon Language	GRAC_LOGON_LANGU	LANG	1	Assigned to domain	ISOLA	GRAC_LANG
DEC_NOTATION	Decimal Notations	GRAC_DEC_NOTATION	CHAR	1			XUDCPFM
DATE_FORMAT	Date Format	GRAC_DATE_FORMAT	CHAR	1			XUDATFM
TIME_ZONE	Time Zone	GRAC_TIME_ZONE	CHAR	6			GRAC_TZNZONE
MANAGER	User ID	GRAC_USER	CHAR	50			GRAC_USER
FUNCTION	Function field for su01 provisioning	GRAC_FUNCTION_SU01	CHAR	40	Assigned to domain		GRAC_FUNCTION

Key field

Non-key field

< GRAC_S_API_USER_ANAL_MGMT - User Analysis Management Dashboard Data GRAC_S_API_USER_MITIGATION - User mitigations API structure >

How do I retrieve data from SAP structure GRAC_S_API_USER_INFO using ABAP code?

As GRAC_S_API_USER_INFO is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on GRAC_S_API_USER_INFO as there is no data to select.

How to access SAP table GRAC_S_API_USER_INFO

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

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