EHFNDD_REQ_RL_SN

Transparent Table Control Table (SAP+Cust)
15 Fields 2 CDS Views

Compliance Requirement - Name on List

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_CmplRqVersETablNameOnList view from BASIC
P_CmplRqVersUnionNameOnList view from BASIC

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
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
eew_req_rl_sn_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.

-- Compliance Requirement - Name on List
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_REQ_RL_SN (
    MANDT,                       -- Client [MANDT]
    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]
    EEW_REQ_RL_SN_D,             -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, BCO_ID, BCO_KEY)
);

Learn More