EHFNDD_CHM_BINFO

Transparent Table Application Table
22 Fields 3 CDS Views

Chemical - Basic Info

EHFNDD_CHM_BINFO is an SAP database table in S/4HANA. Chemical - Basic Info. It contains 22 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
Ehfnd_Chemical_Name view inner Determines the name of a chemical
I_ChemicalBasicInfo view from BASIC Chemical Basic Information
I_ChemicalNameText view inner BASIC Chemical Name

Fields (22)

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
color EHFND_CHM_COLOR_CODE Color
form EHFND_CHM_FORM_CODE Form
odor EHFND_CHM_ODOR_CODE Odor
state_of_matter EHFND_CHM_STATE_OF_MATTER_CODE Physical State
atf_key /BOBF/CONF_KEY NodeID
molec_formula EHFND_CHM_MOL_FORMULA Molecular Formula
iupac_name EHFND_CHM_IUPAC_NAME IUPAC Name
cas_number EHFND_CHM_CAS_NO CAS Number
einecs_number EHFND_CHM_EINECS_NO EINECS Number
reach_reg_number EHFND_CHM_REACH_REG_NO REACH Reg. Number
reach_reg_name EHFND_CHM_REACH_REG_NAME REACH Reg. Name
is_sara_ehs EHFND_CHM_IS_SARA_EHS Is EHS
eew_chm_basinf_d DUMMY Dummy function in length 1
hazard EHHSS_HAZARD_CMA_CODE Hazard

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 - Basic Info
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_CHM_BINFO (
    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]
    COLOR,             -- Color [EHFND_CHM_COLOR_CODE]
    FORM,              -- Form [EHFND_CHM_FORM_CODE]
    ODOR,              -- Odor [EHFND_CHM_ODOR_CODE]
    STATE_OF_MATTER,   -- Physical State [EHFND_CHM_STATE_OF_MATTER_CODE]
    ATF_KEY,           -- NodeID [/BOBF/CONF_KEY]
    MOLEC_FORMULA,     -- Molecular Formula [EHFND_CHM_MOL_FORMULA]
    IUPAC_NAME,        -- IUPAC Name [EHFND_CHM_IUPAC_NAME]
    CAS_NUMBER,        -- CAS Number [EHFND_CHM_CAS_NO]
    EINECS_NUMBER,     -- EINECS Number [EHFND_CHM_EINECS_NO]
    REACH_REG_NUMBER,  -- REACH Reg. Number [EHFND_CHM_REACH_REG_NO]
    REACH_REG_NAME,    -- REACH Reg. Name [EHFND_CHM_REACH_REG_NAME]
    IS_SARA_EHS,       -- Is EHS [EHFND_CHM_IS_SARA_EHS]
    EEW_CHM_BASINF_D,  -- Dummy function in length 1 [DUMMY]
    HAZARD,            -- Hazard [EHHSS_HAZARD_CMA_CODE]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More