SAP table ETYP (Device Category: IS-U Additional Data for the Material)

SAP table ETYP has 2 primary key fields being MANDT,MATNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
KOMBINAT Combination of a device category CHAR 8 0 KOMBINAT
FUNKLAS Function class CHAR 8 0 TE055 FUNKLAS
BAUKLAS Construction class CHAR 8 0 TE237 BAUKLAS
BAUFORM Device category description CHAR 30 0 BAUFORM
BAUTXT Text for description CHAR 30 0 BAUTXT
PREISKLA Price Class CHAR 10 0 TE431 PREISKLA
PTBNUM PTI number CHAR 15 0 PTBNUM
DVGWNUM GGWA number CHAR 15 0 DVGWNUM
BGLKZ Type of certification requirement CHAR 1 0 BGLKZ
0 Not subject to certification
1 Subject to external certification (legal regulations)
2 Subject to internal certification (utility co. regulations)
VLZEITT Calibration validity (yrs) for ext. devs subject to certif. DEC 2 0 VLZEIT
VLZEITTI Internal certification period (years) DEC 2 0 VLZEITI
VLZEITN Old cal. validity/int. cert. period (yrs) until prod. year DEC 2 0 VLZEITN
VLKZBAU Prod. yr until which old calib. valid./int.insp.per.is valid NUMC 4 0 BISBAUJR
ZWGRUPPE Register Group CHAR 8 0 EZWG E_ZWGRUPPE
EAGRUPPE Input/output group CHAR 8 0 EEAG EAGRUPPE
MESSART Type of measurement CHAR 1 0 MESSART
0 Direct measurement
1 Semi-indirect measurement
2 Indirect measurement
3 Indirect/semi-indirect measurement
UEBERVER Transformation ratio DEC 10 3 UEBERVER
BGLNETZ Certify installed devices CHAR 1 0 BGLNETZ
WGRUPPE Winding group CHAR 8 0 EWIK WGRUPPE
PRIMWNR1 Winding number of active primary winding NUMC 2 0 PRIMWNR
SEKWNR1 Winding number of active secondary winding NUMC 2 0 SEKWNR
PRIMWNR2 Winding number of active primary winding NUMC 2 0 PRIMWNR
SEKWNR2 Winding number of active secondary winding NUMC 2 0 SEKWNR
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
ZSPANNS Register factor: secondary transformer voltage DEC 4 1 E_ZSPANNS
ZSTROMS Register factor: secondary transformer current DEC 5 2 E_ZSTROMS
ZSPANNP Register factor: primary transformer voltage DEC 6 0 E_ZSPANNP
ZSTROMP Register factor: primary transformer current DEC 5 1 E_ZSTROMP
GRPMATNR Number for group material for IS-U serialization CHAR 40 0 MARA GRPMATNR
ORDER_CODE Special Order Code for Dev./Dev. Category in Replacement CHAR 4 0 TEWOCODES ORDERCODE2
SPARTE Division CHAR 2 0 TSPA SPARTE
NENNBEL Nominal load DEC 10 4 NENNBEL
KENNZTYP Vehicle category CHAR 2 0 KENNZ_TYP
01 Roll-off
02 Waste truck
KENNZTYP_TXT Short Description of Repository Objects CHAR 60 0 AS4TEXT
STELLPLATZ Number of container spaces NUMC 2 0 ANZ_PLATZ
HOEHEBEH Height of container category DEC 7 2 HOEHEBEH
BREITEBEH Width of container category DEC 7 2 BREITEBEH
TIEFEBEH Depth of container category DEC 7 2 TIEFEBEH
ABMEIH Unit for the dimensions of the container category UNIT 3 0 T006 ABMEIH
LADEZEIT Pull-up time of container category DEC 7 2 LADEZEIT
LADZ_EIH Unit of pull-up time UNIT 3 0 T006 LADZ_EIH
LADEVOL Load volume DEC 7 2 LADEVOL
LADV_EIH Unit of load volume UNIT 3 0 T006 LADV_EIH
GEW_ZUL Maximum permissible load for container category DEC 7 2 GEW_ZUL
GEWEIH Unit of Weight UNIT 3 0 T006 GEWEIH
EIGENTUM Owner CHAR 2 0 EIGENTUM
01 Property of customer
02 Property of waste disposal company
EIGENTUM_TXT Short Description of Repository Objects CHAR 60 0 AS4TEXT
LADV_TXT Dimension Text CHAR 60 0 DIMTEXT
LADZ_TXT Dimension Text CHAR 60 0 DIMTEXT
GEW_TXT Dimension Text CHAR 60 0 DIMTEXT
ABM_TXT Dimension Text CHAR 60 0 DIMTEXT
PRODUCT_AREA Service Area CHAR 2 0 TPRDCTAREA PRODUCT_AREA
GEW_LEER Unladen Weight of the Container Type DEC 7 2 EWADGEW_LEER
GEWLEER_EIH Unit of Measurement of the Unladen Weight UNIT 3 0 T006 EWADGEWLEER_EIH
GEWLEER_TXT Dimension Text CHAR 60 0 DIMTEXT
NOTIF_CODE Notification code CHAR 4 0 TENOCODES NOTIF_CODE
G_INFOSATZ Type of Device to be Created CHAR 1 0 G_INFOSATZ
Devices and Device Info Records Permitted
1 Only Devices Permitted
2 Only Device Info Records Permitted
3 Only Device Info Records Permitted; Multiple Ser. No. Poss.
PPM_METER Prepayment Meter NUMC 2 0 TEPPM PPM_METER
LOSSDTGROUP Loss Determination Group CHAR 8 0 TE1001 E_LOSSDTGROUP
RATING Power Transformer: Rating CHAR 11 0 TE1002 E_RATING
P_VOLTAGE Power Transformer: Primary Voltage CHAR 8 0 TE1002 E_P_VOLTAGE
S_VOLTAGE Power Transformer: Secondary Voltage CHAR 8 0 TE1002 E_S_VOLTAGE
AMS_DGRP AMS Determination Group CHAR 10 0 TEAMI_AMSDGRP E_AMI_AMS_DGRP
AMCG_DGRP AMCG Determination Group CHAR 10 0 TEAMI_AMCGDGRP E_AMI_AMCG_DGRP
SMART_METER Advanced Meter CHAR 1 0 E_AMI_SMART_METER
Not Defined
1 No Advanced Meter
2 Advanced Meter
MSG_DGRP_ID Message Attribute Determination Group NUMC 4 0 TEAMI_MSG_DGRP E_AMI_MSG_DGRP_ID

ETYP foreign key relationships

Table Field Check Table Check Field
0 ETYP ABMEIH T006 Units of Measurement MANDT
1 ETYP AMCG_DGRP TEAMI_AMCGDGRP Determination Group of Advanced Meter Capability Group MANDT
1 ETYP AMCG_DGRP TEAMI_AMCGDGRP Determination Group of Advanced Meter Capability Group AMCG_DGRP
0 ETYP AMS_DGRP TEAMI_AMSDGRP Advanced Metering System Determination Group MANDT
0 ETYP AMS_DGRP TEAMI_AMSDGRP Advanced Metering System Determination Group AMS_DGRP
1 ETYP BAUKLAS TE237 Constr.Cls MANDT
0 ETYP EAGRUPPE EEAG Input/Output Group MANDT
1 ETYP FUNKLAS TE055 Function Classes MANDT
0 ETYP GEWEIH T006 Units of Measurement MANDT
1 ETYP GEWLEER_EIH T006 Units of Measurement MANDT
0 ETYP GRPMATNR MARA General Material Data MANDT
0 ETYP GRPMATNR MARA General Material Data MATNR
1 ETYP LADV_EIH T006 Units of Measurement MANDT
0 ETYP LADZ_EIH T006 Units of Measurement MANDT
1 ETYP LOSSDTGROUP TE1001 Power Transformer: Loss Determination Group MANDT
0 ETYP MANDT T000 Clients MANDT
1 ETYP MATNR MARA General Material Data MANDT
1 ETYP MATNR MARA General Material Data MATNR
0 ETYP MSG_DGRP_ID TEAMI_MSG_DGRP Message Attribute Determination Group MANDT
1 ETYP NOTIF_CODE TENOCODES Notification Codes MANDT
1 ETYP NOTIF_CODE TENOCODES Notification Codes NOTIF_CODE
0 ETYP ORDER_CODE TEWOCODES Order Codes MANDT
0 ETYP ORDER_CODE TEWOCODES Order Codes ORDER_CODE
1 ETYP PPM_METER TEPPM Prepayment Meter MANDT
0 ETYP PREISKLA TE431 Price Classes MANDT
0 ETYP PREISKLA TE431 Price Classes PREISKLA
1 ETYP PRODUCT_AREA TPRDCTAREA Service Area for IS-U Waste Management MANDT
1 ETYP PRODUCT_AREA TPRDCTAREA Service Area for IS-U Waste Management PRODUCT_AREA
0 ETYP P_VOLTAGE TE1002 Combination of Rating, Primary, and Secondary Voltage MANDT
0 ETYP P_VOLTAGE TE1002 Combination of Rating, Primary, and Secondary Voltage RATING
1 ETYP RATING TE1002 Combination of Rating, Primary, and Secondary Voltage MANDT
1 ETYP RATING TE1002 Combination of Rating, Primary, and Secondary Voltage RATING
0 ETYP SPARTE TSPA Organizational Unit: Sales Divisions MANDT
0 ETYP SPARTE TSPA Organizational Unit: Sales Divisions SPART
1 ETYP S_VOLTAGE TE1002 Combination of Rating, Primary, and Secondary Voltage MANDT
1 ETYP S_VOLTAGE TE1002 Combination of Rating, Primary, and Secondary Voltage RATING
0 ETYP WGRUPPE EWIK Winding Group WNUMMER
1 ETYP ZWGRUPPE EZWG Register Group ZWGRUPPE
1 ETYP ZWGRUPPE EZWG Register Group ZWNUMMER