SAP ABAP Table GRAC_S_API_ERM_REP (API structure for ERM reports)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC-AC (Application Component) Access Control
     ⤷ GRAC_ROLE_MANAGEMENT (Package) GRC ERM Support

Basic Data

Table Category	INTTAB	Structure
Structure	GRAC_S_API_ERM_REP	Table Relationship Diagram
Short Description	API structure for ERM reports

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	CONNECTOR	☐	GRFN_CONNECTORID	RFCDEST	CHAR	32	0	Connector Id	*
2	CONNECTOR_DESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
3	ACTION	☐	GRAC_ACTION	GRAC_ACTION	CHAR	50	0	Action
4	ACTIONDESC	☐	GRAC_LONG_DESCN	GRAC_LONG_DESCN	CHAR	255	0	Long Description
5	PROFILE	☐	GRAC_PROFILE	GRAC_PROFILE	CHAR	20	0	Profile Name
6	PROFILEDESCN	☐	GRAC_LONG_DESCN	GRAC_LONG_DESCN	CHAR	255	0	Long Description
7	ROLE_NAME	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
8	ROLEDESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
9	USEDFLAG	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
10	USERID	☐	GRAC_USER	GRAC_USER	CHAR	50	0	User ID
11	FULLNAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
12	EXEC_COUNT	☐	INT4	INT4	INT4	10	0	Natural number
13	EXECUTION_DATE	☐	GRFN_TIMESTAMP	GRFN_TIMESTAMP	DEC	15	0	Time Stamp
14	RISKID	☐	GRAC_SODRISK_ID	GRAC_SODRISK_ID	CHAR	8	0	Access Risk ID
15	DERIVED_ROLE	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
16	DERIVED_ROLE_DESC	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
17	ORGVALUE	☐	GRAC_ORG_VAL_MAP	GRAC_ORG_VAL_MAP	CHAR	50	0	Organization Value Mapping
18	FROMVAL	☐	GRAC_FROM_VAL	GRAC_AUTH_VAL	CHAR	50	0	From Value
19	TOVAL	☐	GRAC_TO_VAL	GRAC_AUTH_VAL	CHAR	50	0	To Value
20	ORG_LEVEL	☐	GRAC_ORG_LEVEL	GRAC_ORG_LEVEL	CHAR	50	0	Organization Level
21	DISCREPANCY	☐	GRAC_LONG_DESCN	GRAC_LONG_DESCN	CHAR	255	0	Long Description
22	ROLE_TYPE	☐	GRAC_SOD_ROLE_TYPE	GRAC_SOD_ROLE_TYPE	CHAR	1	0	Role Type for risk analysis
23	BZPRCID	☐	GRAC_BPROC	GRACBPROC	CHAR	10	0	Business Process	*
24	CONNECTOR_GRP	☐	GRFN_CONNECTORGRP	GRFN_CONNECTORGRP	CHAR	10	0	Connector Group	*
25	VALIDFROM	☐	GRAC_VALID_FROM	GRAC_DATE	DATS	8	0	Validity Start Date
26	VALIDTO	☐	GRAC_VALID_TO	GRAC_DATE	DATS	8	0	Validity End Date
27	EXPIREDROLE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
28	COMPROLE	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
29	CMPACTION	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
30	SINGLEROLE	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
31	USERGROUP	☐	GRAC_USER_GROUP	GRAC_USER_GROUP	CHAR	12	0	User group	*
32	RSTATUS	☐			CHAR	10	0
33	GEN_DATETIME	☐	GRFN_TIMESTAMP	GRFN_TIMESTAMP	DEC	15	0	Time Stamp
34	GEN_BY	☐	GRAC_USER	GRAC_USER	CHAR	50	0	User ID
35	STARTDT	☐	GRAC_VALID_FROM	GRAC_DATE	DATS	8	0	Validity Start Date
36	STARTIM	☐	UZEIT	UZEIT	TIMS	6	0	Time
37	ENDDT	☐	GRAC_VALID_TO	GRAC_DATE	DATS	8	0	Validity End Date
38	ENDTIM	☐	UZEIT	UZEIT	TIMS	6	0	Time
39	CHANGEBY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
40	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
41	LANGUAGE	☐	GRAC_LOGON_LANGU	GRAC_LANG	LANG	1	0	Logon Language	*
42	OLD_VALUE	☐	GRAC_OLD_VALUE	GRAC_OLD_VALUE	CHAR	254	0	Old Value
43	NEW_VALUE	☐	GRAC_NEW_VALUE	GRAC_NEW_VALUE	CHAR	254	0	New Value
44	UDATE	☐	DATUM	DATUM	DATS	8	0	Date
45	UTIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
46	CONNGRP_DESCN	☐	GRAC_CONNGRP_TEXT	GRFN_CONNECTORGRPT	CHAR	40	0	Connector Group
47	RLTYPE_DESCN	☐	GRAC_RLTYPE_DESCN	GRAC_DESCN	CHAR	132	0	Role Type
48	BPDESCN	☐	GRAC_BPROC_DESCN	GRAC_DESCN	CHAR	132	0	Business process
49	CHILD_ROLE_NAME	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
50	CHILD_ROLE_DESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
51	BSUBPROC_DESCN	☐	GRAC_BSUBPROC_T	GRAC_DESCN	CHAR	132	0	Subprocess
52	CRITLVL_DESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
53	OWNER	☐	GRAC_IS_OWNER	GRFN_BOOLEAN	CHAR	1	0	Role Owner
54	APPRVR	☐	GRAC_APPRVR	GRFN_BOOLEAN	CHAR	1	0	Assignment Approver
55	APPROVER	☐	GRAC_APPROVER	XUBNAME	CHAR	12	0	Role approver	*
56	ALT_APPROVER	☐	GRAC_ALTAPPROVER	XUBNAME	CHAR	12	0	Alternate approver	*
57	ALT_APP_NAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
58	APPLICATION_TYPE	☐	GRAC_APPL_TYPE	GRAC_APPL_TYPE	CHAR	10	0	Application Type	*
59	BSUBPROC	☐	GRAC_BSUBPROC	GRAC_BSUBPROC	CHAR	10	0	Subprocess	*

History

Last changed by/on	SAP	20141106
SAP Release Created in	600