SAP ABAP Table CRMST_ADMIN_SVYIL (GENIL Admin Structure for Surveys)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-SVY (Application Component) Survey Suite
     ⤷ CRM_SURVEY_IL (Package) Interaction Layer of Surveys

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_ADMIN_SVYIL	Table Relationship Diagram
Short Description	GENIL Admin Structure for Surveys

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	SURVEYID	☐	CRM_SVY_DB_SID	CHAR32	CHAR	32	0	CRM Surveys: Survey ID
2	SURVEYVERSION	☐	CRM_SVY_DB_SVERS	NUMC10	NUMC	10	0	CRM Surveys: Survey Version
3	SURVEYGUID	☐	CRM_SVY_DB_SGUID	CHAR32	CHAR	32	0	CRM Surveys: Survey GUID
4	MASTERLANGUAGE	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
5	PERSISTVALUES	☐	CRM_SVY_DB_PERSISTVALUES	BOOLEAN	CHAR	1	0	Flag: Save Completed Questionnaires
6	SUPPORTQUERIES	☐	CRM_SVY_DB_SUPPORTQUERIES	BOOLEAN	CHAR	1	0	Flag: Simple Evaluation of Surveys
7	SUPPORTBW	☐	CRM_SVY_DB_SUPPORTBW	BOOLEAN	CHAR	1	0	Flag: Evaluation of Surveys in Business Warehouse
8	VALUESVERSIONING	☐	CRM_SVY_DB_VALUESVERSIONING	BOOLEAN	CHAR	1	0	Flag: Create Versions of Completed Questionnaires
9	VALUESDELETES	☐	CRM_SVY_DB_VALUESDELETES	BOOLEAN	CHAR	1	0	Flag: Deletion of Survey (Answers)
10	VALUESUPDATES	☐	CRM_SVY_DB_VALUESUPDATES	BOOLEAN	CHAR	1	0	Flag: Completed Questionnaires Can Be Changed Later
11	CALLBACKPBO	☐	CRM_SVY_DB_CALLBACK	FUNCNAME	CHAR	30	0	CRM Surveys: Callback Specification	*
12	CALLBACKPAI	☐	CRM_SVY_DB_CALLBACK	FUNCNAME	CHAR	30	0	CRM Surveys: Callback Specification	*
13	VALIDFROMDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
14	VALIDTODATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
15	SCHEMAVERSION	☐	CRM_SVY_DB_SSC_VERSID	CRM_SVY_DB_SSC_VERSID	NUMC	10	0	CRM Surveys: Version Number of Survey Schema
16	APPLICATIONID	☐	CRM_SVY_DB_APPL_ID	CRM_SVY_DB_APPL_ID	CHAR	32	0	CRM Surveys: Application	*
17	TESTVALUEGUID	☐	CRM_SVY_DB_SV_GUID	CHAR32	CHAR	32	0	CRM Surveys: Survey Values GUID
18	TESTVALUEVERSION	☐	CRM_SVY_DB_SVERS	NUMC10	NUMC	10	0	CRM Surveys: Survey Version
19	TESTPASSED	☐	CRM_SVY_DB_TEST_PASSED	BOOLEAN	CHAR	1	0	Flag: Submit Test Ran Correctly
20	TRANSL_EXIST	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
21	LANGUAGE	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
22	STATUS	☐	CRM_SVY_DB_SD_STATUS	CRM_SVY_DB_SD_STATUS	CHAR	1	0	CRM Surveys: Translation Status
23	DESC_SHORT	☐	CRM_SVY_DB_SD_SHORT	TEXT45	CHAR	45	0	CRM Surveys: Short Description
24	DESC_LONG	☐	CRM_SVY_DB_SD_LONG	TEXT128	CHAR	128	0	CRM Surveys: Description
25	CREATED_BY	☐	STAT_FUSER	UNAME	CHAR	12	0	Created By
26	CREATED_AT	☐	CRM_SVY_DB_CRTSTAMP	CRM_SVY_DB_TIMESTAMP	DEC	15	0	CRM Surveys: Creation Date
27	MODIFIED_BY	☐	STAT_LUSER	UNAME	CHAR	12	0	Changed by
28	MODIFIED_AT	☐	CRM_SVY_DB_MODTSTAMP	CRM_SVY_DB_TIMESTAMP	DEC	15	0	CRM Surveys: Change Date
29	SCREEN	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
30	PRINTER	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
31	BSP	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
32	OFF_LINE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
33	HANDHELD	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
34	CSS_STYLE_SHEET	☐	CRMDT_STYLE	STRING	STRG	0	0	CSS Style Sheet
35	PUBLIC_SVY	☐	CRM_SVY_DB_PUBLIC	BOOLEAN	CHAR	1	0	Flag: Public Survey

History

Last changed by/on	SAP	20140802
SAP Release Created in	520