EHFNDD_CHM_HCG

Transparent Table Application Table
9 Fields 2 CDS Views

Chemical - Hazard Classification Group

EHFNDD_CHM_HCG is an SAP database table in S/4HANA. Chemical - Hazard Classification Group. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChmlGHSHazardClassGroup view from BASIC Chemical Hazard Classification Group
I_ChmlGHSHazardClGroupCntry view inner BASIC Hazard Classif. Group Country/Region

Fields (9)

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
eew_chm_hazclass_group_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 - Hazard Classification Group
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_CHM_HCG (
    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]
    EEW_CHM_HAZCLASS_GROUP_D,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More