SAP ABAP Table GRFN_S_BI_CN_ATTR (Control attributes for extraction)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC (Application Component) Governance, Risk and Compliance
     ⤷ GRFN_EXTRACTION (Package) PC-RM BI Extraction

Basic Data

Table Category	INTTAB	Structure
Structure	GRFN_S_BI_CN_ATTR	Table Relationship Diagram
Short Description	Control attributes for extraction

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	.INCLUDE	☐				0	0	Common part of data source structures
2	.INCLUDE	☐				0	0	Details about extraction
3	SNAPSHOT_ID	☐	GRFN_DM_SNAPSHOT_ID	SYSUUID_C	CHAR	32	0	Datamart - Snapshot ID
4	TIMESTAMP	☐	GRFN_TIMESTAMP	GRFN_TIMESTAMP	DEC	15	0	Time Stamp
5	DB_TABLE	☐	GRFN_TABNAME		CHAR	30	0	Table name
6	.INCLUDE	☐				0	0	Timeframe info for extraction
7	TF_YEAR	☐	GRFN_TF_YEAR	GRFN_TF_YEAR	CHAR	4	0	Timeframe Year
8	TIMEFRAME	☐	GRFN_TIMEFRAME	GRFN_TIMEFRAME	CHAR	10	0	Timeframe	*
9	TF_FREQ	☐	GRFN_TF_FREQUENCY	GRFN_TF_FREQUENCY	CHAR	10	0	Timeframe Frequency	*
10	DATEFROM	☐	GRFN_DATE_FROM	GRFN_DATE_FROM	DATS	8	0	Valid from Date
11	DATETO	☐	GRFN_DATE_TO	GRFN_DATE_TO	DATS	8	0	Valid to Date
12	TF_ID	☐	GRFN_BI_TF_ID	GRFN_BI_TF_ID	CHAR	32	0	Compounded timeframe ID
13	.INCLUDE	☐				0	0	Object info for extraction
14	OBJECT_ID	☐	GRFN_API_OBJECT_ID	CHAR50	CHAR	50	0	Object ID
15	ENTITY_ID	☐	GRFN_API_ENTITY_ID	GRFN_API_ENTITY_ID	CHAR	20	0	Entity ID	*
16	OBJECT_KEY	☐	GRFN_API_TECHNAME_ID	GRFN_API_TECHNAME_ID	CHAR	50	0	Object's technical name
17	SHORT_ENTITY_ID	☐	GRFN_SHORT_ENTITY_ID	CHAR2	CHAR	2	0	Shor Entity ID (used in DM)
18	CN_ID	☐	GRFN_REP_CONTROL_ID		CHAR	9	0	Control ID
19	RE_ID	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
20	OU_ID	☐	GRFN_REP_ORGUNIT_ID	NUMC08	NUMC	8	0	Organization ID
21	SP_ID	☐	GRFN_REP_SUBPROCESS_ID	NUMC08	NUMC	8	0	Subprocess ID
22	SP_CENTRAL	☐	GRFN_REP_SUBPROCESS_ID	NUMC08	NUMC	8	0	Subprocess ID
23	.INCLUDE	☐				0	0	Control reporting attributes
24	CN_CENTRAL	☐	GRFN_REP_CONTROL_CENTRAL	NUMC08	NUMC	8	0	Central control id
25	CN_SIG	☐	GRFN_REP_CONTROL_SIG	GRFN_ATTRVALUE	CHAR	10	0	Significance ID
26	CN_IS_CONTROL	☐	GRFN_REP_CONTROL_IS_CONTROL	GRFN_XFELD	CHAR	1	0	Is Control ID
27	CN_PURP	☐	GRFN_REP_CONTROL_PURP	GRFN_ATTRVALUE	CHAR	10	0	Control Purpose ID
28	CN_MATAR	☐	GRFN_REP_CONTROL_MATAR	GRFN_ATTRVALUE	CHAR	10	0	Control Maturity Target ID
29	CN_AUTOM	☐	GRFN_REP_CONTROL_AUTOM	GRFN_ATTRVALUE	CHAR	10	0	Automation ID
30	CN_FREQ	☐	GRFN_REP_CONTROL_FREQ	GRFN_ATTRVALUE	CHAR	10	0	Frequency ID
31	CN_NATURE	☐	GRFN_REP_CONTROL_NATURE	GRFN_ATTRVALUE	CHAR	10	0	Nature ID
32	CN_TEST	☐	GRFN_REP_CONTROL_TEST	GRFN_XFELD	CHAR	1	0	Control To Be Tested ID
33	CN_TTECH	☐	GRFN_REP_CONTROL_TTECHNQ	GRFN_ATTRVALUE	CHAR	10	0	Testing Technique ID
34	CN_TSTAUT	☐	GRFN_REP_CONTROL_TEST_AUTOM	GRFN_ATTRVALUE	CHAR	10	0	Test Automation ID
35	CN_DTEVT	☐	GRFN_REP_CONTROL_DATE_EVENT	GRFN_REP_CONTROL_DATE_EVENT	CHAR	1	0	Trigger ID
36	CN_VALID_FROM	☐	GRFN_REP_CONTROL_VALID_FROM	DATUM	DATS	8	0	Valid From
37	CN_VALID_TO	☐	GRFN_REP_CONTROL_VALID_TO	DATUM	DATS	8	0	Valid to
38	CN_TEST_PLAN	☐	GRFN_REP_CONTROL_TEST_PLAN	NUMC08	NUMC	8	0	Control test plan
39	CN_ALLOW_REFER	☐	GRFN_REP_CONTROL_ALLOW_REFER	GRFN_XFELD	CHAR	1	0	Allow reference ID
40	CN_RESP_USER	☐	GRFN_REP_CONTROL_RESP_USER	GRFN_REP_RESP_USER	CHAR	12	0	Owner ID
41	CN_CATEGORY	☐	GRFN_REP_CONTROL_CATEGORY		CHAR	10	0	Control Category ID
42	CN_EVIDENCE	☐	GRFN_REP_CONTROL_EVIDENCE	GRFN_ATTRVALUE	CHAR	10	0	Level of Evidence ID
43	CN_EVIDENCE_SS	☐	GRFN_REP_CONTROL_EVIDENCE_SS	GRFN_REP_YES_NO	CHAR	1	0	Level of Evidence - System Suggested ID
44	CN_CNTR_RISK	☐	GRFN_REP_CONTROL_RISK	GRFN_ATTRVALUE	CHAR	10	0	Control Risk ID
45	CN_CNTR_RISK_SS	☐	GRFN_REP_CONTROL_RISK_SS	GRFN_REP_YES_NO	CHAR	1	0	Control Risk - System Sugested ID
46	CN_CNGROUP	☐	GRFN_REP_CONTROL_CNGROUP	GRFN_ATTRVALUE	CHAR	10	0	Control Group ID
47	CN_ORIGIN	☐	GRFN_REP_CONTROL_ORIGIN	GRFN_REP_CONTROL_ORIGIN	CHAR	1	0	Control origin ID
48	CN_SS_OU	☐	GRFN_REP_CONTROL_SS_OU	NUMC08	NUMC	8	0	Shared Service Organization ID
49	CN_SS_CN_ID	☐	GRFN_REP_CONTROL_SS_CN_ID		NUMC	8	0	Shared Service Control HR ID
50	CN_SS_CN	☐	GRFN_REP_CONTROL_SS_CN		CHAR	9	0	Shared Service Control ID
51	.INCLUDE	☐				0	0
52	.INCLU-_CD	☐				0	0	Case's aggregation values
53	REFERENCE_CD	☐	GRFN_CASE_ID	GRFN_GUID	CHAR	32	0	Leading case GUID
54	RATING_CD	☐	GRFN_RATING	GRFN_AS_RATING	CHAR	1	0	Rating
55	STATUS_CD	☐	GRFN_CASE_STATUS	CRM_J_STATUS	CHAR	5	0	Case status
56	OPEN_ISSUES_CD	☐	GRFN_CASE_OPEN_ISSUES		INT4	10	0	Open Issues
57	ISSUES_CD	☐	GRFN_CASE_ISSUES		INT4	10	0	Issues
58	RMPLANS_CD	☐	GRFN_CASE_RMPLANS		INT4	10	0	Remmediation Plans
59	CAPAPLANS_CD	☐	GRFN_CASE_CAPAPLANS		INT4	10	0	CAPA Plans
60	ISSUE_PRIO_CD	☐	GRFN_REP_ISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Issue Priority ID
61	CASES_CD	☐	GRFN_CASE_CASES		INT4	10	0	Cases
62	CASES_FAILED_CD	☐	GRFN_CASE_CASES_FAILED		INT4	10	0	Failed Cases
63	CASES_REMED_CD	☐	GRFN_REP_CASES_REMEDIATE		INT4	10	0	Number of remediated cases
64	DUE_DATE_CD	☐	GRFN_REP_CASES_DUE_DATE	DATUM	DATS	8	0	Cases Due Date
65	.INCLU-_CE	☐				0	0	Case's aggregation values
66	REFERENCE_CE	☐	GRFN_CASE_ID	GRFN_GUID	CHAR	32	0	Leading case GUID
67	RATING_CE	☐	GRFN_RATING	GRFN_AS_RATING	CHAR	1	0	Rating
68	STATUS_CE	☐	GRFN_CASE_STATUS	CRM_J_STATUS	CHAR	5	0	Case status
69	OPEN_ISSUES_CE	☐	GRFN_CASE_OPEN_ISSUES		INT4	10	0	Open Issues
70	ISSUES_CE	☐	GRFN_CASE_ISSUES		INT4	10	0	Issues
71	RMPLANS_CE	☐	GRFN_CASE_RMPLANS		INT4	10	0	Remmediation Plans
72	CAPAPLANS_CE	☐	GRFN_CASE_CAPAPLANS		INT4	10	0	CAPA Plans
73	ISSUE_PRIO_CE	☐	GRFN_REP_ISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Issue Priority ID
74	CASES_CE	☐	GRFN_CASE_CASES		INT4	10	0	Cases
75	CASES_FAILED_CE	☐	GRFN_CASE_CASES_FAILED		INT4	10	0	Failed Cases
76	CASES_REMED_CE	☐	GRFN_REP_CASES_REMEDIATE		INT4	10	0	Number of remediated cases
77	DUE_DATE_CE	☐	GRFN_REP_CASES_DUE_DATE	DATUM	DATS	8	0	Cases Due Date
78	.INCLU-_MO	☐				0	0	Case's aggregation values
79	REFERENCE_MO	☐	GRFN_CASE_ID	GRFN_GUID	CHAR	32	0	Leading case GUID
80	RATING_MO	☐	GRFN_RATING	GRFN_AS_RATING	CHAR	1	0	Rating
81	STATUS_MO	☐	GRFN_CASE_STATUS	CRM_J_STATUS	CHAR	5	0	Case status
82	OPEN_ISSUES_MO	☐	GRFN_CASE_OPEN_ISSUES		INT4	10	0	Open Issues
83	ISSUES_MO	☐	GRFN_CASE_ISSUES		INT4	10	0	Issues
84	RMPLANS_MO	☐	GRFN_CASE_RMPLANS		INT4	10	0	Remmediation Plans
85	CAPAPLANS_MO	☐	GRFN_CASE_CAPAPLANS		INT4	10	0	CAPA Plans
86	ISSUE_PRIO_MO	☐	GRFN_REP_ISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Issue Priority ID
87	CASES_MO	☐	GRFN_CASE_CASES		INT4	10	0	Cases
88	CASES_FAILED_MO	☐	GRFN_CASE_CASES_FAILED		INT4	10	0	Failed Cases
89	CASES_REMED_MO	☐	GRFN_REP_CASES_REMEDIATE		INT4	10	0	Number of remediated cases
90	DUE_DATE_MO	☐	GRFN_REP_CASES_DUE_DATE	DATUM	DATS	8	0	Cases Due Date
91	.INCLU-_TE	☐				0	0	Case's aggregation values
92	REFERENCE_TE	☐	GRFN_CASE_ID	GRFN_GUID	CHAR	32	0	Leading case GUID
93	RATING_TE	☐	GRFN_RATING	GRFN_AS_RATING	CHAR	1	0	Rating
94	STATUS_TE	☐	GRFN_CASE_STATUS	CRM_J_STATUS	CHAR	5	0	Case status
95	OPEN_ISSUES_TE	☐	GRFN_CASE_OPEN_ISSUES		INT4	10	0	Open Issues
96	ISSUES_TE	☐	GRFN_CASE_ISSUES		INT4	10	0	Issues
97	RMPLANS_TE	☐	GRFN_CASE_RMPLANS		INT4	10	0	Remmediation Plans
98	CAPAPLANS_TE	☐	GRFN_CASE_CAPAPLANS		INT4	10	0	CAPA Plans
99	ISSUE_PRIO_TE	☐	GRFN_REP_ISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Issue Priority ID
100	CASES_TE	☐	GRFN_CASE_CASES		INT4	10	0	Cases
101	CASES_FAILED_TE	☐	GRFN_CASE_CASES_FAILED		INT4	10	0	Failed Cases
102	CASES_REMED_TE	☐	GRFN_REP_CASES_REMEDIATE		INT4	10	0	Number of remediated cases
103	DUE_DATE_TE	☐	GRFN_REP_CASES_DUE_DATE	DATUM	DATS	8	0	Cases Due Date
104	EVALTYP_CD	☐	GRFN_BI_EVALUATION_TYPE	GRFN_BI_EVALUATION_TYPE	CHAR	4	0	Evaluation Type
105	EVALTYP_CE	☐	GRFN_BI_EVALUATION_TYPE	GRFN_BI_EVALUATION_TYPE	CHAR	4	0	Evaluation Type
106	EVALTYP_MO	☐	GRFN_BI_EVALUATION_TYPE	GRFN_BI_EVALUATION_TYPE	CHAR	4	0	Evaluation Type
107	EVALTYP_TE	☐	GRFN_BI_EVALUATION_TYPE	GRFN_BI_EVALUATION_TYPE	CHAR	4	0	Evaluation Type

History

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