SAP ABAP Table CCIHS_FALHBUF (EHS: Buffer Structure for Injury/Illness Log Entry)
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_FALHBUF | Table Relationship Diagram |
Short Description | EHS: Buffer Structure for Injury/Illness Log Entry |
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 | .INCLUDE | 0 | 0 | EHS: Standard fields for buffer table | |||||
2 | VALFLG | ESEVALFLG | ESDFLAG | CHAR | 1 | 0 | Indicator: Data record is currently valid | ||
3 | CHCOFLG | ESECHCOFLG | ESDFLAG | CHAR | 1 | 0 | Indicator: Change number collision | ||
4 | LOCKMOD | ESELOCKMOD | CHAR1 | CHAR | 1 | 0 | Lock Mode (Shared, Exclusive) | ||
5 | LOGLOCKMOD | ESELGLCKMD | CHAR1 | CHAR | 1 | 0 | Logical Lock Mode | ||
6 | SAVEMOD | ESESAVEMOD | CHAR1 | CHAR | 1 | 0 | Processing type when saving: INSERT, UPDATE, DELETE | ||
7 | SPLIT | ESESPLIT | ESDSPLIT | CHAR | 1 | 0 | Record Split Indicator of a Buffer Record | ||
8 | BUF_ORIG_INDEX | SYTABIX | SYST_LONG | INT4 | 10 | 0 | Row Index of Internal Tables | ||
9 | CHANGENO | ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | * | |
10 | KEYDATE | ESEDIAGVD | DATUM | DATS | 8 | 0 | Key Date | ||
11 | .INCLUDE | 0 | 0 | EHS: Injury/Illness Log | |||||
12 | .INCLUDE | 0 | 0 | EHS: Structure for key info of master data | |||||
13 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
14 | RECN | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
15 | ACTN | ESEACTN | ESDACTN | NUMC | 20 | 0 | Sequential Number of the Change State | ||
16 | .INCLUDE | 0 | 0 | EHS: Structure for General Administration Information | |||||
17 | VALFR | ESEVALFR | DATUM | DATS | 8 | 0 | Valid-From Date | ||
18 | VALTO | ESEVALTO | DATUM | DATS | 8 | 0 | Valid-To Date | ||
19 | AENNR | ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
20 | DELFLG | ESEDELFLG | ESDFLAG | CHAR | 1 | 0 | Deletion Indicator | ||
21 | PARKFLG | ESEPARKFLG | ESDFLAG | CHAR | 1 | 0 | Data Record Is Inactive | ||
22 | CRDAT | ESECRDAT | DATUM | DATS | 8 | 0 | Created On | ||
23 | CRNAM | ESECRNAM | USNAM | CHAR | 12 | 0 | Created By | ||
24 | UPDDAT | ESEUPDDAT | DATUM | DATS | 8 | 0 | Changed On | ||
25 | UPDNAM | ESEUPDNAM | USNAM | CHAR | 12 | 0 | Last Changed By | ||
26 | SRSID | ESESRSID | ESDSRSID | CHAR | 10 | 0 | Source of Data | TCG56 | |
27 | OWNID | ESEVENDRID | AD_ADDRNUM | CHAR | 10 | 0 | Data Provider | * | |
28 | RECNROOT | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
29 | FAID | CCIHE_FAID | CCIHD_FAID | CHAR | 20 | 0 | Injury/Illness Log Entry | ||
30 | FATYPE | CCIHE_FATYPE | CCIHD_FATYPE | CHAR | 3 | 0 | Injury/Illness Log Entry Type | CCIHC_FATYPE | |
31 | FAPLANT | CCIHE_FAPLANT | WERKS | CHAR | 4 | 0 | Plant Assignment | T001W | |
32 | FASTATUS | EHSBE_STATUS | J_STATUS | CHAR | 5 | 0 | Status | ||
33 | FAINITSTATUS | CCIHE_INITSTATUS | J_STATUS | CHAR | 5 | 0 | Initial Status of an Object | ||
34 | MTNLANGU | CCIHE_MTNLANGU | SPRAS | LANG | 1 | 0 | Language of Entry | T002 | |
35 | FALOC | CCIHE_FALOC | CCIHD_FALOC | CHAR | 3 | 0 | Entry Location | CCIHC_FALOC | |
36 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
37 | FATRANSFLG | CCIHE_FATRANSFLG | ESDFLAG | CHAR | 1 | 0 | Data Record Is for Transfer to Incident/Accident Log | ||
38 | FATRANSDEC | CCIHE_FATRANSDEC | ESDEXTFLAG | CHAR | 1 | 0 | Transfer decision injury/illness log - incident/accident log | ||
39 | RECNTIA | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
40 | TRANSDAT | CCIHE_TRANSDAT | DATUM | DATS | 8 | 0 | Date of Data Transfer Injury/Illness Log to Inc./Acc. Log | ||
41 | TRANSTIME | CCIHE_TRANSTIME | TIME | TIMS | 6 | 0 | Time of Data Transfer Injury/Illness Log to Inc./Acc. Log | ||
42 | TRANSNAM | CCIHE_TRANSNAM | USNAM | CHAR | 12 | 0 | Administrator Data Transfer Injury/Illness Log to I/A Log | ||
43 | FATALFLG | CCIHE_FATALFLG | ESDFLAG | CHAR | 1 | 0 | Fatality | ||
44 | FAFIRSTRFLG | CCIHE_FAFIRSTRFLG | ESDFLAG | CHAR | 1 | 0 | Initial Treatment After Event | ||
45 | FADAT | CCIHE_FADAT | DATUM | DATS | 8 | 0 | Date When Aid Was Given | ||
46 | FATIME | CCIHE_FATIME | TIME | TIMS | 6 | 0 | Time and Date of Aid Given | ||
47 | FAHELPER | CCIHE_FAHELPER | CCIHD_PERSON | CHAR | 10 | 0 | First-Aider | ||
48 | FAHELPERFLG | CCIHE_FAHELPERFLG | CCIHD_EXTFLG | CHAR | 1 | 0 | First-Aider (External) | ||
49 | FATRTOHC | CCIHE_FATRTOHC | CCIHD_TRMEANS | CHAR | 21 | 0 | Transport to First Aid Center By | * | |
50 | FATRFRHC | CCIHE_FATRFRHC | CCIHD_TRMEANS | CHAR | 21 | 0 | Means of Further Transport from Health Center | * | |
51 | .INCLUDE | 0 | 0 | EHS: Event Data | |||||
52 | EVDAT | CCIHE_EVDAT | DATUM | DATS | 8 | 0 | Event Date | ||
53 | EVTIME | CCIHE_EVTIME | TIME | TIMS | 6 | 0 | Event Time | ||
54 | RECNTWAH | CCIHE_RECNTWAH | ESDRECN | NUMC | 20 | 0 | Reference to Work Area | ||
55 | ACLOC | CCIHE_ACLOC | CCIHD_ACLOC | CHAR | 10 | 0 | Accident Location | * | |
56 | ACLOCDESC | CCIHE_ACLOCDESC | TEXT60 | CHAR | 60 | 0 | Description of Accident Location | ||
57 | .INCLUDE | 0 | 0 | EHS: Event Data for Person Affected | |||||
58 | FRTRMT | CCIHE_FRTRMT | CCIHD_PERSON | CHAR | 10 | 0 | Further Treatment | * | |
59 | FRTRMTFLG | CCIHE_FRTRMTFLG | CCIHD_EXTFLG | CHAR | 1 | 0 | Physician Giving Further Treatment (Internal/External) | ||
60 | INTNOTE | CCIHE_INTNOTELXT | TEXT72 | CHAR | 72 | 0 | Commentary for internal use | ||
61 | INTNOTEFLG | CCIHE_INTNOTEFLG | FLAG | CHAR | 1 | 0 | Long Text Available for an Internal Note | ||
62 | EXTNOTE | CCIHE_EXTNOTELXT | TEXT72 | CHAR | 72 | 0 | Information for External Purposes | ||
63 | EXTNOTEFLG | CCIHE_EXTNOTEFLG | FLAG | CHAR | 1 | 0 | Long Text Available on External Note | ||
64 | FRTRMTGRP | CCIHE_PERSGRP | CCIHD_PERSGRP | CHAR | 1 | 0 | Person Group | ||
65 | .INCLUDE | 0 | 0 | EHS: Absence Person Affected (Event Data) | |||||
66 | OFFJOBDAT | CCIHE_OFFJOBDAT | DATUM | DATS | 8 | 0 | Date of Ceasing to Work | ||
67 | OFFJOBTIME | CCIHE_OFFJOBTIME | UZEIT | TIMS | 6 | 0 | Time of Ceasing to Work | ||
68 | IPABSSUBTYPE | CCIHE_IPABSSUBTYPE | SUBTYP | CHAR | 4 | 0 | Absence Type | * | |
69 | IPABSBEGDAT | CCIHE_IPABSBEGDAT | DATUM | DATS | 8 | 0 | Start Date of Absence | ||
70 | IPABSENDDAT | CCIHE_IPABSENDDAT | DATUM | DATS | 8 | 0 | End Date of Absence | ||
71 | IPABSSEQNUM | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
72 | IPABSESTDAYS | CCIHE_IPABSESTDAYS | CCIHD_DAYS | DEC | 6 | 2 | Estimated Duration of Absence (in Days) | ||
73 | IPABSDAYS | CCIHE_IPABSDAYS | CCIHD_IPABSDAYS | DEC | 6 | 2 | Number of Workdays Absent | ||
74 | IPABSCALDAYS | CCIHE_IPABSCALDAYS | CCIHD_IPABSCALDAYS | DEC | 8 | 2 | Calendar Days | ||
75 | IPRSWBEGDAT | CCIHE_IPRSWBEGDAT | DATUM | DATS | 8 | 0 | Start of Restriction or Date of Job Transfer | ||
76 | IPRSWENDDAT | CCIHE_IPRSWENDDAT | DATUM | DATS | 8 | 0 | End Date of Restriction or Job Transfer | ||
77 | IPRSWDAYS | CCIHE_IPRSWDAYS | DEC4_2 | DEC | 6 | 2 | Number of Workdays with Restriction or Job Transfer | ||
78 | IPRSWCALDAYS | CCIHE_IPRSWCALDAYS | CCIHD_IPABSCALDAYS | DEC | 8 | 2 | Calendar Days with Restriction or Job Transfer | ||
79 | FAHELPERGRP | CCIHE_PERSGRP | CCIHD_PERSGRP | CHAR | 1 | 0 | Person Group | ||
80 | FATIMEZONE | CCIHE_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Valid Time Zone | TTZZ | |
81 | EVTIMEZONE | CCIHE_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Valid Time Zone | TTZZ | |
82 | OFFJOBTIMEZONE | CCIHE_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Valid Time Zone | TTZZ | |
83 | IAREPORTFLG | CCIHE_IAREPORTFLG | ESDFLAG | CHAR | 1 | 0 | Reportable Accident | ||
84 | PRIVCONCFLG | CCIHE_PRIVCONCFLG | ESDFLAG | CHAR | 1 | 0 | Privacy Concern Case | ||
85 | EMERGRMFLG | CCIHE_EMERGRMFLG | ESDFLAG | CHAR | 1 | 0 | Treatment in Emergency Room | ||
86 | INPATFLG | CCIHE_INPATFLG | ESDFLAG | CHAR | 1 | 0 | Treatment Overnight As Inpatient | ||
87 | IPDEATHDATE | CCIHE_IPDEATHDATE | DATUM | DATS | 8 | 0 | Date of Death of Person Affected | ||
88 | UNCONSCIOUS | CCIHE_UNCONSCIOUS | ESDFLAG | CHAR | 1 | 0 | Person Unconscious | ||
89 | RESUSCITATION | CCIHE_RESUSCITATION | ESDFLAG | CHAR | 1 | 0 | Resuscitation Performed | ||
90 | HOSPITALIZATION | CCIHE_HOSPITALIZATION | ESDFLAG | CHAR | 1 | 0 | Hospitalization for over 24 Hours |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CCIHS_FALHBUF | AENNR | AENR | AENNR | REF | 1 | CN |
2 | CCIHS_FALHBUF | EVTIMEZONE | TTZZ | TZONE | REF | 1 | CN |
3 | CCIHS_FALHBUF | FALOC | CCIHC_FALOC | FALOC | REF | C | CN |
4 | CCIHS_FALHBUF | FAPLANT | T001W | WERKS | REF | 1 | CN |
5 | CCIHS_FALHBUF | FATIMEZONE | TTZZ | TZONE | REF | 1 | CN |
6 | CCIHS_FALHBUF | FATYPE | CCIHC_FATYPE | FATYPE | REF | 1 | CN |
7 | CCIHS_FALHBUF | MANDT | T000 | MANDT | KEY | 1 | CN |
8 | CCIHS_FALHBUF | MTNLANGU | T002 | SPRAS | REF | 1 | CN |
9 | CCIHS_FALHBUF | OFFJOBTIMEZONE | TTZZ | TZONE | REF | 1 | CN |
10 | CCIHS_FALHBUF | SRSID | TCG56 | SRSID | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |