EGERS

Transparent Table Application Table
29 Fields 4 CDS Views

Gerätestammdaten im ISU

EGERS is an SAP database table in S/4HANA. Gerätestammdaten im ISU. It contains 29 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 (29)

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
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

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.

-- Gerätestammdaten im ISU
-- 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]
    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]
    PRIMARY KEY (MANDT, EQUNR)
);

Learn More