SAP ABAP Table EHS00S_AGENT_IOT (EHS: I/O Structure of Basic Data - Agent)

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_AGENT_IOT	Table Relationship Diagram
Short Description	EHS: I/O Structure of Basic Data - Agent

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	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
18	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
19	.INCLUDE	☐				0	0	Agents for Protocol
20	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
21	PGROUP	☐	EHS00_PGROUP	EHS00_PGROUP	CHAR	3	0	Health Surveillance Protocol Category	T7EHS00_PGROUP
22	PNUMBER	☐	EHS00_PNUMBER	CHAR3	CHAR	3	0	Protocol Number	T7EHS00_PROT
23	AGENT_ID	☐	EHS00_AGEID	CCIHD_EPID	CHAR	20	0	Agent	T7EHS00_AGENT
24	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
25	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
26	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
27	KTEXT	☐	EHS00_MEMO75	EHS00_MEMO75	CHAR	75	0	Notes Field (75 Characters)
28	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
29	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
30	STARDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
31	STOPDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
32	.INCLUDE	☐				0	0	EHS: Structure for Administration Fields
33	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	*
34	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
35	CRDTIMESTAMP	☐	EHS00_CRTS		DEC	15	0	Creation Time
36	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
37	UPDTIMESTAMP	☐	EHS00_UPDTS		DEC	15	0	Time of Last Change
38	AGE_FROM	☐	EHS00E_AG_AGE_FROM	EHS00D_AGE	NUMC	3	0	Age from Which Trigger Levels Apply
39	AGE_TO	☐	EHS00E_AG_AGE_TO		NUMC	3	0	Age to Which Trigger Levels Apply
40	GENDER	☐	GESCH	GESCH	CHAR	1	0	Gender Key
41	LTA_TRIGGER	☐	EHS00_AERT1	EHS00_AERAT	CHAR	1	0	Long-Term Average Trigger Level	T7EHS00RA
42	FREQ_FULL_RV_EX	☐	EHS00_RAT15	EHS00_14RAT	CHAR	1	0	Frequency Reference Values Exceeded	T7EHS00RN
43	FREQ_ACT_LEV_EX	☐	EHS00_RAT16	EHS00_14RAT	CHAR	1	0	Frequency Trigger Levels Exceeded	T7EHS00RN
44	ER_RAT_TRIG	☐	EHS00_AERT3	EHS00_AERAT	CHAR	1	0	Short-Time Exposure Rating	T7EHS00RA
45	ER_RAT_FREQ_TRIG	☐	EHS00_RAT01	EHS00_14RAT	CHAR	1	0	Exposure Frequency Trigger Level	T7EHS00RN
46	AND_LTA_TRIGGER	☐	EHS00_AERT2	EHS00_AERAT	CHAR	1	0	Additional Long-Term Average Trigger Level	T7EHS00RA
47	SKINEFFFREQ_TRIG	☐	EHS00_RAT03	EHS00_14RAT	CHAR	1	0	Skin Exposure Effects Trigger Level	T7EHS00RN
48	SKINEXPFREQ_TRIG	☐	EHS00_RAT02	EHS00_14RAT	CHAR	1	0	Skin Absorption Trigger Level	T7EHS00RN
49	INGESTFREQ_TRIG	☐	EHS00_RAT04	EHS00_14RAT	CHAR	1	0	Ingestion Effects Trigger Level	T7EHS00RN
50	EPNAM	☐	CCIHE_EPNAM	TEXT60	CHAR	60	0	Description of Agent
51	GENDERTEXT	☐	CCIHE_GENDERTEXT	CHAR60	CHAR	60	0	Description of Gender
52	LTA_TRIGGERTXT	☐	EHS00_TXT75	TEXT75	CHAR	75	0	Text field length 75
53	FREQ_FULL_RV_EXTXT	☐	EHS00_TXT75	TEXT75	CHAR	75	0	Text field length 75
54	FREQ_ACT_LEV_EXTXT	☐	EHS00_TXT75	TEXT75	CHAR	75	0	Text field length 75
55	ER_RAT_TRIGTXT	☐	EHS00_TXT75	TEXT75	CHAR	75	0	Text field length 75
56	ER_RAT_FREQ_TRIGTXT	☐	EHS00_TXT75	TEXT75	CHAR	75	0	Text field length 75
57	AND_LTA_TRIGGERTXT	☐	EHS00_TXT75	TEXT75	CHAR	75	0	Text field length 75
58	SKINEFFFREQ_TRIGTXT	☐	EHS00_TXT75	TEXT75	CHAR	75	0	Text field length 75
59	SKINEXPFREQ_TRIGTXT	☐	EHS00_TXT75	TEXT75	CHAR	75	0	Text field length 75
60	INGESTFREQ_TRIGTXT	☐	EHS00_TXT75	TEXT75	CHAR	75	0	Text field length 75

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS00S_AGENT_IOT	AGENT_ID	T7EHS00_AGENT	AGENT_ID	KEY
2	EHS00S_AGENT_IOT	AND_LTA_TRIGGER	T7EHS00RA	ARATE	REF	C	CN
3	EHS00S_AGENT_IOT	ER_RAT_FREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN
4	EHS00S_AGENT_IOT	ER_RAT_TRIG	T7EHS00RA	ARATE	REF	C	CN
5	EHS00S_AGENT_IOT	FREQ_ACT_LEV_EX	T7EHS00RN	NRATE	REF	C	CN
6	EHS00S_AGENT_IOT	FREQ_FULL_RV_EX	T7EHS00RN	NRATE	REF	C	CN
7	EHS00S_AGENT_IOT	INGESTFREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN
8	EHS00S_AGENT_IOT	LTA_TRIGGER	T7EHS00RA	ARATE	REF	C	CN
9	EHS00S_AGENT_IOT	MANDT	T000	MANDT	KEY	1	CN
10	EHS00S_AGENT_IOT	PGROUP	T7EHS00_PGROUP	PGROUP	KEY	1	CN
11	EHS00S_AGENT_IOT	PNUMBER	T7EHS00_PROT	PNUMBER	KEY	1	CN
12	EHS00S_AGENT_IOT	SKINEFFFREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN
13	EHS00S_AGENT_IOT	SKINEXPFREQ_TRIG	T7EHS00RN	NRATE	REF	C	CN

History

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