SAP ABAP Table GRFN_S_CY_F5 (Crystal report RFC: Control Test History with Ratings)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC (Application Component) Governance, Risk and Compliance
     ⤷ GRFN_REPORTING (Package) Shared PC-RM Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	GRFN_S_CY_F5	Table Relationship Diagram
Short Description	Crystal report RFC: Control Test History with Ratings

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_D	☐	GRFN_REP_ORGUNIT_DESCR_CY	GRFN_REP_CY_DESCR	CHAR	1024	0	Organization description
6	OU_IN_SCOPE	☐	GRFN_REP_ORGUNIT_IN_SCOPE	GRFN_REP_YES_NO	CHAR	1	0	In Scope (Organization) ID
7	OU_IN_SCOPE_T	☐	GRFN_REP_ORGUNIT_IN_SCOPE_T	GRFN_REP_CHAR60	CHAR	60	0	In Scope (Organization)
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	PR	☐	GRFN_REP_PROCESS_ID	NUMC08	NUMC	8	0	Process ID
13	PR_T	☐	GRFN_REP_PROCESS_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Process
14	PR_D	☐	GRFN_REP_PROCESS_DESCR_CY	GRFN_REP_CY_DESCR	CHAR	1024	0	Process Description
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	SP_D	☐	GRFN_REP_SUBPROCESS_DESCR_CY	GRFN_REP_CY_DESCR	CHAR	1024	0	Subprocess Description
18	SP_IN_SCOPE	☐	GRFN_REP_SUBPROCESS_IN_SCOPE	GRFN_REP_YES_NO	CHAR	1	0	In Scope (Subprocess) ID
19	SP_IN_SCOPE_T	☐	GRFN_REP_SUBPROCESS_IN_SCOPE_T	GRFN_REP_CHAR60	CHAR	60	0	In Scope (Subprocess)
20	SP_TRTYPE	☐	GRFN_REP_SUBPROCESS_TRTYPE	GRPC_ATTRVALUE	CHAR	10	0	Transaction type (central) ID
21	SP_TRTYPE_T	☐	GRFN_REP_SUBPROCESS_TRTYPE_T	GRFN_REP_TEXT_100	CHAR	100	0	Transaction Type (central)
22	CN_RS	☐	GRFN_REP_CONTROL_ASS_RISK_CY	GRFN_REP_CY_DESCR	CHAR	1024	0	Assigned Risks ID
23	CN_RS_T	☐	GRFN_REP_CONTROL_ASS_RISK_T_CY	GRFN_REP_CY_DESCR	CHAR	1024	0	Assigned Risks
24	CN	☐	GRFN_REP_CONTROL_ID		CHAR	9	0	Control ID
25	CN_T	☐	GRFN_REP_CONTROL_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Control
26	CN_D	☐	GRFN_REP_CONTROL_DESCR_CY	GRFN_REP_CY_DESCR	CHAR	1024	0	Control Description
27	CN_RESP_USER	☐	GRFN_REP_CONTROL_RESP_USER	GRFN_REP_RESP_USER	CHAR	12	0	Owner ID
28	CN_RESP_USER_T	☐	GRFN_REP_CONTROL_RESP_USER_T	GRFN_REP_USER_NAME	CHAR	80	0	Owner
29	CN_VALID_FROM	☐	GRFN_REP_CONTROL_VALID_FROM	DATUM	DATS	8	0	Valid From
30	CN_VALID_TO	☐	GRFN_REP_CONTROL_VALID_TO	DATUM	DATS	8	0	Valid to
31	CN_CATEGORY	☐	GRFN_REP_CONTROL_CATEGORY		CHAR	10	0	Control Category ID
32	CN_CATEGORY_T	☐	GRFN_REP_CONTROL_CATEGORY_T	GRFN_REP_TEXT_100	CHAR	100	0	Control Category
33	CN_SIG	☐	GRFN_REP_CONTROL_SIG	GRFN_ATTRVALUE	CHAR	10	0	Significance ID
34	CN_SIG_T	☐	GRFN_REP_CONTROL_SIG_T	GRFN_REP_TEXT_100	CHAR	100	0	Significance
35	CN_EVIDENCE	☐	GRFN_REP_CONTROL_EVIDENCE	GRFN_ATTRVALUE	CHAR	10	0	Level of Evidence ID
36	CN_EVIDENCE_T	☐	GRFN_REP_CONTROL_EVIDENCE_T	GRFN_REP_TEXT_100	CHAR	100	0	Level of Evidence
37	CN_CNTR_RISK	☐	GRFN_REP_CONTROL_RISK	GRFN_ATTRVALUE	CHAR	10	0	Control Risk ID
38	CN_CNTR_RISK_T	☐	GRFN_REP_CONTROL_RISK_T	GRFN_REP_TEXT_100	CHAR	100	0	Control Risk
39	CN_CNGROUP	☐	GRFN_REP_CONTROL_CNGROUP	GRFN_ATTRVALUE	CHAR	10	0	Control Group ID
40	CN_CNGROUP_T	☐	GRFN_REP_CONTROL_CNGROUP_T	GRFN_REP_TEXT_100	CHAR	100	0	Control Group
41	CN_SUBGROUP	☐	GRFN_REP_CONTROL_SUBGROUP_CY	GRFN_REP_CY_DESCR	CHAR	1024	0	Control Subgroup ID
42	CN_SUBGROUP_T	☐	GRFN_REP_CONTROL_SUBGROUP_T_CY	GRFN_REP_CY_DESCR	CHAR	1024	0	Control Subgroup
43	CN_PURP	☐	GRFN_REP_CONTROL_PURP	GRFN_ATTRVALUE	CHAR	10	0	Control Purpose ID
44	CN_PURP_T	☐	GRFN_REP_CONTROL_PURP_T	GRFN_REP_TEXT_100	CHAR	100	0	Control Purpose
45	CN_AUTOM	☐	GRFN_REP_CONTROL_AUTOM	GRFN_ATTRVALUE	CHAR	10	0	Automation ID
46	CN_AUTOM_T	☐	GRFN_REP_CONTROL_AUTOM_T	GRFN_REP_TEXT_100	CHAR	100	0	Automation
47	CN_NATURE	☐	GRFN_REP_CONTROL_NATURE	GRFN_ATTRVALUE	CHAR	10	0	Nature ID
48	CN_NATURE_T	☐	GRFN_REP_CONTROL_NATURE_T	GRFN_REP_TEXT_100	CHAR	100	0	Nature
49	CN_TEST	☐	GRFN_REP_CONTROL_TEST	GRFN_XFELD	CHAR	1	0	Control To Be Tested ID
50	CN_TEST_ICON	☐	GRFN_REP_CONTROL_TEST_ICON	ICONNAME	CHAR	30	0	To Be Tested (Symbol)
51	CN_FREQ	☐	GRFN_REP_CONTROL_FREQ	GRFN_ATTRVALUE	CHAR	10	0	Frequency ID
52	CN_FREQ_T	☐	GRFN_REP_CONTROL_FREQ_T	GRFN_REP_TEXT_100	CHAR	100	0	Frequency
53	CN_TTECH	☐	GRFN_REP_CONTROL_TTECHNQ	GRFN_ATTRVALUE	CHAR	10	0	Testing Technique ID
54	CN_TTECH_T	☐	GRFN_REP_CONTROL_TTECHNQ_T	GRFN_REP_TEXT_100	CHAR	100	0	Testing Technique
55	TP	☐	GRFN_REP_TESTPLAN_ID	NUMC08	NUMC	8	0	Test Plan ID
56	CN_TEST_PLAN	☐	GRFN_REP_CONTROL_TEST_PLAN	NUMC08	NUMC	8	0	Control test plan
57	TP_T	☐	GRFN_REP_TESTPLAN_TEXT	GRFN_REP_TEXT_40	CHAR	40	0	Test Plan
58	TP_D	☐	GRFN_REP_TESTPLAN_DESCR_CY	GRFN_REP_CY_DESCR	CHAR	1024	0	Test Plan Description
59	TL_T	☐	GRFN_REP_TESTLOG_T	GRFN_REP_TEXT_100	CHAR	100	0	Test Log
60	TL_TFRAME	☐	GRFN_REP_TESTLOG_TIMEFRAME	GRFN_ATTRVALUE	CHAR	10	0	Test Log Timeframe ID
61	TL_TFRAME_T	☐	GRFN_REP_TESTLOG_TIMEFRAME_T	GRFN_REP_TEXT_100	CHAR	100	0	Test Log Timeframe
62	TL_TFRAME_YEAR	☐	GRFN_REP_TESTLOG_TF_YEAR		CHAR	4	0	Test Log Time Frame Year
63	TL_CF_TFRAME	☐	GRFN_REP_TESTLOG_CF_TIMEFRAME	GRFN_ATTRVALUE	CHAR	10	0	Test Log Timeframe Before Carryforward ID
64	TL_CF_TFRAME_T	☐	GRFN_REP_TESTLOG_CF_TIMEFR_T	GRFN_REP_TEXT_40	CHAR	40	0	Test Log Timeframe Before Carryforward
65	TL_CF_YEAR	☐	GRFN_REP_TESTLOG_CF_YEAR		CHAR	4	0	Test Log Timeframe Before Carryforward (Year)
66	TL_TEST_DATE	☐	GRFN_REP_TESTLOG_TEST_DATE	DATUM	DATS	8	0	Test Log Test Date
67	TL_EXCEPTION_T	☐	GRFN_REP_TESTLOG_EXCEPTION_T	GRFN_REP_CHAR60	CHAR	60	0	Test Result
68	TL_RESULT	☐	GRFN_REP_TESTLOG_RESULT_CY	GRFN_REP_CY_COMMENT	CHAR	1024	0	Test Log Result
69	TL_TEST_OWNER_T	☐	GRFN_REP_TESTLOG_TEST_OWNER_T	GRFN_REP_USER_NAME	CHAR	80	0	Test owner name
70	TL_TESTER_T	☐	GRFN_REP_TESTLOG_TUNAME	GRFN_REP_USER_NAME	CHAR	80	0	Test Log: Tester User Name
71	TL_VAL_USER_T	☐	GRFN_REP_TESTLOG_VAL_USER_T	GRFN_REP_USER_NAME	CHAR	80	0	Test log validate by
72	TL_TTECH	☐	GRFN_REP_TESTLOG_TTECH	GRFN_ATTRVALUE	CHAR	10	0	Test Log Testing Technique
73	TL_TPROC	☐	GRFN_REP_TESTLOG_TPROC_CY	GRFN_REP_CY_COMMENT	CHAR	1024	0	Test Log Testing Procedure
74	TE_STATUS	☐	GRFN_REP_TESTING_STATUS	CRM_J_STATUS	CHAR	5	0	Testing Status
75	TE_STATUS_T	☐	GRFN_REP_TESTING_STATUS_T	GRFN_REP_CASE_STATUS_T	CHAR	30	0	Testing Status
76	TE_RATING	☐	GRFN_REP_TE_RATING	GRFN_AS_RATING	CHAR	1	0	Effectiveness Rating ID
77	TE_RATING_ICON	☐	GRFN_REP_TE_ICON	ICONNAME	CHAR	30	0	Effectiveness Rating (Symbol)
78	TE_RATING_T	☐	GRFN_REP_TE_RATING_TXT	GRFN_REP_RATING_T	CHAR	60	0	Effectiveness Rating
79	TE_REFERENCE	☐	GRFN_REP_TE_REFERENCE	SYSUUID_C	CHAR	32	0	Effectiveness Case ID
80	TE_ISSUES	☐	GRFN_REP_TE_ISSUES		INT4	10	0	Issue - Test of Effectiveness
81	TE_PLANS	☐	GRFN_REP_TE_PLANS		INT4	10	0	Remediation - Test of effectiveness
82	TE_CAPA_PLANS	☐	GRFN_REP_TE_CAPA_PLANS		INT4	10	0	CAPA - Test of effectiveness
83	TE_ISSUE_PRIO	☐	GRFN_REP_TE_ISSUE_PRIO	GRFN_ISSUE_PRIORITY	CHAR	1	0	Issue Priority - Test of Effectiveness (ID)
84	TE_ISSUE_PRIO_T	☐	GRFN_REP_TE_ISSUE_PRIO_T	GRFN_REP_CHAR60	CHAR	60	0	Issue Priority - Test of Effectiveness
85	.INCLUDE	☐				0	0

History

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