1. Home
  2. Resources
  3. SAP Tables
  4. CCIHT_IP - EHS: List of Persons Involved

SAP Table CCIHT_IP

EHS: List of Persons Involved

CCIHT_IP (EHS: List of Persons Involved) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CCIHT_IP to other SAP tables.

CCIHT_IP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RECN Sequential Number of Data Record ESERECN NUMC 20 0
ACTN Sequential Number of the Change State ESEACTN NUMC 20 0
VALFR Valid-From Date ESEVALFR DATS 8 0
VALTO Valid-To Date ESEVALTO DATS 8 0
AENNR Change Number ESEAENNR AENR CHAR 12 0
DELFLG Deletion Indicator ESEDELFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PARKFLG Data Record Is Inactive ESEPARKFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
CRDAT Created On ESECRDAT DATS 8 0
CRNAM Created By ESECRNAM CHAR 12 0
UPDDAT Changed On ESEUPDDAT DATS 8 0
UPDNAM Last Changed By ESEUPDNAM CHAR 12 0
SRSID Source of Data ESESRSID TCG56 CHAR 10 0
OWNID Data Provider ESEVENDRID CHAR 10 0
RECNROOT Sequential Number of Data Record ESERECN NUMC 20 0
REFOBJ Reference Object CCIHE_IHREFOBJ CHAR 3 0
WA Reference to work areas, table CCIHT_WAH
IAL Reference to incident/accident log entries, table CCIHT_IAL
FAL Reference to injury/illness log entries, table CCIHT_FAL
HAS Reference to exposure assignment, table CCIHT_ERH
AFP Reference to person affected, table CCIHT_IPEVA
SUB Reference to substance (agent) value assignment, table ESTVA
QTY Reference to exposure amounts, table CCIHT_ERQT
SAM Reference to safety measures, table CCIHT_ACH
MP Reference to measurement project, table CCIHT_MP
MJ Reference to measurement, table CCIHT_MJ
IPTYPE Role of Person CCIHE_IPTYPE CCIHC_IPTYPE CHAR 3 0
IPPERS Person Involved CCIHE_IPPERS CHAR 10 0
IPPFLAG External Person CCIHE_IPPFLAG CHAR 1 0
X Person is external
NULL Person is internal
ACDESC Description of How Accident Happened CCIHE_ACDESCLXT CHAR 72 0
ACDESCFLG Indicator for SAPscript Text CCIHE_ACDESCFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
REPDAT Statement Date CCIHE_REPDAT DATS 8 0
REPTIME Statement Time CCIHE_REPTIME TIMS 6 0
WITNESS Witness for Person Affected CCIHE_WITNESS CHAR 10 0
WITEXFLAG External Person CCIHE_IPPFLAG CHAR 1 0
X Person is external
NULL Person is internal
IPPERSGRP Person Group CCIHE_PERSGRP CHAR 1 0
A Employee
B Applicant
C External person
WITNESSGRP Person Group CCIHE_PERSGRP CHAR 1 0
A Employee
B Applicant
C External person
REPTIMEZONE Valid Time Zone CCIHE_TIMEZONE TTZZ CHAR 6 0

CCIHT_IP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CCIHT_IP AENNR SY MANDT AENR Change Master MANDT
CCIHT_IP AENNR CCIHT_IP AENNR AENR Change Master AENNR
CCIHT_IP IPTYPE CCIHT_IP MANDT CCIHC_IPTYPE EHS: Role of Person Involved MANDT
CCIHT_IP IPTYPE CCIHT_IP IPTYPE CCIHC_IPTYPE EHS: Role of Person Involved IPTYPE
CCIHT_IP MANDT CCIHT_IP MANDT T000 Clients MANDT
CCIHT_IP REPTIMEZONE * TTZZ Time zones CLIENT
CCIHT_IP REPTIMEZONE CCIHT_IP REPTIMEZONE TTZZ Time zones TZONE
CCIHT_IP SRSID CCIHT_IP SRSID TCG56 EHS: Data Origin SRSID
CCIHT_IP SRSID * TCG56 EHS: Data Origin MANDT