EHFNDD_CHM_HING

Transparent Table Application Table
15 Fields 1 CDS Views

Chemical - Hazardous Ingredients

EHFNDD_CHM_HING is an SAP database table in S/4HANA. Chemical - Hazardous Ingredients. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChemicalHzdsIngredients view from BASIC Hazardous Ingredients of the Chemical

Fields (15)

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
haz_ingr_key_ref EHFND_LISU_ROOT_REF_KEY Listed Substance
prop_lower_meas EHFND_CHM_PROPORTION_MIN Minimal Proportion
prop_upper_meas EHFND_CHM_PROPORTION_MAX Maximal Proportion
prop_unit EHFND_CHM_PROP_UNIT_CODE Unit
prop_lower_op EHFND_CHM_PROP_LOWER_OP Min. Prop. Operator
prop_upper_op EHFND_CHM_PROP_UPPER_OP Max. Prop. Operator
eew_chm_hing_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 - Hazardous Ingredients
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_CHM_HING (
    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]
    HAZ_INGR_KEY_REF,  -- Listed Substance [EHFND_LISU_ROOT_REF_KEY]
    PROP_LOWER_MEAS,   -- Minimal Proportion [EHFND_CHM_PROPORTION_MIN]
    PROP_UPPER_MEAS,   -- Maximal Proportion [EHFND_CHM_PROPORTION_MAX]
    PROP_UNIT,         -- Unit [EHFND_CHM_PROP_UNIT_CODE]
    PROP_LOWER_OP,     -- Min. Prop. Operator [EHFND_CHM_PROP_LOWER_OP]
    PROP_UPPER_OP,     -- Max. Prop. Operator [EHFND_CHM_PROP_UPPER_OP]
    EEW_CHM_HING_D,    -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More