SAP ABAP Table T7EHS00_QUEST (Questionnaire Definition)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ CQ99 (Package) Question Catalog and Questionnaire

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T7EHS00_QUEST	Table Relationship Diagram
Short Description	Questionnaire Definition

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	Q_ID	☑	EHS00_QID	NUMC06	NUMC	6	0	Number of General Questionnaire
3	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
4	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
5	STATUS	☐	EHS00_STATUS	CHAR01	CHAR	1	0	Object Status	T7EHS00_STATUS
6	LDATE	☐	EHS00_LDATE	DATUM	DATS	8	0	Changed On
7	LUSER	☐	EHS00_LUSER	UNAME	CHAR	12	0	Last Changed By
8	LTIME	☐	EHS00_LTIME	SYTIME	TIMS	6	0	Time of Last Change
9	FUSER	☐	EHS00_FUSER	UNAME	CHAR	12	0	Created By
10	FDATE	☐	EHS00_FDATE	DATUM	DATS	8	0	Created On
11	FTIME	☐	EHS00_FTIME	SYTIME	TIMS	6	0	Time Created
12	TYPE	☐	EHS00_RELTYPE	CHAR3	CHAR	3	0	Questionnaire Assignment Category	T7EHS00_QRELTYP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7EHS00_QUEST	MANDT	T000	MANDT	KEY	1	CN
2	T7EHS00_QUEST	STATUS	T7EHS00_STATUS	STATUS	REF	1	CN
3	T7EHS00_QUEST	TYPE	T7EHS00_QRELTYP	TYPE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in