SAP ABAP Table CRM_SVY_DB_SD (CRM Surveys: Survey Description)

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	TRANSP	Transparent table
Transparent table	CRM_SVY_DB_SD	Table Relationship Diagram
Short Description	CRM Surveys: Survey Description

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	LANGUAGE	☑	CRM_SVY_DB_LANGU	CRM_SVY_DB_LANGU	CHAR	1	0	CRM Surveys: Language Attribute
6	.INCLUDE	☐				0	0	CRM Surveys: Survey Description Value
7	SOURCELANGUAGE	☐	CRM_SVY_DB_LANGU	CRM_SVY_DB_LANGU	CHAR	1	0	CRM Surveys: Language Attribute
8	STATUS	☐	CRM_SVY_DB_SD_STATUS	CRM_SVY_DB_SD_STATUS	CHAR	1	0	CRM Surveys: Translation Status
9	.INCLUDE	☐				0	0	CRM Surveys: References to a Survey Translation
10	T_VALUEGUID	☐	CRM_SVY_DB_SV_GUID	CHAR32	CHAR	32	0	CRM Surveys: Survey Values GUID	CRM_SVY_DB_SVS
11	T_VALUEVERSION	☐	CRM_SVY_DB_SV_VERS	NUMC10	NUMC	10	0	CRM Surveys: Survey Values Version	*
12	T_SURVEYID	☐	CRM_SVY_DB_SID	CHAR32	CHAR	32	0	CRM Surveys: Survey ID	CRM_SVY_DB_S
13	T_SURVEYVERSION	☐	CRM_SVY_DB_SVERS	NUMC10	NUMC	10	0	CRM Surveys: Survey Version	*
14	.INCLUDE	☐				0	0	CRM Surveys: Description (Short and Long)
15	DESC_SHORT	☐	CRM_SVY_DB_SD_SHORT	TEXT45	CHAR	45	0	CRM Surveys: Short Description
16	DESC_LONG	☐	CRM_SVY_DB_SD_LONG	TEXT128	CHAR	128	0	CRM Surveys: Description
17	XML	☐	CRM_SVY_DB_SD_XML		RSTR	0	0	CRM Surveys: Survey XML
18	.INCLUDE	☐				0	0	CRM Surveys: Organizational Attributes
19	CREATED_AT	☐	CRM_SVY_DB_CRTSTAMP	CRM_SVY_DB_TIMESTAMP	DEC	15	0	CRM Surveys: Creation Date
20	CREATED_BY	☐	STAT_FUSER	UNAME	CHAR	12	0	Created By
21	MODIFIED_AT	☐	CRM_SVY_DB_MODTSTAMP	CRM_SVY_DB_TIMESTAMP	DEC	15	0	CRM Surveys: Change Date
22	MODIFIED_BY	☐	STAT_LUSER	UNAME	CHAR	12	0	Changed by

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRM_SVY_DB_SD	CLIENT	T000	MANDT	KEY
2	CRM_SVY_DB_SD	SURVEYID	CRM_SVY_DB_S	SURVEYID	KEY
3	CRM_SVY_DB_SD	T_SURVEYID	CRM_SVY_DB_S	SURVEYID	KEY
4	CRM_SVY_DB_SD	T_VALUEGUID	CRM_SVY_DB_SVS	CLIENT	KEY

History

Last changed by/on	SAP	20100420
SAP Release Created in