SAP ABAP Table GRPC_S_GRFN_DAB_D3 (Dashboard report: Remediation Plan and CAPA Plan Status)

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_GRFN_DAB_D3	Table Relationship Diagram
Short Description	Dashboard report: Remediation Plan and CAPA Plan Status

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	RE	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
2	RE_T	☐	GRFN_REP_REGULATION_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Regulation
3	OU	☐	GRFN_REP_ORGUNIT_ID	NUMC08	NUMC	8	0	Organization ID
4	OU_T	☐	GRFN_REP_ORGUNIT_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Orgunit
5	OU_COUNTRY	☐	GRFN_REP_COUNTRY	LAND1	CHAR	3	0	Country ID	*
6	OU_COUNTRY_T	☐	GRFN_REP_COUNTRY_T	GRFN_REP_CHAR60	CHAR	60	0	Country Key
7	OU_REGION	☐	GRFN_REP_REGION	REGIO	CHAR	3	0	Region ID	*
8	OU_REGION_T	☐	GRFN_REP_REGION_T	GRFN_REP_CHAR60	CHAR	60	0	Region (State, Province, County)
9	EG	☐	GRFN_REP_ECGROUP	NUMC08	NUMC	8	0	iELC Group ID
10	EG_T	☐	GRFN_REP_ECGROUP_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	iELC Group
11	EC	☐	GRFN_REP_ECONTROL	NUMC08	NUMC	8	0	Indirect ELC ID
12	EC_T	☐	GRFN_REP_ECONTROL_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Indirect ELC
13	PR	☐	GRFN_REP_PROCESS_ID	NUMC08	NUMC	8	0	Process ID
14	PR_T	☐	GRFN_REP_PROCESS_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Process
15	SP	☐	GRFN_REP_SUBPROCESS_ID	NUMC08	NUMC	8	0	Subprocess ID
16	SP_T	☐	GRFN_REP_SUBPROCESS_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Subprocess
17	CN	☐	GRFN_REP_CONTROL_ID		CHAR	9	0	Control ID
18	CN_T	☐	GRFN_REP_CONTROL_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Control
19	AI_GUID	☐	GRFN_REP_ADISSUE_ID	SYSUUID_C	CHAR	32	0	Ad-Hoc issue ID
20	AI_T	☐	GRFN_REP_ADISSUE_TEXT	GRFN_REP_TEXT_100	CHAR	100	0	Ad-Hoc Issue
21	AI_RESPONSIBLE	☐	GRFN_REP_ADISSUE_RESP	XUBNAME	CHAR	12	0	Ad-Hoc Issue Responsible Person ID	*
22	AI_RESPONSIBLE_T	☐	GRFN_REP_ADISSUE_RESP_T	GRFN_REP_USER_NAME	CHAR	80	0	Ad-Hoc Issue Responsible Person
23	AI_PROCESSOR	☐	GRFN_REP_ADISSUE_PROC	XUBNAME	CHAR	12	0	Ad-Hoc Issue Processor ID	*
24	AI_PROCESSOR_T	☐	GRFN_REP_ADISSUE_PROC_T	GRFN_REP_USER_NAME	CHAR	80	0	Ad-Hoc Issue Processor
25	AI_CATEGORY	☐	GRFN_REP_ADISSUE_CATEGORY	CHAR4	CHAR	4	0	AD-Hoc Issue Type ID
26	AI_CATEGORY_T	☐	GRFN_REP_ADISSUE_CATEGORY_T	GRFN_REP_CASE_CATEGORY_T	CHAR	60	0	Ad-Hoc Issue Type
27	AI_STATUS	☐	GRFN_REP_ADISSUE_STATUS	CRM_J_STATUS	CHAR	5	0	Ad-Hoc Issue Status ID
28	AI_STATUS_T	☐	GRFN_REP_ADISSUE_STATUS_T	GRFN_REP_TEXT_40	CHAR	40	0	Ad-Hoc Issue Status
29	AI_PRIORITY	☐	GRFN_REP_ADISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Ad-Hoc Issue Priority ID
30	AI_PRIORITY_T	☐	GRFN_REP_ADISSUE_PRIORITY_T	GRFN_REP_CHAR60	CHAR	60	0	Ad-Hoc Issue Priority
31	AI_CREATE_ON	☐	GRFN_REP_ADISSUE_CREATED_ON		DATS	8	0	Ad-Hoc Issue Created On (Date)
32	AI_DUE_DATE	☐	GRFN_REP_ADISSUE_DUE_DATE	DATUM	DATS	8	0	Ad-Hoc Issue Due Date
33	AI_ORI_OBJ_ID	☐	GRFN_REP_ADISSUE_ORI_OBJ_ID	CHAR50	CHAR	50	0	Ad-Hoc Issue Original Object ID
34	AI_CASE_TYPE	☐	GRFN_REP_ADISSUE_CASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Ad-Hoc Issue Case Type	*
35	AI_CASE_TYPE_T	☐	GRFN_REP_ADISSUE_CASE_TYPE_T	GRFN_REP_TEXT_40	CHAR	40	0	Ad-Hoc Issue Case Type
36	AI_SOURCE	☐	GRFN_REP_ADISSUE_ISSUE_SOU	GRFN_REP_TEXT_20	CHAR	20	0	Ad_Hoc Issue Source ID
37	IS_GUID	☐	GRFN_REP_ISSUE_ID	SYSUUID_C	CHAR	32	0	Issue ID
38	IS_T	☐	GRFN_REP_ISSUE_TEXT	GRFN_REP_TEXT_100	CHAR	100	0	Issue
39	IS_TFRAME	☐	GRFN_REP_ISSUE_TIME_FRAME	GRFN_ATTRVALUE	CHAR	10	0	Timeframe ID
40	IS_TFRAME_T	☐	GRFN_REP_ISSUE_TFRAME_T	GRFN_REP_TEXT_100	CHAR	100	0	Timeframe
41	IS_TF_YEAR	☐	GRFN_REP_ISSUE_TF_YEAR	CHAR4	CHAR	4	0	Year
42	IS_RESP_USER	☐	GRFN_REP_ISSUE_RESP	XUBNAME	CHAR	12	0	Reported by ID	*
43	IS_RESP_USER_T	☐	GRFN_REP_ISSUE_RESP_T	GRFN_REP_USER_NAME	CHAR	80	0	Reported by
44	IS_PROCESSOR	☐	GRFN_REP_ISSUE_PROC	XUBNAME	CHAR	12	0	Issue Processor ID	*
45	IS_PROCESSOR_T	☐	GRFN_REP_ISSUE_PROC_T	GRFN_REP_USER_NAME	CHAR	80	0	Issue Processor
46	IS_CATEGORY	☐	GRFN_REP_ISSUE_CAT	CHAR4	CHAR	4	0	Issue type ID
47	IS_CATEGORY_T	☐	GRFN_REP_ISSUE_CAT_T	GRFN_REP_CASE_CATEGORY_T	CHAR	60	0	Issue Type
48	IS_STATUS	☐	GRFN_REP_ISSUE_STATUS	CRM_J_STATUS	CHAR	5	0	Issue Status ID
49	IS_STATUS_T	☐	GRFN_REP_ISSUE_STATUS_T	GRFN_REP_CASE_STATUS_T	CHAR	30	0	Issue Status
50	IS_PRIORITY	☐	GRFN_REP_ISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Issue Priority ID
51	IS_PRIORITY_T	☐	GRFN_REP_ISSUE_PRIORITY_T	GRFN_REP_CHAR60	CHAR	60	0	Issue Priority
52	IS_DURATION	☐	GRFN_REP_ISSUE_DURATION		INT4	10	0	Duration in Days
53	IS_CREATED_ON	☐	GRFN_REP_ISSUE_CREATED_ON		DATS	8	0	Issue Created On (Date)
54	IS_CREATED_ON_TM	☐	GRFN_REP_ISSUE_CREATED_ON_TM		TIMS	6	0	Issue Created On (Time)
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_TFRAME	☐	GRFN_REP_RMPLAN_TIME_FRAME	GRFN_ATTRVALUE	CHAR	10	0	Remediation plan time frame
60	PL_TFRAME_T	☐	GRFN_REP_RMPLAN_TIME_FRAME_T	GRFN_REP_TEXT_100	CHAR	100	0	Remediation plan time frame description
61	PL_TF_YEAR	☐	GRFN_REP_RMPLAN_TF_YEAR	CHAR4	CHAR	4	0	Remediation plan time frame year
62	PL_RESP_USER	☐	GRFN_REP_RMPLAN_RESP	XUBNAME	CHAR	12	0	Reported by ID	*
63	PL_RESP_USER_T	☐	GRFN_REP_RMPLAN_RESP_T	GRFN_REP_USER_NAME	CHAR	80	0	Reported by
64	PL_PROCESSOR	☐	GRFN_REP_RMPLAN_PROC	XUBNAME	CHAR	12	0	Remediator ID	*
65	PL_PROCESSOR_T	☐	GRFN_REP_RMPLAN_PROC_T	GRFN_REP_USER_NAME	CHAR	80	0	Remediator
66	PL_CATEGORY	☐	GRFN_REP_RMPLAN_CATEGORY	CHAR4	CHAR	4	0	Remediation plan category
67	PL_CATEGORY_T	☐	GRFN_REP_RMPLAN_CAT_T	GRFN_REP_CASE_CATEGORY_T	CHAR	60	0	Remediation Plan Type
68	PL_STATUS	☐	GRFN_REP_RMPLAN_STATUS	CRM_J_STATUS	CHAR	5	0	Remediation Plan Status ID
69	PL_STATUS_T	☐	GRFN_REP_RMPLAN_STATUS_T	GRFN_REP_CASE_STATUS_T	CHAR	30	0	Remediation Plan Status
70	PL_DURATION	☐	GRFN_REP_RMPLAN_DURATION		INT4	10	0	Remediation Plan Duration
71	PL_DUEDATE	☐	GRFN_REP_RMPLAN_DUEDATE		DATS	8	0	Remediation Plan Due Date
72	CP_GUID	☐	GRFN_REP_CPPLAN	SYSUUID_C	CHAR	32	0	CAPA Plan ID
73	CP_T	☐	GRFN_REP_CPPLAN_T	GRFN_REP_TEXT_100	CHAR	100	0	CAPA Plan
74	CP_D	☐	GRFN_REP_CPPLAN_DESCRIPTION		STRG	0	0	CAPA Plan Description
75	CP_TFRAME	☐	GRFN_REP_CPPLAN_TIME_FRAME	GRFN_ATTRVALUE	CHAR	10	0	CAPA plan - time frame
76	CP_TFRAME_T	☐	GRFN_REP_CPPLAN_TIME_FRAME_T	GRFN_REP_TEXT_100	CHAR	100	0	CAPA plan time frame description
77	CP_TF_YEAR	☐	GRFN_REP_CPPLAN_TF_YEAR	CHAR4	CHAR	4	0	CAPA plan - time frame year
78	CP_RESP_USER	☐	GRFN_REP_CPPLAN_RESP	XUBNAME	CHAR	12	0	CAPA plan - Reported by ID	*
79	CP_RESP_USER_T	☐	GRFN_REP_CPPLAN_RESP_T	GRFN_REP_USER_NAME	CHAR	80	0	CAPA plan - Reported by
80	CP_PROCESSOR	☐	GRFN_REP_CPPLAN_PROC	XUBNAME	CHAR	12	0	Processor ID	*
81	CP_PROCESSOR_T	☐	GRFN_REP_CPPLAN_PROC_T	GRFN_REP_USER_NAME	CHAR	80	0	Processor
82	CP_CATEGORY	☐	GRFN_REP_CPLAN_CATEGORY	CHAR4	CHAR	4	0	CAPA plan case category
83	CP_CATEGORY_T	☐	GRFN_REP_CPLAN_CATEGORY_TXT	GRFN_REP_CASE_CATEGORY_T	CHAR	60	0	CAPA plan case category description
84	CP_STATUS	☐	GRFN_REP_CPPLAN_STATUS	CRM_J_STATUS	CHAR	5	0	CAPA Status ID
85	CP_STATUS_T	☐	GRFN_REP_CPPLAN_STATUS_T	GRFN_REP_CASE_STATUS_T	CHAR	30	0	CAPA Status
86	CP_END_DATE	☐	GRFN_REP_CPPLAN_END_DATE	DATUM	DATS	8	0	Due Date
87	CP_OVERDUE	☐	GRFN_REP_RMPLAN_OVERDUE	GRFN_XFELD	CHAR	1	0	Overdue
88	RS	☐	GRFN_REP_RISK_ID	CHAR9	CHAR	9	0	Risk ID
89	RS_T	☐	GRFN_REP_RISK_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Risk
90	RP	☐	GRFN_REP_RESPONSE_ID		CHAR	32	0	Response ID
91	RP_T	☐	GRFN_REP_RP_TEXT		CHAR	80	0	Response Title
92	IN_ID	☐	GRFN_REP_INCIDENT		NUMC	10	0	Incident ID
93	IN_T	☐	GRFN_REP_INCIDENT_TEXT		CHAR	40	0	Incident
94	AC_ID	☐	GRFN_REP_ACTIVITY		CHAR	9	0	Activity ID
95	AC_T	☐	GRFN_REP_ACTIVITY_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Activity Title
96	SM_ID	☐	GRFN_REP_SIM_SCENARIO_ID	SYSUUID	RAW	16	0	Scenario ID (Simulation)
97	SM_T	☐	GRFN_REP_SIM_TITLE	GRFN_TITLE	CHAR	40	0	Title (Simulation)
98	OR_ID	☐	GRFN_REP_OPPORTUNITY		NUMC	8	0	Opportunity ID
99	OR_T	☐	GRFN_REP_OPPORTUNITY_TEXT		CHAR	40	0	Opportunity

History

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