SAP ABAP Table CCIHS_IALEXPORT (EHS: Export Structure for Incident/Accident Log)

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_IALEXPORT	Table Relationship Diagram
Short Description	EHS: Export Structure for Incident/Accident Log

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	IALID	☐	CCIHE_IALID	CCIHD_IAID	CHAR	20	0	Incident/Accident Log Entry
2	IATYPE	☐	CCIHE_IATYPE	CCIHD_IATYPE	CHAR	3	0	Incident/Accident Log Entry Type	*
3	IASTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
4	IATYPETXT	☐	CCIHE_IATYPETXT	TEXT40	CHAR	40	0	Description of Log Entry Type
5	EVDAT	☐	CCIHE_EVDAT	DATUM	DATS	8	0	Event Date
6	EVTIME	☐	CCIHE_EVTIME	TIME	TIMS	6	0	Event Time
7	WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
8	WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
9	IAPLANT	☐	CCIHE_IAPLANT	WERKS	CHAR	4	0	Plant Assignment for the Log Entry	*
10	IAPLANTXT	☐	CCIHE_IAPLANTTXT	TEXT30	CHAR	30	0	Description of Plant for Incident/Accident Log Entry
11	EVDESC	☐	CCIHE_EVDESCLXT	TEXT60	CHAR	60	0	Event Description
12	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
13	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
14	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
15	EQTXT	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
16	EQDESC	☐	CCIHE_EQDESC	TEXT80	CHAR	80	0	Description of Machine
17	PMFLG	☐	CCIHE_PMFLG	ESDFLAG	CHAR	1	0	Maintenance Required
18	PRODLFLG	☐	CCIHE_PRODLFLG	ESDFLAG	CHAR	1	0	Production Time Lost
19	ACLOCTXT	☐	CCIHE_ACLOCTXT	TEXT40	CHAR	40	0	Description of Accident Location
20	ACLOCDESC	☐	CCIHE_ACLOCDESC	TEXT60	CHAR	60	0	Description of Accident Location
21	DMTYPETXT	☐	CCIHE_DMTYPETXT	TEXT132	CHAR	132	0	Description of Damage Type
22	IPTYPETXT	☐	CCIHE_IPTYPETXT	TEXT40	CHAR	40	0	Description of Person's Role
23	TITLE	☐	CCIHE_TITLE	TEXT10	CHAR	10	0	Form of Address of Person
24	FULLNAME	☐	CCIHE_FULLNAME	TEXT80	CHAR	80	0	Full Name of Person
25	BIRTHDATE	☐	CCIHE_BIRTHDATE	DATS	DATS	8	0	Person's Date of Birth
26	OFFJOBDAT	☐	CCIHE_OFFJOBDAT	DATUM	DATS	8	0	Date of Ceasing to Work
27	OFFJOBTIME	☐	CCIHE_OFFJOBTIME	UZEIT	TIMS	6	0	Time of Ceasing to Work
28	IPABSSUBTYPE	☐	CCIHE_IPABSSUBTYPE	SUBTYP	CHAR	4	0	Absence Type	*
29	IPABSBEGDAT	☐	CCIHE_IPABSBEGDAT	DATUM	DATS	8	0	Start Date of Absence
30	IPABSBEGTIME	☐	CCIHE_IPABSBEGTIME	UZEIT	TIMS	6	0	Start Time of Absence
31	IPABSENDDAT	☐	CCIHE_IPABSENDDAT	DATUM	DATS	8	0	End Date of Absence
32	IPABSENDTIME	☐	CCIHE_IPABSENDTIME	UZEIT	TIMS	6	0	End Time of Absence
33	IPABSESTDAYS	☐	CCIHE_IPABSESTDAYS	CCIHD_DAYS	DEC	6	2	Estimated Duration of Absence (in Days)
34	IAREPORTFLG	☐	CCIHE_IAREPORTFLG	ESDFLAG	CHAR	1	0	Reportable Accident
35	IALPREPID	☐	CCIHE_IALPREPID	CCIHD_PRID	CHAR	20	0	Accident Notification Number
36	IPSTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
37	IALDEADFLG	☐	CCIHE_IALPDEADFLG	ESDFLAG	CHAR	1	0	Fatality
38	IALPEXP	☐	CCIHE_IALPEXP	CCIHD_IALPEXP	NUMC	3	0	Time at Work Center in Months
39	RETJOBDAT	☐	CCIHE_RETJOBDAT	DATUM	DATS	8	0	Return to Work
40	IPABSDAYS	☐	CCIHE_IPABSDAYS	CCIHD_IPABSDAYS	DEC	6	2	Number of Workdays Absent
41	IPABSHOURS	☐	ABS_ATT_HOURS	JRSTD	DEC	7	2	Absence/Attendance hours
42	IPABSCALDAYS	☐	HRCALDAYS	HRDAYS	DEC	6	2	Calendar days
43	IPABSLFZED	☐	ENDDA	DATUM	DATS	8	0	End Date
44	IPREGWTTXT	☐	CCIHE_IPREGWTTXT	TEXT20	CHAR	20	0	Daily Work Schedule
45	IPREGWTBEG	☐	CCIHE_IPREGWTBEG	TIME	TIMS	6	0	Start of Normal Working Time
46	IPREGWTEND	☐	CCIHE_IPREGWTEND	TIME	TIMS	6	0	End of Normal Working Time
47	FRTRMTNAM	☐	CCIHE_FRTRMTNAM	TEXT60	CHAR	60	0	Further Treatment
48	IALPCATXT	☐	CCIHE_IACATXT	TEXT40	CHAR	40	0	Accident Category
49	FAPHYSNAM	☐	CCIHE_FAPHYSNAM	TEXT60	CHAR	60	0	First Physician to Give Treatment
50	IALPHOSPNAM	☐	CCIHE_IALPHOSPNAM	TEXT60	CHAR	60	0	Name of Hospital
51	IACAUSTXT	☐	CCIHE_IACAUSTXT	TEXT132	CHAR	132	0	Description of Cause of Accident
52	IAEXINFTXT	☐	CCIHE_IAEXINFTXT	TEXT132	CHAR	132	0	Description of External Influences on Accident
53	IAOBJTXT	☐	CCIHE_IAOBJTXT	TEXT132	CHAR	132	0	Description of the Object that Caused the Accident
54	IAOBJMTXT	☐	CCIHE_IAOBJMTXT	TEXT132	CHAR	132	0	Desc. of the Movement of the Object that Caused the Accident
55	IPACTTXT	☐	CCIHE_IPACTTXT	TEXT132	CHAR	132	0	Description of Activity of Injured Person
56	IPMOVTXT	☐	CCIHE_IPMOVTXT	TEXT132	CHAR	132	0	Description of Movement of Injured Person
57	PERSPROTTXT	☐	CCIHE_PERSPROTTXT	CHAR132	CHAR	132	0	Description of Personal Protective Equipment
58	TECHPROTTXT	☐	CCIHE_TECHPROTTXT	CHAR132	CHAR	132	0	Description of Technical Safety Device
59	IPEVAACTXT	☐	CCIHE_IPEVAACTXT	TEXT132	CHAR	132	0	Description of Safety Measure Taken to Prevent Accidents
60	IPAGE	☐	CCIHE_IPAGE	CCIHD_PERSONAGE	NUMC	3	0	Age in Years at Time of Accident
61	LSTSHIFT	☐	CCIHE_LSTSHIFT	NUMC3	NUMC	3	0	Lost Shifts
62	MAININJFLG	☐	CCIHE_MAININJFLG	ESDFLAG	CHAR	1	0	Main Injury or Main Illness
63	OLDINJFLG	☐	CCIHE_OLDINJFLG	ESDFLAG	CHAR	1	0	Old Injury or Illness
64	BODYPARTXT	☐	CCIHE_BODYPARTXT	TEXT132	CHAR	132	0	Name of body part
65	BODYPARTDESC	☐	CCIHE_BODYPARDESC	TEXT60	CHAR	60	0	Description of Body Part
66	INJURYTXT	☐	CCIHE_INJURYTXT	TEXT132	CHAR	132	0	Name of Injury or Illness
67	INJURYDESC	☐	CCIHE_INJURYDESC	TEXT60	CHAR	60	0	Description of Injury or Illness

History

Last changed by/on	SAP	20110901
SAP Release Created in