EHENVC_MDEF_RO

Transparent Table Customizing Table
4 Fields 3 CDS Views

Measurement Data Collector Roles

EHENVC_MDEF_RO is an SAP database table in S/4HANA. Measurement Data Collector Roles. It contains 4 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_EHSDtaCollLocResponsibleRole view_entity from BASIC Mapping between a Role and a Data Collection Privileges
I_EHSLocRespManager view inner BASIC Location Responsible Manager
I_EHSLocRespTechnician view inner BASIC Location Responsible Technician

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY code EHENV_MDEF_ROLE_CODE Env Mgmt Roles
KEY is_collector EHENV_MDEF_ROLE_COLLECTOR_IND Collector Role
KEY is_scheduler EHENV_MDEF_ROLE_SCHEDULER_IND Manager Role

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.

-- Measurement Data Collector Roles
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHENVC_MDEF_RO (
    CLIENT,        -- Client [MANDT]
    CODE,          -- Env Mgmt Roles [EHENV_MDEF_ROLE_CODE]
    IS_COLLECTOR,  -- Collector Role [EHENV_MDEF_ROLE_COLLECTOR_IND]
    IS_SCHEDULER,  -- Manager Role [EHENV_MDEF_ROLE_SCHEDULER_IND]
    PRIMARY KEY (CLIENT, CODE, IS_COLLECTOR, IS_SCHEDULER)
);

Learn More