EHENVD_SCEN_AGGR

Transparent Table Application Table
10 Fields 4 CDS Views

Compliance Scenario - Loc. Aggregation - Database Table

EHENVD_SCEN_AGGR is an SAP database table in S/4HANA. Compliance Scenario - Loc. Aggregation - Database Table. It contains 10 fields. 4 CDS views read from this table.

CDS Views using this table (4)

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
I_EHSCmplncScenLocAggrgn view from BASIC EHS Compliance Scenario Loc. Aggregation

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_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
adef_root_key_ref EHFND_CONF_KEY NodeID
is_owned_indicator EHFND_BOOLEAN Select
eew_scen_aggr_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 - Loc. Aggregation - Database Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVD_SCEN_AGGR (
    MANDT,               -- Client [MANDT]
    DB_KEY,              -- NodeID [/BOBF/CONF_KEY]
    PARENT_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]
    ADEF_ROOT_KEY_REF,   -- NodeID [EHFND_CONF_KEY]
    IS_OWNED_INDICATOR,  -- Select [EHFND_BOOLEAN]
    EEW_SCEN_AGGR_D,     -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More