EHFNDI_REQ_THRL

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

Compliance Requirement Threshold List

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CmplRqVersThldListItmSAP view from BASIC Thresholds at List. Subs. on Subs. Lists (SAP Content Only)
P_CmplRqVersUnionThresholdList 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
listsub_id EHFND_REGBASLST_SUB Listed Substance
value EHFND_REQ_THRL_VALUE Threshold
unit EHFND_REGL_COMP_UNIT_CODE Unit
add_info EHFND_DESCRIPTION_XL Description(XL)

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 Threshold List
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDI_REQ_THRL (
    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]
    LISTSUB_ID,   -- Listed Substance [EHFND_REGBASLST_SUB]
    VALUE,        -- Threshold [EHFND_REQ_THRL_VALUE]
    UNIT,         -- Unit [EHFND_REGL_COMP_UNIT_CODE]
    ADD_INFO,     -- Description(XL) [EHFND_DESCRIPTION_XL]
    PRIMARY KEY (BCO_ID, BCO_KEY)
);

Learn More