SAP ABAP Table CCIHS_BW_IAL_MD (EHS: BW: Master Data 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_BW_IAL_MD	Table Relationship Diagram
Short Description	EHS: BW: Master Data 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	.INCLUDE	☐				0	0	EHS: IOTAB for Incident/Accident Log (CCIHT_IAL)
2	.INCLUDE	☐				0	0	EHS: Standard fields for IOTABs (step loop library)
3	MARKFLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
4	SELEFLG	☐	ESESELEFLG	ESDFLAG	CHAR	1	0	Step Loop Line Selected
5	LINENO	☐	ESECOUNTER	NUMC10	NUMC	10	0	General Auxiliary Counter
6	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
7	CHCOFLG	☐	ESECHCOFLG	ESDFLAG	CHAR	1	0	Indicator: Change number collision
8	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
9	INTRFLG	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
10	.INCLUDE	☐				0	0	EHS: Incident/Accident Log - Header
11	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
12	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
13	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
14	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
15	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
16	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
17	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
18	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
19	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
20	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
21	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
22	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
23	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
24	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
25	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
26	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
27	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
28	IALID	☐	CCIHE_IALID	CCIHD_IAID	CHAR	20	0	Incident/Accident Log Entry
29	IATYPE	☐	CCIHE_IATYPE	CCIHD_IATYPE	CHAR	3	0	Incident/Accident Log Entry Type	CCIHC_IATYPE
30	IAPLANT	☐	CCIHE_IAPLANT	WERKS	CHAR	4	0	Plant Assignment for the Log Entry	T001W
31	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
32	IASTATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
33	EVDESC	☐	CCIHE_EVDESCLXT	TEXT60	CHAR	60	0	Event Description
34	DMTYPE	☐	CCIHE_DMTYPE	CCIHD_DMTYPE	CHAR	21	0	Type of Damage
35	TPLNR	☐	CCIHE_FUNLOC	CCIHD_FUNLOC	CHAR	30	0	Functional Location	*
36	EQUNR	☐	CCIHE_EQUNR	CHAR18	CHAR	18	0	Equipment Number	*
37	EQDESC	☐	CCIHE_EQDESC	TEXT80	CHAR	80	0	Description of Machine
38	FATALFLG	☐	CCIHE_FATALFLG	ESDFLAG	CHAR	1	0	Fatality
39	CNTRFLG	☐	CCIHE_CNTRFLG	ESDFLAG	CHAR	1	0	Contractor Affected
40	INVRESULT	☐	CCIHE_INVRESULT	TEXT60	CHAR	60	0	Investigation Result
41	INVRESULTFLG	☐	CCIHE_INVRESULTFLG	FLAG	CHAR	1	0	Indicator for SAPscript Text
42	PMFLG	☐	CCIHE_PMFLG	ESDFLAG	CHAR	1	0	Maintenance Required
43	PRODLFLG	☐	CCIHE_PRODLFLG	ESDFLAG	CHAR	1	0	Production Time Lost
44	MTNLANGU	☐	CCIHE_MTNLANGU	SPRAS	LANG	1	0	Language of Entry	T002
45	.INCLUDE	☐				0	0	EHS: Event Data
46	EVDAT	☐	CCIHE_EVDAT	DATUM	DATS	8	0	Event Date
47	EVTIME	☐	CCIHE_EVTIME	TIME	TIMS	6	0	Event Time
48	RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
49	ACLOC	☐	CCIHE_ACLOC	CCIHD_ACLOC	CHAR	10	0	Accident Location
50	ACLOCDESC	☐	CCIHE_ACLOCDESC	TEXT60	CHAR	60	0	Description of Accident Location
51	EVTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
52	IAREPHDFLG	☐	CCIHE_IAREPHDFLG	ESDFLAG	CHAR	1	0	Reportable Event
53	FLPLANT	☐	CCIHE_FLPLANT	WERKS	CHAR	4	0	Functional Location Plant	T001W
54	IALDEADFLG	☐	CCIHE_FATALFLG	ESDFLAG	CHAR	1	0	Fatality
55	IATYPETXT	☐	CCIHE_IATYPETXT	TEXT40	CHAR	40	0	Description of Log Entry Type
56	IAPLANTXT	☐	CCIHE_IAPLANTTXT	TEXT30	CHAR	30	0	Description of Plant for Incident/Accident Log Entry
57	DMTYPETXT	☐	CCIHE_DMTYPETXT	TEXT132	CHAR	132	0	Description of Damage Type
58	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
59	EQTXT	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
60	WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
61	WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
62	ACLOCTXT	☐	CCIHE_ACLOCTXT	TEXT40	CHAR	40	0	Description of Accident Location
63	ACFLG	☐	CCIHE_ACFLG	ESDFLAG	CHAR	1	0	Safety Measures Exist
64	WTLFLG	☐	CCIHE_WTLFLG	ESDFLAG	CHAR	1	0	Witness List Entry Available
65	PMOFLG	☐	CCIHE_PMOFLG	ESDFLAG	CHAR	1	0	Maintenance Orders Exist
66	COFLG	☐	CCIHE_COFLG	ESDFLAG	CHAR	1	0	Costs Exist
67	QUESFLG	☐	CCIHE_QUESFLG	ESDFLAG	CHAR	1	0	Questionnaire Exists
68	IASHSTATNAM	☐	CCIHE_IASHSTATNAM	TEXT4	CHAR	4	0	Incident/Accident Log Entry Status
69	IASTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
70	KEYDRAWNFLG	☐	CCIHE_KEYDRAWN	ESDFLAG	CHAR	1	0	Key Assigned Automatically
71	TMODNEWFLG	☐	CCIHE_TRANSMOD	ESDFLAG	CHAR	1	0	Transport Mode Injury/Illness Log to Incident/Accident Log
72	TMODEXSFLG	☐	CCIHE_TRANSMOD	ESDFLAG	CHAR	1	0	Transport Mode Injury/Illness Log to Incident/Accident Log
73	MTNLANGUTXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
74	SRV_NUMBER	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service
75	FLPLANTTXT	☐	CCIHE_FLPLANTTXT	TEXT30	CHAR	30	0	Name of Functional Location Plant
76	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_BW_IAL_MD	AENNR	AENR	AENNR	REF	1	CN
2	CCIHS_BW_IAL_MD	EVTIMEZONE	TTZZ	TZONE	REF	1	CN
3	CCIHS_BW_IAL_MD	FLPLANT	T001W	WERKS	REF	C	CN
4	CCIHS_BW_IAL_MD	IAPLANT	T001W	WERKS	REF	1	CN
5	CCIHS_BW_IAL_MD	IATYPE	CCIHC_IATYPE	IATYPE	REF	C	CN
6	CCIHS_BW_IAL_MD	MANDT	T000	MANDT	KEY	1	CN
7	CCIHS_BW_IAL_MD	MTNLANGU	T002	SPRAS	REF	1	CN
8	CCIHS_BW_IAL_MD	SRSID	TCG56	SRSID	REF	1	CN

History

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