EHENVD_MDEF_ROOT

Transparent Table Application Table
24 Fields 8 CDS Views

Measurement Definition Root

EHENVD_MDEF_ROOT is an SAP database table in S/4HANA. Measurement Definition Root. It contains 24 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
E_EHSDataCollection view from EXTENSION EHS Data Collection - Extension
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_Mdef_Amns view inner Measurement Amounts
Ehenv_Mdef_Amns_At_Location view inner Measurement Amounts At Location
ehenv_scen_mdef_schedules view inner Scenario Measurement Definition schedule
I_DataCollectionRootBasic view from BASIC Data Collection Root
I_EHSActivityTitle view from BASIC EHS Activity Title

Fields (24)

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
id EHENV_MDEF_ID Data Collection ID
input_method EHENV_MDEF_INPUT_METHOD Input Method
tag_id EHENV_TAG_ID External Source
mdef_period EHENV_MDEF_PERIOD_CODE Data Period
loc_root_key_ref EHFND_LOCATION_KEY_REF Location
unit EHFND_UNIT_CODE Unit of Measurement
unit_alt EHFND_UNIT_CODE Unit of Measurement
category EHENV_MDEF_CATEGORY_CODE Category
counter_ind EHENV_MDEF_COUNTER_IND Totalizer Indicator
subject_type_code EHFND_AMNS_SUBJ_TYPE Subject Type
subject_root_key_ref EHFND_AMNS_SBJ_ROOT_KEY_REF Subject Ref Key
name EHENV_MDEF_NAME Data Collection Name
title EHFND_DESCRIPTION_L Description (L)
title_normed EHFND_DESCRIPTION_L Description (L)
is_overwrite_allowed EHENV_MDEF_OVERWRITE_ALLOWED Overwrite Allowed
auto_approve EHENV_MDEF_AUTO_APPROVE Auto Approve
migration_src EHENV_MDEF_MIGRATION_SOURCE Migr. Source
eew_mdef_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.

-- Measurement Definition Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVD_MDEF_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]
    ID,                    -- Data Collection ID [EHENV_MDEF_ID]
    INPUT_METHOD,          -- Input Method [EHENV_MDEF_INPUT_METHOD]
    TAG_ID,                -- External Source [EHENV_TAG_ID]
    MDEF_PERIOD,           -- Data Period [EHENV_MDEF_PERIOD_CODE]
    LOC_ROOT_KEY_REF,      -- Location [EHFND_LOCATION_KEY_REF]
    UNIT,                  -- Unit of Measurement [EHFND_UNIT_CODE]
    UNIT_ALT,              -- Unit of Measurement [EHFND_UNIT_CODE]
    CATEGORY,              -- Category [EHENV_MDEF_CATEGORY_CODE]
    COUNTER_IND,           -- Totalizer Indicator [EHENV_MDEF_COUNTER_IND]
    SUBJECT_TYPE_CODE,     -- Subject Type [EHFND_AMNS_SUBJ_TYPE]
    SUBJECT_ROOT_KEY_REF,  -- Subject Ref Key [EHFND_AMNS_SBJ_ROOT_KEY_REF]
    NAME,                  -- Data Collection Name [EHENV_MDEF_NAME]
    TITLE,                 -- Description (L) [EHFND_DESCRIPTION_L]
    TITLE_NORMED,          -- Description (L) [EHFND_DESCRIPTION_L]
    IS_OVERWRITE_ALLOWED,  -- Overwrite Allowed [EHENV_MDEF_OVERWRITE_ALLOWED]
    AUTO_APPROVE,          -- Auto Approve [EHENV_MDEF_AUTO_APPROVE]
    MIGRATION_SRC,         -- Migr. Source [EHENV_MDEF_MIGRATION_SOURCE]
    EEW_MDEF_ROOT_D,       -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More