SAP ABAP Table GRFNDMQI (DataMart: Questions)

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	GRFNDMQI	Table Relationship Diagram
Short Description	DataMart: Questions

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	QI	☐	GRFN_REP_QI_ID	SYSUUID_C	CHAR	32	0	Question answers - generated GUID
5	.INCLUDE	☐				0	0	Question and answers rep. struct. - general attributes
6	QI_SURVEY_ID	☐	GRFN_REP_QI_SURVEY_TEMPL_ID	SYSUUID_C	CHAR	32	0	Questions and answers - survey template ID
7	QI_QUESTION_ID	☐	GRFN_REP_QI_QUESTION_ID	SYSUUID_C	CHAR	32	0	Questions and answers - question ID
8	QI_SVYINST_ID	☐	GRFN_REP_QI_ASSESSMENT_ID	SYSUUID_C	CHAR	32	0	Questions and answers - related assessment GUID
9	QI_QNUMBER	☐	GRFN_REP_QI_QSEQ	NUM3	NUMC	3	0	Questions and answers - question sequence
10	QI_QCATEGORY	☐	GRFN_REP_QI_QCATEGORY	GRFN_REP_QCATEGORY	CHAR	2	0	Questions and answers - question category ID
11	QI_QUESTION_TEXT	☐	GRFN_REP_QI_QTEXT	TEXTA1024	CHAR	1024	0	Questions and answers - question text
12	QI_ATYPE	☐	GRFN_REP_QI_ATYPE	GRPC_D_ATYPE	CHAR	1	0	Questions and answers - answer type ID
13	QI_RTYPE	☐	GRFN_REP_QI_RTYPE	GRFN_RTYPE	CHAR	2	0	Questions and answers - rating type ID
14	QI_ANSWER_TEXT	☐	GRFN_REP_QI_ATEXT	TEXT255	CHAR	255	0	Questions and answers - answer text
15	QI_CHOICES	☐	GRPC_ACHOICE	GRPC_ACHOICE	CHAR	1	0	Answer Yes/No/NA
16	QI_RATING	☐	GRPC_ARATING	GRPC_ARATING	NUMC	2	0	Answer rating
17	QI_PERCENTAGE	☐	GRFN_APERCENTAGE		DEC	7	4	Percentage
18	QI_AMOUNT	☐	GRFN_AAMOUNT		CURR	15	3	Amount
19	QI_CURRENCY	☐	GRFN_ACURRENCY		CUKY	5	0	Currency
20	QI_IMPACT_LEVEL	☐	GRFN_IMPACT_LEVEL	GRFN_IMPACT_LEVEL	NUMC	2	0	Impact Level	*
21	QI_PROB_LEVEL	☐	GRRM_PROBABILITY_LEVEL_ID	GRRM_PROBABILITY_LEVEL	NUMC	3	0	Probability Level	*
22	QI_SOO	☐	GRRM_SPEED_OF_ONSET	GRRM_SPEED_OF_ONSET	CHAR	4	0	Speed of Onset	*
23	QI_CUST_CHOICE	☐	GRFN_ACUST_CHOICE	NUMC2	NUMC	2	0	Customer Defined Choice

History

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