SAP GRAC_S_API_ERM_REP API structure for ERM reports Table data and field list

GRAC_S_API_ERM_REP 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 "API structure for ERM reports" 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_ERM_REP TYPE GRAC_S_API_ERM_REP.

The GRAC_S_API_ERM_REP table consists of various fields, each holding specific information or linking keys about API structure for ERM reports data available in SAP. These include CONNECTOR_DESCN (Description), ACTION (Action), ACTIONDESC (Long Description), PROFILE (Profile 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. .

GRAC_S_API_ERM_REP 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_ERM_REP 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_ERM_REP 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
CONNECTOR	Connector Id	GRFN_CONNECTORID	CHAR	32	Assigned to domain		RFCDEST
CONNECTOR_DESCN	Description	GRAC_DESCN	CHAR	132			GRAC_DESCN
ACTION	Action	GRAC_ACTION	CHAR	50			GRAC_ACTION
ACTIONDESC	Long Description	GRAC_LONG_DESCN	CHAR	255			GRAC_LONG_DESCN
PROFILE	Profile Name	GRAC_PROFILE	CHAR	20			GRAC_PROFILE
PROFILEDESCN	Long Description	GRAC_LONG_DESCN	CHAR	255			GRAC_LONG_DESCN
ROLE_NAME	Role Name	GRAC_ROLE_NAME	CHAR	300			GRAC_ROLE_NAME
ROLEDESCN	Description	GRAC_DESCN	CHAR	132			GRAC_DESCN
USEDFLAG	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
USERID	User ID	GRAC_USER	CHAR	50			GRAC_USER
FULLNAME	Full Name of Person	AD_NAMTEXT	CHAR	80			TEXT80
EXEC_COUNT	Natural Number	INT4	INT4	10			INT4
EXECUTION_DATE	Time Stamp	GRFN_TIMESTAMP	DEC	15		TSTPS	GRFN_TIMESTAMP
RISKID	Access Risk ID	GRAC_SODRISK_ID	CHAR	8			GRAC_SODRISK_ID
DERIVED_ROLE	Role Name	GRAC_ROLE_NAME	CHAR	300			GRAC_ROLE_NAME
DERIVED_ROLE_DESC	Description	GRAC_DESCN	CHAR	132			GRAC_DESCN
ORGVALUE	Organization Value Mapping	GRAC_ORG_VAL_MAP	CHAR	50			GRAC_ORG_VAL_MAP
FROMVAL	From Value	GRAC_FROM_VAL	CHAR	50			GRAC_AUTH_VAL
TOVAL	To Value	GRAC_TO_VAL	CHAR	50			GRAC_AUTH_VAL
ORG_LEVEL	Organization Level	GRAC_ORG_LEVEL	CHAR	50			GRAC_ORG_LEVEL
DISCREPANCY	Long Description	GRAC_LONG_DESCN	CHAR	255			GRAC_LONG_DESCN
ROLE_TYPE	Role Type for risk analysis	GRAC_SOD_ROLE_TYPE	CHAR	1			GRAC_SOD_ROLE_TYPE
BZPRCID	Business Process	GRAC_BPROC	CHAR	10	Assigned to domain		GRACBPROC
CONNECTOR_GRP	Connector Group	GRFN_CONNECTORGRP	CHAR	10	Assigned to domain		GRFN_CONNECTORGRP
VALIDFROM	Validity Start Date	GRAC_VALID_FROM	DATS	8			GRAC_DATE
VALIDTO	Validity End Date	GRAC_VALID_TO	DATS	8			GRAC_DATE
EXPIREDROLE	Character Field Length = 10	CHAR10	CHAR	10			CHAR10
COMPROLE	Role Name	GRAC_ROLE_NAME	CHAR	300			GRAC_ROLE_NAME
CMPACTION	Character Field Length = 10	CHAR10	CHAR	10			CHAR10
SINGLEROLE	Role Name	GRAC_ROLE_NAME	CHAR	300			GRAC_ROLE_NAME
USERGROUP	User group	GRAC_USER_GROUP	CHAR	12	Assigned to domain		GRAC_USER_GROUP
RSTATUS	Role Status			0
GEN_DATETIME	Time Stamp	GRFN_TIMESTAMP	DEC	15		TSTPS	GRFN_TIMESTAMP
GEN_BY	User ID	GRAC_USER	CHAR	50			GRAC_USER
STARTDT	Validity Start Date	GRAC_VALID_FROM	DATS	8			GRAC_DATE
STARTIM	Time	UZEIT	TIMS	6			UZEIT
ENDDT	Validity End Date	GRAC_VALID_TO	DATS	8			GRAC_DATE
ENDTIM	Time	UZEIT	TIMS	6			UZEIT
CHANGEBY	User Name in User Master Record	XUBNAME	CHAR	12	Assigned to domain		XUBNAME	XUS
TCODE	Transaction Code	TCODE	CHAR	20	Assigned to domain		TCODE	TCD
LANGUAGE	Logon Language	GRAC_LOGON_LANGU	LANG	1	Assigned to domain	ISOLA	GRAC_LANG
OLD_VALUE	Old Value	GRAC_OLD_VALUE	CHAR	254			GRAC_OLD_VALUE
NEW_VALUE	New Value	GRAC_NEW_VALUE	CHAR	254			GRAC_NEW_VALUE
UDATE	Date	DATUM	DATS	8			DATUM
UTIME	Time	UZEIT	TIMS	6			UZEIT
CONNGRP_DESCN	Connector Group	GRAC_CONNGRP_TEXT	CHAR	40			GRFN_CONNECTORGRPT
RLTYPE_DESCN	Role Type	GRAC_RLTYPE_DESCN	CHAR	132			GRAC_DESCN
BPDESCN	Business process	GRAC_BPROC_DESCN	CHAR	132			GRAC_DESCN
CHILD_ROLE_NAME	Role Name	GRAC_ROLE_NAME	CHAR	300			GRAC_ROLE_NAME
CHILD_ROLE_DESCN	Description	GRAC_DESCN	CHAR	132			GRAC_DESCN
BSUBPROC_DESCN	Subprocess	GRAC_BSUBPROC_T	CHAR	132			GRAC_DESCN
CRITLVL_DESCN	Description	GRAC_DESCN	CHAR	132			GRAC_DESCN
OWNER	Role Owner	GRAC_IS_OWNER	CHAR	1			GRFN_BOOLEAN
APPRVR	Assignment Approver	GRAC_APPRVR	CHAR	1			GRFN_BOOLEAN
APPROVER	Role approver	GRAC_APPROVER	CHAR	12	Assigned to domain		XUBNAME
ALT_APPROVER	Alternate approver	GRAC_ALTAPPROVER	CHAR	12	Assigned to domain		XUBNAME
ALT_APP_NAME	Full Name of Person	AD_NAMTEXT	CHAR	80			TEXT80
APPLICATION_TYPE	Application Type	GRAC_APPL_TYPE	CHAR	10	Assigned to domain		GRAC_APPL_TYPE		GRAC_APPL_TYPE
BSUBPROC	Subprocess	GRAC_BSUBPROC	CHAR	10	Assigned to domain		GRAC_BSUBPROC

Key field

Non-key field

< GRAC_S_API_CUSTOMFIELD_VALUE - The customer defined fields GRAC_S_API_EXIT_SERVICE - IDM inbound services Exit Service >

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

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

How to access SAP table GRAC_S_API_ERM_REP

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

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