SAP ABAP Table GRAC_SOD_ACCESS_RULE (Access rule report)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC-AC (Application Component) Access Control
     ⤷ GRAC_SOD (Package) Access Control GRC SoD Rules and etc.

Basic Data

Table Category	APPEND	Append structure
Append structure	GRAC_SOD_ACCESS_RULE	Table Relationship Diagram
Short Description	Access rule report

Delivery and Maintenance

Pool/cluster	GRFN_S_RP_ATTR
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	RISKID	☐	GRAC_SODRISK_ID	GRAC_SODRISK_ID	CHAR	8	0	Access Risk ID
2	RULESETID	☐	GRAC_RULESET_ID	GRAC_RULESET_ID	CHAR	8	0	Rule Set ID
3	DESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
4	ACTION	☐	GRAC_ACTION	GRAC_ACTION	CHAR	50	0	Action
5	ACTIONDESC	☐	GRAC_LONG_DESCN	GRAC_LONG_DESCN	CHAR	255	0	Long Description
6	ACTRULEID	☐	GRAC_ACTRULE_ID	GRAC_ACTRULE_ID	CHAR	4	0	SOD Rule ID
7	BZPRCID	☐	GRAC_BPROC	GRACBPROC	CHAR	10	0	Business Process	*
8	RESOURCEEXTN	☐	GRAC_RESOURCE_EXTN	GRAC_RESOURCE_EXTN	CHAR	50	0	Resource Extension
9	FSTAT	☐	GRAC_IS_ORG_LVL	GRFN_BOOLEAN	CHAR	1	0	Org Level Field
10	FUNCTID	☐	GRAC_FUNCT_ID	GRAC_FUNCT_ID	CHAR	8	0	Function Id
11	RESOURCEID	☐	GRAC_SOD_RESOURCE	GRAC_SOD_RESOURCE	CHAR	100	0	SOD Resource
12	RISKLEVEL	☐	GRAC_SODRISK_LEVEL	GRAC_SODRISK_LEVEL	NUMC	1	0	SOD Risk Level	*
13	RISKTYPE	☐	GRAC_SODRISK_TYPE	GRAC_SODRISK_TYPE	NUMC	1	0	Access Risk Type
14	STATUS	☐	GRAC_ACTIVE	GRAC_ACTIVE	CHAR	1	0	Active indicator
15	DETAIL_DESCN	☐	GRAC_DETAIL_DESCN	GRAC_DETAIL_DESCN	STRG	0	0	Detail Description
16	BPDESCN	☐	GRAC_BPROC_DESCN	GRAC_DESCN	CHAR	132	0	Business process
17	RISKOWNEREXTN	☐			STRG	0	0
18	RISKOWNER	☐	GRAC_OWNER	XUBNAME	CHAR	12	0	Owner Description	*
19	ACTIVE	☐	GRAC_ACTIVE	GRAC_ACTIVE	CHAR	1	0	Active indicator
20	FROMVAL	☐	GRAC_FROM_VAL	GRAC_AUTH_VAL	CHAR	50	0	From Value
21	TOVAL	☐	GRAC_TO_VAL	GRAC_AUTH_VAL	CHAR	50	0	To Value
22	SEARCHTYPE	☐	GRAC_SEARCH_TYPE	GRAC_LOGIC_OPER	CHAR	3	0	Search Type
23	CONTROL_OBJ	☐	GRAC_DETAIL_DESCN	GRAC_DETAIL_DESCN	STRG	0	0	Detail Description
24	REPTYPE	☐	GRAC_SOD_REPTYPE	GRAC_SOD_REPTYPE	NUMC	2	0	Report Type
25	CUSTOMGROUP	☐	GRAC_SOD_GROUP	GRAC_SOD_GROUP	CHAR	50	0	SOD Group
26	ORGRULEID	☐	GRAC_ORGRULE_ID	GRAC_ORGRULE_ID	CHAR	10	0	Orgrule Id
27	MANAGERID	☐	GRAC_MANAGER_ID	GRAC_USER	CHAR	50	0	Manager ID
28	USERTYPE	☐	GRAC_SOD_USER_TYPE	GRAC_SOD_USER_TYPE	CHAR	1	0	User Type
29	ROLEID	☐	GRAC_ROLEID	GRFN_GUID	CHAR	32	0	Role ID
30	PROFILE	☐	GRAC_PROFILE	GRAC_PROFILE	CHAR	20	0	Profile Name
31	ROLE_TYPE	☐	GRAC_SOD_ROLE_TYPE	GRAC_SOD_ROLE_TYPE	CHAR	1	0	Role Type for risk analysis
32	OBJECTID	☐	GRAC_MITIGATION_OBJ		CHAR	50	0	Generic mitigation object
33	OBJECTTYPE	☐	GRAC_HROBJECT_TYPE	GRAC_HROBJECT_TYPE	INT1	3	0	HR Object Type
34	ORG_LEVEL	☐	GRAC_ORG_LEVEL	GRAC_ORG_LEVEL	CHAR	50	0	Organization Level
35	ORGVALUE	☐	GRAC_ORG_VAL_MAP	GRAC_ORG_VAL_MAP	CHAR	50	0	Organization Value Mapping
36	ACCONTROLID	☐	GRAC_CONTROL_ID	GRAC_CONTROL_ID	CHAR	10	0	SOD Control ID
37	ORGUNITID	☐	GRPC_API_OBJECT_ID	GRPC_API_OBJECT_ID	CHAR	50	0	GRPC ID of the individual object
38	DESCR	☐	GRPC_TEXT	GRPC_TEXT	CHAR	100	0	Text
39	MNG_APPR	☐	GRAC_OWNER	XUBNAME	CHAR	12	0	Owner Description	*
40	MONITOR	☐	GRAC_OWNER	XUBNAME	CHAR	12	0	Owner Description	*
41	FULLNAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
42	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
43	FREQUENCY	☐	GRAC_FREQUENCY	INT2	INT2	5	0	AC Frequency
44	ACTIONDATE	☐	GRAC_DATE	GRAC_DATE	DATS	8	0	Date Description
45	ACTIONBY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
46	ROLE_NAME	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
47	USEDFLAG	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
48	USERID	☐	GRAC_USER	GRAC_USER	CHAR	50	0	User ID
49	USERGROUP	☐	GRAC_USER_GROUP	GRAC_USER_GROUP	CHAR	12	0	User group	*
50	PROFILEDESCN	☐	GRAC_LONG_DESCN	GRAC_LONG_DESCN	CHAR	255	0	Long Description
51	ROLEDESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
52	ACTIONTYPE	☐	GRAC_ACTIONTYPE	GRAC_ACTIONTYPE	NUMC	3	0	Action Type
53	VALIDFROM	☐	GRAC_VALID_FROM	GRAC_DATE	DATS	8	0	Validity Start Date
54	VALIDTO	☐	GRAC_VALID_TO	GRAC_DATE	DATS	8	0	Validity End Date
55	CONNECTOR	☐	GRFN_CONNECTORID	RFCDEST	CHAR	32	0	Connector Id	*
56	PNAME	☐	PROGNAME	PROGNAME	CHAR	40	0	ABAP Program Name
57	IPNAME	☐	PROGNAME	PROGNAME	CHAR	40	0	ABAP Program Name
58	LINENUM	☐			NUMC	10	0
59	ROLE_STATUS	☐	GRAC_ROLE_STATUS	GRAC_ROLE_STATUS	CHAR	3	0	Role Status	*
60	BSUBPROC	☐	GRAC_BSUBPROC	GRAC_BSUBPROC	CHAR	10	0	Subprocess	*
61	CONN_TYPE	☐	GRAC_CONNECTORTYPE	GRFN_CONNECTTYPE	CHAR	8	0	Connector Type
62	PRJREL	☐	GRAC_PRJ_REL	GRAC_PRJ_REL	CHAR	10	0	Project Release	*
63	FUNC_AREA	☐	GRAC_FUNAREA	GRAC_FUNAREA	CHAR	10	0	Functional Area	*
64	ROLEOWNER	☐	GRAC_ROLE_OWNER	XUBNAME	CHAR	12	0	Role Owner	*
65	ROLEAPPROVER	☐	GRAC_ROLE_APPROVER	XUBNAME	CHAR	12	0	Role Approver	*
66	ORGVALUEFROM	☐	GRAC_ORG_VAL	GRAC_AUTH_VAL	CHAR	50	0	Organizational Field Value
67	ORGVALUETO	☐	GRAC_ORG_VAL	GRAC_AUTH_VAL	CHAR	50	0	Organizational Field Value
68	CURRENT_STEP	☐	GRAC_SEQUENCE	GRAC_SEQUENCE	NUMC	4	0	Sequence
69	CRITLVL	☐	GRAC_CRITLVL	GRAC_CRITLVL	CHAR	3	0	Critical Level	*
70	PHASE	☐	GRAC_MTH_ACTION	GRAC_MTH_ACTION	NUMC	3	0	Methodology Action
71	DERIVED_ROLE	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
72	DERIVED_ROLE_DESC	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
73	ROLECLASS	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
74	DISCREPANCY	☐	GRAC_LONG_DESCN	GRAC_LONG_DESCN	CHAR	255	0	Long Description
75	CONNECTOR_GRP	☐	GRFN_CONNECTORGRP	GRFN_CONNECTORGRP	CHAR	10	0	Connector Group	*
76	EXPDROL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
77	EXPIROL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
78	DDASROL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
79	EXPDATE	☐	GRAC_DATE	GRAC_DATE	DATS	8	0	Date Description
80	RSTATUS	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
81	EXPIREDROLE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
82	EXPIRINGROLE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
83	ASSIGNEDROLE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
84	MAXHITS	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
85	SOURCETYPE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
86	TARGETTYPE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
87	SOURCEVALUE	☐	GRAC_USER	GRAC_USER	CHAR	50	0	User ID
88	TARGETVALUE	☐	GRAC_USER	GRAC_USER	CHAR	50	0	User ID
89	COMPROLE	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
90	CHANGEDOC	☐	GRAC_CHGDOCS	GRAC_CHGDOCS	CHAR	132	0	Change Documents
91	OLD_VALUE	☐	GRAC_OLD_VALUE	GRAC_OLD_VALUE	CHAR	254	0	Old Value
92	NEW_VALUE	☐	GRAC_NEW_VALUE	GRAC_NEW_VALUE	CHAR	254	0	New Value
93	LANGUAGE	☐	GRAC_LOGON_LANGU	GRAC_LANG	LANG	1	0	Logon Language	*
94	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
95	CMPACTION	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
96	SINGLEROLE	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
97	GEN_DATE	☐	GRAC_DATE	GRAC_DATE	DATS	8	0	Date Description
98	GEN_BY	☐	GRAC_USER	GRAC_USER	CHAR	50	0	User ID
99	GEN_DATETIME	☐	GRAC_TIMESTAMP	TZNTSTMPS	DEC	15	0	Time Stamp
100	AUTH_COUNT	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
101	ACTION_TYPE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
102	STARTDT	☐	GRAC_VALID_FROM	GRAC_DATE	DATS	8	0	Validity Start Date
103	STARTIM	☐	UZEIT	UZEIT	TIMS	6	0	Time
104	ENDDT	☐	GRAC_VALID_TO	GRAC_DATE	DATS	8	0	Validity End Date
105	ENDTIM	☐	UZEIT	UZEIT	TIMS	6	0	Time
106	CHANGEBY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
107	CONNGRP_DESCN	☐	GRAC_CONNGRP_TEXT	GRFN_CONNECTORGRPT	CHAR	40	0	Connector Group
108	RLTYPE_DESCN	☐	GRAC_RLTYPE_DESCN	GRAC_DESCN	CHAR	132	0	Role Type
109	CHILD_ROLE_NAME	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
110	CHILD_ROLE_DESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
111	CONNECTOR_DESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
112	BSUBPROC_DESCN	☐	GRAC_BSUBPROC_T	GRAC_DESCN	CHAR	132	0	Subprocess
113	CRITLVL_DESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
114	OWNER	☐	GRAC_IS_OWNER	GRFN_BOOLEAN	CHAR	1	0	Role Owner
115	APPRVR	☐	GRAC_APPRVR	GRFN_BOOLEAN	CHAR	1	0	Assignment Approver
116	APPROVER	☐	GRAC_APPROVER	XUBNAME	CHAR	12	0	Role approver	*
117	ALT_APPROVER	☐	GRAC_ALTAPPROVER	XUBNAME	CHAR	12	0	Alternate approver	*
118	OBJECTTYPEDESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
119	ALT_APP_NAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
120	APPLICATION_TYPE	☐	GRAC_APPL_TYPE	GRAC_APPL_TYPE	CHAR	10	0	Application Type	*
121	STATUSDESCN	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
122	RISKDESC	☐	GRAC_DESCN	GRAC_DESCN	CHAR	132	0	Description
123	ASSOC_RLNAME	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
124	CERTIFY_PERIOD	☐	GRAC_CERTIFY_PERIOD	GRAC_NUMBER	NUMC	5	0	Certification period
125	CAN_BE_FF	☐	GRAC_CAN_BE_FF	GRFN_BOOLEAN	CHAR	1	0	Can be Firefighter Role
126	CERTIFY_DUE	☐	GRAC_CERTIFY_DATE	GRFN_DATUM	DATS	8	0	Cerfified Date
127	CERTIFY_DATE	☐	GRAC_CERTIFY_DATE	GRFN_DATUM	DATS	8	0	Cerfified Date
128	REAFF_DUE	☐	GRAC_REAFF_DATE	GRFN_DATUM	DATS	8	0	Reaffirm Date
129	REAFF_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
130	REAFF_PERIOD	☐	GRAC_REAF_PERIOD	GRAC_NUMBER	NUMC	5	0	Reaffirm Period
131	SENSITIVITY	☐	GRAC_SENSITIVITY	GRAC_SENSITIVITY	NUMC	3	0	Role Sensitivity	*
132	COMPANY	☐	GRAC_ROLE_COMPANY	GRAC_ROLE_COMPANY	CHAR	10	0	Company
133	AGR_NAME	☐	AGR_NAME	AGR_NAME	CHAR	30	0	Role Name	*
134	GEN_DAT	☐	DATUM	DATUM	DATS	8	0	Date
135	GEN_TIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
136	BNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
137	REASON	☐	CHAR250_D	CHAR250	CHAR	250	0	Data field
138	USERROLEFLAG	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
139	CONNECTORID	☐	CHAR250_D	CHAR250	CHAR	250	0	Data field

History

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