SAP ABAP Table GRFN_S_BI_CP_ATTR (CAPA plan 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_CP_ATTR	Table Relationship Diagram
Short Description	CAPA plan 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	RE_ID	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
21	OU_ID	☐	GRFN_REP_ORGUNIT_ID	NUMC08	NUMC	8	0	Organization ID
22	SP_ID	☐	GRFN_REP_SUBPROCESS_ID	NUMC08	NUMC	8	0	Subprocess ID
23	CN_ID	☐	GRFN_REP_CONTROL_ID		CHAR	9	0	Control ID
24	EC_ID	☐	GRFN_REP_ECONTROL	NUMC08	NUMC	8	0	Indirect ELC ID
25	IS_GUID	☐	GRFN_REP_ISSUE_ID	SYSUUID_C	CHAR	32	0	Issue ID
26	.INCLUDE	☐				0	0	CAPA plan reporting attributes
27	CP_PROCESSOR	☐	GRFN_REP_CPPLAN_PROC	XUBNAME	CHAR	12	0	Processor ID	*
28	CP_CREA_USER	☐	GRFN_REP_CPPLAN_CREATED_BY	XUBNAME	CHAR	12	0	Initiated by	*
29	CP_CREA_DATE	☐	GRFN_REP_CPPLAN_CREATED_ON	DATUM	DATS	8	0	CAPA Plan - Created On (Date)
30	CP_CREA_DATE_TM	☐	GRFN_REP_CPLAN_CREATED_ON_TM		TIMS	6	0	CAPA Plan - Created On (Time)
31	CP_CHANGED_ON	☐	GRFN_REP_CPLAN_CHANGED_ON		DATS	8	0	CAPA Plan - Changed On (Date)
32	CP_CHANGED_ON_TM	☐	GRFN_REP_CPLAN_CHANGED_ON_TM		TIMS	6	0	CAPA Plan - Changed On (Time)
33	CP_CLOSED_ON	☐	GRFN_REP_CPLAN_CLOSED_ON		DATS	8	0	CAPA Plan - Closed On (Date)
34	CP_CLOSED_ON_TM	☐	GRFN_REP_CPLAN_CLOSED_ON_TM		TIMS	6	0	CAPA Plan - Closed On (Time)
35	CP_START_DATE	☐	GRFN_REP_CPPLAN_START_DATE	DATUM	DATS	8	0	Start Date
36	CP_END_DATE	☐	GRFN_REP_CPPLAN_END_DATE	DATUM	DATS	8	0	Due Date
37	CP_STATUS	☐	GRFN_REP_CPPLAN_STATUS	CRM_J_STATUS	CHAR	5	0	CAPA Status ID
38	CP_OVERDUE	☐	GRFN_REP_RMPLAN_OVERDUE	GRFN_XFELD	CHAR	1	0	Overdue
39	CP_RE	☐	GRFN_REP_CPLAN_REGULATION_ID	NUMC08	NUMC	8	0	CAPA plan source regulation ID
40	CP_CATEGORY	☐	GRFN_REP_CPLAN_CATEGORY	CHAR4	CHAR	4	0	CAPA plan case category
41	CP_RESP_USER	☐	GRFN_REP_CPPLAN_RESP	XUBNAME	CHAR	12	0	CAPA plan - Reported by ID	*
42	CP_CF_STATUS	☐	GRFN_REP_CPPLAN_CF_STAT	GRFN_REP_CF_STATUS	CHAR	1	0	CAPA plan - Carryforward Status ID
43	CP_CF_TFRAME	☐	GRFN_REP_CPPLAN_CF_TFRAME	GRFN_ATTRVALUE	CHAR	10	0	CAPA plan - Timeframe Before Carryforward ID
44	CP_CF_YEAR	☐	GRFN_REP_CPPLAN_CF_YEAR		CHAR	4	0	CAPA plan - Timeframe Before Carryforward (Year)
45	CP_VAL_USER	☐	GRFN_REP_CPPLAN_VALIDATED_BY	XUBNAME	CHAR	12	0	CAPA plan - Validated By ID	*
46	CP_VAL_DATE	☐	GRFN_REP_CPPLAN_VALIDATED_ON	DATUM	DATS	8	0	CAPA plan - Validated On
47	CP_TF_BEGDA	☐	GRFN_REP_CPPLAN_TF_BEGDA	DATUM	DATS	8	0	CAPA plan - start date of the time frame
48	CP_TF_ENDDA	☐	GRFN_REP_CPPLAN_TF_ENDDA	DATUM	DATS	8	0	CAPA plan - time frame end date
49	CP_TFRAME	☐	GRFN_REP_CPPLAN_TIME_FRAME	GRFN_ATTRVALUE	CHAR	10	0	CAPA plan - time frame
50	CP_TF_YEAR	☐	GRFN_REP_CPPLAN_TF_YEAR	CHAR4	CHAR	4	0	CAPA plan - time frame year
51	CP_SURVEY_ID	☐	GRFN_REP_CPPLAN_SURVEY_ID	SYSUUID_C	CHAR	32	0	CAPA plan - survery ID
52	.INCLUDE	☐				0	0
53	CASE_CLOSED	☐	GRFN_BI_CASE_CLOSED	GRFN_XFELD	CHAR	1	0	Closed cases
54	REMED_STARTED	☐	GRFN_BI_REMED_STARTED	GRFN_XFELD	CHAR	1	0	Remediation started

History

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