SAP ABAP Table /SAPSRM/V_SURVEY (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/SAPSRM/V_SURVEY	Table Relationship Diagram
Short Description	Generated Table for View

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client
2	SURVEY_PKG_ID	☑	/SAPSRM/SURVEY_PKG_ID	CRM_OBJECT_ID	CHAR	10	0	Survey Package ID
3	SURVEY_PKG_NAME	☑	/SAPSRM/SURVEY_PKG_NAME	/SAPSRM/SURVEY_PKG_NAME	CHAR	40	0	Survey Package Name
4	GUID	☑	/SAPSRM/SURVEY_GUID	UUID	RAW	16	0	Survey Guid
5	OBJECT_ID	☐	/SAPSRM/SURVEY_ID	CRM_OBJECT_ID	CHAR	10	0	Survey ID
6	NAME	☐	/SAPSRM/SURVEY_NAME	TEXT40	CHAR	40	0	Survey Name
7	DESCRIPTION	☐	/SAPSRM/SURVEY_DESCRIPTION		STRG	0	0	Description of a SRM Survey
8	SURVEY_PKG_GUID	☐	/SAPSRM/SURVEY_PKG_GUID	UUID	RAW	16	0	Survey Package GUID	/SAPSRM/D_SRVPKG
9	STATUS	☐	/SAPSRM/SURVEY_STATUS	/SAPSRM/SURVEY_STATUS	CHAR	5	0	Survey Status
10	QSTN_GUID	☐	/SAPSRM/QSTN_GUID	UUID	RAW	16	0	GUID of a questionnaire object	/SAPSRM/D_QSTN
11	UWS_SURVEY_ID	☐	UXB_ID	UXB_ID	CHAR	64	0	Object ID
12	EVAL_CATEGORY	☐	/SAPSRM/SURVEY_EVAL_CAT	/SAPSRM/SURVEY_EVAL_CAT	CHAR	4	0	Survey Evaluation Category	/SAPSRM/C_EVCAT
13	EVAL_AREA	☐	/SAPSRM/SURVEY_EVAL_AREA	/SAPSRM/SURVEY_EVAL_AREA	CHAR	4	0	Survey Evaluation Area	/SAPSRM/C_EVAR
14	SURVEY_MANAGER	☐	/SAPSRM/SURVEY_MANAGER	BU_PARTNER	CHAR	10	0	Survey Owner
15	ASSISTANT	☐	/SAPSRM/ASSISTANT	BU_PARTNER	CHAR	10	0	Assistant
16	EVAL_START_DATE	☐	/SAPSRM/SURVEY_EVAL_PRD_START	DATE	DATS	8	0	Start of Survey Evaluation Period
17	EVAL_END_DATE	☐	/SAPSRM/SURVEY_EVAL_PRD_END	DATE	DATS	8	0	End of Survey Evaluation Period
18	SURVEY_DEADLINE	☐	/SAPSRM/SURVEY_DEADLINE	DATE	DATS	8	0	Survey Deadline
19	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
20	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
21	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
22	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
23	QUESTIONNAIRE_ID	☐	/SAPSRM/QSTN_ID	CRM_OBJECT_ID	CHAR	10	0	Questionnaire ID
24	QSTN_NAME	☐	/SAPSRM/QSTN_NAME	TEXT40	CHAR	40	0	Questionnaire Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPSRM/V_SURVEY	EVAL_AREA	/SAPSRM/C_EVAR	EVAL_AREA	KEY	C	CN
2	/SAPSRM/V_SURVEY	EVAL_CATEGORY	/SAPSRM/C_EVCAT	EVAL_CATEGORY	KEY	C	CN
3	/SAPSRM/V_SURVEY	QSTN_GUID	/SAPSRM/D_QSTN	GUID	KEY	1	N
4	/SAPSRM/V_SURVEY	SURVEY_PKG_GUID	/SAPSRM/D_SRVPKG	GUID	KEY	1	N

History

Last changed by/on	SAP	20110913
SAP Release Created in