SAP ABAP View CRM_SVY_RE_ALV (CRM Survey: View for Evaluating Values)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-SVY (Application Component) Survey Suite
     ⤷ CRM_SVY_RE (Package) Survey Result Evaluation

Basic Data

View Type	D	Database View
Database View	CRM_SVY_RE_ALV
Short Description	CRM Survey: View for Evaluating Values
Root table	CRM_SVY_DB_S	CRM Surveys: Survey

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRM_SVY_DB_S	CRM_SVY_DB_S
2	CRM_SVY_DB_SVS
3	CRM_SVY_RE_QSTNR
4	CRM_SVY_RE_QUEST
5	CRM_SVY_RE_ANSW
6	CRM_SVY_DB_SV

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRM_SVY_DB_SVS	CLIENT	JL	EQ				0	0
2	CRM_SVY_DB_S	CLIENT	JR	EQ			AND	0	0
3	CRM_SVY_DB_SVS	SURVEYID	JL	EQ				0	0
4	CRM_SVY_DB_S	SURVEYID	JR	EQ			AND	0	0
5	CRM_SVY_DB_SVS	SURVEYVERSION	JL	EQ				0	0
6	CRM_SVY_DB_S	SURVEYVERSION	JR	EQ			AND	0	0
7	CRM_SVY_RE_QSTNR	CLIENT	JL	EQ				0	0
8	CRM_SVY_DB_S	CLIENT	JR	EQ			AND	0	0
9	CRM_SVY_RE_QSTNR	SURVEY_ID	JL	EQ				0	0
10	CRM_SVY_DB_S	SURVEYID	JR	EQ			AND	0	0
11	CRM_SVY_RE_QSTNR	SURVEY_VERSION	JL	EQ				0	0
12	CRM_SVY_DB_S	SURVEYVERSION	JR	EQ			AND	0	0
13	CRM_SVY_RE_QUEST	CLIENT	JL	EQ				0	0
14	CRM_SVY_RE_QSTNR	CLIENT	JR	EQ			AND	0	0
15	CRM_SVY_RE_QUEST	SURVEY_ID	JL	EQ				0	0
16	CRM_SVY_RE_QSTNR	SURVEY_ID	JR	EQ			AND	0	0
17	CRM_SVY_RE_QUEST	SURVEY_VERSION	JL	EQ				0	0
18	CRM_SVY_RE_QSTNR	SURVEY_VERSION	JR	EQ			AND	0	0
19	CRM_SVY_RE_QUEST	LANGUAGE	JL	EQ				0	0
20	CRM_SVY_DB_S	MASTERLANGUAGE	JR	EQ			AND	0	0
21	CRM_SVY_RE_ANSW	CLIENT	JL	EQ				0	0
22	CRM_SVY_RE_QSTNR	CLIENT	JR	EQ			AND	0	0
23	CRM_SVY_RE_ANSW	SURVEY_ID	JL	EQ				0	0
24	CRM_SVY_RE_QSTNR	SURVEY_ID	JR	EQ			AND	0	0
25	CRM_SVY_RE_ANSW	SURVEY_VERSION	JL	EQ				0	0
26	CRM_SVY_RE_QSTNR	SURVEY_VERSION	JR	EQ			AND	0	0
27	CRM_SVY_RE_ANSW	LANGUAGE	JL	EQ				0	0
28	CRM_SVY_DB_S	MASTERLANGUAGE	JR	EQ			AND	0	0
29	CRM_SVY_DB_SV	CLIENT	JL	EQ				0	0
30	CRM_SVY_DB_SVS	CLIENT	JR	EQ			AND	0	0
31	CRM_SVY_DB_SV	VALUEGUID	JL	EQ				0	0
32	CRM_SVY_DB_SVS	VALUEGUID	JR	EQ			AND	0	0
33	CRM_SVY_DB_SV	VALUEVERSION	JL	EQ				0	0
34	CRM_SVY_DB_SVS	VALUEVERSION	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT_S	CRM_SVY_DB_S	CLIENT		☐	MANDT	☐	Client
2	SURVEYID_S	CRM_SVY_DB_S	SURVEYID		☐	CRM_SVY_DB_SID	☐	CRM Surveys: Survey ID
3	SURVEYVERSION_S	CRM_SVY_DB_S	SURVEYVERSION		☐	CRM_SVY_DB_SVERS	☐	CRM Surveys: Survey Version
4	MASTERLANGUAGE	CRM_SVY_DB_S	MASTERLANGUAGE		☐	LANGU	☐	Language Key
5	SUPPORTQUERIES	CRM_SVY_DB_S	SUPPORTQUERIES		☐	CRM_SVY_DB_SUPPORTQUERIES	☐	Flag: Simple Evaluation of Surveys
6	SUPPORTBW	CRM_SVY_DB_S	SUPPORTBW		☐	CRM_SVY_DB_SUPPORTBW	☐	Flag: Evaluation of Surveys in Business Warehouse
7	CLIENT_SVS	CRM_SVY_DB_SVS	CLIENT		☐	MANDT	☐	Client
8	VALUEGUID_SVS	CRM_SVY_DB_SVS	VALUEGUID		☐	CRM_SVY_DB_SV_GUID	☐	CRM Surveys: Survey Values GUID
9	VALUEVERSION_SVS	CRM_SVY_DB_SVS	VALUEVERSION		☐	CRM_SVY_DB_SV_VERS	☐	CRM Surveys: Survey Values Version
10	STATUS	CRM_SVY_DB_SVS	STATUS		☐	CRM_SVY_DB_SVS_STATUS	☐	CRM Surveys: Survey Values Status
11	SURVEYID_SVS	CRM_SVY_DB_SVS	SURVEYID		☐	CRM_SVY_DB_SID	☐	CRM Surveys: Survey ID
12	SURVEYVERSION_SV	CRM_SVY_DB_SVS	SURVEYVERSION		☐	CRM_SVY_DB_SVERS	☐	CRM Surveys: Survey Version
13	CLIENT_QSTN	CRM_SVY_RE_QSTNR	CLIENT		☐	MANDT	☐	Client
14	LANGUAGE_QSTN	CRM_SVY_RE_QSTNR	LANGUAGE		☐	LANGU	☐	Language Key
15	APPLICATION_QSTN	CRM_SVY_RE_QSTNR	APPLICATION		☐	CRM_SVY_RE_BW_APPL	☐	CRM Survey: BW Application
16	SURVEY_QSTN	CRM_SVY_RE_QSTNR	SURVEY		☐	CRM_SVY_RE_SURVEY	☐	CRM Survey: BW Survey (Not Filled by CRM Survey)
17	QSTNNR_QSTN	CRM_SVY_RE_QSTNR	QSTNNR		☐	CRM_SVY_RE_QSTNNR	☐	CRM Survey: Questionnaire
18	TXTLG_QSTN	CRM_SVY_RE_QSTNR	TXTLG		☐	CRM_SVY_RE_TXTLG	☐	CRM Survey: Long Description
19	SURVEY_ID_QSTN	CRM_SVY_RE_QSTNR	SURVEY_ID		☐	CRM_SVY_DB_SID	☐	CRM Surveys: Survey ID
20	SURVEY_VERSION_Q	CRM_SVY_RE_QSTNR	SURVEY_VERSION		☐	CRM_SVY_DB_SVERS	☐	CRM Surveys: Survey Version
21	CLIENT_QUES	CRM_SVY_RE_QUEST	CLIENT		☐	MANDT	☐	Client
22	LANGUAGE_QUES	CRM_SVY_RE_QUEST	LANGUAGE		☐	LANGU	☐	Language Key
23	APPLICATION_QUES	CRM_SVY_RE_QUEST	APPLICATION		☐	CRM_SVY_RE_BW_APPL	☐	CRM Survey: BW Application
24	SURVEY_QUES	CRM_SVY_RE_QUEST	SURVEY		☐	CRM_SVY_RE_SURVEY	☐	CRM Survey: BW Survey (Not Filled by CRM Survey)
25	QSTNNR_QUES	CRM_SVY_RE_QUEST	QSTNNR		☐	CRM_SVY_RE_QSTNNR	☐	CRM Survey: Questionnaire
26	CONSNR	CRM_SVY_RE_QUEST	CONSNR		☐	CRM_SVY_RE_CONSNR	☐	CRM Survey: Sequence Number for Questions
27	QUEST_QUES	CRM_SVY_RE_QUEST	QUEST		☐	CRM_SVY_RE_BW_QUEST	☐	Question
28	TXTLG_QUES	CRM_SVY_RE_QUEST	TXTLG		☐	CRM_SVY_RE_TXTLG	☐	CRM Survey: Long Description
29	SURVEY_ID_QUES	CRM_SVY_RE_QUEST	SURVEY_ID		☐	CRM_SVY_DB_SID	☐	CRM Surveys: Survey ID
30	SURVEY_VERSION_F	CRM_SVY_RE_QUEST	SURVEY_VERSION		☐	CRM_SVY_DB_SVERS	☐	CRM Surveys: Survey Version
31	CLIENT_ANSW	CRM_SVY_RE_ANSW	CLIENT		☐	MANDT	☐	Client
32	LANGUAGE_ANSW	CRM_SVY_RE_ANSW	LANGUAGE		☐	LANGU	☐	Language Key
33	APPLICATION_ANSW	CRM_SVY_RE_ANSW	APPLICATION		☐	CRM_SVY_RE_BW_APPL	☐	CRM Survey: BW Application
34	SURVEY_ANSW	CRM_SVY_RE_ANSW	SURVEY		☐	CRM_SVY_RE_SURVEY	☐	CRM Survey: BW Survey (Not Filled by CRM Survey)
35	QSTNNR_ANSW	CRM_SVY_RE_ANSW	QSTNNR		☐	CRM_SVY_RE_QSTNNR	☐	CRM Survey: Questionnaire
36	QUEST_ANSW	CRM_SVY_RE_ANSW	QUEST		☐	CRM_SVY_RE_BW_QUEST	☐	Question
37	ANSWER	CRM_SVY_RE_ANSW	ANSWER		☐	CRM_SVY_RE_BW_ANSWER	☐	Answer Option
38	TXTLG_ANSW	CRM_SVY_RE_ANSW	TXTLG		☐	CRM_SVY_RE_TXTLG	☐	CRM Survey: Long Description
39	SURVEY_ID_ANSW	CRM_SVY_RE_ANSW	SURVEY_ID		☐	CRM_SVY_DB_SID	☐	CRM Surveys: Survey ID
40	SURVEY_VERSION_A	CRM_SVY_RE_ANSW	SURVEY_VERSION		☐	CRM_SVY_DB_SVERS	☐	CRM Surveys: Survey Version
41	QUEST_ID	CRM_SVY_RE_ANSW	QUEST_ID		☐	CRM_SVY_RE_QUEST_ID	☐	CRM Survey: Question ID
42	ANSWER_ID	CRM_SVY_RE_ANSW	ANSWER_ID		☐	CRM_SVY_RE_ANSWER_ID	☐	CRM Survey: Answer ID
43	CLIENT_SV	CRM_SVY_DB_SV	CLIENT		☐	MANDT	☐	Client
44	VALUEGUID_SV	CRM_SVY_DB_SV	VALUEGUID		☐	CRM_SVY_DB_SV_GUID	☐	CRM Surveys: Survey Values GUID
45	VALUEVERSION_SV	CRM_SVY_DB_SV	VALUEVERSION		☐	CRM_SVY_DB_SV_VERS	☐	CRM Surveys: Survey Values Version
46	NAME	CRM_SVY_DB_SV	NAME		☐	CRM_SVY_DB_SV_NAME	☐	CRM Surveys: Survey Value Key Attribute
47	INDX	CRM_SVY_DB_SV	INDX		☐	NUMC3	☐	Numc3, internal use
48	VALUE	CRM_SVY_DB_SV	VALUE		☐	CRM_SVY_DB_SV_VALUE	☐	CRM Surveys: Survey Value Attribute
49	XML	CRM_SVY_DB_SVS	XML		☐	CRM_SVY_DB_SVS_XML	☐	CRM Surveys: Survey Values Binary Long Object

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	20130604
SAP Release Created in	400