EGERH

Transparent Table Application Table
29 Fields 5 CDS Views

Historical Data of ISU Device Master Record

EGERH is an SAP database table in S/4HANA. Historical Data of ISU Device Master Record. It contains 29 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
CRMS4_IU_I_DEV view inner Device
CRMS4_IU_I_DEVH view union_all Device History
CRMS4_IU_P_DEVH_MAX view from Device History (max)
CRMS4_IU_P_DEVINL view inner Device by Installation
I_UtilitiesDeviceHistory view from BASIC Device History

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY equnr EQUNR Equipment
KEY bis BISZEITSCH Valid to
ab ABZEITSCH Valid From
kombinat KOMBINAT Dev. type comb.
logiknr LOGIKNR Log. dev. no.
zwgruppe E_ZWGRUPPE Register Group
einbdat EINBDAT Install. date
ausbdat AUSBDAT Removal date
gerwechs GERWECHS Activity reason
devloc DEVLOC Device Location
devgrp DEVGRP Device group
wgruppe WGRUPPE Winding group
ppm_meter PPM_METER PP Meter
primwnr1 PRIMWNR PrimaryWind.no.
sekwnr1 SEKWNR Secondary wind.
primwnr2 PRIMWNR PrimaryWind.no.
sekwnr2 SEKWNR Secondary wind.
lossdtgroup E_LOSSDTGROUP Loss Det. Group
rating E_RATING Rating
p_voltage E_P_VOLTAGE Primary Voltage
s_voltage E_S_VOLTAGE Sec. Voltage
ams E_AMI_AMS AMS
amcg_cap_grp E_AMI_AMCG_CAP_GRP AMCG
msg_attr_id E_AMI_MSG_ATTR_ID Msg. Attribute
cap_act_grp E_AMI_CAP_ACT_GRP AMICAG
einbzeit INSTTIME Install.Time
ausbzeit REMOVTIME Removal Time
zeitzone INSTREMOV_TIMEZONE Time Zone

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.

-- Historical Data of ISU Device Master Record
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EGERH (
    MANDT,         -- Client [MANDT]
    EQUNR,         -- Equipment [EQUNR]
    BIS,           -- Valid to [BISZEITSCH]
    AB,            -- Valid From [ABZEITSCH]
    KOMBINAT,      -- Dev. type comb. [KOMBINAT]
    LOGIKNR,       -- Log. dev. no. [LOGIKNR]
    ZWGRUPPE,      -- Register Group [E_ZWGRUPPE]
    EINBDAT,       -- Install. date [EINBDAT]
    AUSBDAT,       -- Removal date [AUSBDAT]
    GERWECHS,      -- Activity reason [GERWECHS]
    DEVLOC,        -- Device Location [DEVLOC]
    DEVGRP,        -- Device group [DEVGRP]
    WGRUPPE,       -- Winding group [WGRUPPE]
    PPM_METER,     -- PP Meter [PPM_METER]
    PRIMWNR1,      -- PrimaryWind.no. [PRIMWNR]
    SEKWNR1,       -- Secondary wind. [SEKWNR]
    PRIMWNR2,      -- PrimaryWind.no. [PRIMWNR]
    SEKWNR2,       -- Secondary wind. [SEKWNR]
    LOSSDTGROUP,   -- Loss Det. Group [E_LOSSDTGROUP]
    RATING,        -- Rating [E_RATING]
    P_VOLTAGE,     -- Primary Voltage [E_P_VOLTAGE]
    S_VOLTAGE,     -- Sec. Voltage [E_S_VOLTAGE]
    AMS,           -- AMS [E_AMI_AMS]
    AMCG_CAP_GRP,  -- AMCG [E_AMI_AMCG_CAP_GRP]
    MSG_ATTR_ID,   -- Msg. Attribute [E_AMI_MSG_ATTR_ID]
    CAP_ACT_GRP,   -- AMICAG [E_AMI_CAP_ACT_GRP]
    EINBZEIT,      -- Install.Time [INSTTIME]
    AUSBZEIT,      -- Removal Time [REMOVTIME]
    ZEITZONE,      -- Time Zone [INSTREMOV_TIMEZONE]
    PRIMARY KEY (MANDT, EQUNR, BIS)
);

Learn More