ETYP

Device Category: IS-U Additional Data for the Material | #masterdata | Component: Device Management
Column Name Description
MANDT FK Client
MATNR FK Material Number
Column Name Description
Column Name Description
Column Name Description
AEDAT Last Changed On
Column Name Description
BGLKZ Type of certification requirement Show values
MESSART Type of measurement Show values
BGLNETZ Certify installed devices Show values
KENNZTYP Vehicle category Show values
EIGENTUM Owner Show values
G_INFOSATZ Type of Device to be Created Show values
SMART_METER Advanced Meter Show values
Column Name Description Domain name
KOMBINAT Combination of a device category KOMBINAT
BAUFORM Device category description TEXT30
BAUTXT Text for description TEXT30
PTBNUM PTI number REGNUMMER
DVGWNUM GGWA number REGNUMMER
VLZEITT Calibration validity (yrs) for ext. devs subject to certif. ALLGVLZEIT
VLZEITTI Internal certification period (years) ALLGVLZEIT
VLZEITN Old cal. validity/int. cert. period (yrs) until prod. year ALLGVLZEIT
VLKZBAU Prod. yr until which old calib. valid./int.insp.per.is valid JAHR
UEBERVER Transformation ratio UEBERV
PRIMWNR1 Winding number of active primary winding LFDNR2
SEKWNR1 Winding number of active secondary winding LFDNR2
PRIMWNR2 Winding number of active primary winding LFDNR2
SEKWNR2 Winding number of active secondary winding LFDNR2
AENAM Name of Person Who Changed Object USNAM
ZSPANNS Register factor: secondary transformer voltage SPANNUNG
ZSTROMS Register factor: secondary transformer current E_ZSTROMS
ZSPANNP Register factor: primary transformer voltage WSPANNP
ZSTROMP Register factor: primary transformer current E_ZSTROMP
NENNBEL Nominal load NENNBEL
KENNZTYP_TXT Short Description of Repository Objects AS4TEXT
STELLPLATZ Number of container spaces ANZ_PLATZ
HOEHEBEH Height of container category DEC5_2
BREITEBEH Width of container category DEC5_2
TIEFEBEH Depth of container category DEC5_2
LADEZEIT Pull-up time of container category DEC5_2
LADEVOL Load volume DEC5_2
GEW_ZUL Maximum permissible load for container category DEC5_2
EIGENTUM_TXT Short Description of Repository Objects AS4TEXT
LADV_TXT Dimension Text CHAR60
LADZ_TXT Dimension Text CHAR60
GEW_TXT Dimension Text CHAR60
ABM_TXT Dimension Text CHAR60
GEW_LEER Unladen Weight of the Container Type DEC5_2
GEWLEER_TXT Dimension Text CHAR60
Master Data Relations Join Conditions
Unit for the dimensions of the container category
  • ETYP.MANDT == T006.MANDT
  • ETYP.ABMEIH == T006.MSEHI
AMCG Determination Group
AMS Determination Group
Construction class
  • Construction class
  • Client
  • ETYP.BAUKLAS == TE237.BAUKLAS
  • ETYP.MANDT == TE237.MANDT
Function class
  • ETYP.MANDT == TE055.MANDT
  • ETYP.FUNKLAS == TE055.FUNKLAS
Unit of Weight
  • ETYP.MANDT == T006.MANDT
  • ETYP.GEWEIH == T006.MSEHI
Unit of Measurement of the Unladen Weight
  • ETYP.MANDT == T006.MANDT
  • ETYP.GEWLEER_EIH == T006.MSEHI
Foreign key for group material number
  • Number for group material for IS-U serialization
  • Client
  • ETYP.GRPMATNR == MARA.MATNR
  • ETYP.MANDT == MARA.MANDT
Unit of load volume
  • ETYP.MANDT == T006.MANDT
  • ETYP.LADV_EIH == T006.MSEHI
Unit of pull-up time
  • ETYP.MANDT == T006.MANDT
  • ETYP.LADZ_EIH == T006.MSEHI
Loss Determination Group
  • ETYP.MANDT == TE1001.MANDT
  • ETYP.LOSSDTGROUP == TE1001.LOSSDTGROUP
Client ETYP.MANDT == T000.MANDT
Foreign key for material number
  • Material Number
  • Client
  • ETYP.MATNR == MARA.MATNR
  • ETYP.MANDT == MARA.MANDT
Message Attribute Determination Group
Notification code
Special Order Code for Dev./Dev. Category in Replacement
Prepayment Meter
  • ETYP.MANDT == TEPPM.MANDT
  • ETYP.PPM_METER == TEPPM.PPM_METER
Price Class
  • ETYP.MANDT == TE431.MANDT
  • ETYP.PREISKLA == TE431.PREISKLA
Service Area
Power Transformer: Primary Voltage
  • Power Transformer: Rating
  • Power Transformer: Secondary Voltage
  • Client
  • Power Transformer: Primary Voltage
  • ETYP.RATING == TE1002.RATING
  • ETYP.S_VOLTAGE == TE1002.S_VOLTAGE
  • ETYP.MANDT == TE1002.MANDT
  • ETYP.P_VOLTAGE == TE1002.P_VOLTAGE
Power Transformer: Rating
  • Power Transformer: Rating
  • Power Transformer: Secondary Voltage
  • Client
  • Power Transformer: Primary Voltage
  • ETYP.RATING == TE1002.RATING
  • ETYP.S_VOLTAGE == TE1002.S_VOLTAGE
  • ETYP.MANDT == TE1002.MANDT
  • ETYP.P_VOLTAGE == TE1002.P_VOLTAGE
Foreign Key Check for Division
  • ETYP.MANDT == TSPA.MANDT
  • ETYP.SPARTE == TSPA.SPART
Power Transformer: Secondary Voltage
  • Power Transformer: Rating
  • Power Transformer: Secondary Voltage
  • Client
  • Power Transformer: Primary Voltage
  • ETYP.RATING == TE1002.RATING
  • ETYP.S_VOLTAGE == TE1002.S_VOLTAGE
  • ETYP.MANDT == TE1002.MANDT
  • ETYP.P_VOLTAGE == TE1002.P_VOLTAGE
Winding group
  • Winding group
  • ?
  • Client
  • ETYP.WGRUPPE == EWIK.WGRUPPE
  • ETYP.[column in domain "WNUMMER"] == EWIK.WNUMMER
  • ETYP.MANDT == EWIK.MANDT