CCIHT_IAL

EHS: Incident/Accident Log - Header | #masterdata | Component: Environment, Health, and Safety / Product Compliance
Column Name Description
MANDT FK Client
RECN Sequential Number of Data Record
ACTN Sequential Number of the Change State
Column Name Description
Column Name Description
Column Name Description
VALFR Valid-From Date
VALTO Valid-To Date
CRDAT Created On
UPDDAT Last Changed On
EVDAT Event Date
EVTIME Event Time
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
FATALFLG Fatality Show values
CNTRFLG Contractor Affected Show values
INVRESULTFLG Indicator for SAPscript Text Show values
PMFLG Maintenance Required Show values
PRODLFLG Production Time Lost Show values
IAREPHDFLG Reportable Event Show values
BLOCKFLG Lock Indicator Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
RECNROOT Sequential Number of Data Record ESDRECN
IALID Incident/Accident Log Entry CCIHD_IAID
OBJNR Object number J_OBJNR
IASTATUS Status J_STATUS
EVDESC Event Description TEXT60
DMTYPE Type of Damage CCIHD_DMTYPE
TPLNR Functional Location CCIHD_FUNLOC
EQUNR Equipment Number CHAR18
EQDESC Description of Machine TEXT80
INVRESULT Investigation Result TEXT60
RECNTWAH Reference to Work Area ESDRECN
ACLOCDESC Description of Accident Location TEXT60
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • CCIHT_IAL.AENNR == AENR.AENNR
  • CCIHT_IAL.MANDT == AENR.MANDT
Relationship to Time Zone Table
  • CCIHT_IAL.MANDT == TTZZ.CLIENT
  • CCIHT_IAL.EVTIMEZONE == TTZZ.TZONE
EHS: Foreign Key for Plant
  • CCIHT_IAL.MANDT == T001W.MANDT
  • CCIHT_IAL.FLPLANT == T001W.WERKS
EHS: Foreign Key for Plant
  • CCIHT_IAL.MANDT == T001W.MANDT
  • CCIHT_IAL.IAPLANT == T001W.WERKS
EHS: Foreign Key for Incident/Accident Log Entry Type
Client CCIHT_IAL.MANDT == T000.MANDT
EHS: Relationship to Maintenance Language CCIHT_IAL.MTNLANGU == T002.SPRAS
EHS: Foreign Key for Substance Authorization Group
  • CCIHT_IAL.MANDT == TCG56.MANDT
  • CCIHT_IAL.SRSID == TCG56.SRSID