EHENVD_CDEF_RESH

Transparent Table Application Table
21 Fields 8 CDS Views

Calculation Definition - Result Header - Transparent Table

EHENVD_CDEF_RESH is an SAP database table in S/4HANA. Calculation Definition - Result Header - Transparent Table. It contains 21 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
Ehenv_Amns_All_Loc_Filter view inner Amounts for all locations filter
Ehenv_Amns_At_Loc_Filter view inner Amounts for location and sublocations filter
Ehenv_Cdef_Amns view inner Calculation Amounts
Ehenv_Cdef_Amns_All view inner All CDEFs for Amounts
Ehenv_Cdef_Amns_All_P view inner All CDEFs for Amounts with parameter
Ehenv_Cdef_Amns_At_Location view inner Calculation Amounts At Location
I_CalcDefResultHeader view from BASIC Calculation Definition - Result Header
I_EHSActivityTitle view union BASIC EHS Activity Title

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_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
id EHENV_CDEF_RESULT_HEADER_ID Calc. Def. ID
title EHFND_DESCRIPTION_L Description (L)
title_normed EHFND_DESCRIPTION_L Description (L)
usage_period EHFND_CALC_USAGE_PERIOD Data Period
is_rolling EHFND_BOOLEAN Select
name EHFND_REQ_EQU_VAR_NAME Calc Var Name
description EHFND_REQ_EQU_VAR_DESCRIPTION Description
subject_type_code EHFND_AMNS_SUBJ_TYPE Subject Type
subject_root_key_ref EHFND_AMNS_SBJ_ROOT_KEY_REF Subject Ref Key
unit EHFND_UNIT_CODE Unit of Measurement
chem_property EHFND_CHEM_PROPERTY_CODE Chem. Property
loc_root_key_ref EHFND_LOCATION_KEY_REF Location
result_type EHFND_REQ_EQU_RES_TYPE Result Type
eew_cdef_res_hdr_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.

-- Calculation Definition - Result Header - Transparent Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVD_CDEF_RESH (
    MANDT,                 -- Client [MANDT]
    DB_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]
    ID,                    -- Calc. Def. ID [EHENV_CDEF_RESULT_HEADER_ID]
    TITLE,                 -- Description (L) [EHFND_DESCRIPTION_L]
    TITLE_NORMED,          -- Description (L) [EHFND_DESCRIPTION_L]
    USAGE_PERIOD,          -- Data Period [EHFND_CALC_USAGE_PERIOD]
    IS_ROLLING,            -- Select [EHFND_BOOLEAN]
    NAME,                  -- Calc Var Name [EHFND_REQ_EQU_VAR_NAME]
    DESCRIPTION,           -- Description [EHFND_REQ_EQU_VAR_DESCRIPTION]
    SUBJECT_TYPE_CODE,     -- Subject Type [EHFND_AMNS_SUBJ_TYPE]
    SUBJECT_ROOT_KEY_REF,  -- Subject Ref Key [EHFND_AMNS_SBJ_ROOT_KEY_REF]
    UNIT,                  -- Unit of Measurement [EHFND_UNIT_CODE]
    CHEM_PROPERTY,         -- Chem. Property [EHFND_CHEM_PROPERTY_CODE]
    LOC_ROOT_KEY_REF,      -- Location [EHFND_LOCATION_KEY_REF]
    RESULT_TYPE,           -- Result Type [EHFND_REQ_EQU_RES_TYPE]
    EEW_CDEF_RES_HDR_D,    -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More