EHHSSD_INC_INJIL

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
I_IncidentInjuryIllness view from BASIC Injury or Illness of an Injured Person

Fields (24)

KeyField Data ElementDescription DomainTypeLength
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)
);