SAP ABAP Table CCIHS_IALHIOT (EHS: IOTAB for Incident/Accident Log (CCIHT_IAL))

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_IALHIOT	Table Relationship Diagram
Short Description	EHS: IOTAB for Incident/Accident Log (CCIHT_IAL)

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: Incident/Accident Log - Header
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	IALID	☐	CCIHE_IALID	CCIHD_IAID	CHAR	20	0	Incident/Accident Log Entry
28	IATYPE	☐	CCIHE_IATYPE	CCIHD_IATYPE	CHAR	3	0	Incident/Accident Log Entry Type	CCIHC_IATYPE
29	IAPLANT	☐	CCIHE_IAPLANT	WERKS	CHAR	4	0	Plant Assignment for the Log Entry	T001W
30	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
31	IASTATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
32	EVDESC	☐	CCIHE_EVDESCLXT	TEXT60	CHAR	60	0	Event Description
33	DMTYPE	☐	CCIHE_DMTYPE	CCIHD_DMTYPE	CHAR	21	0	Type of Damage	*
34	TPLNR	☐	CCIHE_FUNLOC	CCIHD_FUNLOC	CHAR	30	0	Functional Location	*
35	EQUNR	☐	CCIHE_EQUNR	CHAR18	CHAR	18	0	Equipment Number	*
36	EQDESC	☐	CCIHE_EQDESC	TEXT80	CHAR	80	0	Description of Machine
37	FATALFLG	☐	CCIHE_FATALFLG	ESDFLAG	CHAR	1	0	Fatality
38	CNTRFLG	☐	CCIHE_CNTRFLG	ESDFLAG	CHAR	1	0	Contractor Affected
39	INVRESULT	☐	CCIHE_INVRESULT	TEXT60	CHAR	60	0	Investigation Result
40	INVRESULTFLG	☐	CCIHE_INVRESULTFLG	FLAG	CHAR	1	0	Indicator for SAPscript Text
41	PMFLG	☐	CCIHE_PMFLG	ESDFLAG	CHAR	1	0	Maintenance Required
42	PRODLFLG	☐	CCIHE_PRODLFLG	ESDFLAG	CHAR	1	0	Production Time Lost
43	MTNLANGU	☐	CCIHE_MTNLANGU	SPRAS	LANG	1	0	Language of Entry	T002
44	.INCLUDE	☐				0	0	EHS: Event Data
45	EVDAT	☐	CCIHE_EVDAT	DATUM	DATS	8	0	Event Date
46	EVTIME	☐	CCIHE_EVTIME	TIME	TIMS	6	0	Event Time
47	RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
48	ACLOC	☐	CCIHE_ACLOC	CCIHD_ACLOC	CHAR	10	0	Accident Location	*
49	ACLOCDESC	☐	CCIHE_ACLOCDESC	TEXT60	CHAR	60	0	Description of Accident Location
50	EVTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
51	IAREPHDFLG	☐	CCIHE_IAREPHDFLG	ESDFLAG	CHAR	1	0	Reportable Event
52	FLPLANT	☐	CCIHE_FLPLANT	WERKS	CHAR	4	0	Functional Location Plant	T001W
53	IALDEADFLG	☐	CCIHE_FATALFLG	ESDFLAG	CHAR	1	0	Fatality
54	IATYPETXT	☐	CCIHE_IATYPETXT	TEXT40	CHAR	40	0	Description of Log Entry Type
55	IAPLANTXT	☐	CCIHE_IAPLANTTXT	TEXT30	CHAR	30	0	Description of Plant for Incident/Accident Log Entry
56	DMTYPETXT	☐	CCIHE_DMTYPETXT	TEXT132	CHAR	132	0	Description of Damage Type
57	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
58	EQTXT	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
59	WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
60	WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
61	ACLOCTXT	☐	CCIHE_ACLOCTXT	TEXT40	CHAR	40	0	Description of Accident Location
62	ACFLG	☐	CCIHE_ACFLG	ESDFLAG	CHAR	1	0	Safety Measures Exist
63	WTLFLG	☐	CCIHE_WTLFLG	ESDFLAG	CHAR	1	0	Witness List Entry Available
64	PMOFLG	☐	CCIHE_PMOFLG	ESDFLAG	CHAR	1	0	Maintenance Orders Exist
65	COFLG	☐	CCIHE_COFLG	ESDFLAG	CHAR	1	0	Costs Exist
66	QUESFLG	☐	CCIHE_QUESFLG	ESDFLAG	CHAR	1	0	Questionnaire Exists
67	IASHSTATNAM	☐	CCIHE_IASHSTATNAM	TEXT4	CHAR	4	0	Incident/Accident Log Entry Status
68	IASTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
69	KEYDRAWNFLG	☐	CCIHE_KEYDRAWN	ESDFLAG	CHAR	1	0	Key Assigned Automatically
70	TMODNEWFLG	☐	CCIHE_TRANSMOD	ESDFLAG	CHAR	1	0	Transport Mode Injury/Illness Log to Incident/Accident Log
71	TMODEXSFLG	☐	CCIHE_TRANSMOD	ESDFLAG	CHAR	1	0	Transport Mode Injury/Illness Log to Incident/Accident Log
72	MTNLANGUTXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
73	SRV_NUMBER	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service
74	FLPLANTTXT	☐	CCIHE_FLPLANTTXT	TEXT30	CHAR	30	0	Name of Functional Location Plant
75	STRNO	☐	CCIHE_STRNO	CHAR40	CHAR	40	0	Functional Location Label

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_IALHIOT	AENNR	AENR	AENNR	REF	1	CN
2	CCIHS_IALHIOT	EVTIMEZONE	TTZZ	TZONE	REF	1	CN
3	CCIHS_IALHIOT	FLPLANT	T001W	WERKS	REF	C	CN
4	CCIHS_IALHIOT	IAPLANT	T001W	WERKS	REF	1	CN
5	CCIHS_IALHIOT	IATYPE	CCIHC_IATYPE	IATYPE	REF	C	CN
6	CCIHS_IALHIOT	MANDT	T000	MANDT	KEY	1	CN
7	CCIHS_IALHIOT	MTNLANGU	T002	SPRAS	REF	1	CN
8	CCIHS_IALHIOT	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in