EHFNDI_REQ_RL_SN

Transparent Table System Table (SAP only)
13 Fields 2 CDS Views

Compliance Requirement - Name on List

EHFNDI_REQ_RL_SN is an SAP database table in S/4HANA. Compliance Requirement - Name on List. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SubstanceNameOnListSAP view from BASIC Substance Name on List View (SAP Content Only)
P_CmplRqVersUnionNameOnList view union_all BASIC

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY bco_id EHFND_BCO_ID BCO ID
KEY bco_key EHFND_BCO_KEY BCO 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
listed_substance_name_uuid /BOBF/CONF_KEY NodeID
name_sequence EHFND_NAME_ON_LIST_SEQ_NUM Sequence Number
language EHFND_LANGU Language
listsub_id 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.

-- Compliance Requirement - Name on List
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDI_REQ_RL_SN (
    BCO_ID,                      -- BCO ID [EHFND_BCO_ID]
    BCO_KEY,                     -- BCO KEY [EHFND_BCO_KEY]
    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]
    LISTED_SUBSTANCE_NAME_UUID,  -- NodeID [/BOBF/CONF_KEY]
    NAME_SEQUENCE,               -- Sequence Number [EHFND_NAME_ON_LIST_SEQ_NUM]
    LANGUAGE,                    -- Language [EHFND_LANGU]
    LISTSUB_ID,                  -- Listed Substance [EHFND_REGBASLST_SUB]
    PRIMARY KEY (BCO_ID, BCO_KEY)
);

Learn More