SAP ABAP Table CCIHS_IALHBUF (EHS: Buffer Structure for 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	INTTAB	Structure
Structure	CCIHS_IALHBUF	Table Relationship Diagram
Short Description	EHS: Buffer Structure for Incident/Accident Log Header

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 buffer table
2	VALFLG	☐	ESEVALFLG	ESDFLAG	CHAR	1	0	Indicator: Data record is currently valid
3	CHCOFLG	☐	ESECHCOFLG	ESDFLAG	CHAR	1	0	Indicator: Change number collision
4	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
5	LOGLOCKMOD	☐	ESELGLCKMD	CHAR1	CHAR	1	0	Logical Lock Mode
6	SAVEMOD	☐	ESESAVEMOD	CHAR1	CHAR	1	0	Processing type when saving: INSERT, UPDATE, DELETE
7	SPLIT	☐	ESESPLIT	ESDSPLIT	CHAR	1	0	Record Split Indicator of a Buffer Record
8	BUF_ORIG_INDEX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
9	CHANGENO	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	*
10	KEYDATE	☐	ESEDIAGVD	DATUM	DATS	8	0	Key Date
11	.INCLUDE	☐				0	0	EHS: Incident/Accident Log - Header
12	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
13	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
14	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
15	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
16	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
17	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
18	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
19	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
20	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
21	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
22	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
23	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
24	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
25	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
26	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
27	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
28	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
29	IALID	☐	CCIHE_IALID	CCIHD_IAID	CHAR	20	0	Incident/Accident Log Entry
30	IATYPE	☐	CCIHE_IATYPE	CCIHD_IATYPE	CHAR	3	0	Incident/Accident Log Entry Type	CCIHC_IATYPE
31	IAPLANT	☐	CCIHE_IAPLANT	WERKS	CHAR	4	0	Plant Assignment for the Log Entry	T001W
32	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
33	IASTATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
34	EVDESC	☐	CCIHE_EVDESCLXT	TEXT60	CHAR	60	0	Event Description
35	DMTYPE	☐	CCIHE_DMTYPE	CCIHD_DMTYPE	CHAR	21	0	Type of Damage	*
36	TPLNR	☐	CCIHE_FUNLOC	CCIHD_FUNLOC	CHAR	30	0	Functional Location	*
37	EQUNR	☐	CCIHE_EQUNR	CHAR18	CHAR	18	0	Equipment Number	*
38	EQDESC	☐	CCIHE_EQDESC	TEXT80	CHAR	80	0	Description of Machine
39	FATALFLG	☐	CCIHE_FATALFLG	ESDFLAG	CHAR	1	0	Fatality
40	CNTRFLG	☐	CCIHE_CNTRFLG	ESDFLAG	CHAR	1	0	Contractor Affected
41	INVRESULT	☐	CCIHE_INVRESULT	TEXT60	CHAR	60	0	Investigation Result
42	INVRESULTFLG	☐	CCIHE_INVRESULTFLG	FLAG	CHAR	1	0	Indicator for SAPscript Text
43	PMFLG	☐	CCIHE_PMFLG	ESDFLAG	CHAR	1	0	Maintenance Required
44	PRODLFLG	☐	CCIHE_PRODLFLG	ESDFLAG	CHAR	1	0	Production Time Lost
45	MTNLANGU	☐	CCIHE_MTNLANGU	SPRAS	LANG	1	0	Language of Entry	T002
46	.INCLUDE	☐				0	0	EHS: Event Data
47	EVDAT	☐	CCIHE_EVDAT	DATUM	DATS	8	0	Event Date
48	EVTIME	☐	CCIHE_EVTIME	TIME	TIMS	6	0	Event Time
49	RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
50	ACLOC	☐	CCIHE_ACLOC	CCIHD_ACLOC	CHAR	10	0	Accident Location	*
51	ACLOCDESC	☐	CCIHE_ACLOCDESC	TEXT60	CHAR	60	0	Description of Accident Location
52	EVTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
53	IAREPHDFLG	☐	CCIHE_IAREPHDFLG	ESDFLAG	CHAR	1	0	Reportable Event
54	FLPLANT	☐	CCIHE_FLPLANT	WERKS	CHAR	4	0	Functional Location Plant	T001W
55	IATPYETXT	☐	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	STTXT	☐	CCIHE_STTXT	TEXT40	CHAR	40	0	System Status
58	DMTYPETXT	☐	CCIHE_DMTYPETXT	TEXT132	CHAR	132	0	Description of Damage Type
59	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
60	EQTXT	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in