EHFNDD_REQ_OEL

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

Occupational Exposure Limits

EHFNDD_REQ_OEL is an SAP database table in S/4HANA. Occupational Exposure Limits. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_CmplRqVersETablExposureLimit view from BASIC
P_CmplRqVersUnionExposureLimit view from BASIC

Fields (22)

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
listsub_id EHFND_REGBASLST_SUB Listed Substance
value_type EHFND_VALUE_TYPE_CODE Value Type
value_meas EHFND_OEL_VALUE_MEAS Limit
value_unit EHFND_UNIT_CODE Unit of Measurement
exposure_form EHFND_EXPOSURE_FORM_CODE Form of Exposure
measured_as EHFND_MEASURED_AS_CODE Measured As
oel_type EHFND_OEL_TYPE_CODE OEL Type
duration EHFND_EXPOSURE_DURATION Exposure Duration
duration_unit EHFND_EXPOSURE_DUR_UNIT_CODE Exp. Duration Unit
external_src EHFND_OEL_EXTERNAL_SOURCE External Source
amount_category EHFND_AMN_CATEGORY_CODE Category
eew_req_oel_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.

-- Occupational Exposure Limits
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_REQ_OEL (
    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]
    LISTSUB_ID,       -- Listed Substance [EHFND_REGBASLST_SUB]
    VALUE_TYPE,       -- Value Type [EHFND_VALUE_TYPE_CODE]
    VALUE_MEAS,       -- Limit [EHFND_OEL_VALUE_MEAS]
    VALUE_UNIT,       -- Unit of Measurement [EHFND_UNIT_CODE]
    EXPOSURE_FORM,    -- Form of Exposure [EHFND_EXPOSURE_FORM_CODE]
    MEASURED_AS,      -- Measured As [EHFND_MEASURED_AS_CODE]
    OEL_TYPE,         -- OEL Type [EHFND_OEL_TYPE_CODE]
    DURATION,         -- Exposure Duration [EHFND_EXPOSURE_DURATION]
    DURATION_UNIT,    -- Exp. Duration Unit [EHFND_EXPOSURE_DUR_UNIT_CODE]
    EXTERNAL_SRC,     -- External Source [EHFND_OEL_EXTERNAL_SOURCE]
    AMOUNT_CATEGORY,  -- Category [EHFND_AMN_CATEGORY_CODE]
    EEW_REQ_OEL_D,    -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, BCO_ID, BCO_KEY)
);

Learn More