EHHSSD_RSK_ROOT

Transparent Table Application Table
24 Fields 4 CDS Views

Risk - Root

EHHSSD_RSK_ROOT is an SAP database table in S/4HANA. Risk - Root. It contains 24 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
Ehhss_Exposures_Of_Risks view from Risks and assosiated exposures
Ehhss_Risks_At_Location view from Risk at given location and sublocation
I_EHSRiskRoot view from BASIC EHS Risk Root
P_RqdPrsnlProtectiveEquipAtLoc view inner BASIC

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
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
id EHHSS_RISK_ID Risk ID
hazard EHHSS_HAZARD_CODE Hazard
loc_root_key_ref EHFND_LOCATION_KEY_REF Location
operation_status EHHSS_OPSTATUS_CODE Oper. Status
ras_type EHHSS_RAS_TYPE_CODE Assess. Type
agent_key_ref EHHSS_AGENT_KEY_REF Agent
cma_key_ref EHHSS_CMA_KEY_REF Chemical Agent
abagt_key_ref EHHSS_ABAGT_KEY_REF Airborne Agent
atf_key /BOFU/CONF_KEY Key
risk_level EHHSS_RISK_LEVEL_CODE Risk Level
job_key_ref EHHSS_JOB_KEY_REF Job
step_id EHHSS_RAS_STEP_ID Step ID
risk_icon EHHSS_RISK_LEVEL_ICON Level Icon
haz_cat EHHSS_HAZ_CATEGORY_CODE Hazard Category
is_simulated EHHSS_RISK_SIMULATED_FLAG Simulated
meth_of_use_code EHFND_METHOD_OF_USE Method of Use
archiving_status /BOFU/ARCHIVING_STATUS_CODE Archiving Stat.
eew_rsk_root_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.

-- Risk - Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSD_RSK_ROOT (
    MANDT,             -- Client [MANDT]
    DB_KEY,            -- NodeID [/BOBF/CONF_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]
    ID,                -- Risk ID [EHHSS_RISK_ID]
    HAZARD,            -- Hazard [EHHSS_HAZARD_CODE]
    LOC_ROOT_KEY_REF,  -- Location [EHFND_LOCATION_KEY_REF]
    OPERATION_STATUS,  -- Oper. Status [EHHSS_OPSTATUS_CODE]
    RAS_TYPE,          -- Assess. Type [EHHSS_RAS_TYPE_CODE]
    AGENT_KEY_REF,     -- Agent [EHHSS_AGENT_KEY_REF]
    CMA_KEY_REF,       -- Chemical Agent [EHHSS_CMA_KEY_REF]
    ABAGT_KEY_REF,     -- Airborne Agent [EHHSS_ABAGT_KEY_REF]
    ATF_KEY,           -- Key [/BOFU/CONF_KEY]
    RISK_LEVEL,        -- Risk Level [EHHSS_RISK_LEVEL_CODE]
    JOB_KEY_REF,       -- Job [EHHSS_JOB_KEY_REF]
    STEP_ID,           -- Step ID [EHHSS_RAS_STEP_ID]
    RISK_ICON,         -- Level Icon [EHHSS_RISK_LEVEL_ICON]
    HAZ_CAT,           -- Hazard Category [EHHSS_HAZ_CATEGORY_CODE]
    IS_SIMULATED,      -- Simulated [EHHSS_RISK_SIMULATED_FLAG]
    METH_OF_USE_CODE,  -- Method of Use [EHFND_METHOD_OF_USE]
    ARCHIVING_STATUS,  -- Archiving Stat. [/BOFU/ARCHIVING_STATUS_CODE]
    EEW_RSK_ROOT_D,    -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More