SAP ABAP Table CCIHS_IASEL (EHS: Data Structure for Sel. Screen (Initial) Inc./Acc. Log)
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_IASEL | Table Relationship Diagram |
Short Description | EHS: Data Structure for Sel. Screen (Initial) Inc./Acc. Log |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | IAPLANT | CCIHE_IAPLANT | WERKS | CHAR | 4 | 0 | Plant Assignment for the Log Entry | T001W | |
3 | IAPLANTTXT | CCIHE_IAPLANTTXT | TEXT30 | CHAR | 30 | 0 | Description of Plant for Incident/Accident Log Entry | ||
4 | IALID | CCIHE_IALID | CCIHD_IAID | CHAR | 20 | 0 | Incident/Accident Log Entry | ||
5 | FAID | CCIHE_FAID | CCIHD_FAID | CHAR | 20 | 0 | Injury/Illness Log Entry | ||
6 | IATYPE | CCIHE_IATYPE | CCIHD_IATYPE | CHAR | 3 | 0 | Incident/Accident Log Entry Type | CCIHC_IATYPE | |
7 | IATYPETXT | CCIHE_IATYPETXT | TEXT40 | CHAR | 40 | 0 | Description of Log Entry Type | ||
8 | EVDAT | CCIHE_EVDAT | DATUM | DATS | 8 | 0 | Event Date | ||
9 | EVDATFROM | CCIHE_EVDATFROM | DATUM | DATS | 8 | 0 | Lower Limit of Event Date (Inclusive) | ||
10 | EVDATTO | CCIHE_EVDATTO | DATUM | DATS | 8 | 0 | Upper Limit of Event Date (Inclusive) | ||
11 | IPPERS | CCIHE_IPPERS | CCIHD_PERSON | CHAR | 10 | 0 | Person Involved | ||
12 | PERSFLGEXTERN | CCIHE_IPPFLAG | CCIHD_PERSFLAG | CHAR | 1 | 0 | External Person | ||
13 | PERSFLGINTERN | CCIHE_IPPFLAG_INT | CCIHD_PERSFLAG | CHAR | 1 | 0 | Employee | ||
14 | IPTYPE | CCIHE_IPTYPE | CCIHD_IPTYPE | CHAR | 3 | 0 | Role of Person | CCIHC_IPTYPE | |
15 | IPTYPETXT | CCIHE_IPTYPETXT | TEXT40 | CHAR | 40 | 0 | Description of Person's Role | ||
16 | VORNA | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
17 | NACHN | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
18 | DMTYPE | CCIHE_DMTYPE | CCIHD_DMTYPE | CHAR | 21 | 0 | Type of Damage | ||
19 | DMTYPETXT | CCIHE_DMTYPETXT | TEXT132 | CHAR | 132 | 0 | Description of Damage Type | ||
20 | TPLNR | TPLNR | TPLNR | CHAR | 30 | 0 | Functional Location | * | |
21 | PLTXT | PLTXT | TEXT40 | CHAR | 40 | 0 | Description of functional location | ||
22 | EQUNR | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
23 | EQTXT | KTX01 | TEXT40 | CHAR | 40 | 0 | Description of technical object | ||
24 | EQDESC | CCIHE_EQDESC | TEXT80 | CHAR | 80 | 0 | Description of Machine | ||
25 | FATALFLG | CCIHE_FATALFLG | ESDFLAG | CHAR | 1 | 0 | Fatality | ||
26 | PMFLG | CCIHE_PMFLG | ESDFLAG | CHAR | 1 | 0 | Maintenance Required | ||
27 | PRODLFLG | CCIHE_PRODLFLG | ESDFLAG | CHAR | 1 | 0 | Production Time Lost | ||
28 | AENNR | AENNR | AENNR | CHAR | 12 | 0 | Change Number | * | |
29 | VALDAT | ESEDIAGVD | DATUM | DATS | 8 | 0 | Key Date | ||
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 | IASTATUS | EHSBE_STATUS | J_STATUS | CHAR | 5 | 0 | Status | ||
35 | EVDESC | CCIHE_EVDESCLXT | TEXT60 | CHAR | 60 | 0 | Event Description | ||
36 | IASHSTATNAM | CCIHE_IASHSTATNAM | TEXT4 | CHAR | 4 | 0 | Incident/Accident Log Entry Status | ||
37 | IASTATNAM | J_TXT30 | TEXT30 | CHAR | 30 | 0 | Object status | ||
38 | CRDATFROM | CCIHE_CRDATFROM | DATUM | DATS | 8 | 0 | Created-On Date (Lower Limit) | ||
39 | CRDATTO | CCIHE_CRDATTO | DATUM | DATS | 8 | 0 | Created-On Date (Upper Limit) | ||
40 | UPDDATFROM | CCIHE_UPDDATFROM | DATUM | DATS | 8 | 0 | Date of Last Change (Lower Limit) | ||
41 | UPDDATTO | CCIHE_UPDDATTO | DATUM | DATS | 8 | 0 | Date of Last Change (Upper Limit) | ||
42 | VALFR | ESEVALFR | DATUM | DATS | 8 | 0 | Valid-From Date | ||
43 | VALTO | ESEVALTO | DATUM | DATS | 8 | 0 | Valid-To Date | ||
44 | PERSFLGAPP | CCIHE_PERSFLAG_APP | CCIHD_PERSFLAG | CHAR | 1 | 0 | Applicant | ||
45 | IPPERSGRP | CCIHE_PERSGRP | CCIHD_PERSGRP | CHAR | 1 | 0 | Person Group | ||
46 | SEARCHMODE | ESESEARCHMODE | ESDSEARCHMODE | CHAR | 1 | 0 | Search mode to find historical data | ||
47 | FLPLANT | CCIHE_FLPLANT | WERKS | CHAR | 4 | 0 | Functional Location Plant | T001W | |
48 | STRNO | CCIHE_STRNO | CHAR40 | CHAR | 40 | 0 | Functional Location Label |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CCIHS_IASEL | FLPLANT | T001W | WERKS | REF | C | CN |
2 | CCIHS_IASEL | IAPLANT | T001W | WERKS | REF | C | CN |
3 | CCIHS_IASEL | IATYPE | CCIHC_IATYPE | IATYPE | 1 | CN | |
4 | CCIHS_IASEL | IPTYPE | CCIHC_IPTYPE | IPTYPE | 1 | CN |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in |