EHENVD_SCEN_LMT

Transparent Table Application Table
30 Fields 3 CDS Views

Compliance Scenario - Environmental Limit - Database Table

EHENVD_SCEN_LMT is an SAP database table in S/4HANA. Compliance Scenario - Environmental Limit - Database Table. It contains 30 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
Ehenv_Scenario_Limits view from Environmental Scenario Limits
I_EHSCmplncScenEnvrnmtlLimitVH view inner BASIC EHS Compliance Scneraio Env Limits
I_EHSCmplncScenLimit view from BASIC EHS Compliance Scenario Limit

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
req_structure_key EHFND_CONF_KEY NodeID
req_envlimit_key EHFND_CONF_KEY NodeID
bo_key_ref EHFND_CONF_KEY NodeID
bo_node_key_ref EHFND_CONF_KEY NodeID
bo_node_inst_key_ref EHFND_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
name EHFND_REQ_LIM_NAME Limit Name
type EHFND_REQ_LIM_TYPE_CODE Env. Limit Type
subject_type EHFND_AMNS_SUBJ_TYPE Subject Type
subject_key_ref EHFND_AMNS_SBJ_ROOT_KEY_REF Subject Ref Key
limit_operator EHFND_SEL_OPTION Operator
is_limit_value_zero EHFND_BOOLEAN Select
limit_value EHFND_AMNS_VALUE Value
upper_limit_operator EHFND_SEL_OPTION Operator
is_upper_limit_value_zero EHFND_BOOLEAN Select
upper_limit_value EHFND_AMNS_VALUE Value
warning_limit_oper EHFND_SEL_OPTION Operator
is_warning_limit_value_zero EHFND_BOOLEAN Select
warning_limit_value EHFND_AMNS_VALUE Value
is_warn_upper_limit_zero EHFND_BOOLEAN Select
warning_upper_limit_value EHFND_AMNS_VALUE Value
warning_upper_limit_oper EHFND_SEL_OPTION Operator
unit EHFND_UNIT_CODE Unit of Measurement
eew_req_envilim_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 Scenario - Environmental Limit - Database Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVD_SCEN_LMT (
    MANDT,                        -- Client [MANDT]
    DB_KEY,                       -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,                   -- NodeID [/BOBF/CONF_KEY]
    REQ_STRUCTURE_KEY,            -- NodeID [EHFND_CONF_KEY]
    REQ_ENVLIMIT_KEY,             -- NodeID [EHFND_CONF_KEY]
    BO_KEY_REF,                   -- NodeID [EHFND_CONF_KEY]
    BO_NODE_KEY_REF,              -- NodeID [EHFND_CONF_KEY]
    BO_NODE_INST_KEY_REF,         -- NodeID [EHFND_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]
    NAME,                         -- Limit Name [EHFND_REQ_LIM_NAME]
    TYPE,                         -- Env. Limit Type [EHFND_REQ_LIM_TYPE_CODE]
    SUBJECT_TYPE,                 -- Subject Type [EHFND_AMNS_SUBJ_TYPE]
    SUBJECT_KEY_REF,              -- Subject Ref Key [EHFND_AMNS_SBJ_ROOT_KEY_REF]
    LIMIT_OPERATOR,               -- Operator [EHFND_SEL_OPTION]
    IS_LIMIT_VALUE_ZERO,          -- Select [EHFND_BOOLEAN]
    LIMIT_VALUE,                  -- Value [EHFND_AMNS_VALUE]
    UPPER_LIMIT_OPERATOR,         -- Operator [EHFND_SEL_OPTION]
    IS_UPPER_LIMIT_VALUE_ZERO,    -- Select [EHFND_BOOLEAN]
    UPPER_LIMIT_VALUE,            -- Value [EHFND_AMNS_VALUE]
    WARNING_LIMIT_OPER,           -- Operator [EHFND_SEL_OPTION]
    IS_WARNING_LIMIT_VALUE_ZERO,  -- Select [EHFND_BOOLEAN]
    WARNING_LIMIT_VALUE,          -- Value [EHFND_AMNS_VALUE]
    IS_WARN_UPPER_LIMIT_ZERO,     -- Select [EHFND_BOOLEAN]
    WARNING_UPPER_LIMIT_VALUE,    -- Value [EHFND_AMNS_VALUE]
    WARNING_UPPER_LIMIT_OPER,     -- Operator [EHFND_SEL_OPTION]
    UNIT,                         -- Unit of Measurement [EHFND_UNIT_CODE]
    EEW_REQ_ENVILIM_D,            -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More