SAP ABAP Table GRPC_S_PC_DAB_D3_MERGE (Dashboard report: Merged Issue and Remediation Plan)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC-SPC (Application Component) Process Controls
     ⤷ GRPC_DASHBOARD (Package) GRC-PC Dashboards

Basic Data

Table Category	INTTAB	Structure
Structure	GRPC_S_PC_DAB_D3_MERGE	Table Relationship Diagram
Short Description	Dashboard report: Merged Issue and Remediation Plan

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	ADHOC	☐			STRG	0	0
2	CAPA	☐			STRG	0	0
3	.INCLUDE	☐				0	0	Dashboard report: Remediation Plan and CAPA Plan Status
4	RE	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
5	RE_T	☐	GRFN_REP_REGULATION_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Regulation
6	OU	☐	GRFN_REP_ORGUNIT_ID	NUMC08	NUMC	8	0	Organization ID
7	OU_T	☐	GRFN_REP_ORGUNIT_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Orgunit
8	OU_COUNTRY	☐	GRFN_REP_COUNTRY	LAND1	CHAR	3	0	Country ID	*
9	OU_COUNTRY_T	☐	GRFN_REP_COUNTRY_T	GRFN_REP_CHAR60	CHAR	60	0	Country Key
10	OU_REGION	☐	GRFN_REP_REGION	REGIO	CHAR	3	0	Region ID	*
11	OU_REGION_T	☐	GRFN_REP_REGION_T	GRFN_REP_CHAR60	CHAR	60	0	Region (State, Province, County)
12	OU_IN_SCOPE	☐	GRFN_REP_ORGUNIT_IN_SCOPE	GRFN_REP_YES_NO	CHAR	1	0	In Scope (Organization) ID
13	OU_IN_SCOPE_T	☐	GRFN_REP_ORGUNIT_IN_SCOPE_T	GRFN_REP_CHAR60	CHAR	60	0	In Scope (Organization)
14	EG	☐	GRFN_REP_ECGROUP	NUMC08	NUMC	8	0	iELC Group ID
15	EG_T	☐	GRFN_REP_ECGROUP_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	iELC Group
16	EC	☐	GRFN_REP_ECONTROL	NUMC08	NUMC	8	0	Indirect ELC ID
17	EC_T	☐	GRFN_REP_ECONTROL_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Indirect ELC
18	PR	☐	GRFN_REP_PROCESS_ID	NUMC08	NUMC	8	0	Process ID
19	PR_T	☐	GRFN_REP_PROCESS_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Process
20	SP	☐	GRFN_REP_SUBPROCESS_ID	NUMC08	NUMC	8	0	Subprocess ID
21	SP_T	☐	GRFN_REP_SUBPROCESS_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Subprocess
22	CN	☐	GRFN_REP_CONTROL_ID		CHAR	9	0	Control ID
23	CN_T	☐	GRFN_REP_CONTROL_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Control
24	AI_GUID	☐	GRFN_REP_ADISSUE_ID	SYSUUID_C	CHAR	32	0	Ad-Hoc issue ID
25	AI_T	☐	GRFN_REP_ADISSUE_TEXT	GRFN_REP_TEXT_100	CHAR	100	0	Ad-Hoc Issue
26	AI_D	☐	GRFN_REP_ADISSUE_DESRIPTION		STRG	0	0	Ad-Hoc Issue description
27	AI_RESPONSIBLE	☐	GRFN_REP_ADISSUE_RESP	XUBNAME	CHAR	12	0	Ad-Hoc Issue Responsible Person ID	*
28	AI_RESPONSIBLE_T	☐	GRFN_REP_ADISSUE_RESP_T	GRFN_REP_USER_NAME	CHAR	80	0	Ad-Hoc Issue Responsible Person
29	AI_PROCESSOR	☐	GRFN_REP_ADISSUE_PROC	XUBNAME	CHAR	12	0	Ad-Hoc Issue Processor ID	*
30	AI_PROCESSOR_T	☐	GRFN_REP_ADISSUE_PROC_T	GRFN_REP_USER_NAME	CHAR	80	0	Ad-Hoc Issue Processor
31	AI_CATEGORY	☐	GRFN_REP_ADISSUE_CATEGORY	CHAR4	CHAR	4	0	AD-Hoc Issue Type ID
32	AI_CATEGORY_T	☐	GRFN_REP_ADISSUE_CATEGORY_T	GRFN_REP_CASE_CATEGORY_T	CHAR	60	0	Ad-Hoc Issue Type
33	AI_STATUS	☐	GRFN_REP_ADISSUE_STATUS	CRM_J_STATUS	CHAR	5	0	Ad-Hoc Issue Status ID
34	AI_STATUS_T	☐	GRFN_REP_ADISSUE_STATUS_T	GRFN_REP_TEXT_40	CHAR	40	0	Ad-Hoc Issue Status
35	AI_PRIORITY	☐	GRFN_REP_ADISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Ad-Hoc Issue Priority ID
36	AI_PRIORITY_T	☐	GRFN_REP_ADISSUE_PRIORITY_T	GRFN_REP_CHAR60	CHAR	60	0	Ad-Hoc Issue Priority
37	AI_DUE_DATE	☐	GRFN_REP_ADISSUE_DUE_DATE	DATUM	DATS	8	0	Ad-Hoc Issue Due Date
38	AI_ORI_OBJ_ID	☐	GRFN_REP_ADISSUE_ORI_OBJ_ID	CHAR50	CHAR	50	0	Ad-Hoc Issue Original Object ID
39	AI_CASE_TYPE	☐	GRFN_REP_ADISSUE_CASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Ad-Hoc Issue Case Type	*
40	AI_CASE_TYPE_T	☐	GRFN_REP_ADISSUE_CASE_TYPE_T	GRFN_REP_TEXT_40	CHAR	40	0	Ad-Hoc Issue Case Type
41	IS_GUID	☐	GRFN_REP_ISSUE_ID	SYSUUID_C	CHAR	32	0	Issue ID
42	IS_T	☐	GRFN_REP_ISSUE_TEXT	GRFN_REP_TEXT_100	CHAR	100	0	Issue
43	IS_D	☐	GRFN_REP_ISSUE_DESRIPTION		STRG	0	0	Issue description
44	IS_RESP_USER	☐	GRFN_REP_ISSUE_RESP	XUBNAME	CHAR	12	0	Reported by ID	*
45	IS_RESP_USER_T	☐	GRFN_REP_ISSUE_RESP_T	GRFN_REP_USER_NAME	CHAR	80	0	Reported by
46	IS_PROCESSOR	☐	GRFN_REP_ISSUE_PROC	XUBNAME	CHAR	12	0	Issue Processor ID	*
47	IS_PROCESSOR_T	☐	GRFN_REP_ISSUE_PROC_T	GRFN_REP_USER_NAME	CHAR	80	0	Issue Processor
48	IS_CATEGORY	☐	GRFN_REP_ISSUE_CAT	CHAR4	CHAR	4	0	Issue type ID
49	IS_CATEGORY_T	☐	GRFN_REP_ISSUE_CAT_T	GRFN_REP_CASE_CATEGORY_T	CHAR	60	0	Issue Type
50	IS_STATUS	☐	GRFN_REP_ISSUE_STATUS	CRM_J_STATUS	CHAR	5	0	Issue Status ID
51	IS_STATUS_T	☐	GRFN_REP_ISSUE_STATUS_T	GRFN_REP_CASE_STATUS_T	CHAR	30	0	Issue Status
52	IS_PRIORITY	☐	GRFN_REP_ISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Issue Priority ID
53	IS_PRIORITY_T	☐	GRFN_REP_ISSUE_PRIORITY_T	GRFN_REP_CHAR60	CHAR	60	0	Issue Priority
54	IS_DURATION	☐	GRFN_REP_ISSUE_DURATION		INT4	10	0	Duration in Days
55	IS_DUE_DATE	☐	GRFN_REP_ISSUE_DUE_DATE	DATUM	DATS	8	0	Issue Due Date
56	PL_GUID	☐	GRFN_REP_RMPLAN	SYSUUID_C	CHAR	32	0	Remediation Plan ID
57	PL_T	☐	GRFN_REP_RMPLAN_T	GRFN_REP_TEXT_100	CHAR	100	0	Remediation Plan
58	PL_D	☐	GRFN_REP_RMPLAN_DESCRIPTION		STRG	0	0	Remediation Plan Description
59	PL_RESP_USER	☐	GRFN_REP_RMPLAN_RESP	XUBNAME	CHAR	12	0	Reported by ID	*
60	PL_RESP_USER_T	☐	GRFN_REP_RMPLAN_RESP_T	GRFN_REP_USER_NAME	CHAR	80	0	Reported by
61	PL_PROCESSOR	☐	GRFN_REP_RMPLAN_PROC	XUBNAME	CHAR	12	0	Remediator ID	*
62	PL_PROCESSOR_T	☐	GRFN_REP_RMPLAN_PROC_T	GRFN_REP_USER_NAME	CHAR	80	0	Remediator
63	PL_CATEGORY	☐	GRFN_REP_RMPLAN_CATEGORY	CHAR4	CHAR	4	0	Remediation plan category
64	PL_CATEGORY_T	☐	GRFN_REP_RMPLAN_CAT_T	GRFN_REP_CASE_CATEGORY_T	CHAR	60	0	Remediation Plan Type
65	PL_STATUS	☐	GRFN_REP_RMPLAN_STATUS	CRM_J_STATUS	CHAR	5	0	Remediation Plan Status ID
66	PL_STATUS_T	☐	GRFN_REP_RMPLAN_STATUS_T	GRFN_REP_CASE_STATUS_T	CHAR	30	0	Remediation Plan Status
67	PL_DURATION	☐	GRFN_REP_RMPLAN_DURATION		INT4	10	0	Remediation Plan Duration
68	PL_DUEDATE	☐	GRFN_REP_RMPLAN_DUEDATE		DATS	8	0	Remediation Plan Due Date
69	CP_GUID	☐	GRFN_REP_CPPLAN	SYSUUID_C	CHAR	32	0	CAPA Plan ID
70	CP_T	☐	GRFN_REP_CPPLAN_T	GRFN_REP_TEXT_100	CHAR	100	0	CAPA Plan
71	CP_D	☐	GRFN_REP_CPPLAN_DESCRIPTION		STRG	0	0	CAPA Plan Description
72	CP_RESP_USER	☐	GRFN_REP_CPPLAN_RESP	XUBNAME	CHAR	12	0	CAPA plan - Reported by ID	*
73	CP_RESP_USER_T	☐	GRFN_REP_CPPLAN_RESP_T	GRFN_REP_USER_NAME	CHAR	80	0	CAPA plan - Reported by
74	CP_PROCESSOR	☐	GRFN_REP_CPPLAN_PROC	XUBNAME	CHAR	12	0	Processor ID	*
75	CP_PROCESSOR_T	☐	GRFN_REP_CPPLAN_PROC_T	GRFN_REP_USER_NAME	CHAR	80	0	Processor
76	CP_CATEGORY	☐	GRFN_REP_CPLAN_CATEGORY	CHAR4	CHAR	4	0	CAPA plan case category
77	CP_CATEGORY_T	☐	GRFN_REP_CPLAN_CATEGORY_TXT	GRFN_REP_CASE_CATEGORY_T	CHAR	60	0	CAPA plan case category description
78	CP_STATUS	☐	GRFN_REP_CPPLAN_STATUS	CRM_J_STATUS	CHAR	5	0	CAPA Status ID
79	CP_STATUS_T	☐	GRFN_REP_CPPLAN_STATUS_T	GRFN_REP_CASE_STATUS_T	CHAR	30	0	CAPA Status
80	CP_END_DATE	☐	GRFN_REP_CPPLAN_END_DATE	DATUM	DATS	8	0	Due Date
81	CP_OVERDUE	☐	GRFN_REP_RMPLAN_OVERDUE	GRFN_XFELD	CHAR	1	0	Overdue

History

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