SAP ABAP Table GRFN_S_BI_SP_ATTR_ALL_REGS (Sub process 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_SP_ATTR_ALL_REGS	Table Relationship Diagram
Short Description	Sub process 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_SUBPROCESS_ID	NUMC08	NUMC	8	0	Subprocess 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	PR_ID	☐	GRFN_REP_PROCESS_ID	NUMC08	NUMC	8	0	Process ID
22	.INCLUDE	☐				0	0	Sub process attributes for reporting
23	SP_CENTRAL	☐	GRFN_REP_SUBPROCESS_ASSIGNED	NUMC08	NUMC	8	0	Assigned subprocess
24	SP_REGULATION	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
25	SP_TRTYPE	☐	GRFN_REP_SUBPROCESS_TRTYPE	GRPC_ATTRVALUE	CHAR	10	0	Transaction type (central) ID
26	SP_TRTYPE_O	☐	GRFN_REP_SUBPROCESS_TRTYPE_O	GRPC_ATTRVALUE	CHAR	10	0	Transaction Type ID
27	SP_INDUSTRY	☐	GRFN_REP_SUBPROCESS_INDUSTRY	GRPC_ATTRVALUE	CHAR	10	0	Subprocess Industry
28	SP_VAL_ASS_CD	☐	GRFN_REP_SUBPROCESS_VAL_ASS_CD	GRFN_FLAG	CHAR	1	0	Control Design Assessment Validation
29	SP_VAL_ASS_CE	☐	GRFN_REP_SUBPROCESS_VAL_ASS_CE	GRFN_FLAG	CHAR	1	0	Control Self-Assessment Validation
30	SP_VAL_TEST	☐	GRFN_REP_SUBPROCESS_VAL_TEST	GRFN_FLAG	CHAR	1	0	Control Effectiveness Test Validation
31	SP_VAL_RMPLAN	☐	GRFN_REP_SUBPROCESS_VAL_RMPLAN	GRFN_FLAG	CHAR	1	0	Remediation Plan Validation
32	SP_RTST_CE	☐	GRFN_REP_SUBPROCESS_RTST_CE	GRFN_REP_SUBPROCESS_RTST	CHAR	1	0	Retest Control Self-Assessment
33	SP_RTST_CD	☐	GRFN_REP_SUBPROCESS_RTST_CD	GRFN_REP_SUBPROCESS_RTST	CHAR	1	0	Retest Control Design Assessment
34	SP_RTST_TE	☐	GRFN_REP_SUBPROCESS_RTST_TE	GRFN_REP_SUBPROCESS_RTST	CHAR	1	0	Retest Control Effectiveness Test
35	SP_VALID_FROM	☐	GRFN_REP_SUBPROCESS_VALID_FROM	DATUM	DATS	8	0	Subprocess start date
36	SP_VALID_TO	☐	GRFN_REP_SUBPROCESS_VALID_TO	DATUM	DATS	8	0	Subprocess end date
37	SP_IS_PROVIDER	☐	GRFN_REP_SUBPROCESS_IS_PROVID		CHAR	1	0	Subprocess: shared servicess is provider
38	SP_IS_CONSUMER	☐	GRFN_REP_SUBPROCESS_IS_CONSUM		CHAR	1	0	Subprocess: shared services is consumer
39	SP_SS_ORGUNIT	☐	GRFN_REP_SUBPROCESS_SS_ORGUNIT	NUMC08	NUMC	8	0	Subprocess: shared services shared orgunit
40	SP_SS_ASGN_METH	☐	GRFN_REP_SUBPROCESS_SS_METHOD	GRPC_METHOD_ASSIGN_STATUS	CHAR	1	0	Subprocess: shared services assign method ID
41	SP_RESP_USER	☐	GRFN_REP_SUBPROCESS_RESP_USER	GRFN_REP_RESP_USER	CHAR	12	0	Subprocess responsible person
42	SP_IN_SCOPE	☐	GRFN_REP_SUBPROCESS_IN_SCOPE	GRFN_REP_YES_NO	CHAR	1	0	In Scope (Subprocess) ID
43	.INCLUDE	☐				0	0
44	.INCLU-_PD	☐				0	0	Case's aggregation values
45	REFERENCE_PD	☐	GRFN_CASE_ID	GRFN_GUID	CHAR	32	0	Leading case GUID
46	RATING_PD	☐	GRFN_RATING	GRFN_AS_RATING	CHAR	1	0	Rating
47	STATUS_PD	☐	GRFN_CASE_STATUS	CRM_J_STATUS	CHAR	5	0	Case status
48	OPEN_ISSUES_PD	☐	GRFN_CASE_OPEN_ISSUES		INT4	10	0	Open Issues
49	ISSUES_PD	☐	GRFN_CASE_ISSUES		INT4	10	0	Issues
50	RMPLANS_PD	☐	GRFN_CASE_RMPLANS		INT4	10	0	Remmediation Plans
51	CAPAPLANS_PD	☐	GRFN_CASE_CAPAPLANS		INT4	10	0	CAPA Plans
52	ISSUE_PRIO_PD	☐	GRFN_REP_ISSUE_PRIORITY	GRFN_ISSUE_PRIORITY	CHAR	1	0	Issue Priority ID
53	CASES_PD	☐	GRFN_CASE_CASES		INT4	10	0	Cases
54	CASES_FAILED_PD	☐	GRFN_CASE_CASES_FAILED		INT4	10	0	Failed Cases
55	CASES_REMED_PD	☐	GRFN_REP_CASES_REMEDIATE		INT4	10	0	Number of remediated cases
56	DUE_DATE_PD	☐	GRFN_REP_CASES_DUE_DATE	DATUM	DATS	8	0	Cases Due Date
57	EVALTYP_PD	☐	GRFN_BI_EVALUATION_TYPE	GRFN_BI_EVALUATION_TYPE	CHAR	4	0	Evaluation Type
58	SPRE_CENTRAL	☐	GRFN_BI_SPRE_CENTRAL		CHAR	16	0	Central Subprocess with Regulation

History

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