SAP ABAP Table GRFN_S_BI_OR_ATTR (Opportunity Risk 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_OR_ATTR	Table Relationship Diagram
Short Description	Opportunity Risk 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	OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
19	GUID	☐	GRFN_GUID	GRFN_GUID	CHAR	32	0	UUID of the GRC object (char32)
20	OU_ID	☐	GRFN_REP_ORGUNIT_ID	NUMC08	NUMC	8	0	Organization ID
21	AC_ID	☐	GRFN_REP_ACTIVITY_C9		CHAR	9	0	Activity ID
22	OB_ID	☐	GRFN_REP_OBJECTIVE		NUMC	8	0	Objective Id
23	AL_ID	☐	GRFN_REP_ANALYSIS_ID		CHAR	32	0	Analysis ID
24	OG_ID	☐	GRFN_REP_OPP_CAT_GROUP		NUMC	8	0	Opportunity Category Group ID
25	.INCLUDE	☐				0	0	Opportunity Risk Entity Attribute
26	OR_VALID_FROM	☐	GRFN_REP_OPP_VALID_FROM	GRFN_DATUM	DATS	8	0	Start Date
27	OR_VALID_TO	☐	GRFN_REP_OPP_VALID_TO	GRFN_DATUM	DATS	8	0	End Date
28	OR_STATUS	☐	GRFN_REP_OPP_STATUS	J_ISTAT	CHAR	5	0	Status ID	*
29	OR_RESP_USER	☐	GRFN_REP_OPP_RESP_USER	GRFN_REP_RESP_USER	CHAR	12	0	Opportunity Owner ID
30	OR_CENTRAL	☐	GRFN_REP_OPP_REFCOPP		NUMC	8	0	Central Opportunity ID
31	.INCLUDE	☐				0	0
32	.INCLUDE	☐				0	0	Attributes of analysis - opportunity
33	AL_CREATED_BY	☐	GRFN_REP_ANALYSIS_CREATE_USER	XUBNAME	CHAR	12	0	Analysis Created By	*
34	AL_CREATE_TIME	☐	GRFN_REP_ANALYSIS_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Analysis Created On
35	AL_CHANGED_BY	☐	GRFN_REP_ANALYSIS_CHANGE_USER	XUBNAME	CHAR	12	0	Analysis Last Changed By	*
36	AL_CHANGE_TIME	☐	GRFN_REP_ANALYSIS_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Analysis Last Changed On
37	AL_RESP_USER	☐	GRFN_REP_ANALYSIS_PERS_RESP	XUBNAME	CHAR	12	0	Analysis Owner	*
38	AL_STATUS	☐	GRFN_REP_ANALYSIS_STATUS	GRRM_ANALYSIS_STATUS	NUMC	2	0	Analysis Status
39	AL_CURRENCY	☐	GRFN_REP_ANALYSIS_CURRENCY	WAERS	CUKY	5	0	Currency	*
40	AL_VALID_FROM	☐	GRFN_REP_ANALYSIS_VALID_FROM		DATS	8	0	Analysis Date
41	AL_VALID_TO	☐	GRFN_REP_ANALYSIS_VALID_TO		DATS	8	0	Analysis End Date
42	AL_PROFILE_ID	☐	GRFN_REP_ANALYSIS_PROFILE_ID		CHAR	10	0	Cause & Consequence Id
43	AL_INH_PRB	☐	GRFN_REP_ANALYSIS_INH_PRB		DEC	6	4	Inherent Probability
44	AL_INH_EXL	☐	GRFN_REP_ANALYSIS_INH_EXL_O		CURR	15	2	Inherent Expected Gain
45	AL_INH_PRL	☐	GRFN_REP_ANALYSIS_INH_PRL		NUMC	3	0	Inherent Probability Level
46	AL_INH_IMN	☐	GRFN_REP_ANALYSIS_INH_IMN_O		CURR	15	2	Inherent Gain (Best Case)
47	AL_INH_IAV	☐	GRFN_REP_ANALYSIS_INH_IAV_O		CURR	15	2	Inherent Gain (Average Case)
48	AL_INH_IMX	☐	GRFN_REP_ANALYSIS_INH_IMX_O		CURR	15	2	Inherent Gain (Worst case)
49	AL_INH_IWG	☐	GRFN_REP_ANALYSIS_INH_IWG_O		CURR	15	2	Inherent Gain (Weighted)
50	AL_INH_IML	☐	GRFN_REP_ANALYSIS_INH_IML_O	GRFN_IMPACT_LEVEL	NUMC	2	0	Inherent Benefit Level ID	*
51	AL_INH_RSL	☐	GRFN_REP_ANALYSIS_INH_RSL_O		CHAR	4	0	Inherent Opportunity Level ID
52	AL_INH_RSC	☐	GRFN_REP_ANALYSIS_INH_RSC_O	GRRM_RISK_LEVEL_COLOR	CHAR	2	0	Inherent Opportunity Level colour
53	AL_INH_PRI	☐	GRFN_REP_ANALYSIS_INH_PRI_O	GRRM_RISK_PRIORITY	NUMC	3	0	Inherent Opportunity Priority ID	*
54	AL_INH_IMM	☐	GRFN_REP_ANALYSIS_INH_IMM_O		CURR	15	2	Inherent Total Gain
55	AL_RSP_PRB	☐	GRFN_REP_ANALYSIS_RSP_PRB		DEC	6	4	Planned Probability
56	AL_RSP_EXL	☐	GRFN_REP_ANALYSIS_RSP_EXL_O		CURR	15	2	Planned Expected Gain
57	AL_RSP_PRL	☐	GRFN_REP_ANALYSIS_RSP_PRL		NUMC	3	0	Planned Probabaility Level ID
58	AL_RSP_IMN	☐	GRFN_REP_ANALYSIS_RSP_IMN_O		CURR	15	2	Planned Gain (Best Case)
59	AL_RSP_IAV	☐	GRFN_REP_ANALYSIS_RSP_IAV_O		CURR	15	2	Planned Gain (Average Case)
60	AL_RSP_IMX	☐	GRFN_REP_ANALYSIS_RSP_IMX_O		CURR	15	2	Planned Gain (Worst Case)
61	AL_RSP_IWG	☐	GRFN_REP_ANALYSIS_RSP_IWG_O		CURR	15	2	Planned Gain (Weighted)
62	AL_RSP_IML	☐	GRFN_REP_ANALYSIS_RSP_IML_O	GRFN_IMPACT_LEVEL	NUMC	2	0	Planned Benefit Level ID	*
63	AL_RSP_RSL	☐	GRFN_REP_ANALYSIS_RSP_RSL_O		CHAR	4	0	Planned Opportunity Level ID
64	AL_RSP_RSC	☐	GRFN_REP_ANALYSIS_RSP_RSC_O	GRRM_RISK_LEVEL_COLOR	CHAR	2	0	Planned Opportunity Level Colour
65	AL_RSP_PRI	☐	GRFN_REP_ANALYSIS_RSP_PRI_O	GRRM_RISK_PRIORITY	NUMC	3	0	Planned Opportunity Priority ID	*
66	AL_RSP_IMM	☐	GRFN_REP_ANALYSIS_RSP_IMM_O		CURR	15	2	Planned Total Gain
67	AL_RSA_PRB	☐	GRFN_REP_ANALYSIS_RSA_PRB_O		DEC	6	4	Enhanced Probability
68	AL_RSA_EXL	☐	GRFN_REP_ANALYSIS_RSA_EXL_O		CURR	15	2	Enhanced Expected Gain
69	AL_RSA_PRL	☐	GRFN_REP_ANALYSIS_RSA_PRL_O		NUMC	3	0	Enhanced Probability Level
70	AL_RSA_IMN	☐	GRFN_REP_ANALYSIS_RSA_IMN_O		CURR	15	2	Enhanced Gain (Best Case)
71	AL_RSA_IAV	☐	GRFN_REP_ANALYSIS_RSA_IAV_O		CURR	15	2	Enhanced Gain (Average Case)
72	AL_RSA_IMX	☐	GRFN_REP_ANALYSIS_RSA_IMX_O		CURR	15	2	Enhanced Gain (Worst Case)
73	AL_RSA_IWG	☐	GRFN_REP_ANALYSIS_RSA_IWG_O		CURR	15	2	Enhanced Gain (Weighted)
74	AL_RSA_IML	☐	GRFN_REP_ANALYSIS_RSA_IML_O	GRFN_IMPACT_LEVEL	NUMC	2	0	Enhanced Benefit Level ID	*
75	AL_RSA_RSL	☐	GRFN_REP_ANALYSIS_RSA_RSL_O		CHAR	4	0	Enhanced Opportunity Level ID
76	AL_RSA_RSC	☐	GRFN_REP_ANALYSIS_RSA_RSC_O	GRRM_RISK_LEVEL_COLOR	CHAR	2	0	Enhanced Opportunity Level Colour
77	AL_RSA_PRI	☐	GRFN_REP_ANALYSIS_RSA_PRI_O	GRRM_RISK_PRIORITY	NUMC	3	0	Enhanced Opportunity Priority ID	*
78	AL_RSA_IMM	☐	GRFN_REP_ANALYSIS_RSA_IMM_O		CURR	15	2	Enhanced Total Gain

History

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