EGERS

Transparent Table Application Table
37 Fields 4 CDS Views

IS-U Device Master Data

EGERS is an SAP database table in S/4HANA. IS-U Device Master Data. It contains 37 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
CRMS4_IU_I_DEV view inner Device
CRMS4_IU_I_DEVH view inner Device History
E_UtilitiesDeviceHeader view from EXTENSION Device Header Data Extension
I_UtilitiesDeviceHeader view from BASIC Device Header Data

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY equnr EQUNR Equipment
eagruppe EAGRUPPE I/O Group
komgrp KOMGRP Command Group
los LOS Lot
messdrck MESSDRCK Measured Press.
ueberver UEBERVER Transform.ratio
besitz BESITZ Inspection rel.
bgljahr BGLJAHR Cert. year
wechsel WECHSEL Advance repl.
bglstat BGLSTAT Certific. stat.
kzstich KZSTICH Samp.dev.status
schwgrad SCHWGRAD Diffic. level
plombdat PLOMBDAT Sealing date
bglart BGLART Certif. type
bglnum BGLNUM Certific. no.
umbaudat UMBAUDAT Modificat. date
umbaugr UMBAUGR Modific. reason
eichfael EICHFAEL Calibrat.valid.
parametr PARAMETR Parametrization
plombe PLOMBE Seal code
aedat AEDAT Changed On
aenam AENAM Changed By
zspanns E_ZSPANNS Sec. voltage
zstroms E_ZSTROMS Secondary curr.
zspannp E_ZSPANNP Primary voltage
zstromp E_ZSTROMP Primary current
prgruppe PRGRUPPE Insp. point grp
bglnetz BGLNETZ Cert. ins. devs
order_code ORDERCODE2 Order Code
approvalnr APPROVALNR Inspection no.
vlzeit_dev VLZEIT_DEV Ind. cal. val.
notif_code NOTIF_CODE Notif. code
dummy_utilsdvcehdr_incl_eew_ps E_UTILSDVCEHDR_INCL_EEW Dummy
cert_date /SAPCE/IURU_CERT_DATE Certification date
nxt_repl_date /SAPCE/IURU_NXTREPL_DATE Next repl. date
per_repl_date /SAPCE/IURU_PER_REPL_DATE Per replacement date

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.

-- IS-U Device Master Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EGERS (
    MANDT,                           -- Client [MANDT]
    EQUNR,                           -- Equipment [EQUNR]
    EAGRUPPE,                        -- I/O Group [EAGRUPPE]
    KOMGRP,                          -- Command Group [KOMGRP]
    LOS,                             -- Lot [LOS]
    MESSDRCK,                        -- Measured Press. [MESSDRCK]
    UEBERVER,                        -- Transform.ratio [UEBERVER]
    BESITZ,                          -- Inspection rel. [BESITZ]
    BGLJAHR,                         -- Cert. year [BGLJAHR]
    WECHSEL,                         -- Advance repl. [WECHSEL]
    BGLSTAT,                         -- Certific. stat. [BGLSTAT]
    KZSTICH,                         -- Samp.dev.status [KZSTICH]
    SCHWGRAD,                        -- Diffic. level [SCHWGRAD]
    PLOMBDAT,                        -- Sealing date [PLOMBDAT]
    BGLART,                          -- Certif. type [BGLART]
    BGLNUM,                          -- Certific. no. [BGLNUM]
    UMBAUDAT,                        -- Modificat. date [UMBAUDAT]
    UMBAUGR,                         -- Modific. reason [UMBAUGR]
    EICHFAEL,                        -- Calibrat.valid. [EICHFAEL]
    PARAMETR,                        -- Parametrization [PARAMETR]
    PLOMBE,                          -- Seal code [PLOMBE]
    AEDAT,                           -- Changed On [AEDAT]
    AENAM,                           -- Changed By [AENAM]
    ZSPANNS,                         -- Sec. voltage [E_ZSPANNS]
    ZSTROMS,                         -- Secondary curr. [E_ZSTROMS]
    ZSPANNP,                         -- Primary voltage [E_ZSPANNP]
    ZSTROMP,                         -- Primary current [E_ZSTROMP]
    PRGRUPPE,                        -- Insp. point grp [PRGRUPPE]
    BGLNETZ,                         -- Cert. ins. devs [BGLNETZ]
    ORDER_CODE,                      -- Order Code [ORDERCODE2]
    APPROVALNR,                      -- Inspection no. [APPROVALNR]
    VLZEIT_DEV,                      -- Ind. cal. val. [VLZEIT_DEV]
    NOTIF_CODE,                      -- Notif. code [NOTIF_CODE]
    DUMMY_UTILSDVCEHDR_INCL_EEW_PS,  -- Dummy [E_UTILSDVCEHDR_INCL_EEW]
    CERT_DATE,                       -- Certification date [/SAPCE/IURU_CERT_DATE]
    NXT_REPL_DATE,                   -- Next repl. date [/SAPCE/IURU_NXTREPL_DATE]
    PER_REPL_DATE,                   -- Per replacement date [/SAPCE/IURU_PER_REPL_DATE]
    PRIMARY KEY (MANDT, EQUNR)
);

Learn More