EHHSSD_RSK_CTRL

Transparent Table Application Table
29 Fields 2 CDS Views

Risk - Control

EHHSSD_RSK_CTRL is an SAP database table in S/4HANA. Risk - Control. It contains 29 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EHSRiskControl view from BASIC EHS Risk Control
P_RqdPrsnlProtectiveEquipAtLoc view from BASIC

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
root_key /BOBF/CONF_KEY NodeID
parent_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
control_code EHHSS_CONTROL2_CODE Control Code
resp_id EHHSS_CTRL_RESP_ID Responsible
impl_status EHHSS_CTRL_IMPL_STATUS Impl. Status
effectivn_code EHFND_CTRL_EFFECTIVN_CODE Effectiveness
hazard_code EHHSS_HAZARD_CODE Hazard
desc_key_ref /BOBF/CONF_KEY NodeID
proposal_ind EHHSS_CTRL_PROPOSAL_IND Proposed
proposed_title EHHSS_CTRL_PROPOSED_TITLE Name
proposed_type EHFND_ACT_CTRL_TYPE_CODE Type
proposed_subj EHFND_ACT_SUBJECT_CODE Subtype
proposed_cat_tit EHFND_CONTROL_CATALOG_TITLE Control Catalog
goal_target_code EHHSS_CTRL_GOAL_TARGET_CODE Target
goal_object_code EHHSS_CTRL_GOAL_OBJECT_CODE Objective
goal_ctrl_effect EHHSS_CTRL_GOAL_CTRL_EFFECT Desired Effect
effect_det_date EHHSS_CTRL_EVAL_DATE Evaluation Date
effect_det_code EHHSS_CTRL_EFFECTIVN_DET_CODE Eval. Via
orgnl_key_ref /BOBF/CONF_KEY NodeID
last_effect_key /BOBF/CONF_KEY NodeID
ref_category EHFND_CTRL_REF_CAT_CODE Object
ref_id EHFND_TO_ID Technical Object
eew_rsk_ctrl_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 - Control
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSD_RSK_CTRL (
    MANDT,             -- Client [MANDT]
    DB_KEY,            -- NodeID [/BOBF/CONF_KEY]
    ROOT_KEY,          -- NodeID [/BOBF/CONF_KEY]
    PARENT_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]
    CONTROL_CODE,      -- Control Code [EHHSS_CONTROL2_CODE]
    RESP_ID,           -- Responsible [EHHSS_CTRL_RESP_ID]
    IMPL_STATUS,       -- Impl. Status [EHHSS_CTRL_IMPL_STATUS]
    EFFECTIVN_CODE,    -- Effectiveness [EHFND_CTRL_EFFECTIVN_CODE]
    HAZARD_CODE,       -- Hazard [EHHSS_HAZARD_CODE]
    DESC_KEY_REF,      -- NodeID [/BOBF/CONF_KEY]
    PROPOSAL_IND,      -- Proposed [EHHSS_CTRL_PROPOSAL_IND]
    PROPOSED_TITLE,    -- Name [EHHSS_CTRL_PROPOSED_TITLE]
    PROPOSED_TYPE,     -- Type [EHFND_ACT_CTRL_TYPE_CODE]
    PROPOSED_SUBJ,     -- Subtype [EHFND_ACT_SUBJECT_CODE]
    PROPOSED_CAT_TIT,  -- Control Catalog [EHFND_CONTROL_CATALOG_TITLE]
    GOAL_TARGET_CODE,  -- Target [EHHSS_CTRL_GOAL_TARGET_CODE]
    GOAL_OBJECT_CODE,  -- Objective [EHHSS_CTRL_GOAL_OBJECT_CODE]
    GOAL_CTRL_EFFECT,  -- Desired Effect [EHHSS_CTRL_GOAL_CTRL_EFFECT]
    EFFECT_DET_DATE,   -- Evaluation Date [EHHSS_CTRL_EVAL_DATE]
    EFFECT_DET_CODE,   -- Eval. Via [EHHSS_CTRL_EFFECTIVN_DET_CODE]
    ORGNL_KEY_REF,     -- NodeID [/BOBF/CONF_KEY]
    LAST_EFFECT_KEY,   -- NodeID [/BOBF/CONF_KEY]
    REF_CATEGORY,      -- Object [EHFND_CTRL_REF_CAT_CODE]
    REF_ID,            -- Technical Object [EHFND_TO_ID]
    EEW_RSK_CTRL_D,    -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More