SAP GRAC_S_API_ACC_REQ_TEMPLATE Structure for Access Request Template Table data and field list

GRAC_S_API_ACC_REQ_TEMPLATE 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 "Structure for Access Request Template" 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_ACC_REQ_TEMPLATE TYPE GRAC_S_API_ACC_REQ_TEMPLATE.

The GRAC_S_API_ACC_REQ_TEMPLATE table consists of various fields, each holding specific information or linking keys about Structure for Access Request Template data available in SAP. These include TEMPLATE_NAME (Template Name), TEMPLATE_DATA (), REQ_ID (Object ID), REQNO (Request Number)... 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_ACC_REQ_TEMPLATE structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP GRAC_S_API_ACC_REQ_TEMPLATE 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_ACC_REQ_TEMPLATE 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
TEMPLATE_ID	Template ID	GRAC_TEMPLATE_ID	CHAR	32			GRFN_GUID
TEMPLATE_NAME	Template Name	GRAC_TEMPLATE_NAME	CHAR	50			GRAC_TEMPLATE_NAME
TEMPLATE_DATA				0
REQ_ID	Object ID	GRFN_API_OBJECT_ID	CHAR	50			CHAR50
REQNO	Request Number	GRAC_REQNO	CHAR	20			GRAC_REQNO
REQ_CREATED	Request Creation Date	GRAC_REQ_CREATED	DATS	8			GRAC_DATE
REQ_APPROVED	Request Approval Due Date	GRAC_DUEDATE	DATS	8			GRAC_DATE
REQTYPE	Request Type	GRAC_REQTYPE	NUMC	3			GRAC_REQTYPE		GRAC_REQUEST_TYPE
PRIORITY	Request Priority	GRAC_PRIORITY	NUMC	3			GRAC_PRIORITY		GRAC_PRIORITY
BPROC	Business Process	GRAC_BPROC	CHAR	10			GRACBPROC
MSMP_PROCESS_ID	Process ID	GRFN_MW_PROCESS_ID	CHAR	30			GRFN_MW_PROCESS_ID		GRFNMW_PROCESS_SRCH_HLP
FUNCAREA	Functional Area	GRAC_FUNAREA	CHAR	10			GRAC_FUNAREA
REQ_COMPLETED	Request Completion Date	GRAC_REQ_COMPLETED	DATS	8			GRAC_DATE
BGJOBID	Background Job ID	GRAC_BGJOBID	CHAR	8			GRAC_BGJOBID
REQJUSTIFICATION	Request Justification	GRAC_REQJUSTIFICATION	CHAR	255			GRAC_LONG_DESCN
UPDATED_BY_ID	Field Last Updated by Username	GRAC_UPDATED_BY	CHAR	12			XUBNAME
UPDATED_BY_NAME	Updated By User Name	GRAC_UPDATED_BY_NAME	CHAR	80			TEXT80
UPDATED_ON	Changed on	GRAC_CHANGED_ON	DATS	8			GRFN_DATUM
EMPTYPE	Employee Type	GRAC_EMPTYPE	NUMC	3			GRAC_EMPTYPE		GRAC_EMPTYPE
STATUS	Request Status	GRAC_REQSTATUS	CHAR	2			GRAC_REQSTATUS
ON_HOLD_BY	User Name in User Master Record	XUBNAME	CHAR	12			XUBNAME	XUS
MSMP_APPROVAL_STATUS	Instance Approval Status	GRFN_MW_INSTANCE_APPROVAL_STAT	CHAR	10			GRFN_MW_INSTANCE_APPROVAL_STAT
TEMPLATE_ID	UUID of the GRC object (char32)	GRFN_GUID	CHAR	32			GRFN_GUID
REQ_INIT_SYS	System	GRAC_SYSTEM	CHAR	32			RFCDEST
SKIP_MSMP	Indicator	GRFN_BOOLEAN	CHAR	1			GRFN_BOOLEAN
SLA_ID	SLA ID	GRAC_SLA_ID	NUMC	3			GRAC_SLA_ID
REQOWNER				0
REQUSER				0
REQLINEITM				0
PROVLINEITM				0
HROMOBJECTS				0
SOD_REVLINEITEM				0
SOD_FUNCUSAGE				0
SOD_USERROLE				0
REQGROUPS				0
REQPARAM				0
REQSYS				0
EXT_RISK				0
BUSINESS_ROLES				0
EUP_ID	End User Personalization ID	GRAC_EUP_ID	NUMC	3			GRAC_EUP_ID		GRAC_EUP_ID
CATEGORY	Template Category	GRAC_TEMPLATE_CATEGORY	NUMC	1			GRAC_TEMPLATE_CATEGORY
DESCN	Long Description	GRAC_LONG_DESCN	CHAR	255			GRAC_LONG_DESCN
REQTYPE	Request Type	GRAC_REQTYPE	NUMC	3			GRAC_REQTYPE		GRAC_REQUEST_TYPE
CHGMODE	Operation Type	GRAC_OPERATION_TYPE	CHAR	1
CREATED_BY	Created by	GRAC_CREATED_BY	CHAR	12			UNAME
CREATED_ON	Date Created	GRAC_CREATED_ON	DATS	8			DATS

Key field

Non-key field

< GRAC_S_API_ACCESS_REQUEST - Access Request Structure for API Usage GRAC_S_API_ALERTS_MGMT - Alert Management Data >

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

As GRAC_S_API_ACC_REQ_TEMPLATE 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_ACC_REQ_TEMPLATE as there is no data to select.

How to access SAP table GRAC_S_API_ACC_REQ_TEMPLATE

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

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