EHHSSD_RAS_ROOT

Transparent Table Application Table
23 Fields 1 CDS Views

Risk Assessment Root

EHHSSD_RAS_ROOT is an SAP database table in S/4HANA. Risk Assessment Root. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EHSRiskAssessment view from BASIC EHS Risk Assessment

Fields (23)

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_RAS_ID Risk Assessment ID
status EHHSS_RAS_STATUS Status
type EHHSS_RAS_TYPE_CODE Assess. Type
title EHHSS_RAS_TITLE Title
comment_key_ref /BOBF/CONF_KEY NodeID
atf_key /BOBF/CONF_KEY NodeID
copied_key_ref /BOBF/CONF_KEY NodeID
job_root_key_ref EHHSS_JOB_KEY_REF Job
obs_person_id EHHSS_RAS_OBS_PERSON_ID Obs. Person
archiving_status /BOFU/ARCHIVING_STATUS_CODE Archiving Stat.
agent_key_ref EHHSS_AGENT_KEY_REF Agent
is_simulated EHHSS_RAS_SIMULATED_FLAG Simulated
loc_key_ref EHFND_LOCATION_KEY_REF Location
op_status_code EHHSS_OPSTATUS_CODE Oper. Status
title_normed EHHSS_RAS_TITLE Title
archiving_loc_key_ref EHFND_LOCATION_KEY_REF Location
eew_ras_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 Assessment Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSD_RAS_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 Assessment ID [EHHSS_RAS_ID]
    STATUS,                 -- Status [EHHSS_RAS_STATUS]
    TYPE,                   -- Assess. Type [EHHSS_RAS_TYPE_CODE]
    TITLE,                  -- Title [EHHSS_RAS_TITLE]
    COMMENT_KEY_REF,        -- NodeID [/BOBF/CONF_KEY]
    ATF_KEY,                -- NodeID [/BOBF/CONF_KEY]
    COPIED_KEY_REF,         -- NodeID [/BOBF/CONF_KEY]
    JOB_ROOT_KEY_REF,       -- Job [EHHSS_JOB_KEY_REF]
    OBS_PERSON_ID,          -- Obs. Person [EHHSS_RAS_OBS_PERSON_ID]
    ARCHIVING_STATUS,       -- Archiving Stat. [/BOFU/ARCHIVING_STATUS_CODE]
    AGENT_KEY_REF,          -- Agent [EHHSS_AGENT_KEY_REF]
    IS_SIMULATED,           -- Simulated [EHHSS_RAS_SIMULATED_FLAG]
    LOC_KEY_REF,            -- Location [EHFND_LOCATION_KEY_REF]
    OP_STATUS_CODE,         -- Oper. Status [EHHSS_OPSTATUS_CODE]
    TITLE_NORMED,           -- Title [EHHSS_RAS_TITLE]
    ARCHIVING_LOC_KEY_REF,  -- Location [EHFND_LOCATION_KEY_REF]
    EEW_RAS_ROOT_D,         -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More