SAP ABAP Table GRFNDMSV (DataMart: Survey)

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	GRFNDMSV	Table Relationship Diagram
Short Description	DataMart: Survey

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	SV	☐	GRFN_REP_SV_SVYINST	GRFN_GUID	CHAR	32	0	Survey Object ID
5	.INCLUDE	☐				0	0	Survey Domain Attribute
6	SV_SURVEY	☐	GRFN_REP_SV_SURVEY	GRFN_GUID	CHAR	32	0	Survey instance: Survey ID
7	SV_TASKPLANID	☐	GRFN_REP_SV_TASKPLANID	GRFN_GUID	CHAR	32	0	Survey instance: taskplan id
8	SV_CREATED_BY	☐	GRFN_REP_SV_CREATED_BY	UNAME	CHAR	12	0	Created By
9	SV_CREATED_AT	☐	GRFN_REP_SV_CREATED_AT	TZNTSTMPS	DEC	15	0	Created At
10	SV_DUEDATE	☐	GRFN_REP_SV_DUEDATE	DATUM	DATS	8	0	Survey Duedate
11	SV_SENT_AT	☐	GRFN_REP_SENT	TZNTSTMPS	DEC	15	0	Timestamp of survey sending out
12	SV_COMPLETED_AT	☐	GRFN_REP_COMP_AT	TZNTSTMPS	DEC	15	0	Completed At
13	SV_RECIPIENT	☐	GRFN_REP_RECIPIENT	UNAME	CHAR	12	0	Recipient
14	SV_OBJECT_ID	☐	GRFN_REP_SV_OBJECT_ID	GRFN_API_OBJECT_ID	CHAR	50	0	Survey instance object ID
15	SV_ENTITY_ID	☐	GRFN_REP_SV_OBJECT_ENTITY_ID	GRFN_API_ENTITY_ID	CHAR	20	0	Survey instance object entity ID	*
16	SV_EMAIL	☐	GRFN_REP_EMAIL	AD_SMTPADR	CHAR	241	0	E-Mail Address
17	SV_SCORE_ABS	☐	GRFN_REP_SV_SCORE_ABS		DEC	13	5	Survey Score
18	SV_SCORE_PER	☐	GRFN_APERCENTAGE		DEC	7	4	Percentage

History

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