SAP ABAP Table GRFN_S_BI_AL_ATTR (Analysis 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_AL_ATTR	Table Relationship Diagram
Short Description	Analysis 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	OR_ID	☐	GRFN_REP_OPPORTUNITY		NUMC	8	0	Opportunity ID
22	RS_ID	☐	GRFN_REP_RISK_ID	CHAR9	CHAR	9	0	Risk ID
23	.INCLUDE	☐				0	0	domain specific attributes of analysis for reporting
24	AL_CREATED_BY	☐	GRFN_REP_ANALYSIS_CREATE_USER	XUBNAME	CHAR	12	0	Analysis Created By	*
25	AL_CREATE_TIME	☐	GRFN_REP_ANALYSIS_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Analysis Created On
26	AL_CHANGED_BY	☐	GRFN_REP_ANALYSIS_CHANGE_USER	XUBNAME	CHAR	12	0	Analysis Last Changed By	*
27	AL_CHANGE_TIME	☐	GRFN_REP_ANALYSIS_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Analysis Last Changed On
28	AL_RESP_USER	☐	GRFN_REP_ANALYSIS_PERS_RESP	XUBNAME	CHAR	12	0	Analysis Owner	*
29	AL_STATUS	☐	GRFN_REP_ANALYSIS_STATUS	GRRM_ANALYSIS_STATUS	NUMC	2	0	Analysis Status
30	AL_CURRENCY	☐	GRFN_REP_ANALYSIS_CURRENCY	WAERS	CUKY	5	0	Currency	*
31	AL_VALID_FROM	☐	GRFN_REP_ANALYSIS_VALID_FROM		DATS	8	0	Analysis Date
32	AL_VALID_TO	☐	GRFN_REP_ANALYSIS_VALID_TO		DATS	8	0	Analysis End Date
33	AL_PROFILE_ID	☐	GRFN_REP_ANALYSIS_PROFILE_ID		CHAR	10	0	Cause & Consequence Id
34	AL_INH_PRB	☐	GRFN_REP_ANALYSIS_INH_PRB		DEC	6	4	Inherent Probability
35	AL_INH_EXL	☐	GRFN_REP_ANALYSIS_INH_EXL		CURR	15	2	Inherent Expected Loss
36	AL_INH_PRL	☐	GRFN_REP_ANALYSIS_INH_PRL		NUMC	3	0	Inherent Probability Level
37	AL_INH_IMN	☐	GRFN_REP_ANALYSIS_INH_IMN		CURR	15	2	Inherent Impact (Best Case)
38	AL_INH_IAV	☐	GRFN_REP_ANALYSIS_INH_IAV		CURR	15	2	Inherent Impact (Average Case)
39	AL_INH_IMX	☐	GRFN_REP_ANALYSIS_INH_IMX		CURR	15	2	Inherent Impact (Worst case)
40	AL_INH_IWG	☐	GRFN_REP_ANALYSIS_INH_IWG		CURR	15	2	Inherent Impact (Weighted)
41	AL_INH_IML	☐	GRFN_REP_ANALYSIS_INH_IML	GRFN_IMPACT_LEVEL	NUMC	2	0	Inherent Impact Level ID	*
42	AL_INH_RSL	☐	GRFN_REP_ANALYSIS_INH_RSL		CHAR	4	0	Inherent Risk Level ID
43	AL_INH_RSC	☐	GRFN_REP_ANALYSIS_INH_RSC	GRRM_RISK_LEVEL_COLOR	CHAR	2	0	Inherent Risk Level colour
44	AL_INH_PRI	☐	GRFN_REP_ANALYSIS_INH_PRI	GRRM_RISK_PRIORITY	NUMC	3	0	Inherent Risk Priority ID	*
45	AL_INH_IMM	☐	GRFN_REP_ANALYSIS_INH_IMM		CURR	15	2	Inherent Total Loss
46	AL_RSP_PRB	☐	GRFN_REP_ANALYSIS_RSP_PRB		DEC	6	4	Planned Probability
47	AL_RSP_EXL	☐	GRFN_REP_ANALYSIS_RSP_EXL		CURR	15	2	Planned Expected Loss
48	AL_RSP_PRL	☐	GRFN_REP_ANALYSIS_RSP_PRL		NUMC	3	0	Planned Probabaility Level ID
49	AL_RSP_IMN	☐	GRFN_REP_ANALYSIS_RSP_IMN		CURR	15	2	Planned Impact (Best Case)
50	AL_RSP_IAV	☐	GRFN_REP_ANALYSIS_RSP_IAV		CURR	15	2	Planned Impact (Average Case)
51	AL_RSP_IMX	☐	GRFN_REP_ANALYSIS_RSP_IMX		CURR	15	2	Planned Impact (Worst Case)
52	AL_RSP_IWG	☐	GRFN_REP_ANALYSIS_RSP_IWG		CURR	15	2	Planned Impact (Weighted)
53	AL_RSP_IML	☐	GRFN_REP_ANALYSIS_RSP_IML	GRFN_IMPACT_LEVEL	NUMC	2	0	Planned Impact Level ID	*
54	AL_RSP_RSL	☐	GRFN_REP_ANALYSIS_RSP_RSL		CHAR	4	0	Planned Risk Level ID
55	AL_RSP_RSC	☐	GRFN_REP_ANALYSIS_RSP_RSC	GRRM_RISK_LEVEL_COLOR	CHAR	2	0	Planned Risk Level Colour
56	AL_RSP_PRI	☐	GRFN_REP_ANALYSIS_RSP_PRI	GRRM_RISK_PRIORITY	NUMC	3	0	Planned Risk Priority ID	*
57	AL_RSP_IMM	☐	GRFN_REP_ANALYSIS_RSP_IMM		CURR	15	2	Planned Total Loss
58	AL_RSA_PRB	☐	GRFN_REP_ANALYSIS_RSA_PRB		DEC	6	4	Residual Probability
59	AL_RSA_EXL	☐	GRFN_REP_ANALYSIS_RSA_EXL		CURR	15	2	Residual Expected Loss
60	AL_RSA_PRL	☐	GRFN_REP_ANALYSIS_RSA_PRL		NUMC	3	0	Residual Probability Level ID
61	AL_RSA_IMN	☐	GRFN_REP_ANALYSIS_RSA_IMN		CURR	15	2	Residual Impact (Best Case)
62	AL_RSA_IAV	☐	GRFN_REP_ANALYSIS_RSA_IAV		CURR	15	2	Residual Impact (Average Case)
63	AL_RSA_IMX	☐	GRFN_REP_ANALYSIS_RSA_IMX		CURR	15	2	Residual Impact (Worst Case)
64	AL_RSA_IWG	☐	GRFN_REP_ANALYSIS_RSA_IWG		CURR	15	2	Residual Impact (Weighted)
65	AL_RSA_IML	☐	GRFN_REP_ANALYSIS_RSA_IML	GRFN_IMPACT_LEVEL	NUMC	2	0	Residual Impact Level ID	*
66	AL_RSA_RSL	☐	GRFN_REP_ANALYSIS_RSA_RSL		CHAR	4	0	Residual Risk Level ID
67	AL_RSA_RSC	☐	GRFN_REP_ANALYSIS_RSA_RSC	GRRM_RISK_LEVEL_COLOR	CHAR	2	0	Residual Risk Level Colour
68	AL_RSA_PRI	☐	GRFN_REP_ANALYSIS_RSA_PRI	GRRM_RISK_PRIORITY	NUMC	3	0	Residual Risk Priority ID	*
69	AL_RSA_IMM	☐	GRFN_REP_ANALYSIS_RSA_IMM		CURR	15	2	Residual Total Loss

History

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