SAP ABAP Table GRFN_S_BI_EC_ATTR_ALL_RE (Entity level 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_EC_ATTR_ALL_RE	Table Relationship Diagram
Short Description	Entity level 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	OBJID	☐	GRFN_REP_ECONTROL	NUMC08	NUMC	8	0	Indirect ELC 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	EG_ID	☐	GRFN_REP_ECGROUP	NUMC08	NUMC	8	0	iELC Group ID
22	.INCLUDE	☐				0	0	Entity level control reporting attributes
23	EC_CENTRAL	☐	GRFN_REP_ECONTROL_CENTRAL_ID	NUMC08	NUMC	8	0	Entity level control central id
24	EC_REGULATION	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
25	EC_VALIDFROM	☐	GRFN_REP_ECONTROL_VALID_FROM	DATUM	DATS	8	0	Entity level control valid from
26	EC_VALIDTO	☐	GRFN_REP_ECONTROL_VALID_TO	DATUM	DATS	8	0	Entity level control end date
27	EC_PRIOX	☐	GRFN_REP_ECONTROL_PRIOX	CHAR2	CHAR	2	0	Entity level control priox
28	EC_FREQ	☐	GRFN_REP_ECONTROL_FREQ	CHAR10	CHAR	10	0	Entity level control frequence
29	EC_TB_TESTED	☐	GRFN_REP_ECONTROL_TB_TEST	XFELD	CHAR	1	0	Entity level control to be tested
30	EC_TEST_PLAN	☐	GRFN_REP_ECONTROL_TEST_PLAN	NUMC08	NUMC	8	0	Entity level control test plan
31	.INCLUDE	☐				0	0
32	.INCLU-_MC	☐				0	0	Case's aggregation values
33	REFERENCE_MC	☐	GRFN_CASE_ID	GRFN_GUID	CHAR	32	0	Leading case GUID
34	RATING_MC	☐	GRFN_RATING	GRFN_AS_RATING	CHAR	1	0	Rating
35	STATUS_MC	☐	GRFN_CASE_STATUS	CRM_J_STATUS	CHAR	5	0	Case status
36	OPEN_ISSUES_MC	☐	GRFN_CASE_OPEN_ISSUES		INT4	10	0	Open Issues
37	ISSUES_MC	☐	GRFN_CASE_ISSUES		INT4	10	0	Issues
38	RMPLANS_MC	☐	GRFN_CASE_RMPLANS		INT4	10	0	Remmediation Plans
39	CAPAPLANS_MC	☐	GRFN_CASE_CAPAPLANS		INT4	10	0	CAPA Plans
40	ISSUE_PRIO_MC	☐	GRFN_REP_ISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Issue Priority ID
41	CASES_MC	☐	GRFN_CASE_CASES		INT4	10	0	Cases
42	CASES_FAILED_MC	☐	GRFN_CASE_CASES_FAILED		INT4	10	0	Failed Cases
43	CASES_REMED_MC	☐	GRFN_REP_CASES_REMEDIATE		INT4	10	0	Number of remediated cases
44	DUE_DATE_MC	☐	GRFN_REP_CASES_DUE_DATE	DATUM	DATS	8	0	Cases Due Date
45	.INCLU-_MT	☐				0	0	Case's aggregation values
46	REFERENCE_MT	☐	GRFN_CASE_ID	GRFN_GUID	CHAR	32	0	Leading case GUID
47	RATING_MT	☐	GRFN_RATING	GRFN_AS_RATING	CHAR	1	0	Rating
48	STATUS_MT	☐	GRFN_CASE_STATUS	CRM_J_STATUS	CHAR	5	0	Case status
49	OPEN_ISSUES_MT	☐	GRFN_CASE_OPEN_ISSUES		INT4	10	0	Open Issues
50	ISSUES_MT	☐	GRFN_CASE_ISSUES		INT4	10	0	Issues
51	RMPLANS_MT	☐	GRFN_CASE_RMPLANS		INT4	10	0	Remmediation Plans
52	CAPAPLANS_MT	☐	GRFN_CASE_CAPAPLANS		INT4	10	0	CAPA Plans
53	ISSUE_PRIO_MT	☐	GRFN_REP_ISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Issue Priority ID
54	CASES_MT	☐	GRFN_CASE_CASES		INT4	10	0	Cases
55	CASES_FAILED_MT	☐	GRFN_CASE_CASES_FAILED		INT4	10	0	Failed Cases
56	CASES_REMED_MT	☐	GRFN_REP_CASES_REMEDIATE		INT4	10	0	Number of remediated cases
57	DUE_DATE_MT	☐	GRFN_REP_CASES_DUE_DATE	DATUM	DATS	8	0	Cases Due Date
58	EVALTYP_MC	☐	GRFN_BI_EVALUATION_TYPE	GRFN_BI_EVALUATION_TYPE	CHAR	4	0	Evaluation Type
59	EVALTYP_MT	☐	GRFN_BI_EVALUATION_TYPE	GRFN_BI_EVALUATION_TYPE	CHAR	4	0	Evaluation Type

History

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