EHENVD_SDEF_ROOT

Transparent Table Application Table
12 Fields 6 CDS Views

Sampling Definition - Root - Database Table

EHENVD_SDEF_ROOT is an SAP database table in S/4HANA. Sampling Definition - Root - Database Table. It contains 12 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
Ehenv_Adef_Sdef_Defs view inner Location Aggregation - Sampling 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_Sdef_Amns view inner Sampling Amounts
Ehenv_Sdef_Amns_At_Location view inner Sampling Amounts at Location
I_SamplingDefinitionRoot view from BASIC Sampling Definition Root

Fields (12)

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_SDEF_NAME Sampling Name
loc_root_key_ref EHFND_LOCATION_KEY_REF Location
subject_type_code EHFND_AMNS_SUBJ_TYPE Subject Type
subject_root_key_ref EHFND_AMNS_SBJ_ROOT_KEY_REF Subject Ref Key
migration_src EHENV_SDEF_MIGRATION_SOURCE Migr. Source
eew_sdef_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.

-- Sampling Definition - Root - Database Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVD_SDEF_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,                  -- Sampling Name [EHENV_SDEF_NAME]
    LOC_ROOT_KEY_REF,      -- Location [EHFND_LOCATION_KEY_REF]
    SUBJECT_TYPE_CODE,     -- Subject Type [EHFND_AMNS_SUBJ_TYPE]
    SUBJECT_ROOT_KEY_REF,  -- Subject Ref Key [EHFND_AMNS_SBJ_ROOT_KEY_REF]
    MIGRATION_SRC,         -- Migr. Source [EHENV_SDEF_MIGRATION_SOURCE]
    EEW_SDEF_ROOT_D,       -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More