SAP ABAP Table CCIHS_ERQTIOT (EHS: IOTAB Structure Exposure Log - Exposure Amounts)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-IHS (Application Component) Industrial Hygiene and Safety
     ⤷ CBIH (Package) EH&S: Industrial Hygiene and Safety

Basic Data

Table Category	INTTAB	Structure
Structure	CCIHS_ERQTIOT	Table Relationship Diagram
Short Description	EHS: IOTAB Structure Exposure Log - Exposure Amounts

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: Exposure Assignment - Exposure Amounts
10	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
11	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
12	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
13	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
14	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
15	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
16	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
17	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
18	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
19	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
20	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
21	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
22	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
23	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
24	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
25	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
26	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
27	.INCLUDE	☐				0	0	EHS: Measurement Structure
28	EPQUANTTYPE	☐	CCIHE_EPQUANTTYPE	CCIHD_EPQUANTTYP	CHAR	3	0	Amount Category	CCIHC_QT01
29	LTTYPE	☐	CCIHE_LTTYPE	CCIHD_LTTYPE	CHAR	3	0	Measured Value/Reference Value Category	CCIHV_LT01
30	EPQUANTSET	☐	CCIHE_EPQUANTSET	CCIHD_SETNUMBER	NUMC	8	0	Measurement Number
31	EPQUANTVAL	☐	CCIHE_EPQUANTVAL	CCIHD_EPQUANTVAL	DEC	10	4	Measurement Value of Physical Variable
32	HQVALFLOAT	☐	CCIHE_HQVALFLOAT	FLOATING	FLTP	16	16	Measured Physical Variable Value (FLOAT)
33	HQVALDECIMALS	☐	CCIHE_HQVALDECIMALS	INT4	INT4	10	0	Decimal Places for a Measured Physical Variable Value
34	EPQUNIT	☐	CCIHE_EPQUANTUNIT	MEINS	UNIT	3	0	Unit of Measurement for Exposure Amount	*
35	MSRBGNDATE	☐	CCIHE_MSRBGNDATE	DATUM	DATS	8	0	Date of Start of Measurement
36	MSRBGNTIME	☐	CCIHE_MSRBGNTIME	UZEIT	TIMS	6	0	Time of Start of Measurement
37	MSRENDDATE	☐	CCIHE_MSRENDDATE	DATUM	DATS	8	0	Date of End of Measurement
38	MSRENDTIME	☐	CCIHE_MSRENDTIME	UZEIT	TIMS	6	0	Time of End of Measurement
39	MSRNAM	☐	CCIHE_MSRNAM	USNAM	CHAR	12	0	Person Acting or Responsible
40	MSRNAMFLG	☐	CCIHE_IPPFLAG	CCIHD_PERSFLAG	CHAR	1	0	External Person
41	MSRORDNR	☐	CCIHE_MSRORDNR	CCIHD_MSRORDNR	CHAR	20	0	Measurement Job Number
42	MSRDESC	☐	CCIHE_MSRDESC	TEXT132	CHAR	132	0	Description of Measurement
43	MSRDESCFLG	☐	CCIHE_MSRDESCFLG	FLAG	CHAR	1	0	Indicator for SAPscript Text
44	MSRPROCEDURE	☐	CCIHE_MSRPROCEDURE	CCIHD_MSRPROCEDURE	CHAR	21	0	Measurement Method
45	MSRSTAT	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
46	MSRINITSTAT	☐	CCIHE_INITSTATUS	J_STATUS	CHAR	5	0	Initial Status of an Object
47	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
48	MSRNAMGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
49	RECNTMJ	☐	CCIHE_RECNTMJ	ESDRECN	NUMC	20	0	Reference to Measurement
50	RECNTMP	☐	CCIHE_RECNTMP	ESDRECN	NUMC	20	0	Reference to Measurement Project
51	PROBANDGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
52	PROBAND	☐	CCIHE_MJPERSON	CCIHD_MJPERSON	CHAR	10	0	Test Person
53	EPQUANTNAM	☐	CCIHE_EPQUANTNAM	TEXT26	CHAR	26	0	Description of Amount Category
54	LTTYPENAM	☐	CCIHE_LTTYPENAM	TEXT26	CHAR	26	0	Description of Measured Value Category	CCIHV_LT01
55	EPQUNITNAM	☐	CCIHE_EPQUNITNAM	MSEH6	CHAR	6	0	Unit of Measurement	CCIHV_UNIT
56	EPTYPE	☐	CCIHE_EPTYPE	ESDSUBCAT	CHAR	10	0	Agent Type	*
57	EPQDIMID	☐	DIMID	DIMID	CHAR	6	0	Dimension key	*
58	EXCLUDEFLG	☐	CCIHE_EXCLUDEFLG	ESDFLAG	CHAR	1	0	Exclude Value
59	HQVCHAR12	☐	CCIHE_HQVCHAR12	CHAR12	CHAR	12	0	Measurement of Measured Physical Variable
60	MSRNAMFULL	☐	CCIHE_FULLNAME	TEXT80	CHAR	80	0	Full Name of Person
61	MSRSHSTATNAM	☐	CCIHE_MSRSHSTATNAM	TEXT4	CHAR	4	0	Status of Amount Record
62	MSRSTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
63	MSRPROCEDURETXT	☐	CCIHE_MSRPROCEDURETXT	CHAR132	CHAR	132	0	Language-Dependent Description of Measurement Method
64	SPLITTFLG	☐	CCIHE_SPLITTFLG	FLAG	CHAR	1	0	Record Split
65	MSRNAMGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
66	MJCATTXT	☐	CCIHE_MJCATTXT	TEXT60	CHAR	60	0	Description of Sampling Type
67	MPID	☐	CCIHE_MPID	CCIHD_MPID	CHAR	30	0	Measurement Project
68	MPTYPE	☐	CCIHE_MPTYPETXT	TEXT60	CHAR	60	0	Description of the Measurement Project Type
69	MJID	☐	CCIHE_MJID	CCIHD_MJID	CHAR	30	0	Measurement Number
70	PROBANDNAME	☐	CCIHE_FULLNAME	TEXT80	CHAR	80	0	Full Name of Person

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_ERQTIOT	AENNR	AENR	AENNR	REF	1	CN
2	CCIHS_ERQTIOT	EPQUANTTYPE	CCIHC_QT01	EPQUANTTYPE	REF	1	CN
3	CCIHS_ERQTIOT	EPQUNITNAM	CCIHV_UNIT	MSEH6	REF	1	CN
4	CCIHS_ERQTIOT	LTTYPE	CCIHV_LT01	LTTYPE	REF	1	CN
5	CCIHS_ERQTIOT	LTTYPENAM	CCIHV_LT01	LTTYPENAM		1	CN
6	CCIHS_ERQTIOT	MANDT	T000	MANDT
7	CCIHS_ERQTIOT	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in