EHENVD_CDEF_ROOT

Transparent Table Application Table
19 Fields 8 CDS Views

Calculation Definition - Root - Transparent Table

EHENVD_CDEF_ROOT is an SAP database table in S/4HANA. Calculation Definition - Root - Transparent Table. It contains 19 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
Ehenv_Adef_Cdef_Defs view inner Location Aggregation - Calc. Definitions
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_EHSCalculationDefinitionRoot view_entity from BASIC Calculation Definition Root

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_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
name EHENV_CDEF_NAME Calculation Name
desc_key_ref /BOBF/CONF_KEY NodeID
req_equation_key_ref /BOBF/CONF_KEY NodeID
loc_root_key_ref /BOBF/CONF_KEY NodeID
equation_name EHFND_REQ_EQUATION_NAME Equation Name
usage_period EHENV_USAGE_PERIOD Data Period
fixed_ind EHENV_USAGE_PERIOD_FIXED_IND Usage Period Indicat
disable_full_check_ind EHFND_INDICATOR Select
exec_option EHENV_CDEF_EXEC_TYPE Calculation Mode
exec_option_last_activ EHENV_CDEF_EXEC_TYPE Calculation Mode
calc_engine_type EHENV_CDEF_ENGINE_TYPE Calc. Eng. Type
migration_src EHENV_CDEF_MIGRATION_SOURCE Migr. Source
eew_cdef_root_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 - Root - Transparent Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVD_CDEF_ROOT (
    MANDT,                   -- Client [MANDT]
    DB_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]
    NAME,                    -- Calculation Name [EHENV_CDEF_NAME]
    DESC_KEY_REF,            -- NodeID [/BOBF/CONF_KEY]
    REQ_EQUATION_KEY_REF,    -- NodeID [/BOBF/CONF_KEY]
    LOC_ROOT_KEY_REF,        -- NodeID [/BOBF/CONF_KEY]
    EQUATION_NAME,           -- Equation Name [EHFND_REQ_EQUATION_NAME]
    USAGE_PERIOD,            -- Data Period [EHENV_USAGE_PERIOD]
    FIXED_IND,               -- Usage Period Indicat [EHENV_USAGE_PERIOD_FIXED_IND]
    DISABLE_FULL_CHECK_IND,  -- Select [EHFND_INDICATOR]
    EXEC_OPTION,             -- Calculation Mode [EHENV_CDEF_EXEC_TYPE]
    EXEC_OPTION_LAST_ACTIV,  -- Calculation Mode [EHENV_CDEF_EXEC_TYPE]
    CALC_ENGINE_TYPE,        -- Calc. Eng. Type [EHENV_CDEF_ENGINE_TYPE]
    MIGRATION_SRC,           -- Migr. Source [EHENV_CDEF_MIGRATION_SOURCE]
    EEW_CDEF_ROOT_D,         -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More