EHENVD_SCEN_ROOT

Transparent Table Application Table
2 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 2 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 (2)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY db_key /bobf/conf_key NodeID

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]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More