EHFNDI_LISU_RT

Transparent Table System Table (SAP only)
15 Fields

Delivery of Listed Substances

EHFNDI_LISU_RT is an SAP database table in S/4HANA. Delivery of Listed Substances. It contains 15 fields.

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY listsub_id EHFND_REGBASLST_SUB Listed Substance
KEY bco_key EHFND_BCO_KEY BCO KEY
KEY db_key /BOBF/CONF_KEY NodeID
node_cat_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
cas_number EHFND_LISU_CAS_NO CAS Number
is_group_ind EHFND_LISU_ISGROUP_IND Is Group
external_src EHFND_LSUB_EXTERNAL_SOURCE External Source
mol_formula EHFND_LISU_MOL_FORMULA Molecular Formula
ec_number EHFND_LISU_EC_NUMBER EC Number
condition_code EHFND_LISU_COND_CODE Conditions
listsub_id_root EHFND_REGBASLST_SUB Listed Substance

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.

-- Delivery of Listed Substances
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDI_LISU_RT (
    LISTSUB_ID,       -- Listed Substance [EHFND_REGBASLST_SUB]
    BCO_KEY,          -- BCO KEY [EHFND_BCO_KEY]
    DB_KEY,           -- NodeID [/BOBF/CONF_KEY]
    NODE_CAT_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]
    CAS_NUMBER,       -- CAS Number [EHFND_LISU_CAS_NO]
    IS_GROUP_IND,     -- Is Group [EHFND_LISU_ISGROUP_IND]
    EXTERNAL_SRC,     -- External Source [EHFND_LSUB_EXTERNAL_SOURCE]
    MOL_FORMULA,      -- Molecular Formula [EHFND_LISU_MOL_FORMULA]
    EC_NUMBER,        -- EC Number [EHFND_LISU_EC_NUMBER]
    CONDITION_CODE,   -- Conditions [EHFND_LISU_COND_CODE]
    LISTSUB_ID_ROOT,  -- Listed Substance [EHFND_REGBASLST_SUB]
    PRIMARY KEY (LISTSUB_ID, BCO_KEY, DB_KEY)
);

Learn More