ETYP

Transparent Table Application Table
69 Fields 2 CDS Views

Device Category: IS-U Additional Data for the Material

ETYP is an SAP database table in S/4HANA. Device Category: IS-U Additional Data for the Material. It contains 69 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
EWA_ALY_I_CRV view inner
I_UtilsDeviceCategory view from BASIC Device Category

Fields (69)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
kombinat KOMBINAT Dev. type comb.
funklas FUNKLAS Function class
bauklas BAUKLAS Construct.class
bauform BAUFORM DevCat. descr.
bautxt BAUTXT Descript. text
preiskla PREISKLA Price Class
ptbnum PTBNUM PTI number
dvgwnum DVGWNUM GGWA number
bglkz BGLKZ Certific. req.
vlzeitt VLZEIT Calib. validity
vlzeitti VLZEITI Int. cert. per.
vlzeitn VLZEITN Old cal./cert.
vlkzbau BISBAUJR To-product. yr
zwgruppe E_ZWGRUPPE Register Group
eagruppe EAGRUPPE I/O Group
messart MESSART Type of meas.
ueberver UEBERVER Transform.ratio
bglnetz BGLNETZ Cert. ins. devs
wgruppe WGRUPPE Winding group
primwnr1 PRIMWNR PrimaryWind.no.
sekwnr1 SEKWNR Secondary wind.
primwnr2 PRIMWNR PrimaryWind.no.
sekwnr2 SEKWNR Secondary wind.
aenam AENAM Changed By
aedat AEDAT Changed On
zspanns E_ZSPANNS Sec. voltage
zstroms E_ZSTROMS Secondary curr.
zspannp E_ZSPANNP Primary voltage
zstromp E_ZSTROMP Primary current
grpmatnr GRPMATNR Group mat. no.
order_code ORDERCODE2 Order Code
sparte SPARTE Division
nennbel NENNBEL Nominal load
kennztyp KENNZ_TYP Vehicle categ.
kennztyp_txt AS4TEXT Short Description
stellplatz ANZ_PLATZ Cont. spaces
hoehebeh HOEHEBEH Height
breitebeh BREITEBEH Width
tiefebeh TIEFEBEH Depth
abmeih ABMEIH Unit
ladezeit LADEZEIT Pull-up time
ladz_eih LADZ_EIH Unit
ladevol LADEVOL Load volume
ladv_eih LADV_EIH Unit
gew_zul GEW_ZUL Cargo
geweih GEWEIH Unit
eigentum EIGENTUM Owner
eigentum_txt AS4TEXT Short Description
ladv_txt DIMTEXT Dimension Text
ladz_txt DIMTEXT Dimension Text
gew_txt DIMTEXT Dimension Text
abm_txt DIMTEXT Dimension Text
product_area PRODUCT_AREA Service Area
gew_leer EWADGEW_LEER Unladen Weight
gewleer_eih EWADGEWLEER_EIH Unit of Measure
gewleer_txt DIMTEXT Dimension Text
notif_code NOTIF_CODE Notif. code
g_infosatz G_INFOSATZ Type of Device
ppm_meter PPM_METER PP Meter
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_dgrp E_AMI_AMS_DGRP AMS Det. Group
amcg_dgrp E_AMI_AMCG_DGRP AMCG Det. Group
smart_meter E_AMI_SMART_METER Advanced Meter
msg_dgrp_id E_AMI_MSG_DGRP_ID Msg.Att.Det.Grp

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 Category: IS-U Additional Data for the Material
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ETYP (
    MANDT,         -- Client [MANDT]
    MATNR,         -- Material [MATNR]
    KOMBINAT,      -- Dev. type comb. [KOMBINAT]
    FUNKLAS,       -- Function class [FUNKLAS]
    BAUKLAS,       -- Construct.class [BAUKLAS]
    BAUFORM,       -- DevCat. descr. [BAUFORM]
    BAUTXT,        -- Descript. text [BAUTXT]
    PREISKLA,      -- Price Class [PREISKLA]
    PTBNUM,        -- PTI number [PTBNUM]
    DVGWNUM,       -- GGWA number [DVGWNUM]
    BGLKZ,         -- Certific. req. [BGLKZ]
    VLZEITT,       -- Calib. validity [VLZEIT]
    VLZEITTI,      -- Int. cert. per. [VLZEITI]
    VLZEITN,       -- Old cal./cert. [VLZEITN]
    VLKZBAU,       -- To-product. yr [BISBAUJR]
    ZWGRUPPE,      -- Register Group [E_ZWGRUPPE]
    EAGRUPPE,      -- I/O Group [EAGRUPPE]
    MESSART,       -- Type of meas. [MESSART]
    UEBERVER,      -- Transform.ratio [UEBERVER]
    BGLNETZ,       -- Cert. ins. devs [BGLNETZ]
    WGRUPPE,       -- Winding group [WGRUPPE]
    PRIMWNR1,      -- PrimaryWind.no. [PRIMWNR]
    SEKWNR1,       -- Secondary wind. [SEKWNR]
    PRIMWNR2,      -- PrimaryWind.no. [PRIMWNR]
    SEKWNR2,       -- Secondary wind. [SEKWNR]
    AENAM,         -- Changed By [AENAM]
    AEDAT,         -- Changed On [AEDAT]
    ZSPANNS,       -- Sec. voltage [E_ZSPANNS]
    ZSTROMS,       -- Secondary curr. [E_ZSTROMS]
    ZSPANNP,       -- Primary voltage [E_ZSPANNP]
    ZSTROMP,       -- Primary current [E_ZSTROMP]
    GRPMATNR,      -- Group mat. no. [GRPMATNR]
    ORDER_CODE,    -- Order Code [ORDERCODE2]
    SPARTE,        -- Division [SPARTE]
    NENNBEL,       -- Nominal load [NENNBEL]
    KENNZTYP,      -- Vehicle categ. [KENNZ_TYP]
    KENNZTYP_TXT,  -- Short Description [AS4TEXT]
    STELLPLATZ,    -- Cont. spaces [ANZ_PLATZ]
    HOEHEBEH,      -- Height [HOEHEBEH]
    BREITEBEH,     -- Width [BREITEBEH]
    TIEFEBEH,      -- Depth [TIEFEBEH]
    ABMEIH,        -- Unit [ABMEIH]
    LADEZEIT,      -- Pull-up time [LADEZEIT]
    LADZ_EIH,      -- Unit [LADZ_EIH]
    LADEVOL,       -- Load volume [LADEVOL]
    LADV_EIH,      -- Unit [LADV_EIH]
    GEW_ZUL,       -- Cargo [GEW_ZUL]
    GEWEIH,        -- Unit [GEWEIH]
    EIGENTUM,      -- Owner [EIGENTUM]
    EIGENTUM_TXT,  -- Short Description [AS4TEXT]
    LADV_TXT,      -- Dimension Text [DIMTEXT]
    LADZ_TXT,      -- Dimension Text [DIMTEXT]
    GEW_TXT,       -- Dimension Text [DIMTEXT]
    ABM_TXT,       -- Dimension Text [DIMTEXT]
    PRODUCT_AREA,  -- Service Area [PRODUCT_AREA]
    GEW_LEER,      -- Unladen Weight [EWADGEW_LEER]
    GEWLEER_EIH,   -- Unit of Measure [EWADGEWLEER_EIH]
    GEWLEER_TXT,   -- Dimension Text [DIMTEXT]
    NOTIF_CODE,    -- Notif. code [NOTIF_CODE]
    G_INFOSATZ,    -- Type of Device [G_INFOSATZ]
    PPM_METER,     -- PP Meter [PPM_METER]
    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_DGRP,      -- AMS Det. Group [E_AMI_AMS_DGRP]
    AMCG_DGRP,     -- AMCG Det. Group [E_AMI_AMCG_DGRP]
    SMART_METER,   -- Advanced Meter [E_AMI_SMART_METER]
    MSG_DGRP_ID,   -- Msg.Att.Det.Grp [E_AMI_MSG_DGRP_ID]
    PRIMARY KEY (MANDT, MATNR)
);

Learn More