SAP ABAP Table EHS00S_EXTRACT (EHS: Catalog Entry Line)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-HEA (Application Component) Occupational Health
     ⤷ P99Q1_PDF (Package) EH&S: Adobe Forms in Occupational Health

Basic Data

Table Category	INTTAB	Structure
Structure	EHS00S_EXTRACT	Table Relationship Diagram
Short Description	EHS: Catalog Entry Line

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	QUEST_CATALOG	☐	EHS00_QCATALOG	NUMC03	NUMC	3	0	Number of Question Catalog	T7EHS00_CATALOG
4	QUEST_GROUP	☐	EHS00_QGROUP	NUMC02	NUMC	2	0	Catalog Group	T7EHS00_QGROUP
5	QUEST_ID	☐	EHS00_QUESTID	NUMC05	NUMC	5	0	Number of Catalog Entry
6	SPRAS	☐	EHS00_SPRAS	SPRAS	LANG	1	0	Language	T002
7	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
8	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
9	QUEST_TYPE	☐	EHS00_QTYPE	CHAR02	CHAR	2	0	Catalog Entry Category	T7EHS00_QTYPE
10	ANSWER_TYPE	☐	EHS00_ANSWERTYP	NUMC03	NUMC	3	0	Answer Type	T7EHS00_ANSWTYP
11	STATUS	☐	EHS00_TXT1	CHAR01	CHAR	1	0	Object Status	T7EHS00_STATUS
12	S_LANGU	☐	EHS00_SSPRAS	SPRAS	LANG	1	0	Source Language	*
13	FUSER	☐	EHS00_FUSER	UNAME	CHAR	12	0	Created By
14	FDATE	☐	EHS00_FDATE	DATUM	DATS	8	0	Created On
15	FTIME	☐	EHS00_FTIME	SYTIME	TIMS	6	0	Time Created
16	LUSER	☐	EHS00_LUSER	UNAME	CHAR	12	0	Last Changed By
17	LDATE	☐	EHS00_LDATE	DATUM	DATS	8	0	Changed On
18	LTIME	☐	EHS00_LTIME	SYTIME	TIMS	6	0	Time of Last Change
19	Q_SCORING	☐	EHS00_SCORE	CHAR02	CHAR	2	0	Weighting
20	TEXT	☐	EHS00_TXT255	TEXT255	CHAR	255	0	Catalog Entry Text
21	LTXT_FLAG	☐	EHS00_BOOLEAN	BOOLEAN	CHAR	1	0	Identification Flag
22	CAT_BEZ	☐	EHS00_TXT40	TEXT40	CHAR	40	0	Description
23	STATUST	☐	EHS00_STATUST	TEXT30	CHAR	30	0	Object Status
24	QGROUPT	☐	EHS00_QGROUPT	TEXT30	CHAR	30	0	Description of Catalog Group
25	QEUNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
26	QEAEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
27	QLTIME	☐	EHS00_LTIME	SYTIME	TIMS	6	0	Time of Last Change
28	QLSTATUS	☐	EHS00_QLSTATUS	CHAR01	CHAR	1	0	Text Status	T7EHS00_STATUS
29	TYPE	☐	EHS00_RELTYPE	CHAR3	CHAR	3	0	Questionnaire Assignment Category	T7EHS00_QRELTYP
30	TDOBJECT	☐	TDOBJECT	TDOBJECT	CHAR	10	0	Texts: application object	*
31	TDNAME	☐	TDOBNAME	TDOBNAME	CHAR	70	0	Name
32	TDID	☐	TDID	TDID	CHAR	4	0	Text ID	*
33	TDSPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS00S_EXTRACT	ANSWER_TYPE	T7EHS00_ANSWTYP	QANSW_TYPE	REF	1	CN
2	EHS00S_EXTRACT	MANDT	T000	MANDT	KEY
3	EHS00S_EXTRACT	QLSTATUS	T7EHS00_STATUS	STATUS	REF	1	CN
4	EHS00S_EXTRACT	QUEST_CATALOG	T7EHS00_CATALOG	QUEST_CATALOG	KEY	1	CN
5	EHS00S_EXTRACT	QUEST_GROUP	T7EHS00_QGROUP	QUEST_GROUP	KEY	1	CN
6	EHS00S_EXTRACT	QUEST_TYPE	T7EHS00_QTYPE	QUEST_TYPE	REF	1	CN
7	EHS00S_EXTRACT	SPRAS	T002	SPRAS	KEY	1	CN
8	EHS00S_EXTRACT	STATUS	T7EHS00_STATUS	STATUS	REF	1	CN
9	EHS00S_EXTRACT	TYPE	T7EHS00_QRELTYP	TYPE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	604