SAP ABAP Table T7EHS00_FKATALOG (Administration Data EH&S Question Catalog)

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_FKATALOG	Table Relationship Diagram
Short Description	Administration Data EH&S Question Catalog

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

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	QUEST_CATALOG	☑	EHS00_QCATALOG	NUMC03	NUMC	3	0	Number of Question Catalog	T7EHS00_CATALOG
3	QUEST_GROUP	☑	EHS00_QGROUP	NUMC02	NUMC	2	0	Catalog Group	T7EHS00_QGROUP
4	QUEST_ID	☑	EHS00_QUESTID	NUMC05	NUMC	5	0	Number of Catalog Entry
5	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
6	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
7	QUEST_TYPE	☐	EHS00_QTYPE	CHAR02	CHAR	2	0	Catalog Entry Category	T7EHS00_QTYPE
8	ANSWER_TYPE	☐	EHS00_ANSWERTYP	NUMC03	NUMC	3	0	Answer Type	T7EHS00_ANSWTYP
9	SCORING	☐	EHS00_SCORE	CHAR02	CHAR	2	0	Weighting
10	STATUS	☐	EHS00_TXT1	CHAR01	CHAR	1	0	Object Status	T7EHS00_STATUS
11	S_LANGU	☐	EHS00_SSPRAS	SPRAS	LANG	1	0	Source Language	*
12	FUSER	☐	EHS00_FUSER	UNAME	CHAR	12	0	Created By
13	FDATE	☐	EHS00_FDATE	DATUM	DATS	8	0	Created On
14	FTIME	☐	EHS00_FTIME	SYTIME	TIMS	6	0	Time Created
15	LUSER	☐	EHS00_LUSER	UNAME	CHAR	12	0	Last Changed By
16	LDATE	☐	EHS00_LDATE	DATUM	DATS	8	0	Changed On
17	LTIME	☐	EHS00_LTIME	SYTIME	TIMS	6	0	Time of Last Change
18	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_FKATALOG	ANSWER_TYPE	T7EHS00_ANSWTYP	QANSW_TYPE	REF	1	CN
2	T7EHS00_FKATALOG	MANDT	T000	MANDT	KEY
3	T7EHS00_FKATALOG	QUEST_CATALOG	T7EHS00_CATALOG	QUEST_CATALOG	KEY	1	CN
4	T7EHS00_FKATALOG	QUEST_GROUP	T7EHS00_QGROUP	QUEST_GROUP	KEY	1	CN
5	T7EHS00_FKATALOG	QUEST_TYPE	T7EHS00_QTYPE	QUEST_TYPE	REF	1	CN
6	T7EHS00_FKATALOG	STATUS	T7EHS00_STATUS	STATUS	REF	1	CN
7	T7EHS00_FKATALOG	TYPE	T7EHS00_QRELTYP	TYPE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in