SAP ABAP Table T7EHS00_QREL (Questionnaire Assignment)

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_QREL	Table Relationship Diagram
Short Description	Questionnaire Assignment

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	TYPE	☑	EHS00_RELTYPE	CHAR3	CHAR	3	0	Questionnaire Assignment Category	T7EHS00_QRELTYP
3	REL_ID	☑	EHS00_RELID	CHAR10	CHAR	10	0	Questionnaire Assignment ID
4	Q_ID	☑	EHS00_QID	NUMC06	NUMC	6	0	Number of General Questionnaire	T7EHS00_QUEST
5	ENDDA	☑	ENDDATUM	DATUM	DATS	8	0	End Date
6	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
7	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7EHS00_QREL	MANDT	T000	MANDT	KEY	1	CN
2	T7EHS00_QREL	Q_ID	T7EHS00_QUEST	Q_ID	KEY
3	T7EHS00_QREL	TYPE	T7EHS00_QRELTYP	TYPE	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in