| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | RECN | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | | ESERECN | Allow NULL? |
| 3 | ACTN | Sequential Number of the Change State | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | | ESEACTN | Allow NULL? |
| 4 | VALFR | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEVALFR | Allow NULL? |
| 5 | VALTO | Valid-To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEVALTO | Allow NULL? |
| 6 | AENNR | Change Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AENR | ESEAENNR | Allow NULL? |
| 7 | DELFLG | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEDELFLG | Allow NULL? |
| 8 | PARKFLG | Data Record Is Inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEPARKFLG | Allow NULL? |
| 9 | CRDAT | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESECRDAT | Allow NULL? |
| 10 | CRNAM | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESECRNAM | Allow NULL? |
| 11 | UPDDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEUPDDAT | Allow NULL? |
| 12 | UPDNAM | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESEUPDNAM | Allow NULL? |
| 13 | SRSID | Source of Data | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCG56 | ESESRSID | Allow NULL? |
| 14 | OWNID | Data Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ESEVENDRID | Allow NULL? |
| 15 | RECNROOT | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | ESERECN | Allow NULL? |
| 16 | IALID | Incident/Accident Log Entry | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CCIHE_IALID | Allow NULL? |
| 17 | IATYPE | Incident/Accident Log Entry Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | CCIHC_IATYPE | CCIHE_IATYPE | Allow NULL? |
| 18 | IAPLANT | Plant Assignment for the Log Entry | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | CCIHE_IAPLANT | Allow NULL? |
| 19 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | J_OBJNR | Allow NULL? |
| 20 | IASTATUS | Status | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | EHSBE_STATUS | Allow NULL? |
| 21 | EVDESC | Event Description | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | CCIHE_EVDESCLXT | Allow NULL? |
| 22 | DMTYPE | Type of Damage | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | | CCIHE_DMTYPE | Allow NULL? |
| 23 | TPLNR | Functional Location | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CCIHE_FUNLOC | Allow NULL? |
| 24 | EQUNR | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | CCIHE_EQUNR | Allow NULL? |
| 25 | EQDESC | Description of Machine | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | CCIHE_EQDESC | Allow NULL? |
| 26 | FATALFLG | Fatality | char | 1 | 0 | CHAR | (N' ') | Yes | | CCIHE_FATALFLG | Allow NULL? |
| 27 | CNTRFLG | Contractor Affected | char | 1 | 0 | CHAR | (N' ') | Yes | | CCIHE_CNTRFLG | Allow NULL? |
| 28 | INVRESULT | Investigation Result | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | CCIHE_INVRESULT | Allow NULL? |
| 29 | INVRESULTFLG | Indicator for SAPscript Text | char | 1 | 0 | CHAR | (N' ') | Yes | | CCIHE_INVRESULTFLG | Allow NULL? |
| 30 | PMFLG | Maintenance Required | char | 1 | 0 | CHAR | (N' ') | Yes | | CCIHE_PMFLG | Allow NULL? |
| 31 | PRODLFLG | Production Time Lost | char | 1 | 0 | CHAR | (N' ') | Yes | | CCIHE_PRODLFLG | Allow NULL? |
| 32 | MTNLANGU | Language of Entry | char | 1 | 0 | LANG | (N' ') | Yes | T002 | CCIHE_MTNLANGU | Allow NULL? |
| 33 | EVDAT | Event Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CCIHE_EVDAT | Allow NULL? |
| 34 | EVTIME | Event Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CCIHE_EVTIME | Allow NULL? |
| 35 | RECNTWAH | Reference to Work Area | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | CCIHE_RECNTWAH | Allow NULL? |
| 36 | ACLOC | Accident Location | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CCIHE_ACLOC | Allow NULL? |
| 37 | ACLOCDESC | Description of Accident Location | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | CCIHE_ACLOCDESC | Allow NULL? |
| 38 | EVTIMEZONE | Valid Time Zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TTZZ | CCIHE_TIMEZONE | Allow NULL? |
| 39 | IAREPHDFLG | Reportable Event | char | 1 | 0 | CHAR | (N' ') | Yes | | CCIHE_IAREPHDFLG | Allow NULL? |
| 40 | FLPLANT | Functional Location Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | CCIHE_FLPLANT | Allow NULL? |
