SAP ABAP View V_SURQUESTQ (Survey structure (EHS) question list)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CO (Application Component) Controlling
     ⤷ KSUR (Package) Survey Main Components

Basic Data

View Type	D	Database View
Database View	V_SURQUESTQ
Short Description	Survey structure (EHS) question list
Root table	T7EHS00_QUESTQ	Individual Questions in Questionnaire

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T7EHS00_QUESTQ	T7EHS00_QUESTQ
2	SURQUESTQEXT
3	T7EHS00_FKATALOG
4	SURQUESEXT
5	T7EHS00_QEDITOR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	T7EHS00_QUESTQ	MANDT	JL	EQ				0	0
2	SURQUESTQEXT	MANDT	JR	EQ			AND	0	0
3	T7EHS00_QUESTQ	Q_ID	JL	EQ				0	0
4	SURQUESTQEXT	Q_ID	JR	EQ			AND	0	0
5	T7EHS00_QUESTQ	QUEST_QCATALOG	JL	EQ				0	0
6	SURQUESTQEXT	QUEST_QCATALOG	JR	EQ			AND	0	0
7	T7EHS00_QUESTQ	QUEST_GROUP	JL	EQ				0	0
8	SURQUESTQEXT	QUEST_GROUP	JR	EQ			AND	0	0
9	T7EHS00_QUESTQ	QUEST_ID	JL	EQ				0	0
10	SURQUESTQEXT	QUEST_ID	JR	EQ			AND	0	0
11	T7EHS00_QUESTQ	QUEST_OCCUR	JL	EQ				0	0
12	SURQUESTQEXT	QUEST_OCCUR	JR	EQ			AND	0	0
13	T7EHS00_QUESTQ	MANDT	JL	EQ				0	0
14	T7EHS00_FKATALOG	MANDT	JR	EQ			AND	0	0
15	T7EHS00_QUESTQ	QUEST_QCATALOG	JL	EQ				0	0
16	T7EHS00_FKATALOG	QUEST_CATALOG	JR	EQ			AND	0	0
17	T7EHS00_QUESTQ	QUEST_GROUP	JL	EQ				0	0
18	T7EHS00_FKATALOG	QUEST_GROUP	JR	EQ			AND	0	0
19	T7EHS00_QUESTQ	QUEST_ID	JL	EQ				0	0
20	T7EHS00_FKATALOG	QUEST_ID	JR	EQ			AND	0	0
21	T7EHS00_QUESTQ	MANDT	JL	EQ				0	0
22	SURQUESEXT	CLIENT	JR	EQ			AND	0	0
23	T7EHS00_QUESTQ	QUEST_QCATALOG	JL	EQ				0	0
24	SURQUESEXT	QUEST_QCATALOG	JR	EQ			AND	0	0
25	T7EHS00_QUESTQ	QUEST_GROUP	JL	EQ				0	0
26	SURQUESEXT	QUEST_GROUP	JR	EQ			AND	0	0
27	T7EHS00_QUESTQ	QUEST_ID	JL	EQ				0	0
28	SURQUESEXT	QUEST_ID	JR	EQ			AND	0	0
29	T7EHS00_QUESTQ	MANDT	JL	EQ				0	0
30	T7EHS00_QEDITOR	MANDT	JR	EQ			AND	0	0
31	T7EHS00_QUESTQ	QUEST_QCATALOG	JL	EQ				0	0
32	T7EHS00_QEDITOR	QUEST_CATALOG	JR	EQ			AND	0	0
33	T7EHS00_QUESTQ	QUEST_GROUP	JL	EQ				0	0
34	T7EHS00_QEDITOR	QUEST_GROUP	JR	EQ			AND	0	0
35	T7EHS00_QUESTQ	QUEST_ID	JL	EQ				0	0
36	T7EHS00_QEDITOR	QUEST_ID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	T7EHS00_QUESTQ	MANDT		☐	MANDT	☐	Client
2	Q_ID	T7EHS00_QUESTQ	Q_ID		☐	EHS00_QID	☐	Number of General Questionnaire
3	QUEST_QCATALOG	T7EHS00_QUESTQ	QUEST_QCATALOG		☐	EHS00_QCATALOG	☐	Number of Question Catalog
4	QUEST_GROUP	T7EHS00_QUESTQ	QUEST_GROUP		☐	EHS00_QGROUP	☐	Catalog Group
5	QUEST_ID	T7EHS00_QUESTQ	QUEST_ID		☐	EHS00_QUESTID	☐	Number of Catalog Entry
6	QUEST_OCCUR	T7EHS00_QUESTQ	QUEST_OCCUR		☐	EHS00_QOCCUR	☐	Index of Catalog Entry in Questionnaire
7	SPRAS	T7EHS00_QEDITOR	SPRAS		☐	EHS00_SPRAS	☐	Language
8	SCORING	T7EHS00_QUESTQ	SCORING		☐	EHS00_SCORE	☐	Weighting
9	MANDATORY	T7EHS00_QUESTQ	MANDATORY		☐	EHS00_MANDATORY	☐	Answer Required
10	QUEST_POS	T7EHS00_QUESTQ	QUEST_POS		☐	EHS00_QPOS	☐	Position of Catalog Entries in Questionnaire
11	TARGET_REF	SURQUESTQEXT	TARGET_REF		☐	SUR_TARGET_REF	☐	Survey: Reference between question and target item
12	PRE_PARAM	SURQUESTQEXT	PRE_PARAM		☐	SUR_PRE_PARAM	☐	Survey: field contains default parameters
13	CATEGORY	SURQUESEXT	CATEGORY		☐	SUR_CATEGORY	☐	Survey: Application
14	FIELDNAME	SURQUESEXT	FIELDNAME		☐	SUR_FIELD_ID	☐	Survey: field
15	UNIT_FLAG	SURQUESEXT	UNIT_FLAG		☐	SUR_UNIT_FLAG	☐	Survey: Field with unit
16	COMMENT_FLAG	SURQUESEXT	COMMENT_FLAG		☐	SUR_COMMENT_FLAG	☐	Survey: field with commentary
17	COMPARE_FLAG	SURQUESEXT	COMPARE_FLAG		☐	SUR_COMPARE_FLAG	☐	Survey: field with comparison value
18	QUEST_TYPE	T7EHS00_FKATALOG	QUEST_TYPE		☐	EHS00_QTYPE	☐	Catalog Entry Category
19	ANSWER_TYPE	T7EHS00_FKATALOG	ANSWER_TYPE		☐	EHS00_ANSWERTYP	☐	Answer Type
20	TEXT	T7EHS00_QEDITOR	TEXT		☐	EHS00_TXT255	☐	Catalog Entry Text

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	20130529
SAP Release Created in	46C