EHFNDD_LISU_GRPR

Transparent Table Control Table (SAP+Cust)

Listed Substance Group Relation

EHFNDD_LISU_GRPR is an SAP database table in S/4HANA. Listed Substance Group Relation. It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ListedSubstanceGroupRelation view_entity from BASIC Listed Substances and Groups Relation
P_LstdSubstETableGrpr view from BASIC Listed Substance Direct Access to ETable
P_LSTDSUBSTUNIONGRPR view from BASIC Listed Subs Union for E- and S-Table

Fields (7)

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
parent_key /bobf/conf_key NodeID
node_cat_key /bobf/conf_key NodeID
listsub_ref /bobf/conf_key NodeID

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 Group Relation
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_LISU_GRPR (
    MANDT,         -- Client [mandt]
    LISTSUB_ID,    -- Listed Substance [ehfnd_regbaslst_sub]
    BCO_KEY,       -- BCO KEY [ehfnd_bco_key]
    DB_KEY,        -- NodeID [/bobf/conf_key]
    PARENT_KEY,    -- NodeID [/bobf/conf_key]
    NODE_CAT_KEY,  -- NodeID [/bobf/conf_key]
    LISTSUB_REF,   -- NodeID [/bobf/conf_key]
    PRIMARY KEY (MANDT, LISTSUB_ID, BCO_KEY, DB_KEY)
);