EHHSSD_INC_INJIL
Incident - Injury / Illness
EHHSSD_INC_INJIL is an SAP database table in S/4HANA. Incident - Injury / Illness. It contains 24 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_IncidentInjuryIllness | view | from | BASIC | Injury or Illness of an Injured Person |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | db_key | EHHSS_INC_INJIL_KEY | Injury | |||
| root_key | EHHSS_INC_ROOT_KEY | Incident - Root | ||||
| parent_key | EHHSS_INC_PINJI_KEY | Injured | ||||
| datetime_cr | /BOBF/DATETIME_CR | Created On/At | ||||
| user_id_cr | /BOBF/USER_ID_CR | Created By | ||||
| datetime_ch | /BOBF/DATETIME_CH | Changed On/At | ||||
| user_id_ch | /BOBF/USER_ID_CH | Changed By | ||||
| inj_ill | EHHSS_INJ_ILL_CODE | Classification | ||||
| type | EHHSS_INJ_ILL_TYPE_CODE | Injury/Illness | ||||
| start_timestamp | EHHSS_INJ_ILL_START_TIME_STAMP | Date/Time | ||||
| start_time_zone | EHHSS_INJ_ILL_START_TIME_ZONE | Time Zone | ||||
| end_timestamp | EHHSS_INJ_ILL_END_TIME_STAMP | Date/Time | ||||
| end_time_zone | EHHSS_INJ_ILL_END_TIME_ZONE | Time Zone | ||||
| fatality_ts | EHHSS_INJ_ILL_FATALITY_TS | Fatality | ||||
| body_part | EHHSS_BODY_PART_CODE | Body Part | ||||
| body_side | EHHSS_BODY_SIDE_CODE | Body Side | ||||
| main_ts | EHHSS_INJ_ILL_MAIN_TS | Main Inj./Ill. | ||||
| previous_ts | EHHSS_INJ_ILL_PREVIOUS_TS | Prev. Inj./Ill. | ||||
| reg_rep_ts | EHHSS_INJ_ILL_REGULATOR_REP_TS | Reporting Reqd. | ||||
| txc_bp_desc_key | /BOBF/CONF_KEY | NodeID | ||||
| txc_desc_key | /BOBF/CONF_KEY | NodeID | ||||
| old_injury_ts | EHHSS_INJ_ILL_OLD_INJURY_TS | Old Injury | ||||
| eew_inc_injil_d | DUMMY | Dummy function in length 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Incident - Injury / Illness
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSD_INC_INJIL (
MANDT, -- Client [MANDT]
DB_KEY, -- Injury [EHHSS_INC_INJIL_KEY]
ROOT_KEY, -- Incident - Root [EHHSS_INC_ROOT_KEY]
PARENT_KEY, -- Injured [EHHSS_INC_PINJI_KEY]
DATETIME_CR, -- Created On/At [/BOBF/DATETIME_CR]
USER_ID_CR, -- Created By [/BOBF/USER_ID_CR]
DATETIME_CH, -- Changed On/At [/BOBF/DATETIME_CH]
USER_ID_CH, -- Changed By [/BOBF/USER_ID_CH]
INJ_ILL, -- Classification [EHHSS_INJ_ILL_CODE]
TYPE, -- Injury/Illness [EHHSS_INJ_ILL_TYPE_CODE]
START_TIMESTAMP, -- Date/Time [EHHSS_INJ_ILL_START_TIME_STAMP]
START_TIME_ZONE, -- Time Zone [EHHSS_INJ_ILL_START_TIME_ZONE]
END_TIMESTAMP, -- Date/Time [EHHSS_INJ_ILL_END_TIME_STAMP]
END_TIME_ZONE, -- Time Zone [EHHSS_INJ_ILL_END_TIME_ZONE]
FATALITY_TS, -- Fatality [EHHSS_INJ_ILL_FATALITY_TS]
BODY_PART, -- Body Part [EHHSS_BODY_PART_CODE]
BODY_SIDE, -- Body Side [EHHSS_BODY_SIDE_CODE]
MAIN_TS, -- Main Inj./Ill. [EHHSS_INJ_ILL_MAIN_TS]
PREVIOUS_TS, -- Prev. Inj./Ill. [EHHSS_INJ_ILL_PREVIOUS_TS]
REG_REP_TS, -- Reporting Reqd. [EHHSS_INJ_ILL_REGULATOR_REP_TS]
TXC_BP_DESC_KEY, -- NodeID [/BOBF/CONF_KEY]
TXC_DESC_KEY, -- NodeID [/BOBF/CONF_KEY]
OLD_INJURY_TS, -- Old Injury [EHHSS_INJ_ILL_OLD_INJURY_TS]
EEW_INC_INJIL_D, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (MANDT, DB_KEY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA