SAP ABAP View /SAPSRM/V_SURVEY (Survey)

Hierarchy

☛ SRM_SERVER (Software Component) SRM_SERVER
   ⤷ SRM-EBP-VE (Application Component) Vendor Evaluation
     ⤷ /SAPSRM/PDO_BO_SURV_DAO (Package) Data Access Objects Supplier Survey

Basic Data

View Type	D	Database View
Database View	/SAPSRM/V_SURVEY
Short Description	Survey
Root table	/SAPSRM/D_SURVEY	Survey Test

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	/SAPSRM/D_SURVEY	/SAPSRM/D_SURVEY
2	/SAPSRM/D_SRVPKG
3	/SAPSRM/D_QSTN

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	/SAPSRM/D_QSTN	CLIENT	JL	EQ				0	0
2	/SAPSRM/D_SURVEY	CLIENT	JR	EQ			AND	0	0
3	/SAPSRM/D_QSTN	GUID	JL	EQ				0	0
4	/SAPSRM/D_SURVEY	QSTN_GUID	JR	EQ			AND	0	0
5	/SAPSRM/D_SRVPKG	CLIENT	JL	EQ				0	0
6	/SAPSRM/D_SURVEY	CLIENT	JR	EQ			AND	0	0
7	/SAPSRM/D_SRVPKG	GUID	JL	EQ				0	0
8	/SAPSRM/D_SURVEY	SURVEY_PKG_GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	/SAPSRM/D_SURVEY	CLIENT		☐	MANDT	☐	Client
2	SURVEY_PKG_ID	/SAPSRM/D_SRVPKG	OBJECT_ID		☐	/SAPSRM/SURVEY_PKG_ID	☐	Survey Package ID
3	SURVEY_PKG_NAME	/SAPSRM/D_SRVPKG	NAME		☐	/SAPSRM/SURVEY_PKG_NAME	☐	Survey Package Name
4	GUID	/SAPSRM/D_SURVEY	GUID		☐	/SAPSRM/SURVEY_GUID	☐	Survey Guid
5	OBJECT_ID	/SAPSRM/D_SURVEY	OBJECT_ID		☐	/SAPSRM/SURVEY_ID	☐	Survey ID
6	NAME	/SAPSRM/D_SURVEY	NAME		☐	/SAPSRM/SURVEY_NAME	☐	Survey Name
7	DESCRIPTION	/SAPSRM/D_SURVEY	DESCRIPTION		☐	/SAPSRM/SURVEY_DESCRIPTION	☐	Description of a SRM Survey
8	SURVEY_PKG_GUID	/SAPSRM/D_SURVEY	SURVEY_PKG_GUID		☐	/SAPSRM/SURVEY_PKG_GUID	☐	Survey Package GUID
9	STATUS	/SAPSRM/D_SURVEY	STATUS		☐	/SAPSRM/SURVEY_STATUS	☐	Survey Status
10	QSTN_GUID	/SAPSRM/D_SURVEY	QSTN_GUID		☐	/SAPSRM/QSTN_GUID	☐	GUID of a questionnaire object
11	UWS_SURVEY_ID	/SAPSRM/D_SURVEY	UWS_SURVEY_ID		☐	UXB_ID	☐	Object ID
12	EVAL_CATEGORY	/SAPSRM/D_SURVEY	EVAL_CATEGORY		☐	/SAPSRM/SURVEY_EVAL_CAT	☐	Survey Evaluation Category
13	EVAL_AREA	/SAPSRM/D_SURVEY	EVAL_AREA		☐	/SAPSRM/SURVEY_EVAL_AREA	☐	Survey Evaluation Area
14	SURVEY_MANAGER	/SAPSRM/D_SURVEY	SURVEY_MANAGER		☐	/SAPSRM/SURVEY_MANAGER	☐	Survey Owner
15	ASSISTANT	/SAPSRM/D_SURVEY	ASSISTANT		☐	/SAPSRM/ASSISTANT	☐	Assistant
16	EVAL_START_DATE	/SAPSRM/D_SURVEY	EVAL_START_DATE		☐	/SAPSRM/SURVEY_EVAL_PRD_START	☐	Start of Survey Evaluation Period
17	EVAL_END_DATE	/SAPSRM/D_SURVEY	EVAL_END_DATE		☐	/SAPSRM/SURVEY_EVAL_PRD_END	☐	End of Survey Evaluation Period
18	SURVEY_DEADLINE	/SAPSRM/D_SURVEY	SURVEY_DEADLINE		☐	/SAPSRM/SURVEY_DEADLINE	☐	Survey Deadline
19	CREATED_AT	/SAPSRM/D_SURVEY	CREATED_AT		☐	COMT_CREATED_AT_USR	☐	Created At (Output in User Time Zone)
20	CREATED_BY	/SAPSRM/D_SURVEY	CREATED_BY		☐	CRMT_CREATED_BY	☐	User that Created the Transaction
21	CHANGED_AT	/SAPSRM/D_SURVEY	CHANGED_AT		☐	COMT_CHANGED_AT_USR	☐	Changed At (Output in User Time Zone)
22	CHANGED_BY	/SAPSRM/D_SURVEY	CHANGED_BY		☐	CRMT_CHANGED_BY	☐	Transaction Last Changed By
23	QUESTIONNAIRE_ID	/SAPSRM/D_QSTN	OBJECT_ID		☐	/SAPSRM/QSTN_ID	☐	Questionnaire ID
24	QSTN_NAME	/SAPSRM/D_QSTN	NAME		☐	/SAPSRM/QSTN_NAME	☐	Questionnaire Name

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110913
SAP Release Created in	600