EHENVD_SCEN_ROOT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | mandt | MANDT | |
| KEY | db_key | /BOBF/CONF_KEY | |
| datetime_cr | /BOBF/DATETIME_CR | ||
| user_id_cr | /BOBF/USER_ID_CR | ||
| datetime_ch | /BOBF/DATETIME_CH | ||
| user_id_ch | /BOBF/USER_ID_CH | ||
| desc_key_ref | EHFND_CONF_KEY | ||
| loc_root_key_ref | EHFND_LOCATION_KEY_REF | ||
| date_activated | EHENV_SCEN_DATE_ACTIVATED | ||
| date_inactivated | EHENV_SCEN_DATE_INACTIVATED | ||
| status | EHENV_SCENARIO_STATUS | ||
| resp_key_ref | EHFND_CONF_KEY | ||
| archiving_status | /BOFU/ARCHIVING_STATUS_CODE | ||
| object_key | EHFND_REV_EXT_OBJECT_KEY | ||
| revision_descr | EHFND_REV_EXT_DESCRIPTION | ||
| valid_from | EHFND_REV_EXT_START_DATE | ||
| valid_to | EHFND_REV_EXT_END_DATE | ||
| migration_src | EHENV_SCEN_MIGRATION_SOURCE | ||
| object_id | EHENV_SCEN_ROOT_OBJECT_ID | ||
| scenario_type_code | EHENV_SCENARIO_TYPE_CODE | ||
| prod_proc_type_code | EHENV_SCEN_PRD_PRC_TYP_CODE_CE | ||
| id | EHENV_SCENARIO_ID | ||
| usage_period | EHENV_USAGE_PERIOD | ||
| eew_scen_root_d | DUMMY |