SAP Table ETYP
Dev. Cat.: IS-U Additional Material Data
ETYP (Dev. Cat.: IS-U Additional Material Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ETYP to other SAP tables.
ETYP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||
| KOMBINAT | Combination of a device category | KOMBINAT | CHAR | 8 | 0 | |||||||||||
| FUNKLAS | Function class | FUNKLAS | TE055 | CHAR | 8 | 0 | ||||||||||
| BAUKLAS | Construction class | BAUKLAS | TE237 | CHAR | 8 | 0 | ||||||||||
| BAUFORM | Device category description | BAUFORM | CHAR | 30 | 0 | |||||||||||
| BAUTXT | Text for description | BAUTXT | CHAR | 30 | 0 | |||||||||||
| PREISKLA | Price Class | PREISKLA | TE431 | CHAR | 10 | 0 | ||||||||||
| PTBNUM | PTI number | PTBNUM | CHAR | 15 | 0 | |||||||||||
| DVGWNUM | GGWA number | DVGWNUM | CHAR | 15 | 0 | |||||||||||
| BGLKZ | Type of certification requirement | BGLKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| VLZEITT | Calibration validity (yrs) for ext. devs subject to certif. | VLZEIT | DEC | 2 | 0 | |||||||||||
| VLZEITTI | Internal certification period (years) | VLZEITI | DEC | 2 | 0 | |||||||||||
| VLZEITN | Old cal. validity/int. cert. period (yrs) until prod. year | VLZEITN | DEC | 2 | 0 | |||||||||||
| VLKZBAU | Prod. yr until which old calib. valid./int.insp.per.is valid | BISBAUJR | NUMC | 4 | 0 | |||||||||||
| ZWGRUPPE | Register Group | E_ZWGRUPPE | EZWG | CHAR | 8 | 0 | ||||||||||
| EAGRUPPE | Input/output group | EAGRUPPE | EEAG | CHAR | 8 | 0 | ||||||||||
| MESSART | Type of measurement | MESSART | CHAR | 1 | 0 |
Possible values
|
||||||||||
| UEBERVER | Transformation ratio | UEBERVER | DEC | 10 | 3 | |||||||||||
| BGLNETZ | Certify installed devices | BGLNETZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| WGRUPPE | Winding group | WGRUPPE | EWIK | CHAR | 8 | 0 | ||||||||||
| PRIMWNR1 | Winding number of active primary winding | PRIMWNR | NUMC | 2 | 0 | |||||||||||
| SEKWNR1 | Winding number of active secondary winding | SEKWNR | NUMC | 2 | 0 | |||||||||||
| PRIMWNR2 | Winding number of active primary winding | PRIMWNR | NUMC | 2 | 0 | |||||||||||
| SEKWNR2 | Winding number of active secondary winding | SEKWNR | NUMC | 2 | 0 | |||||||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||||
| AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||||||||||
| ZSPANNS | Register factor: secondary transformer voltage | E_ZSPANNS | DEC | 4 | 1 | |||||||||||
| ZSTROMS | Register factor: secondary transformer current | E_ZSTROMS | DEC | 5 | 2 | |||||||||||
| ZSPANNP | Register factor: primary transformer voltage | E_ZSPANNP | DEC | 6 | 0 | |||||||||||
| ZSTROMP | Register factor: primary transformer current | E_ZSTROMP | DEC | 5 | 1 | |||||||||||
| GRPMATNR | Number for group material for IS-U serialization | GRPMATNR | MARA | CHAR | 18 | 0 | ||||||||||
| ORDER_CODE | Special Order Code for Dev./Dev. Category in Replacement | ORDERCODE2 | TEWOCODES | CHAR | 4 | 0 | ||||||||||
| SPARTE | Division | SPARTE | TSPA | CHAR | 2 | 0 | ||||||||||
| NENNBEL | Nominal load | NENNBEL | DEC | 10 | 4 | |||||||||||
| KENNZTYP | Vehicle category | KENNZ_TYP | CHAR | 2 | 0 |
Possible values
|
||||||||||
| KENNZTYP_TXT | Short Description of Repository Objects | AS4TEXT | CHAR | 60 | 0 | |||||||||||
| STELLPLATZ | Number of container spaces | ANZ_PLATZ | NUMC | 2 | 0 | |||||||||||
| HOEHEBEH | Height of container category | HOEHEBEH | DEC | 7 | 2 | |||||||||||
| BREITEBEH | Width of container category | BREITEBEH | DEC | 7 | 2 | |||||||||||
| TIEFEBEH | Depth of container category | TIEFEBEH | DEC | 7 | 2 | |||||||||||
| ABMEIH | Unit for the dimensions of the container category | ABMEIH | T006 | UNIT | 3 | 0 | ||||||||||
| LADEZEIT | Pull-up time of container category | LADEZEIT | DEC | 7 | 2 | |||||||||||
| LADZ_EIH | Unit of pull-up time | LADZ_EIH | T006 | UNIT | 3 | 0 | ||||||||||
| LADEVOL | Load volume | LADEVOL | DEC | 7 | 2 | |||||||||||
| LADV_EIH | Unit of load volume | LADV_EIH | T006 | UNIT | 3 | 0 | ||||||||||
| GEW_ZUL | Maximum permissible load for container category | GEW_ZUL | DEC | 7 | 2 | |||||||||||
| GEWEIH | Unit of Weight | GEWEIH | T006 | UNIT | 3 | 0 | ||||||||||
| EIGENTUM | Owner | EIGENTUM | CHAR | 2 | 0 |
Possible values
|
||||||||||
| EIGENTUM_TXT | Short Description of Repository Objects | AS4TEXT | CHAR | 60 | 0 | |||||||||||
| LADV_TXT | Dimension Text | DIMTEXT | CHAR | 60 | 0 | |||||||||||
| LADZ_TXT | Dimension Text | DIMTEXT | CHAR | 60 | 0 | |||||||||||
| GEW_TXT | Dimension Text | DIMTEXT | CHAR | 60 | 0 | |||||||||||
| ABM_TXT | Dimension Text | DIMTEXT | CHAR | 60 | 0 | |||||||||||
| PRODUCT_AREA | Service Area | PRODUCT_AREA | TPRDCTAREA | CHAR | 2 | 0 | ||||||||||
| NOTIF_CODE | Notification code | NOTIF_CODE | TENOCODES | CHAR | 4 | 0 | ||||||||||
| G_INFOSATZ | Type of Device to be Created | G_INFOSATZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PPM_METER | Prepayment Meter | PPM_METER | TEPPM | NUMC | 2 | 0 | ||||||||||
| LOSSDTGROUP | Loss Determination Group | E_LOSSDTGROUP | TE1001 | CHAR | 8 | 0 | ||||||||||
| RATING | Power Transformer: Rating | E_RATING | TE1002 | CHAR | 11 | 0 | ||||||||||
| P_VOLTAGE | Power Transformer: Primary Voltage | E_P_VOLTAGE | TE1002 | CHAR | 8 | 0 | ||||||||||
| S_VOLTAGE | Power Transformer: Secondary Voltage | E_S_VOLTAGE | TE1002 | CHAR | 8 | 0 | ||||||||||
| AMS_DGRP | AMS Determination Group | E_AMI_AMS_DGRP | TEAMI_AMSDGRP | CHAR | 10 | 0 | ||||||||||
| AMCG_DGRP | AMCG Determination Group | E_AMI_AMCG_DGRP | TEAMI_AMCGDGRP | CHAR | 10 | 0 | ||||||||||
| SMART_METER | Advanced Meter | E_AMI_SMART_METER | CHAR | 1 | 0 |
Possible values
|
||||||||||
| MSG_DGRP_ID | Message Attribute Determination Group | E_AMI_MSG_DGRP_ID | TEAMI_MSG_DGRP | NUMC | 4 | 0 | ||||||||||
ETYP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ETYP | ABMEIH | SYST | MANDT | T006 | Units of Measurement | MANDT |
| ETYP | ABMEIH | ETYP | ABMEIH | T006 | Units of Measurement | MSEHI |
| ETYP | AMCG_DGRP | ETYP | MANDT | TEAMI_AMCGDGRP | Determination Group of Advanced Meter Capability Group | MANDT |
| ETYP | AMCG_DGRP | ETYP | AMCG_DGRP | TEAMI_AMCGDGRP | Determination Group of Advanced Meter Capability Group | AMCG_DGRP |
| ETYP | AMS_DGRP | ETYP | MANDT | TEAMI_AMSDGRP | Advanced Metering System Determination Group | MANDT |
| ETYP | AMS_DGRP | ETYP | AMS_DGRP | TEAMI_AMSDGRP | Advanced Metering System Determination Group | AMS_DGRP |
| ETYP | BAUKLAS | ETYP | BAUKLAS | TE237 | Constr.Cls | BAUKLAS |
| ETYP | BAUKLAS | ETYP | MANDT | TE237 | Constr.Cls | MANDT |
| ETYP | EAGRUPPE | * | EEAG | Input/Output Group | EANUMMER | |
| ETYP | EAGRUPPE | ETYP | MANDT | EEAG | Input/Output Group | MANDT |
| ETYP | EAGRUPPE | ETYP | EAGRUPPE | EEAG | Input/Output Group | EAGRUPPE |
| ETYP | FUNKLAS | ETYP | FUNKLAS | TE055 | Function Classes | FUNKLAS |
| ETYP | FUNKLAS | ETYP | MANDT | TE055 | Function Classes | MANDT |
| ETYP | GEWEIH | SYST | MANDT | T006 | Units of Measurement | MANDT |
| ETYP | GEWEIH | ETYP | GEWEIH | T006 | Units of Measurement | MSEHI |
| ETYP | GRPMATNR | ETYP | MANDT | MARA | General Material Data | MANDT |
| ETYP | GRPMATNR | ETYP | GRPMATNR | MARA | General Material Data | MATNR |
| ETYP | LADV_EIH | SYST | MANDT | T006 | Units of Measurement | MANDT |
| ETYP | LADV_EIH | ETYP | LADV_EIH | T006 | Units of Measurement | MSEHI |
| ETYP | LADZ_EIH | SYST | MANDT | T006 | Units of Measurement | MANDT |
| ETYP | LADZ_EIH | ETYP | LADZ_EIH | T006 | Units of Measurement | MSEHI |
| ETYP | LOSSDTGROUP | SYST | MANDT | TE1001 | Power Transformer: Loss Determination Group | MANDT |
| ETYP | LOSSDTGROUP | ETYP | LOSSDTGROUP | TE1001 | Power Transformer: Loss Determination Group | LOSSDTGROUP |
| ETYP | MANDT | ETYP | MANDT | T000 | Clients | MANDT |
| ETYP | MATNR | ETYP | MATNR | MARA | General Material Data | MATNR |
| ETYP | MATNR | ETYP | MANDT | MARA | General Material Data | MANDT |
| ETYP | MSG_DGRP_ID | ETYP | MANDT | TEAMI_MSG_DGRP | Message Attribute Determination Group | MANDT |
| ETYP | MSG_DGRP_ID | ETYP | MSG_DGRP_ID | TEAMI_MSG_DGRP | Message Attribute Determination Group | MSG_DGRP_ID |
| ETYP | NOTIF_CODE | ETYP | MANDT | TENOCODES | Notification Codes | MANDT |
| ETYP | NOTIF_CODE | ETYP | NOTIF_CODE | TENOCODES | Notification Codes | NOTIF_CODE |
| ETYP | ORDER_CODE | ETYP | MANDT | TEWOCODES | Order Codes | MANDT |
| ETYP | ORDER_CODE | ETYP | ORDER_CODE | TEWOCODES | Order Codes | ORDER_CODE |
| ETYP | PPM_METER | ETYP | MANDT | TEPPM | Prepayment Meter | MANDT |
| ETYP | PPM_METER | ETYP | PPM_METER | TEPPM | Prepayment Meter | PPM_METER |
| ETYP | PREISKLA | ETYP | MANDT | TE431 | Price Classes | MANDT |
| ETYP | PREISKLA | ETYP | PREISKLA | TE431 | Price Classes | PREISKLA |
| ETYP | PRODUCT_AREA | ETYP | PRODUCT_AREA | TPRDCTAREA | Service Area for IS-U Waste Management | PRODUCT_AREA |
| ETYP | PRODUCT_AREA | SYST | MANDT | TPRDCTAREA | Service Area for IS-U Waste Management | MANDT |
| ETYP | P_VOLTAGE | ETYP | P_VOLTAGE | TE1002 | Combination of Rating, Primary, and Secondary Voltage | P_VOLTAGE |
| ETYP | P_VOLTAGE | ETYP | S_VOLTAGE | TE1002 | Combination of Rating, Primary, and Secondary Voltage | S_VOLTAGE |
| ETYP | P_VOLTAGE | SYST | MANDT | TE1002 | Combination of Rating, Primary, and Secondary Voltage | MANDT |
| ETYP | P_VOLTAGE | ETYP | RATING | TE1002 | Combination of Rating, Primary, and Secondary Voltage | RATING |
| ETYP | RATING | SYST | MANDT | TE1002 | Combination of Rating, Primary, and Secondary Voltage | MANDT |
| ETYP | RATING | ETYP | RATING | TE1002 | Combination of Rating, Primary, and Secondary Voltage | RATING |
| ETYP | RATING | ETYP | P_VOLTAGE | TE1002 | Combination of Rating, Primary, and Secondary Voltage | P_VOLTAGE |
| ETYP | RATING | ETYP | S_VOLTAGE | TE1002 | Combination of Rating, Primary, and Secondary Voltage | S_VOLTAGE |
| ETYP | SPARTE | ETYP | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| ETYP | SPARTE | ETYP | SPARTE | TSPA | Organizational Unit: Sales Divisions | SPART |
| ETYP | S_VOLTAGE | SYST | MANDT | TE1002 | Combination of Rating, Primary, and Secondary Voltage | MANDT |
| ETYP | S_VOLTAGE | ETYP | RATING | TE1002 | Combination of Rating, Primary, and Secondary Voltage | RATING |
| ETYP | S_VOLTAGE | ETYP | P_VOLTAGE | TE1002 | Combination of Rating, Primary, and Secondary Voltage | P_VOLTAGE |
| ETYP | S_VOLTAGE | ETYP | S_VOLTAGE | TE1002 | Combination of Rating, Primary, and Secondary Voltage | S_VOLTAGE |
| ETYP | WGRUPPE | ETYP | MANDT | EWIK | Winding Group | MANDT |
| ETYP | WGRUPPE | ETYP | WGRUPPE | EWIK | Winding Group | WGRUPPE |
| ETYP | WGRUPPE | * | EWIK | Winding Group | WNUMMER | |
| ETYP | ZWGRUPPE | ETYP | ZWGRUPPE | EZWG | Register Group | ZWGRUPPE |
| ETYP | ZWGRUPPE | * | EZWG | Register Group | ZWNUMMER | |
| ETYP | ZWGRUPPE | ETYP | MANDT | EZWG | Register Group | MANDT |
