EGERR

Transparent Table Application Table
46 Fields 6 CDS Views

Device data: Info record for point of delivery - historical

EGERR is an SAP database table in S/4HANA. Device data: Info record for point of delivery - historical. It contains 46 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
CRMS4_IU_I_DEV view inner Device
CRMS4_IU_I_DEVH view from Device History
CRMS4_IU_P_DEVINL view inner Device by Installation
CRMS4_IU_P_DEVR_MAX view from Device Info Record (max)
E_UtilsDvceInfoRecordHistory view from EXTENSION Device Information Record History Extension
I_UtilsDvceInfoRecordHistory view from BASIC Device Information Record History

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY equnr EQUNR Equipment
KEY bis BISZEITSCH Valid to
ab ABZEITSCH Valid From
logiknr LOGIKNR Log. dev. no.
zwgruppe E_ZWGRUPPE Register Group
wgruppe WGRUPPE Winding group
primwnr1 PRIMWNR PrimaryWind.no.
sekwnr1 SEKWNR Secondary wind.
primwnr2 PRIMWNR PrimaryWind.no.
sekwnr2 SEKWNR Secondary wind.
komgrp KOMGRP Command Group
messdrck MESSDRCK Measured Press.
ueberver UEBERVER Transform.ratio
zspanns E_ZSPANNS Sec. voltage
zstroms E_ZSTROMS Secondary curr.
zspannp E_ZSPANNP Primary voltage
zstromp E_ZSTROMP Primary current
matnr MATNR Material
geraet GERNR Serial Number
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
kombinat KOMBINAT Dev. type comb.
sparte SPARTE Division
eagruppe EAGRUPPE I/O Group
umbaudat UMBAUDAT Modificat. date
umbaugr UMBAUGR Modific. reason
einbdat EINBDAT Install. date
ausbdat AUSBDAT Removal date
devgrp DEVGRP Device group
service_prov EGERR_SERVICE_PROV Serv. Provider
egerr_info EGERR_INFO Information
ppm_meter PPM_METER PP Meter
begru IAUTG AuthorizGroup
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
uii UII_CHAR72 UII
msg_attr_id E_AMI_MSG_ATTR_ID Msg. Attribute
cap_act_grp E_AMI_CAP_ACT_GRP AMICAG
dummy_utilsdvceirh_incl_eew_ps E_UTILSDVCEIRH_INCL_EEW Dummy

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.

-- Device data: Info record for point of delivery - historical
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EGERR (
    MANDT,                           -- Client [MANDT]
    EQUNR,                           -- Equipment [EQUNR]
    BIS,                             -- Valid to [BISZEITSCH]
    AB,                              -- Valid From [ABZEITSCH]
    LOGIKNR,                         -- Log. dev. no. [LOGIKNR]
    ZWGRUPPE,                        -- Register Group [E_ZWGRUPPE]
    WGRUPPE,                         -- Winding group [WGRUPPE]
    PRIMWNR1,                        -- PrimaryWind.no. [PRIMWNR]
    SEKWNR1,                         -- Secondary wind. [SEKWNR]
    PRIMWNR2,                        -- PrimaryWind.no. [PRIMWNR]
    SEKWNR2,                         -- Secondary wind. [SEKWNR]
    KOMGRP,                          -- Command Group [KOMGRP]
    MESSDRCK,                        -- Measured Press. [MESSDRCK]
    UEBERVER,                        -- Transform.ratio [UEBERVER]
    ZSPANNS,                         -- Sec. voltage [E_ZSPANNS]
    ZSTROMS,                         -- Secondary curr. [E_ZSTROMS]
    ZSPANNP,                         -- Primary voltage [E_ZSPANNP]
    ZSTROMP,                         -- Primary current [E_ZSTROMP]
    MATNR,                           -- Material [MATNR]
    GERAET,                          -- Serial Number [GERNR]
    ERDAT,                           -- Created On [ERDAT]
    ERNAM,                           -- Created By [ERNAM]
    AEDAT,                           -- Changed On [AEDAT]
    AENAM,                           -- Changed By [AENAM]
    KOMBINAT,                        -- Dev. type comb. [KOMBINAT]
    SPARTE,                          -- Division [SPARTE]
    EAGRUPPE,                        -- I/O Group [EAGRUPPE]
    UMBAUDAT,                        -- Modificat. date [UMBAUDAT]
    UMBAUGR,                         -- Modific. reason [UMBAUGR]
    EINBDAT,                         -- Install. date [EINBDAT]
    AUSBDAT,                         -- Removal date [AUSBDAT]
    DEVGRP,                          -- Device group [DEVGRP]
    SERVICE_PROV,                    -- Serv. Provider [EGERR_SERVICE_PROV]
    EGERR_INFO,                      -- Information [EGERR_INFO]
    PPM_METER,                       -- PP Meter [PPM_METER]
    BEGRU,                           -- AuthorizGroup [IAUTG]
    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]
    UII,                             -- UII [UII_CHAR72]
    MSG_ATTR_ID,                     -- Msg. Attribute [E_AMI_MSG_ATTR_ID]
    CAP_ACT_GRP,                     -- AMICAG [E_AMI_CAP_ACT_GRP]
    DUMMY_UTILSDVCEIRH_INCL_EEW_PS,  -- Dummy [E_UTILSDVCEIRH_INCL_EEW]
    PRIMARY KEY (MANDT, EQUNR, BIS)
);

Learn More