SAP ABAP Table GRFNDMAL (DataMart: Analysis)

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	TRANSP	Transparent table
Transparent table	GRFNDMAL	Table Relationship Diagram
Short Description	DataMart: Analysis

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SNAPSHOT_ID	☑	GRFN_DM_SNAPSHOT_ID	SYSUUID_C	CHAR	32	0	Datamart - Snapshot ID
3	OBJECT_ID	☑	GRFN_API_OBJECT_ID	CHAR50	CHAR	50	0	Object ID
4	AL	☐	GRFN_REP_ANALYSIS_ID		CHAR	32	0	Analysis ID
5	.INCLUDE	☐				0	0	domain specific attributes of analysis for reporting
6	AL_CREATED_BY	☐	GRFN_REP_ANALYSIS_CREATE_USER	XUBNAME	CHAR	12	0	Analysis Created By	*
7	AL_CREATE_TIME	☐	GRFN_REP_ANALYSIS_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Analysis Created On
8	AL_CHANGED_BY	☐	GRFN_REP_ANALYSIS_CHANGE_USER	XUBNAME	CHAR	12	0	Analysis Last Changed By	*
9	AL_CHANGE_TIME	☐	GRFN_REP_ANALYSIS_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Analysis Last Changed On
10	AL_RESP_USER	☐	GRFN_REP_ANALYSIS_PERS_RESP	XUBNAME	CHAR	12	0	Analysis Owner	*
11	AL_STATUS	☐	GRFN_REP_ANALYSIS_STATUS	GRRM_ANALYSIS_STATUS	NUMC	2	0	Analysis Status
12	AL_CURRENCY	☐	GRFN_REP_ANALYSIS_CURRENCY	WAERS	CUKY	5	0	Currency	*
13	AL_VALID_FROM	☐	GRFN_REP_ANALYSIS_VALID_FROM		DATS	8	0	Analysis Date
14	AL_VALID_TO	☐	GRFN_REP_ANALYSIS_VALID_TO		DATS	8	0	Analysis End Date
15	AL_PROFILE_ID	☐	GRFN_REP_ANALYSIS_PROFILE_ID		CHAR	10	0	Cause & Consequence Id
16	AL_FH_ID	☐	GRFN_REP_FH_ID	GRRM_FH_ID	NUMC	6	0	Reporting: DRS5 Forecasting Horizon ID
17	AL_INH_FRQ	☐	GRFN_REP_ANALYSIS_INH_FRQ	GRFN_FREQUENCY	DEC	13	5	Inherent Frequency
18	AL_INH_PRB	☐	GRFN_REP_ANALYSIS_INH_PRB		DEC	6	4	Inherent Probability
19	AL_INH_PRS	☐	GRFN_REP_ANALYSIS_INH_PRS	GRFN_SCORE	DEC	13	5	Inherent Probability Score
20	AL_INH_SOO	☐	GRFN_REP_ANALYSIS_INH_SOO	GRRM_SPEED_OF_ONSET	CHAR	4	0	Inherent Speed of Onset ID	*
21	AL_INH_SOS	☐	GRFN_REP_ANALYSIS_INH_SOS	GRFN_SCORE	DEC	13	5	Inherent Speed of Onset Score
22	AL_INH_EXL	☐	GRFN_REP_ANALYSIS_INH_EXL		CURR	15	2	Inherent Expected Loss
23	AL_INH_PRL	☐	GRFN_REP_ANALYSIS_INH_PRL		NUMC	3	0	Inherent Probability Level
24	AL_INH_IMN	☐	GRFN_REP_ANALYSIS_INH_IMN		CURR	15	2	Inherent Impact (Best Case)
25	AL_INH_IAV	☐	GRFN_REP_ANALYSIS_INH_IAV		CURR	15	2	Inherent Impact (Average Case)
26	AL_INH_IMX	☐	GRFN_REP_ANALYSIS_INH_IMX		CURR	15	2	Inherent Impact (Worst case)
27	AL_INH_IWG	☐	GRFN_REP_ANALYSIS_INH_IWG		CURR	15	2	Inherent Impact (Weighted)
28	AL_INH_IML	☐	GRFN_REP_ANALYSIS_INH_IML	GRFN_IMPACT_LEVEL	NUMC	2	0	Inherent Impact Level ID	*
29	AL_INH_IMS	☐	GRFN_REP_ANALYSIS_INH_IMS	GRFN_SCORE	DEC	13	5	Inherent Impact Score
30	AL_INH_RSL	☐	GRFN_REP_ANALYSIS_INH_RSL		CHAR	4	0	Inherent Risk Level ID
31	AL_INH_RSC	☐	GRFN_REP_ANALYSIS_INH_RSC	GRRM_RISK_LEVEL_COLOR	CHAR	2	0	Inherent Risk Level colour
32	AL_INH_RSS	☐	GRFN_REP_ANALYSIS_INH_RSS	GRFN_SCORE	DEC	13	5	Inherent Risk Score
33	AL_INH_PRI	☐	GRFN_REP_ANALYSIS_INH_PRI	GRRM_RISK_PRIORITY	NUMC	3	0	Inherent Risk Priority ID	*
34	AL_INH_IMM	☐	GRFN_REP_ANALYSIS_INH_IMM		CURR	15	2	Inherent Total Loss
35	AL_INH_OVR	☐	GRFN_REP_ANALYSIS_INH_OVR	GRFN_BOOLEAN	CHAR	1	0	Reporting: Inherent Impact Overwritten
36	AL_RSP_FRQ	☐	GRFN_REP_ANALYSIS_RSP_FRQ	GRFN_FREQUENCY	DEC	13	5	Residual Planned Frequency
37	AL_RSP_PRB	☐	GRFN_REP_ANALYSIS_RSP_PRB		DEC	6	4	Planned Probability
38	AL_RSP_PRS	☐	GRFN_REP_ANALYSIS_RSP_PRS	GRFN_SCORE	DEC	13	5	Planned Probability Score
39	AL_RSP_SOO	☐	GRFN_REP_ANALYSIS_RSP_SOO	GRRM_SPEED_OF_ONSET	CHAR	4	0	Planned Speed of Onset ID	*
40	AL_RSP_SOS	☐	GRFN_REP_ANALYSIS_RSP_SOS	GRFN_SCORE	DEC	13	5	Planned Speed of Onset Score
41	AL_RSP_EXL	☐	GRFN_REP_ANALYSIS_RSP_EXL		CURR	15	2	Planned Expected Loss
42	AL_RSP_PRL	☐	GRFN_REP_ANALYSIS_RSP_PRL		NUMC	3	0	Planned Probabaility Level ID
43	AL_RSP_IMN	☐	GRFN_REP_ANALYSIS_RSP_IMN		CURR	15	2	Planned Impact (Best Case)
44	AL_RSP_IAV	☐	GRFN_REP_ANALYSIS_RSP_IAV		CURR	15	2	Planned Impact (Average Case)
45	AL_RSP_IMX	☐	GRFN_REP_ANALYSIS_RSP_IMX		CURR	15	2	Planned Impact (Worst Case)
46	AL_RSP_IWG	☐	GRFN_REP_ANALYSIS_RSP_IWG		CURR	15	2	Planned Impact (Weighted)
47	AL_RSP_IML	☐	GRFN_REP_ANALYSIS_RSP_IML	GRFN_IMPACT_LEVEL	NUMC	2	0	Planned Impact Level ID	*
48	AL_RSP_IMS	☐	GRFN_REP_ANALYSIS_RSP_IMS	GRFN_SCORE	DEC	13	5	Planned Impact Score
49	AL_RSP_RSL	☐	GRFN_REP_ANALYSIS_RSP_RSL		CHAR	4	0	Planned Risk Level ID
50	AL_RSP_RSS	☐	GRFN_REP_ANALYSIS_RSP_RSS	GRFN_SCORE	DEC	13	5	Planned Risk Score
51	AL_RSP_RSC	☐	GRFN_REP_ANALYSIS_RSP_RSC	GRRM_RISK_LEVEL_COLOR	CHAR	2	0	Planned Risk Level Colour
52	AL_RSP_PRI	☐	GRFN_REP_ANALYSIS_RSP_PRI	GRRM_RISK_PRIORITY	NUMC	3	0	Planned Risk Priority ID	*
53	AL_RSP_IMM	☐	GRFN_REP_ANALYSIS_RSP_IMM		CURR	15	2	Planned Total Loss
54	AL_RSA_FRQ	☐	GRFN_REP_ANALYSIS_RSA_FRQ	GRFN_FREQUENCY	DEC	13	5	Residual Frequency
55	AL_RSA_PRB	☐	GRFN_REP_ANALYSIS_RSA_PRB		DEC	6	4	Residual Probability
56	AL_RSA_EXL	☐	GRFN_REP_ANALYSIS_RSA_EXL		CURR	15	2	Residual Expected Loss
57	AL_RSA_PRL	☐	GRFN_REP_ANALYSIS_RSA_PRL		NUMC	3	0	Residual Probability Level ID
58	AL_RSA_PRS	☐	GRFN_REP_ANALYSIS_RSA_PRS	GRFN_SCORE	DEC	13	5	Residual Probability Score
59	AL_RSA_SOO	☐	GRFN_REP_ANALYSIS_RSA_SOO	GRRM_SPEED_OF_ONSET	CHAR	4	0	Residual Speed of Onset ID	*
60	AL_RSA_SOS	☐	GRFN_REP_ANALYSIS_RSA_SOS	GRFN_SCORE	DEC	13	5	Residual Speed of Onset Score
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_IMS	☐	GRFN_REP_ANALYSIS_RSA_IMS	GRFN_SCORE	DEC	13	5	Residual Impact Score
67	AL_RSA_RSL	☐	GRFN_REP_ANALYSIS_RSA_RSL		CHAR	4	0	Residual Risk Level ID
68	AL_RSA_RSC	☐	GRFN_REP_ANALYSIS_RSA_RSC	GRRM_RISK_LEVEL_COLOR	CHAR	2	0	Residual Risk Level Colour
69	AL_RSA_RSS	☐	GRFN_REP_ANALYSIS_RSA_RSS	GRFN_SCORE	DEC	13	5	Residual Risk Score
70	AL_RSA_PRI	☐	GRFN_REP_ANALYSIS_RSA_PRI	GRRM_RISK_PRIORITY	NUMC	3	0	Residual Risk Priority ID	*
71	AL_RSA_IMM	☐	GRFN_REP_ANALYSIS_RSA_IMM		CURR	15	2	Residual Total Loss
72	AL_RSA_OVR	☐	GRFN_REP_ANALYSIS_RSA_OVR	GRFN_BOOLEAN	CHAR	1	0	Reporting: Residual Impact Overwritten
73	AL_ANA_TYPE_IN	☐	GRRM_ANALYSIS_TYPE_IN	GRRM_RC_BOOLEAN	CHAR	1	0	Analysis Type - Inherent
74	AL_ANA_TYPE_RE	☐	GRRM_ANALYSIS_TYPE_RE	GRRM_RC_BOOLEAN	CHAR	1	0	Analysis Type - Residual
75	AL_ANA_TYPE_RP	☐	GRRM_ANALYSIS_TYPE_RP	GRRM_RC_BOOLEAN	CHAR	1	0	Analysis Type - Residual (Planned)

History

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