EHFNDD_LISU_GRPR

Transparent Table Control Table (SAP+Cust)
12 Fields 3 CDS Views

Listed Substance Group Relation

EHFNDD_LISU_GRPR is an SAP database table in S/4HANA. Listed Substance Group Relation. It contains 12 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
P_LSTDSUBSTUNIONGRPR view from BASIC

Fields (12)

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
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
listsub_ref /BOBF/CONF_KEY NodeID
eew_regl_grpr_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.

-- 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]
    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]
    LISTSUB_REF,      -- NodeID [/BOBF/CONF_KEY]
    EEW_REGL_GRPR_D,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, LISTSUB_ID, BCO_KEY, DB_KEY)
);

Learn More