EHENVD_ADEF_ROOT

Transparent Table Application Table
25 Fields 6 CDS Views

Location Aggregation - Root - Database Table

EHENVD_ADEF_ROOT is an SAP database table in S/4HANA. Location Aggregation - Root - Database Table. It contains 25 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
Ehenv_Adef_Amns view inner Aggregation Amounts
Ehenv_Adef_Amns_At_Location view inner Aggregation Amounts At Location
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
I_EHSActivityTitle view union BASIC EHS Activity Title
I_LocAggregationRoot view from BASIC Location Aggregation Root

Fields (25)

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
desc_key_ref /BOBF/CONF_KEY NodeID
id EHENV_ADEF_ID Loc. Aggr. ID
function EHENV_ADEF_AGGR_FUNC Aggr. Function
usage_period EHENV_ADEF_USAGE_PERIOD Data Period
chem_property EHFND_CHEM_PROPERTY_CODE Chem. Property
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
loc_root_key_ref /BOBF/CONF_KEY NodeID
name EHENV_ADEF_NAME Aggregation Name
title EHFND_DESCRIPTION_L Description (L)
title_normed EHFND_DESCRIPTION_L Description (L)
aggr_cla_root_key_ref EHENV_ACLA_ROOT_KEY_REF Classifier
amounts_created EHFND_BOOLEAN Select
exec_option EHENV_AGGR_EXEC_TYPE Aggregation Mode
exec_option_last_activ EHENV_AGGR_EXEC_TYPE Aggregation Mode
eew_adef_root_d DUMMY Dummy function in length 1
dirty_from_tstmp EHENV_RESULT_DIRTY_FROM_TSTMP Calc. Changed at
migration_src EHENV_ADEF_MIGRATION_SOURCE Migr. Source

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.

-- Location Aggregation - Root - Database Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVD_ADEF_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]
    DESC_KEY_REF,            -- NodeID [/BOBF/CONF_KEY]
    ID,                      -- Loc. Aggr. ID [EHENV_ADEF_ID]
    FUNCTION,                -- Aggr. Function [EHENV_ADEF_AGGR_FUNC]
    USAGE_PERIOD,            -- Data Period [EHENV_ADEF_USAGE_PERIOD]
    CHEM_PROPERTY,           -- Chem. Property [EHFND_CHEM_PROPERTY_CODE]
    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]
    LOC_ROOT_KEY_REF,        -- NodeID [/BOBF/CONF_KEY]
    NAME,                    -- Aggregation Name [EHENV_ADEF_NAME]
    TITLE,                   -- Description (L) [EHFND_DESCRIPTION_L]
    TITLE_NORMED,            -- Description (L) [EHFND_DESCRIPTION_L]
    AGGR_CLA_ROOT_KEY_REF,   -- Classifier [EHENV_ACLA_ROOT_KEY_REF]
    AMOUNTS_CREATED,         -- Select [EHFND_BOOLEAN]
    EXEC_OPTION,             -- Aggregation Mode [EHENV_AGGR_EXEC_TYPE]
    EXEC_OPTION_LAST_ACTIV,  -- Aggregation Mode [EHENV_AGGR_EXEC_TYPE]
    EEW_ADEF_ROOT_D,         -- Dummy function in length 1 [DUMMY]
    DIRTY_FROM_TSTMP,        -- Calc. Changed at [EHENV_RESULT_DIRTY_FROM_TSTMP]
    MIGRATION_SRC,           -- Migr. Source [EHENV_ADEF_MIGRATION_SOURCE]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More