EGTUR

Transparent Table Application Table
14 Fields 2 CDS Views

Turnuswechselliste

EGTUR is an SAP database table in S/4HANA. Turnuswechselliste. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_UtilsPeriodicRplcmtList view from EXTENSION Periodic Replacement List Extension
I_UtilsPeriodicRplcmtList view from BASIC Periodic Replacement List

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY equnr equnr Equipment
turnusj turnusj Per. repl. year
auftrag aufnr Order
meldung qmnum Notification
ausbdat ausbdat Removal date
ableinheit ableinheit MR Unit
country land1 Country/Reg.
city_code city_code City Number
streetcode ad_strnum Street Code
housenum housenum House Number
matnr matnr Material
sparte sparte Division
regiogroup regiogroup Structure Group

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.

-- Turnuswechselliste
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EGTUR (
    MANDT,       -- Client [mandt]
    EQUNR,       -- Equipment [equnr]
    TURNUSJ,     -- Per. repl. year [turnusj]
    AUFTRAG,     -- Order [aufnr]
    MELDUNG,     -- Notification [qmnum]
    AUSBDAT,     -- Removal date [ausbdat]
    ABLEINHEIT,  -- MR Unit [ableinheit]
    COUNTRY,     -- Country/Reg. [land1]
    CITY_CODE,   -- City Number [city_code]
    STREETCODE,  -- Street Code [ad_strnum]
    HOUSENUM,    -- House Number [housenum]
    MATNR,       -- Material [matnr]
    SPARTE,      -- Division [sparte]
    REGIOGROUP,  -- Structure Group [regiogroup]
    PRIMARY KEY (MANDT, EQUNR)
);

Learn More