SAP ABAP Table EHS00S_QREL_IOT (EHS: I/O Structure - Protocol Assignment to Questionnaire)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	EHS00S_QREL_IOT	Table Relationship Diagram
Short Description	EHS: I/O Structure - Protocol Assignment to Questionnaire

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	EHS: Standard fields for IOTABs (step loop library)
2	MARKFLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
3	SELEFLG	☐	ESESELEFLG	ESDFLAG	CHAR	1	0	Step Loop Line Selected
4	LINENO	☐	ESECOUNTER	NUMC10	NUMC	10	0	General Auxiliary Counter
5	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
6	CHCOFLG	☐	ESECHCOFLG	ESDFLAG	CHAR	1	0	Indicator: Change number collision
7	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
8	INTRFLG	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
9	.INCLUDE	☐				0	0	EHS: Standard Fields for EHS-OH API Structures
10	ERRORMODE	☐	ESEERRMODE	CHAR1	CHAR	1	0	Indicator: Error or warning in an API function
11	ERRORINFO	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
12	ERRORCLASS	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
13	ERRORPARAM	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
14	LOGLOCKMOD	☐	ESELGLCKMD	CHAR1	CHAR	1	0	Logical Lock Mode
15	EXTINFO	☐	ESEEXTINFO	CHAR10	CHAR	10	0	External Information
16	ACTYPE	☐	AKTYP	AKTYP	CHAR	1	0	Activity category in SAP transaction
17	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
18	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
19	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
20	.INCLUDE	☐				0	0	Questionnaire Assignment
21	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
22	TYPE	☐	EHS00_RELTYPE	CHAR3	CHAR	3	0	Questionnaire Assignment Category	T7EHS00_QRELTYP
23	REL_ID	☐	EHS00_RELID	CHAR10	CHAR	10	0	Questionnaire Assignment ID
24	Q_ID	☐	EHS00_QID	NUMC06	NUMC	6	0	Number of General Questionnaire	*
25	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
26	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
27	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
28	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
29	ENDDA_SAVED	☐	ENDDATUM	DATUM	DATS	8	0	End Date
30	Q_BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
31	Q_ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
32	Q_NAME	☐	EHS00_QNAME	TEXT50	CHAR	50	0	Description of General Questionnaire
33	Q_STATUS	☐	EHS00_STATUS	CHAR01	CHAR	1	0	Object Status
34	Q_FRTYP	☐	EHS00_FRTYP	EHS00_FRTYP	CHAR	3	0	Examination Type
35	Q_FRTYPNAM	☐	EHS00_FRTYPNAM	TEXT40	CHAR	40	0	Name of Examination Type
36	PGROUP	☐	EHS00_PGROUP	EHS00_PGROUP	CHAR	3	0	Health Surveillance Protocol Category	*
37	PNUMBER	☐	EHS00_PNUMBER	CHAR3	CHAR	3	0	Protocol Number
38	PROT_ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
39	PROT_BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
40	STATUS	☐	EHS00_STATUS	CHAR01	CHAR	1	0	Object Status
41	STATUS_ICON	☐	EHS00E_QUEST_STATUS_ICON	TEXT50	CHAR	50	0	Questionnaire Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS00S_QREL_IOT	MANDT	T000	MANDT	KEY	1	CN
2	EHS00S_QREL_IOT	TYPE	T7EHS00_QRELTYP	TYPE	KEY	1	CN

History

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