EHFNDD_REQ_OEL

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

Occupational Exposure Limits

EHFNDD_REQ_OEL is an SAP database table in S/4HANA. Occupational Exposure Limits. It contains 17 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 (17)

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
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

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]
    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]
    PRIMARY KEY (MANDT, BCO_ID, BCO_KEY)
);

Learn More