SAP ABAP Table GRFNDMCP (DataMart: CAPA plan)

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	GRFNDMCP	Table Relationship Diagram
Short Description	DataMart: CAPA plan

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	CP_GUID	☐	GRFN_REP_CPPLAN	SYSUUID_C	CHAR	32	0	CAPA Plan ID
5	.INCLUDE	☐				0	0	CAPA plan reporting attributes
6	CP_PROCESSOR	☐	GRFN_REP_CPPLAN_PROC	XUBNAME	CHAR	12	0	Processor ID	*
7	CP_CREA_USER	☐	GRFN_REP_CPPLAN_CREATED_BY	XUBNAME	CHAR	12	0	Initiated by	*
8	CP_CREA_DATE	☐	GRFN_REP_CPPLAN_CREATED_ON	DATUM	DATS	8	0	CAPA Plan - Created On (Date)
9	CP_CREA_DATE_TM	☐	GRFN_REP_CPLAN_CREATED_ON_TM		TIMS	6	0	CAPA Plan - Created On (Time)
10	CP_CHANGED_ON	☐	GRFN_REP_CPLAN_CHANGED_ON		DATS	8	0	CAPA Plan - Changed On (Date)
11	CP_CHANGED_ON_TM	☐	GRFN_REP_CPLAN_CHANGED_ON_TM		TIMS	6	0	CAPA Plan - Changed On (Time)
12	CP_CLOSED_ON	☐	GRFN_REP_CPLAN_CLOSED_ON		DATS	8	0	CAPA Plan - Closed On (Date)
13	CP_CLOSED_ON_TM	☐	GRFN_REP_CPLAN_CLOSED_ON_TM		TIMS	6	0	CAPA Plan - Closed On (Time)
14	CP_START_DATE	☐	GRFN_REP_CPPLAN_START_DATE	DATUM	DATS	8	0	Start Date
15	CP_END_DATE	☐	GRFN_REP_CPPLAN_END_DATE	DATUM	DATS	8	0	Due Date
16	CP_STATUS	☐	GRFN_REP_CPPLAN_STATUS	CRM_J_STATUS	CHAR	5	0	CAPA Status ID
17	CP_OVERDUE	☐	GRFN_REP_CPPLAN_OVERDUE	XFELD	CHAR	1	0	CAPA plan - Overdue
18	CP_RE	☐	GRFN_REP_CPLAN_REGULATION_ID	NUMC08	NUMC	8	0	CAPA plan source regulation ID
19	CP_CATEGORY	☐	GRFN_REP_CPLAN_CATEGORY	CHAR4	CHAR	4	0	CAPA plan case category
20	CP_RESP_USER	☐	GRFN_REP_CPPLAN_RESP	XUBNAME	CHAR	12	0	CAPA plan - Reported by ID	*
21	CP_CF_STATUS	☐	GRFN_REP_CPPLAN_CF_STAT	GRFN_REP_CF_STATUS	CHAR	1	0	CAPA plan - Carryforward Status ID
22	CP_CF_TFRAME	☐	GRFN_REP_CPPLAN_CF_TFRAME	GRFN_ATTRVALUE	CHAR	10	0	CAPA plan - Timeframe Before Carryforward ID
23	CP_CF_YEAR	☐	GRFN_REP_CPPLAN_CF_YEAR		CHAR	4	0	CAPA plan - Timeframe Before Carryforward (Year)
24	CP_VAL_USER	☐	GRFN_REP_CPPLAN_VALIDATED_BY	XUBNAME	CHAR	12	0	CAPA plan - Validated By ID	*
25	CP_VAL_DATE	☐	GRFN_REP_CPPLAN_VALIDATED_ON	DATUM	DATS	8	0	CAPA plan - Validated On
26	CP_TF_BEGDA	☐	GRFN_REP_CPPLAN_TF_BEGDA	DATUM	DATS	8	0	CAPA plan - start date of the time frame
27	CP_TF_ENDDA	☐	GRFN_REP_CPPLAN_TF_ENDDA	DATUM	DATS	8	0	CAPA plan - time frame end date
28	CP_TFRAME	☐	GRFN_REP_CPPLAN_TIME_FRAME	GRFN_ATTRVALUE	CHAR	10	0	CAPA plan - time frame
29	CP_TF_YEAR	☐	GRFN_REP_CPPLAN_TF_YEAR	CHAR4	CHAR	4	0	CAPA plan - time frame year
30	CP_SURVEY_ID	☐	GRFN_REP_CPPLAN_SURVEY_ID	SYSUUID_C	CHAR	32	0	CAPA plan - survery ID
31	.INCLUDE	☐				0	0

History

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