EHFNDD_CTRL_ROOT

Transparent Table Application Table
16 Fields 5 CDS Views

Control - Register

EHFNDD_CTRL_ROOT is an SAP database table in S/4HANA. Control - Register. It contains 16 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
Ehfnd_Control_Name view from Determines the name of a control
I_EHSControl view from BASIC EHS Control
I_EHSControlImageURL view from BASIC Image URLs for Controls
I_EHSControlImplmtnImageURL view from BASIC Image URLs for Control Implementations
P_RqdPrsnlProtectiveEquipAtLoc view inner BASIC

Fields (16)

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
catalog_code EHFND_CONTROL_CODE Control Catalog
id EHFND_CTRL_ID Control ID
resp_id EHFND_CTRL_RESP_ID Responsible
goal_target_code EHFND_CTRL_GOAL_TARGET_CODE Target
goal_object_code EHFND_CTRL_GOAL_OBJECT_CODE Objective
goal_ctrl_effect EHFND_CTRL_GOAL_CTRL_EFFECT Desired Effect
rem_desc_key_ref /BOBF/CONF_KEY NodeID
migration_src EHFND_CTRL_MIGRATION_SOURCE Migration Source
image_key_ref EHFND_CTRL_IMAGE_KEY Control Image
eew_ctrl_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.

-- Control - Register
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_CTRL_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]
    CATALOG_CODE,      -- Control Catalog [EHFND_CONTROL_CODE]
    ID,                -- Control ID [EHFND_CTRL_ID]
    RESP_ID,           -- Responsible [EHFND_CTRL_RESP_ID]
    GOAL_TARGET_CODE,  -- Target [EHFND_CTRL_GOAL_TARGET_CODE]
    GOAL_OBJECT_CODE,  -- Objective [EHFND_CTRL_GOAL_OBJECT_CODE]
    GOAL_CTRL_EFFECT,  -- Desired Effect [EHFND_CTRL_GOAL_CTRL_EFFECT]
    REM_DESC_KEY_REF,  -- NodeID [/BOBF/CONF_KEY]
    MIGRATION_SRC,     -- Migration Source [EHFND_CTRL_MIGRATION_SOURCE]
    IMAGE_KEY_REF,     -- Control Image [EHFND_CTRL_IMAGE_KEY]
    EEW_CTRL_ROOT_D,   -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More