EHFNDD_LISU_RT

Transparent Table Control Table (SAP+Cust)
13 Fields 4 CDS Views

Listed Substance

EHFNDD_LISU_RT is an SAP database table in S/4HANA. Listed Substance. It contains 13 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
Ehfnd_Chm_Wpcp_Lisu_with_Sub view inner Chemical Workplace Control Parameter
I_LstdSubstWthVarAndGrp view from BASIC Listed Substance View
P_LstdSubstETableRoot view from BASIC Listed Substance Direct Access to ETable
P_LSTDSUBSTUNIONROOT view from BASIC Listed Subs Union for E- and S-Table

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
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
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
content_provider ehfnd_content_provider

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.

-- Listed Substance
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_LISU_RT (
    MANDT,             -- Client [mandt]
    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]
    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]
    CONTENT_PROVIDER,  -- ehfnd_content_provider
    PRIMARY KEY (MANDT, LISTSUB_ID, BCO_KEY, DB_KEY)
);

Learn More