SAP ABAP Table CCIHT_IAL (EHS: Incident/Accident Log - Header)

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	TRANSP	Transparent table
Transparent table	CCIHT_IAL	Table Relationship Diagram
Short Description	EHS: Incident/Accident Log - Header

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	EHS: Structure for key info of master data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
4	ACTN	☑	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
5	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
6	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
7	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
8	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
9	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
10	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
11	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
12	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
13	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
14	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
15	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
16	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
17	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
18	IALID	☐	CCIHE_IALID	CCIHD_IAID	CHAR	20	0	Incident/Accident Log Entry
19	IATYPE	☐	CCIHE_IATYPE	CCIHD_IATYPE	CHAR	3	0	Incident/Accident Log Entry Type	CCIHC_IATYPE
20	IAPLANT	☐	CCIHE_IAPLANT	WERKS	CHAR	4	0	Plant Assignment for the Log Entry	T001W
21	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
22	IASTATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
23	EVDESC	☐	CCIHE_EVDESCLXT	TEXT60	CHAR	60	0	Event Description
24	DMTYPE	☐	CCIHE_DMTYPE	CCIHD_DMTYPE	CHAR	21	0	Type of Damage
25	TPLNR	☐	CCIHE_FUNLOC	CCIHD_FUNLOC	CHAR	30	0	Functional Location
26	EQUNR	☐	CCIHE_EQUNR	CHAR18	CHAR	18	0	Equipment Number
27	EQDESC	☐	CCIHE_EQDESC	TEXT80	CHAR	80	0	Description of Machine
28	FATALFLG	☐	CCIHE_FATALFLG	ESDFLAG	CHAR	1	0	Fatality
29	CNTRFLG	☐	CCIHE_CNTRFLG	ESDFLAG	CHAR	1	0	Contractor Affected
30	INVRESULT	☐	CCIHE_INVRESULT	TEXT60	CHAR	60	0	Investigation Result
31	INVRESULTFLG	☐	CCIHE_INVRESULTFLG	FLAG	CHAR	1	0	Indicator for SAPscript Text
32	PMFLG	☐	CCIHE_PMFLG	ESDFLAG	CHAR	1	0	Maintenance Required
33	PRODLFLG	☐	CCIHE_PRODLFLG	ESDFLAG	CHAR	1	0	Production Time Lost
34	MTNLANGU	☐	CCIHE_MTNLANGU	SPRAS	LANG	1	0	Language of Entry	T002
35	.INCLUDE	☐				0	0	EHS: Event Data
36	EVDAT	☐	CCIHE_EVDAT	DATUM	DATS	8	0	Event Date
37	EVTIME	☐	CCIHE_EVTIME	TIME	TIMS	6	0	Event Time
38	RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
39	ACLOC	☐	CCIHE_ACLOC	CCIHD_ACLOC	CHAR	10	0	Accident Location	*
40	ACLOCDESC	☐	CCIHE_ACLOCDESC	TEXT60	CHAR	60	0	Description of Accident Location
41	EVTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
42	IAREPHDFLG	☐	CCIHE_IAREPHDFLG	ESDFLAG	CHAR	1	0	Reportable Event
43	FLPLANT	☐	CCIHE_FLPLANT	WERKS	CHAR	4	0	Functional Location Plant	T001W

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in