EHENVD_CDEF_RES

Transparent Table Application Table
17 Fields 2 CDS Views

Calculation Definition - Result - Transparent Table

EHENVD_CDEF_RES is an SAP database table in S/4HANA. Calculation Definition - Result - Transparent Table. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
Ehenv_Cdef_Amns_All view inner All CDEFs for Amounts
Ehenv_Cdef_Amns_All_P view inner All CDEFs for Amounts with parameter

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
root_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
scen_root_key_ref EHENV_SCEN_KEY_REF_TXT Scenario
valid_from EHFND_REV_EXT_START_DATE Valid From
valid_to EHFND_REV_EXT_END_DATE Valid To
expression EHFND_REQ_EQU_EXPRESSION Expression
req_equ_res_key_ref /BOBF/CONF_KEY NodeID
dirty_from_tstmp EHENV_RESULT_DIRTY_FROM_TSTMP Calc. Changed at
non_periodic_inputs_only EHFND_BOOLEAN Select
big_period_inp_than_res_only EHFND_BOOLEAN Select
eew_cdef_result_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 - Transparent Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVD_CDEF_RES (
    MANDT,                         -- Client [MANDT]
    DB_KEY,                        -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,                    -- NodeID [/BOBF/CONF_KEY]
    ROOT_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]
    SCEN_ROOT_KEY_REF,             -- Scenario [EHENV_SCEN_KEY_REF_TXT]
    VALID_FROM,                    -- Valid From [EHFND_REV_EXT_START_DATE]
    VALID_TO,                      -- Valid To [EHFND_REV_EXT_END_DATE]
    EXPRESSION,                    -- Expression [EHFND_REQ_EQU_EXPRESSION]
    REQ_EQU_RES_KEY_REF,           -- NodeID [/BOBF/CONF_KEY]
    DIRTY_FROM_TSTMP,              -- Calc. Changed at [EHENV_RESULT_DIRTY_FROM_TSTMP]
    NON_PERIODIC_INPUTS_ONLY,      -- Select [EHFND_BOOLEAN]
    BIG_PERIOD_INP_THAN_RES_ONLY,  -- Select [EHFND_BOOLEAN]
    EEW_CDEF_RESULT_D,             -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More