SAP ABAP Table CCIHS_BW_IP_MD (EHS: BW: Master Data for Person Involved in Accident)

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_IP_MD	Table Relationship Diagram
Short Description	EHS: BW: Master Data for Person Involved in Accident

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	IPPERS	☐	CCIHE_IPPERS	CCIHD_PERSON	CHAR	10	0	Person Involved
2	IPPFLAG	☐	CCIHE_IPPFLAG	CCIHD_PERSFLAG	CHAR	1	0	External Person
3	BPARTNER	☐	CCIHE_IPPERS	CCIHD_PERSON	CHAR	10	0	Person Involved
4	EMPLOYEE	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	APPLICANT	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
6	IPTYPE	☐	CCIHE_IPTYPE	CCIHD_IPTYPE	CHAR	3	0	Role of Person
7	IPTYPETXT	☐	CCIHE_IPTYPETXT	TEXT40	CHAR	40	0	Description of Person's Role
8	BIRTHDATE	☐	CCIHE_BIRTHDATE	DATS	DATS	8	0	Person's Date of Birth
9	IPPERSGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
10	.INCLUDE	☐				0	0	EHS: Inc./Acc. Log - Data for Person Affected (Event)
11	.INCLUDE	☐				0	0	EHS: Standard fields for IOTABs (step loop library)
12	MARKFLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
13	SELEFLG	☐	ESESELEFLG	ESDFLAG	CHAR	1	0	Step Loop Line Selected
14	LINENO	☐	ESECOUNTER	NUMC10	NUMC	10	0	General Auxiliary Counter
15	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
16	CHCOFLG	☐	ESECHCOFLG	ESDFLAG	CHAR	1	0	Indicator: Change number collision
17	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
18	INTRFLG	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
19	.INCLUDE	☐				0	0	EHS: Inc./Acc. Log - Data for Person Affected (Event)
20	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
21	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
22	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
23	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
24	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
25	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
26	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
27	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
28	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
29	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
30	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
31	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
32	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
33	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
34	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
35	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
36	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
37	.INCLUDE	☐				0	0	EHS: Event Data for Person Affected
38	FRTRMT	☐	CCIHE_FRTRMT	CCIHD_PERSON	CHAR	10	0	Further Treatment
39	FRTRMTFLG	☐	CCIHE_FRTRMTFLG	CCIHD_EXTFLG	CHAR	1	0	Physician Giving Further Treatment (Internal/External)
40	INTNOTE	☐	CCIHE_INTNOTELXT	TEXT72	CHAR	72	0	Commentary for internal use
41	INTNOTEFLG	☐	CCIHE_INTNOTEFLG	FLAG	CHAR	1	0	Long Text Available for an Internal Note
42	EXTNOTE	☐	CCIHE_EXTNOTELXT	TEXT72	CHAR	72	0	Information for External Purposes
43	EXTNOTEFLG	☐	CCIHE_EXTNOTEFLG	FLAG	CHAR	1	0	Long Text Available on External Note
44	FRTRMTGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
45	.INCLUDE	☐				0	0	EHS: Absence Person Affected (Event Data)
46	OFFJOBDAT	☐	CCIHE_OFFJOBDAT	DATUM	DATS	8	0	Date of Ceasing to Work
47	OFFJOBTIME	☐	CCIHE_OFFJOBTIME	UZEIT	TIMS	6	0	Time of Ceasing to Work
48	IPABSSUBTYPE	☐	CCIHE_IPABSSUBTYPE	SUBTYP	CHAR	4	0	Absence Type	*
49	IPABSBEGDAT	☐	CCIHE_IPABSBEGDAT	DATUM	DATS	8	0	Start Date of Absence
50	IPABSENDDAT	☐	CCIHE_IPABSENDDAT	DATUM	DATS	8	0	End Date of Absence
51	IPABSSEQNUM	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
52	IPABSESTDAYS	☐	CCIHE_IPABSESTDAYS	CCIHD_DAYS	DEC	6	2	Estimated Duration of Absence (in Days)
53	IPABSDAYS	☐	CCIHE_IPABSDAYS	CCIHD_IPABSDAYS	DEC	6	2	Number of Workdays Absent
54	IPABSCALDAYS	☐	CCIHE_IPABSCALDAYS	CCIHD_IPABSCALDAYS	DEC	8	2	Calendar Days
55	IPRSWBEGDAT	☐	CCIHE_IPRSWBEGDAT	DATUM	DATS	8	0	Start of Restriction or Date of Job Transfer
56	IPRSWENDDAT	☐	CCIHE_IPRSWENDDAT	DATUM	DATS	8	0	End Date of Restriction or Job Transfer
57	IPRSWDAYS	☐	CCIHE_IPRSWDAYS	DEC4_2	DEC	6	2	Number of Workdays with Restriction or Job Transfer
58	IPRSWCALDAYS	☐	CCIHE_IPRSWCALDAYS	CCIHD_IPABSCALDAYS	DEC	8	2	Calendar Days with Restriction or Job Transfer
59	RECNTIP	☐	CCIHE_RECNTIP	ESDRECN	NUMC	20	0	Reference to Person Affected in Table IP
60	IALPCAT	☐	CCIHE_IALPCAT	CCIHD_IALPCAT	CHAR	3	0	Accident Category	CCIHC_IALPCAT
61	IAREPORTFLG	☐	CCIHE_IAREPORTFLG	ESDFLAG	CHAR	1	0	Reportable Accident
62	IALPREPID	☐	CCIHE_IALPREPID	CCIHD_PRID	CHAR	20	0	Accident Notification Number
63	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
64	IALPSTWCFLG	☐	CCIHE_IALPSTWCFLG	ESDFLAG	CHAR	1	0	Main Work Center
65	IALDEADFLG	☐	CCIHE_IALPDEADFLG	ESDFLAG	CHAR	1	0	Fatality
66	FAPHYS	☐	CCIHE_FAPHYS	CCIHD_PERSON	CHAR	10	0	First Physician to Give Treatment
67	FAPHYSFLG	☐	CCIHE_FAPHYSFLG	CCIHD_EXTFLG	CHAR	1	0	First Physician to Give Treatment (Internal/External)
68	IALPHOSP	☐	CCIHE_IALPHOSP	BU_PARTNER	CHAR	10	0	Hospital	BUT000
69	PERSPROT	☐	CCIHE_PERSPROT	CCIHD_PERSPROT	CHAR	21	0	Personal Protective Equipment
70	TECHPROT	☐	CCIHE_TECHPROT	CCIHD_TECHPROT	CHAR	21	0	Technical Safety Device
71	IPEVAAC	☐	CCIHE_IPEVAAC	CHAR21	CHAR	21	0	Safety Measures Taken to Prevent Accidents
72	IACAUS	☐	CCIHE_IACAUS	CCIHD_IACAUS	CHAR	21	0	Cause of Accident
73	IAEXINF	☐	CCIHE_IAEXINF	CCIHD_IAEXINF	CHAR	21	0	External Influences on Accident
74	IAOBJ	☐	CCIHE_IAOBJ	CCIHD_IAOBJ	CHAR	21	0	Object or Substance that Caused Accident
75	IAOBJM	☐	CCIHE_IAOBJM	CCIHD_IAOBJM	CHAR	21	0	Movement of the Object that Caused the Accident
76	IPACT	☐	CCIHE_IPACT	CCIHD_IPACT	CHAR	21	0	Activity of Injured Person
77	IPMOV	☐	CCIHE_IPMOV	CCIHD_IPMOV	CHAR	21	0	Movement of Injured Person
78	IPSTATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
79	RELWITNESS	☐	CCIHE_RELWIT	CCIHD_PERSON	CHAR	10	0	Relevant Witness for Person Affected
80	RWITEXFLAG	☐	CCIHE_IPPFLAG	CCIHD_PERSFLAG	CHAR	1	0	External Person
81	IALPEXP	☐	CCIHE_IALPEXP	CCIHD_IALPEXP	NUMC	3	0	Time at Work Center in Months
82	FAPHYSGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
83	RELWITNESSGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
84	OFFJOBTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
85	PRIVCONCFLG	☐	CCIHE_PRIVCONCFLG	ESDFLAG	CHAR	1	0	Privacy Concern Case
86	EMERGRMFLG	☐	CCIHE_EMERGRMFLG	ESDFLAG	CHAR	1	0	Treatment in Emergency Room
87	INPATFLG	☐	CCIHE_INPATFLG	ESDFLAG	CHAR	1	0	Treatment Overnight As Inpatient
88	IPDEATHDATE	☐	CCIHE_IPDEATHDATE	DATUM	DATS	8	0	Date of Death of Person Affected
89	IPACTWTBEG	☐	CCIHE_IPACTWTBEG	TIME	TIMS	6	0	Start of Actual Working Time
90	IPACTWTEND	☐	CCIHE_IPACTWTEND	TIME	TIMS	6	0	End of Actual Working Time
91	IALOC	☐	CCIHE_FALOC	CCIHD_FALOC	CHAR	3	0	Entry Location	CCIHC_FALOC
92	IATRTOHC	☐	CCIHE_IATRTOHC	CCIHD_TRMEANS	CHAR	21	0	Transport to First Aid Center By
93	IATRFRHC	☐	CCIHE_IATRFRHC	CCIHD_TRMEANS	CHAR	21	0	Means of Further Transport from Health Center
94	UNCONSCIOUS	☐	CCIHE_UNCONSCIOUS	ESDFLAG	CHAR	1	0	Person Unconscious
95	RESUSCITATION	☐	CCIHE_RESUSCITATION	ESDFLAG	CHAR	1	0	Resuscitation Performed
96	HOSPITALIZATION	☐	CCIHE_HOSPITALIZATION	ESDFLAG	CHAR	1	0	Hospitalization for over 24 Hours
97	.INCLUDE	☐				0	0	EHS: Absence Person Affected (Derived Data)
98	IPABSBEGTIME	☐	CCIHE_IPABSBEGTIME	UZEIT	TIMS	6	0	Start Time of Absence
99	IPABSENDTIME	☐	CCIHE_IPABSENDTIME	UZEIT	TIMS	6	0	End Time of Absence
100	RETJOBDAT	☐	CCIHE_RETJOBDAT	DATUM	DATS	8	0	Return to Work
101	IPABSHOURS	☐	ABS_ATT_HOURS	JRSTD	DEC	7	2	Absence/Attendance hours
102	IPABSLFZED	☐	ENDDA	DATUM	DATS	8	0	End Date
103	IPABSLINK	☐	CCIHE_IPABSLINK	CHAR2	CHAR	2	0	Linking Absences
104	IPABSFLGKEYNF	☐	CCIHE_IPABSFLGKEYNF	CCIHD_IPABSFLGKEYNF	CHAR	1	0	Absence Record Not Found Owing to Key Change
105	IPABSSUBTYPETXT	☐	CCIHE_IPABSSUBTYPETXT	TEXT25	CHAR	25	0	Description of Absence Type
106	.INCLUDE	☐				0	0	EHS: Work Schedule Person Affected
107	IPREGWTTXT	☐	CCIHE_IPREGWTTXT	TEXT20	CHAR	20	0	Daily Work Schedule
108	IPREGWTBEG	☐	CCIHE_IPREGWTBEG	TIME	TIMS	6	0	Start of Normal Working Time
109	IPREGWTEND	☐	CCIHE_IPREGWTEND	TIME	TIMS	6	0	End of Normal Working Time
110	FRTRMTNAM	☐	CCIHE_FRTRMTNAM	TEXT60	CHAR	60	0	Further Treatment
111	IALPTYPETXT	☐	CCIHE_IATYPETXT	TEXT40	CHAR	40	0	Description of Log Entry Type
112	IALPCATXT	☐	CCIHE_IACATXT	TEXT40	CHAR	40	0	Accident Category
113	FAPHYSNAM	☐	CCIHE_FAPHYSNAM	TEXT60	CHAR	60	0	First Physician to Give Treatment
114	IALPHOSPNAM	☐	CCIHE_IALPHOSPNAM	TEXT60	CHAR	60	0	Name of Hospital
115	QUESFLG	☐	CCIHE_QUESFLG	ESDFLAG	CHAR	1	0	Questionnaire Exists
116	IACAUSTXT	☐	CCIHE_IACAUSTXT	TEXT132	CHAR	132	0	Description of Cause of Accident
117	IAEXINFTXT	☐	CCIHE_IAEXINFTXT	TEXT132	CHAR	132	0	Description of External Influences on Accident
118	IAOBJTXT	☐	CCIHE_IAOBJTXT	TEXT132	CHAR	132	0	Description of the Object that Caused the Accident
119	IAOBJMTXT	☐	CCIHE_IAOBJMTXT	TEXT132	CHAR	132	0	Desc. of the Movement of the Object that Caused the Accident
120	IPACTTXT	☐	CCIHE_IPACTTXT	TEXT132	CHAR	132	0	Description of Activity of Injured Person
121	IPMOVTXT	☐	CCIHE_IPMOVTXT	TEXT132	CHAR	132	0	Description of Movement of Injured Person
122	PERSPROTTXT	☐	CCIHE_PERSPROTTXT	CHAR132	CHAR	132	0	Description of Personal Protective Equipment
123	TECHPROTTXT	☐	CCIHE_TECHPROTTXT	CHAR132	CHAR	132	0	Description of Technical Safety Device
124	IPEVAACTXT	☐	CCIHE_IPEVAACTXT	TEXT132	CHAR	132	0	Description of Safety Measure Taken to Prevent Accidents
125	IPSTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
126	IPSHSTATNAM	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
127	KEYDRAWNFLG	☐	CCIHE_KEYDRAWN	ESDFLAG	CHAR	1	0	Key Assigned Automatically
128	IPAGE	☐	CCIHE_IPAGE	CCIHD_PERSONAGE	NUMC	3	0	Age in Years at Time of Accident
129	LSTSHIFT	☐	CCIHE_LSTSHIFT	NUMC3	NUMC	3	0	Lost Shifts
130	RELWITNESSGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
131	FAPHYSGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
132	FRTRMTGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
133	SRV_NUMBER	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service
134	NOINPATFLG	☐	CCIHE_INPATFLG	ESDFLAG	CHAR	1	0	Treatment Overnight As Inpatient
135	NOEMERGRMFLG	☐	CCIHE_EMERGRMFLG	ESDFLAG	CHAR	1	0	Treatment in Emergency Room
136	IALDEADDATE	☐	CCIHE_EVDAT	DATUM	DATS	8	0	Event Date
137	RETJOBYESFLG	☐	ESEINTERFLG	ESDYESNO	CHAR	1	0	Only for Use in Industrial Hygiene and Safety
138	RETJOBNOFLG	☐	ESEINTERFLG	ESDYESNO	CHAR	1	0	Only for Use in Industrial Hygiene and Safety
139	NUMABSASSIGNED	☐	CCIHE_IPNUMABS	NUMC3	NUMC	3	0	Number of Assigned Absences
140	NUMRESASSIGNED	☐	CCIHE_IPNUMRES	NUMC3	NUMC	3	0	Number of Assigned Restrictions
141	STLTX	☐	STLTX	TEXT25	CHAR	25	0	Job Title
142	IALOCTXT	☐	CCIHE_FALOCTXT	TEXT40	CHAR	40	0	Description of Entry Location
143	IATRTOHCTXT	☐	CCIHE_TRMEANSTXT	TEXT132	CHAR	132	0	Description of Means of Transport
144	IATRFRHCTXT	☐	CCIHE_TRMEANSTXT	TEXT132	CHAR	132	0	Description of Means of Transport

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_BW_IP_MD	AENNR	AENR	AENNR	REF	1	CN
2	CCIHS_BW_IP_MD	IALOC	CCIHC_FALOC	FALOC	REF	C	CN
3	CCIHS_BW_IP_MD	IALPCAT	CCIHC_IALPCAT	IALPCAT	REF	C	CN
4	CCIHS_BW_IP_MD	IALPHOSP	BUT000	PARTNER	REF	C	CN
5	CCIHS_BW_IP_MD	MANDT	T000	MANDT	KEY	1	CN
6	CCIHS_BW_IP_MD	OFFJOBTIMEZONE	TTZZ	TZONE	REF	1	CN
7	CCIHS_BW_IP_MD	SRSID	TCG56	SRSID	REF	1	CN

History

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