EHENVD_SCEN_ROOT

Transparent Table Application Table
24 Fields 25 CDS Views

Compliance Scenario - Root - Database Table

EHENVD_SCEN_ROOT is an SAP database table in S/4HANA. Compliance Scenario - Root - Database Table. It contains 24 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
EHENV_ADEF_ADEF_DEFS view inner Location Aggregation - Loc. Aggregation
Ehenv_Adef_Amns view inner Aggregation Amounts
Ehenv_Adef_Amns_At_Location view inner Aggregation Amounts At Location
Ehenv_Adef_Cdef_Defs view inner Location Aggregation - Calc. Definitions
Ehenv_Adef_Mdef_Defs view inner Location Aggregation - Measurement Definitions
Ehenv_Adef_Sdef_Defs view inner Location Aggregation - Sampling Definitions
Ehenv_Amns_All_Loc view left_outer Amounts for all locations
Ehenv_Amns_At_Loc view left_outer Amounts at location and its sublocations
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
Ehenv_Mdef_Amns view inner Measurement Amounts
Ehenv_Mdef_Amns_At_Location view inner Measurement Amounts At Location
Ehenv_Scen_Loc_Active view inner Active Scenarios for a User
ehenv_scen_mdef_schedules view inner Scenario Measurement Definition schedule
Ehenv_Scen_Usr_Active view left_outer Active Scenarios for a User
Ehenv_Scen_Usra_Loc_Curr_Rev view left_outer Active Scenarios per user and location current revision
Ehenv_Scenario_Limits view inner Environmental Scenario Limits
Ehenv_Sdef_Amns view inner Sampling Amounts
Ehenv_Sdef_Amns_At_Location view inner Sampling Amounts at Location
I_EHSActiveScenDataColl view inner BASIC EHS Data Collections of active scenarios
I_EHSCmplncScenRevision view from BASIC EHS Compliance Scenario Revision
I_EHSCmplncScenRoot view from BASIC EHS Compliance Scenario Root
I_EHSComplianceScenario view from BASIC EHS Compliance Scenario

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
desc_key_ref EHFND_CONF_KEY NodeID
loc_root_key_ref EHFND_LOCATION_KEY_REF Location
date_activated EHENV_SCEN_DATE_ACTIVATED Activation Date
date_inactivated EHENV_SCEN_DATE_INACTIVATED Deactivation Date
status EHENV_SCENARIO_STATUS Status
resp_key_ref EHFND_CONF_KEY NodeID
archiving_status /BOFU/ARCHIVING_STATUS_CODE Archiving Stat.
object_key EHFND_REV_EXT_OBJECT_KEY Cross Revision Key
revision_descr EHFND_REV_EXT_DESCRIPTION Revision
valid_from EHFND_REV_EXT_START_DATE Valid From
valid_to EHFND_REV_EXT_END_DATE Valid To
migration_src EHENV_SCEN_MIGRATION_SOURCE Migr. Source
object_id EHENV_SCEN_ROOT_OBJECT_ID Object ID
scenario_type_code EHENV_SCENARIO_TYPE_CODE Scenario Type Code
prod_proc_type_code EHENV_SCEN_PRD_PRC_TYP_CODE_CE Type Code
id EHENV_SCENARIO_ID Scenario ID
usage_period EHENV_USAGE_PERIOD Data Period
eew_scen_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.

-- Compliance Scenario - Root - Database Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVD_SCEN_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 [EHFND_CONF_KEY]
    LOC_ROOT_KEY_REF,     -- Location [EHFND_LOCATION_KEY_REF]
    DATE_ACTIVATED,       -- Activation Date [EHENV_SCEN_DATE_ACTIVATED]
    DATE_INACTIVATED,     -- Deactivation Date [EHENV_SCEN_DATE_INACTIVATED]
    STATUS,               -- Status [EHENV_SCENARIO_STATUS]
    RESP_KEY_REF,         -- NodeID [EHFND_CONF_KEY]
    ARCHIVING_STATUS,     -- Archiving Stat. [/BOFU/ARCHIVING_STATUS_CODE]
    OBJECT_KEY,           -- Cross Revision Key [EHFND_REV_EXT_OBJECT_KEY]
    REVISION_DESCR,       -- Revision [EHFND_REV_EXT_DESCRIPTION]
    VALID_FROM,           -- Valid From [EHFND_REV_EXT_START_DATE]
    VALID_TO,             -- Valid To [EHFND_REV_EXT_END_DATE]
    MIGRATION_SRC,        -- Migr. Source [EHENV_SCEN_MIGRATION_SOURCE]
    OBJECT_ID,            -- Object ID [EHENV_SCEN_ROOT_OBJECT_ID]
    SCENARIO_TYPE_CODE,   -- Scenario Type Code [EHENV_SCENARIO_TYPE_CODE]
    PROD_PROC_TYPE_CODE,  -- Type Code [EHENV_SCEN_PRD_PRC_TYP_CODE_CE]
    ID,                   -- Scenario ID [EHENV_SCENARIO_ID]
    USAGE_PERIOD,         -- Data Period [EHENV_USAGE_PERIOD]
    EEW_SCEN_ROOT_D,      -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More