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
⤷ 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 |