SAP ABAP Table GRFN_S_BI_CN_RS_ATTR (Risk and Control Matrix 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_RS_ATTR	Table Relationship Diagram
Short Description	Risk and Control Matrix 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	RE_ID	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
19	OU_ID	☐	GRFN_REP_ORGUNIT_ID	NUMC08	NUMC	8	0	Organization ID
20	PR_ID	☐	GRFN_REP_PROCESS_ID	NUMC08	NUMC	8	0	Process ID
21	SP_ID	☐	GRFN_REP_SUBPROCESS_ID	NUMC08	NUMC	8	0	Subprocess ID
22	CN_ID	☐	GRFN_REP_CONTROL_ID		CHAR	9	0	Control ID
23	RS_ID	☐	GRFN_REP_RISK_ID	CHAR9	CHAR	9	0	Risk ID
24	RS_SOURCE_TYPE	☐	GRFN_REP_RISK_SOURCE_TYPE	GRFN_RISK_SOURCE	CHAR	4	0	Risk Source Type ID
25	RS_SOURCE_T	☐	GRPC_RISK_SOURCE_TEXT	GRPC_RISK_SOURCE_TEXT	CHAR	160	0	Risk Source Text
26	.INCLUDE	☐				0	0	Control reporting attributes
27	CN_CENTRAL	☐	GRFN_REP_CONTROL_CENTRAL	NUMC08	NUMC	8	0	Central control id
28	CN_SIG	☐	GRFN_REP_CONTROL_SIG	GRFN_ATTRVALUE	CHAR	10	0	Significance ID
29	CN_IS_CONTROL	☐	GRFN_REP_CONTROL_IS_CONTROL	GRFN_XFELD	CHAR	1	0	Is Control ID
30	CN_PURP	☐	GRFN_REP_CONTROL_PURP	GRFN_ATTRVALUE	CHAR	10	0	Control Purpose ID
31	CN_MATAR	☐	GRFN_REP_CONTROL_MATAR	GRFN_ATTRVALUE	CHAR	10	0	Control Maturity Target ID
32	CN_AUTOM	☐	GRFN_REP_CONTROL_AUTOM	GRFN_ATTRVALUE	CHAR	10	0	Automation ID
33	CN_FREQ	☐	GRFN_REP_CONTROL_FREQ	GRFN_ATTRVALUE	CHAR	10	0	Frequency ID
34	CN_NATURE	☐	GRFN_REP_CONTROL_NATURE	GRFN_ATTRVALUE	CHAR	10	0	Nature ID
35	CN_TEST	☐	GRFN_REP_CONTROL_TEST	GRFN_XFELD	CHAR	1	0	Control To Be Tested ID
36	CN_TTECH	☐	GRFN_REP_CONTROL_TTECHNQ	GRFN_ATTRVALUE	CHAR	10	0	Testing Technique ID
37	CN_TSTAUT	☐	GRFN_REP_CONTROL_TEST_AUTOM	GRFN_ATTRVALUE	CHAR	10	0	Test Automation ID
38	CN_DTEVT	☐	GRFN_REP_CONTROL_DATE_EVENT	GRFN_REP_CONTROL_DATE_EVENT	CHAR	1	0	Trigger ID
39	CN_VALID_FROM	☐	GRFN_REP_CONTROL_VALID_FROM	DATUM	DATS	8	0	Valid From
40	CN_VALID_TO	☐	GRFN_REP_CONTROL_VALID_TO	DATUM	DATS	8	0	Valid to
41	CN_TEST_PLAN	☐	GRFN_REP_CONTROL_TEST_PLAN	NUMC08	NUMC	8	0	Control test plan
42	CN_ALLOW_REFER	☐	GRFN_REP_CONTROL_ALLOW_REFER	GRFN_XFELD	CHAR	1	0	Allow reference ID
43	CN_RESP_USER	☐	GRFN_REP_CONTROL_RESP_USER	GRFN_REP_RESP_USER	CHAR	12	0	Owner ID
44	CN_CATEGORY	☐	GRFN_REP_CONTROL_CATEGORY		CHAR	10	0	Control Category ID
45	CN_EVIDENCE	☐	GRFN_REP_CONTROL_EVIDENCE	GRFN_ATTRVALUE	CHAR	10	0	Level of Evidence ID
46	CN_EVIDENCE_SS	☐	GRFN_REP_CONTROL_EVIDENCE_SS	GRFN_REP_YES_NO	CHAR	1	0	Level of Evidence - System Suggested ID
47	CN_CNTR_RISK	☐	GRFN_REP_CONTROL_RISK	GRFN_ATTRVALUE	CHAR	10	0	Control Risk ID
48	CN_CNTR_RISK_SS	☐	GRFN_REP_CONTROL_RISK_SS	GRFN_REP_YES_NO	CHAR	1	0	Control Risk - System Sugested ID
49	CN_CNGROUP	☐	GRFN_REP_CONTROL_CNGROUP	GRFN_ATTRVALUE	CHAR	10	0	Control Group ID
50	CN_ORIGIN	☐	GRFN_REP_CONTROL_ORIGIN	GRFN_REP_CONTROL_ORIGIN	CHAR	1	0	Control origin ID
51	CN_SS_OU	☐	GRFN_REP_CONTROL_SS_OU	NUMC08	NUMC	8	0	Shared Service Organization ID
52	CN_SS_CN	☐	GRFN_REP_CONTROL_SS_CN		CHAR	9	0	Shared Service Control ID
53	CN_IS_MONITOR	☐	GRFN_REP_CONTROL_IS_MONITOR	GRFN_XFELD	CHAR	1	0	Is relevant for monitoring (ID)
54	CN_IS_COMPLIENC	☐	GRFN_REP_CONTROL_IS_COMPL	XFELD	CHAR	1	0	Is control relevant for compliance (ID)
55	CN_REG_SPECIFIC	☐	GRFN_REP_CONTROL_REG_SPEC	GRFN_XFELD	CHAR	1	0	Regulation Specific ID
56	.INCLUDE	☐				0	0
57	.INCLUDE	☐				0	0	Risk Entity Attribute
58	RS_VALID_FROM	☐	GRFN_REP_RISK_VALID_FROM	DATUM	DATS	8	0	Risk Valid From
59	RS_VALID_TO	☐	GRFN_REP_RISK_VALID_TO	DATUM	DATS	8	0	Risk Valid To
60	RS_RESP_USER	☐	GRFN_REP_RISK_RESP_USER	XUBNAME	CHAR	12	0	Risk Owner ID	*
61	RS_STATUS	☐	GRFN_REP_RISK_STATUS	J_ISTAT	CHAR	5	0	Risk Status ID	*
62	RS_RSA_PRL	☐	GRFN_REP_RISK_PROB_LEVEL	GRFN_REP_RISK_PROB_LEVEL	NUMC	3	0	Probability ID
63	RS_RSA_IML	☐	GRFN_REP_RISK_IMPACT_LEVEL	GRFN_IMPACT_LEVEL	NUMC	2	0	Impact Level ID	*
64	RS_RSA_RSL	☐	GRFN_REP_RISK_RISK_LEVEL	GRFN_REP_RISK_RISK_LEVEL	CHAR	4	0	Risk Level ID
65	RS_PAR_OBJTYPE	☐	GRFN_REP_PARENT_OBJTYPE	GRFN_OBJTYPE	CHAR	10	0	Parent Objtype
66	RS_PARENT	☐	GRFN_REP_RISK_PARENT		NUMC	8	0	Risk Parent ID
67	RS_CENTRAL	☐	GRFN_REP_RISK_REFCRISK		NUMC	8	0	Crisk ID
68	RS_CONTROL_ID	☐	GRFN_REP_CONTROL_ID		CHAR	9	0	Control ID
69	RS_VAL_USER	☐	GRFN_REP_RISK_VAL_USER	GRFN_REP_RESP_USER	CHAR	12	0	Risk Validated By
70	RS_VAL_DATE	☐	GRFN_REP_RISK_VAL_DATE	GRFN_DATUM	DATS	8	0	Risk Validated On
71	RS_ORGUNIT	☐	GRFN_REP_RS_ORGUNIT	NUMC08	NUMC	8	0	Reporting: Risk's Orgunit ID
72	RS_ORGUNIT_SEC	☐	GRFN_REP_ORGUNIT_SEC	NUMC08	NUMC	8	0	Secondary Organization ID
73	RS_DISTR_METHOD	☐	GRFN_REP_RS_DISTRIB_METHOD	GRRM_RISK_DISTRIB_METHOD	CHAR	1	0	Risk - distribution method (ID)
74	RS_KRI_VIOL	☐	GRFN_REP_KRI_VIOLATION	GRFN_BOOLEAN	CHAR	1	0	KRI violation
75	RS_IS_LOCAL	☐	GRFN_REP_RISK_IS_LOCAL	GRFN_BOOLEAN	CHAR	1	0	Risk - Is Local ID
76	RS_CREATED_BY	☐	GRFN_REP_RISK_CREATE_USER	XUBNAME	CHAR	12	0	Risk Created By	*
77	RS_CREATED_ON	☐	GRFN_REP_RISK_CREATED_ON		DATS	8	0	Risk Created On (Date)
78	RS_CREATED_ON_TM	☐	GRFN_REP_RISK_CREATED_ON_TM		TIMS	6	0	Risk Created On (Time)
79	RS_RISK_TYPE	☐	GRFN_REP_RISK_TYPE	GRRM_RISK_TYPE	CHAR	10	0	Risk type ID
80	RS_LEADING_FH	☐	GRFN_REP_FH_ID	GRRM_FH_ID	NUMC	6	0	Reporting: DRS5 Forecasting Horizon ID
81	RS_VAL_STATUS	☐	GRFN_REP_RISK_VAL_STS	J_ISTAT	CHAR	5	0	Risk Validation Status ID	*
82	RS_CHANGED_BY	☐	GRRM_REP_RISK_CHANGED_BY	UNAME	CHAR	12	0	Risk Changed By ID
83	RS_CHANGED_ON	☐	GRRM_REP_RISK_CHANGED_ON	DATUM	DATS	8	0	Risk Changed On
84	.INCLUDE	☐				0	0

History

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