SAP ABAP Table CRM_SVY_DB_S_V_LIST (CRM Surveys: Survey Overview Return Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-SVY (Application Component) Survey Suite
     ⤷ CRM_SVY_DB (Package) Database Interface for CRM Surveys

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_SVY_DB_S_V_LIST	Table Relationship Diagram
Short Description	CRM Surveys: Survey Overview Return Structure

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	CRM Surveys: Object Key
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	SURVEYID	☐	CRM_SVY_DB_SID	CHAR32	CHAR	32	0	CRM Surveys: Survey ID	CRM_SVY_DB_S
4	SURVEYVERSION	☐	CRM_SVY_DB_SVERS	NUMC10	NUMC	10	0	CRM Surveys: Survey Version
5	.INCLUDE	☐				0	0	CRM Surveys: Survey
6	SURVEYGUID	☐	CRM_SVY_DB_SGUID	CHAR32	CHAR	32	0	CRM Surveys: Survey GUID
7	MASTERLANGUAGE	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
8	.INCLUDE	☐				0	0	CRM Surveys: Survey Attributes (Defaults from CRM_SVY_DB_SA)
9	PERSISTVALUES	☐	CRM_SVY_DB_PERSISTVALUES	BOOLEAN	CHAR	1	0	Flag: Save Completed Questionnaires
10	SUPPORTQUERIES	☐	CRM_SVY_DB_SUPPORTQUERIES	BOOLEAN	CHAR	1	0	Flag: Simple Evaluation of Surveys
11	SUPPORTBW	☐	CRM_SVY_DB_SUPPORTBW	BOOLEAN	CHAR	1	0	Flag: Evaluation of Surveys in Business Warehouse
12	VALUESVERSIONING	☐	CRM_SVY_DB_VALUESVERSIONING	BOOLEAN	CHAR	1	0	Flag: Create Versions of Completed Questionnaires
13	VALUESDELETES	☐	CRM_SVY_DB_VALUESDELETES	BOOLEAN	CHAR	1	0	Flag: Deletion of Survey (Answers)
14	VALUESUPDATES	☐	CRM_SVY_DB_VALUESUPDATES	BOOLEAN	CHAR	1	0	Flag: Completed Questionnaires Can Be Changed Later
15	CALLBACKPBO	☐	CRM_SVY_DB_CALLBACK	FUNCNAME	CHAR	30	0	CRM Surveys: Callback Specification	*
16	CALLBACKPAI	☐	CRM_SVY_DB_CALLBACK	FUNCNAME	CHAR	30	0	CRM Surveys: Callback Specification	*
17	PUBLIC_SVY	☐	CRM_SVY_DB_PUBLIC	BOOLEAN	CHAR	1	0	Flag: Public Survey
18	VALIDFROM	☐	CRM_SVY_DB_VALIDFROM	CRM_SVY_DB_TIMESTAMP	DEC	15	0	CRM Surveys: Survey Valid From Date
19	VALIDTO	☐	CRM_SVY_DB_VALIDTO	CRM_SVY_DB_TIMESTAMP	DEC	15	0	CRM Surveys: Survey Valid To Date
20	SCHEMAVERSION	☐	CRM_SVY_DB_SSC_VERSID	CRM_SVY_DB_SSC_VERSID	NUMC	10	0	CRM Surveys: Version Number of Survey Schema
21	APPLICATIONID	☐	CRM_SVY_DB_APPL_ID	CRM_SVY_DB_APPL_ID	CHAR	32	0	CRM Surveys: Application	CRM_SVY_DB_SA
22	TESTVALUEGUID	☐	CRM_SVY_DB_SV_GUID	CHAR32	CHAR	32	0	CRM Surveys: Survey Values GUID
23	TESTVALUEVERSION	☐	CRM_SVY_DB_SVERS	NUMC10	NUMC	10	0	CRM Surveys: Survey Version
24	TESTPASSED	☐	CRM_SVY_DB_TEST_PASSED	BOOLEAN	CHAR	1	0	Flag: Submit Test Ran Correctly
25	CREATED_AT	☐	CRM_SVY_DB_CRTSTAMP	CRM_SVY_DB_TIMESTAMP	DEC	15	0	CRM Surveys: Creation Date
26	CREATED_BY	☐	STAT_FUSER	UNAME	CHAR	12	0	Created By
27	MODIFIED_AT	☐	CRM_SVY_DB_MODTSTAMP	CRM_SVY_DB_TIMESTAMP	DEC	15	0	CRM Surveys: Change Date
28	MODIFIED_BY	☐	STAT_LUSER	UNAME	CHAR	12	0	Changed by
29	TRANSL_EXIST	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
30	LANGUAGE	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
31	STATUS	☐	CRM_SVY_DB_SD_STATUS	CRM_SVY_DB_SD_STATUS	CHAR	1	0	CRM Surveys: Translation Status
32	.INCLUDE	☐				0	0	CRM Surveys: Description (Short and Long)
33	DESC_SHORT	☐	CRM_SVY_DB_SD_SHORT	TEXT45	CHAR	45	0	CRM Surveys: Short Description
34	DESC_LONG	☐	CRM_SVY_DB_SD_LONG	TEXT128	CHAR	128	0	CRM Surveys: Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRM_SVY_DB_S_V_LIST	APPLICATIONID	CRM_SVY_DB_SA	APPLICATIONID	REF	1	CN
2	CRM_SVY_DB_S_V_LIST	CLIENT	T000	MANDT	KEY
3	CRM_SVY_DB_S_V_LIST	MASTERLANGUAGE	T002	SPRAS	REF	1	CN
4	CRM_SVY_DB_S_V_LIST	SURVEYID	CRM_SVY_DB_S	SURVEYID	KEY	1	CN

History

Last changed by/on	SAP	20131122
SAP Release Created in