EHFNDD_CHM_ROOT

Transparent Table Application Table
13 Fields 1 CDS Views

Chemical - Root

EHFNDD_CHM_ROOT is an SAP database table in S/4HANA. Chemical - Root. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChemicalRoot view from BASIC Chemical Root

Fields (13)

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 EHFND_CHM_ID Chemical ID
status EHFND_CHM_OBSOLETE_STATUS Obsolete
external_src EHFND_CHM_EXTERNAL_SOURCE External Source
chm_nature EHFND_CHM_NATURE Chemical Type
is_sds_record EHFND_CHM_SDS_RECORD_IND Is SDS Data Record
atf_key EHFND_CHM_ATF_KEY Attachment Folder
eew_chm_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.

-- Chemical - Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_CHM_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,              -- Chemical ID [EHFND_CHM_ID]
    STATUS,          -- Obsolete [EHFND_CHM_OBSOLETE_STATUS]
    EXTERNAL_SRC,    -- External Source [EHFND_CHM_EXTERNAL_SOURCE]
    CHM_NATURE,      -- Chemical Type [EHFND_CHM_NATURE]
    IS_SDS_RECORD,   -- Is SDS Data Record [EHFND_CHM_SDS_RECORD_IND]
    ATF_KEY,         -- Attachment Folder [EHFND_CHM_ATF_KEY]
    EEW_CHM_ROOT_D,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More