EHFNDD_REQ_OEL

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

Occupational Exposure Limits

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_CmplRqVersETablExposureLimit view from BASIC Compliance Requirement Direct Access to ETable
P_CmplRqVersUnionExposureLimit view from BASIC Compliance Requirement Union for E- and S- Tables

Fields (20)

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_oel_form_of_expsr
measured_as ehfnd_oel_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
cmrqvsoelpeaklmtexcursionfctr ehfnd_oel_pk_lmt_exc_fctr
cmrqvsoelmomentaryconcnvalue ehfnd_oel_mo_concn_value
cmrqvsoelexcursionfctrcat ehfnd_oel_excursion_factor_cat

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,                  -- ehfnd_oel_form_of_expsr
    MEASURED_AS,                    -- ehfnd_oel_measured_as
    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]
    CMRQVSOELPEAKLMTEXCURSIONFCTR,  -- ehfnd_oel_pk_lmt_exc_fctr
    CMRQVSOELMOMENTARYCONCNVALUE,   -- ehfnd_oel_mo_concn_value
    CMRQVSOELEXCURSIONFCTRCAT,      -- ehfnd_oel_excursion_factor_cat
    PRIMARY KEY (MANDT, BCO_ID, BCO_KEY)
);

Learn More