SAP ABAP Table GRAC_S_SEARCH_PARAM_REPT (Access Request search parameters for reports)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC-AC (Application Component) Access Control
     ⤷ GRAC_ACCESS_REQUEST (Package) Access Control GRC Access Request

Basic Data

Table Category	INTTAB	Structure
Structure	GRAC_S_SEARCH_PARAM_REPT	Table Relationship Diagram
Short Description	Access Request search parameters for 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	REQ_ID	☐	GRFN_GUID	GRFN_GUID	CHAR	32	0	UUID of the GRC object (char32)
2	PROCESS_ID	☐	GRFN_MW_PROCESS_ID	GRFN_MW_PROCESS_ID	CHAR	30	0	Process ID	*
3	WORKFLOW_TYPE	☐	GRAC_WORKFLOW_TYPE	GRAC_WORKFLOW_TYPE	CHAR	3	0	Workflow types used in access review
4	ARCHIEVED_REQUEST	☐	GRAC_ARCHIEVED_REQUEST	GRAC_ARCHIEVED_REQUEST	CHAR	1	0	Archieved Request
5	SLA_ID	☐	GRAC_SLA_ID	GRAC_SLA_ID	NUMC	3	0	SLA ID	*
6	REQNO	☐	GRFN_MW_EXT_KEY_DISPLAY	GRFN_MW_EXT_KEY_DISPLAY	CHAR	50	0	External Key for Display
7	REQ_CREATED	☐	GRAC_REQ_CREATED	GRAC_DATE	DATS	8	0	Request Creation Date
8	DUEDATE	☐	GRAC_DUEDATE	GRAC_DATE	DATS	8	0	Request Approval Due Date
9	REQTYPE	☐	GRAC_REQTYPE	GRAC_REQTYPE	NUMC	3	0	Request Type
10	BPROC	☐	GRAC_BPROC	GRACBPROC	CHAR	10	0	Business Process	*
11	ESCALATED	☐	GRAC_ESCALATED	GRAC_ESCALATED	CHAR	3	0	Escalated Assignment
12	FUNCAREA	☐	GRAC_FUNAREA	GRAC_FUNAREA	CHAR	10	0	Functional Area	*
13	REQ_COMPLETED	☐	GRAC_REQ_COMPLETED	GRAC_DATE	DATS	8	0	Request Completion Date
14	BGJOBID	☐	BTCJOB	CHAR32	CHAR	32	0	Background job name
15	BGJOBCNT	☐	BTCJOBCNT	CHAR8	CHAR	8	0	Job ID
16	REQUESTOR_ID	☐	GRAC_REQUESTOR_ID	GRAC_USER	CHAR	50	0	Requested By
17	CREATOR_ID	☐	GRAC_CREATOR_ID	GRAC_USER	CHAR	50	0	Created By
18	MANAGER_ID	☐	GRAC_MANAGER_ID	GRAC_USER	CHAR	50	0	Manager ID
19	REQUESTOR_LAST_NAME	☐	GRAC_REQUESTOR_LNAME	GRAC_FNAME	CHAR	100	0	Created by Last Name
20	REQUESTOR_FIRST_NAME	☐	GRAC_REQUESTOR_FNAME	GRAC_FNAME	CHAR	100	0	Created by First Name
21	MANAGER_LAST_NAME	☐	GRAC_MANAGER_LNAME	GRAC_FNAME	CHAR	100	0	Manager Last Name
22	MANAGER_FIRST_NAME	☐	GRAC_MANAGER_FNAME	GRAC_FNAME	CHAR	100	0	Manager First Name
23	ROLE_NAME	☐	GRAC_ROLE_NAME	GRAC_ROLE_NAME	CHAR	300	0	Role Name	*
24	USER_ID	☐	GRAC_USER	GRAC_USER	CHAR	50	0	User ID
25	USER_FIRST_NAME	☐	GRAC_USER_FIRST_NAME	GRAC_FNAME	CHAR	100	0	User First Name
26	USER_LAST_NAME	☐	GRAC_USER_LAST_NAME	GRAC_LNAME	CHAR	100	0	User Last Name
27	STATUS	☐	GRAC_REQUEST_STATUS	GRAC_REQUEST_STATUS	CHAR	10	0	Request Status
28	APPROVER_LAST_NAME	☐	GRAC_USER_LAST_NAME	GRAC_LNAME	CHAR	100	0	User Last Name
29	APPROVER_FIRST_NAME	☐	GRAC_USER_FIRST_NAME	GRAC_FNAME	CHAR	100	0	User First Name
30	RISK_ID	☐	GRAC_SODRISK_ID	GRAC_SODRISK_ID	CHAR	8	0	Access Risk ID
31	CONNECTOR	☐	GRFN_CONNECTORID	RFCDEST	CHAR	32	0	Connector Id	*
32	REVIEWER_ID	☐	GRAC_REVIEWER_ID	XUBNAME	CHAR	12	0	Reviewer User ID	*
33	COORDINATOR_ID	☐	GRAC_COORDINATOR_ID	XUBNAME	CHAR	12	0	Coordinator User ID	*
34	PD_PROFILE_NAME	☐	GRAC_PDPROFILE	GRAC_PDPROFILE	CHAR	20	0	PD Profile Name
35	DESCRIPTION	☐	GRAC_DESC	GRAC_DESC	CHAR	255	0	Description
36	SYSTEM1	☐	GRAC_SYSTEM	RFCDEST	CHAR	32	0	System	*
37	REVIEWER	☐	GRAC_DESC	GRAC_DESC	CHAR	255	0	Description
38	COORDINATOR	☐	GRAC_DESC	GRAC_DESC	CHAR	255	0	Description
39	ROLE_DESC	☐	GRAC_DESC	GRAC_DESC	CHAR	255	0	Description
40	ORGANIZATION	☐	GRAC_ORGUNIT	GRAC_ORGUNIT	CHAR	12	0	Org Unit
41	ACTION	☐	GRAC_ACTION	GRAC_ACTION	CHAR	50	0	Action
42	MISSING	☐	GRAC_NUMBER	INT4	INT4	10	0	Number
43	REJECTED	☐	GRAC_NUMBER	INT4	INT4	10	0	Number
44	COMPLETED	☐	GRAC_NUMBER	INT4	INT4	10	0	Number
45	LAST_ACTION_DATE	☐	GRAC_DATE	GRAC_DATE	DATS	8	0	Date Description
46	PRIORITY	☐	GRAC_PRIORITY	GRAC_PRIORITY	NUMC	3	0	Request Priority
47	TO_DATE	☐	GRAC_DATE	GRAC_DATE	DATS	8	0	Date Description
48	COMPLETION_DATE	☐	GRAC_DATE	GRAC_DATE	DATS	8	0	Date Description
49	USER_NAME	☐	GRAC_USERNAME		CHAR	200	0	Username
50	DELEGATION_FOR_USERID	☐	GRAC_USER	GRAC_USER	CHAR	50	0	User ID
51	DELEGATION_TO_USERID	☐	GRAC_USER	GRAC_USER	CHAR	50	0	User ID
52	DELEGATION_BY_USERID	☐	GRAC_USER	GRAC_USER	CHAR	50	0	User ID
53	REQUESTED_DATE	☐	GRAC_DATE	GRAC_DATE	DATS	8	0	Date Description
54	DELEGATION_CREATION_DATE	☐	GRAC_DATE	GRAC_DATE	DATS	8	0	Date Description
55	START_DATE	☐	GRAC_DATE	GRAC_DATE	DATS	8	0	Date Description
56	APPROVER_ID	☐	GRAC_REQUESTOR_ID	GRAC_USER	CHAR	50	0	Requested By
57	HIT_COUNT	☐	GRAC_NUMBER	INT4	INT4	10	0	Number
58	APPLICATION	☐	GRAC_APPLICATION	GRAC_LINE_ITEM_ID	CHAR	100	0	Request Application
59	JOB_ID	☐	GRAC_BGJOBID	GRAC_BGJOBID	CHAR	8	0	Background Job ID
60	FORWARDED_REVIEWER_ID	☐	GRAC_REVIEWER_ID	XUBNAME	CHAR	12	0	Reviewer User ID	*
61	STAGE	☐	GRFN_MW_STG_DESCR	GRFN_DESCRIPTION132	CHAR	132	0	Stage Description
62	SOD_ACTION	☐	GRAC_REQACTION	GRAC_REQACTION	CHAR	2	0	Request Action
63	UAR_ACTION	☐	GRAC_UAR_ACTION	GRAC_UAR_ACTION	CHAR	10	0	UAR Action
64	PRIORITY_DESC	☐	GRAC_DESC	GRAC_DESC	CHAR	255	0	Description
65	REQTYPE_DESC	☐	GRAC_DESC	GRAC_DESC	CHAR	255	0	Description
66	STATUS_DESC	☐	GRAC_DESC	GRAC_DESC	CHAR	255	0	Description
67	PROCESS_DESC	☐	GRFN_MW_PROCESS_DSCR	GRFN_DESCRIPTION132	CHAR	132	0	Process Description
68	REQ_EXCEED_SLA	☐	GRAC_YESNO	GRAC_YESNO	CHAR	3	0	YES /NO
69	SLA_ID_DESC	☐	GRAC_DESC	GRAC_DESC	CHAR	255	0	Description
70	MITIGATE_CONTROLS	☐	GRAC_MITIGATE_CONTROLS	GRAC_MITIGATE	CHAR	1	0	Mitigate Controls
71	DELEGATION_FOR_USER_NAME	☐	GRAC_USERNAME		CHAR	200	0	Username
72	DELEGATION_TO_USER_NAME	☐	GRAC_USERNAME		CHAR	200	0	Username
73	ROLE_ID	☐	GRAC_ITEM_ID	GRAC_ITEM_ID	CHAR	50	0	Item ID
74	SOD_ITEMNUM	☐	GRAC_SEQ	GRAC_SEQUENCE	NUMC	4	0	Action Sequence
75	END_DATE	☐	GRAC_DATE	GRAC_DATE	DATS	8	0	Date Description
76	DELEGATION_STATUS	☐	GRAC_DELEG_APPROVER_STATUS	GRAC_DELEG_APPROVER_STATUS	CHAR	1	0	Delegator Approver status
77	UAR_APPROVAL_STATUS	☐	GRAC_APPROVAL_STATUS	GRAC_APPROVAL_STATUS	CHAR	3	0	Line Item Status in Application
78	UAR_PROV_ACTION	☐	GRAC_PROV_ITEM_ACTION	GRAC_LINE_ITEM_ACTION	CHAR	3	0	Action Associated with Line Item
79	REV_TYPE	☐	GRAC_REV_TYPE	GRAC_REV_TYPE	CHAR	4	0	Reviewer Type
80	LAST_UPDATED_AT	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)

History

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