SAP ABAP Table ETYP (Dev. Cat.: IS-U Additional Material Data)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-DM (Application Component) Device Management
     ⤷ EE10 (Package) IS-U: Device Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ETYP	Table Relationship Diagram
Short Description	Dev. Cat.: IS-U Additional Material Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	KOMBINAT	☐	KOMBINAT	KOMBINAT	CHAR	8	0	Combination of a device category
4	FUNKLAS	☐	FUNKLAS	FUNKLAS	CHAR	8	0	Function class	TE055
5	BAUKLAS	☐	BAUKLAS	BAUKLAS	CHAR	8	0	Construction class	TE237
6	BAUFORM	☐	BAUFORM	TEXT30	CHAR	30	0	Device category description
7	BAUTXT	☐	BAUTXT	TEXT30	CHAR	30	0	Text for description
8	PREISKLA	☐	PREISKLA	PREISKLA	CHAR	10	0	Price Class	TE431
9	PTBNUM	☐	PTBNUM	REGNUMMER	CHAR	15	0	PTI number
10	DVGWNUM	☐	DVGWNUM	REGNUMMER	CHAR	15	0	GGWA number
11	BGLKZ	☐	BGLKZ	BGLKZ	CHAR	1	0	Type of certification requirement
12	VLZEITT	☐	VLZEIT	ALLGVLZEIT	DEC	2	0	Calibration validity (yrs) for ext. devs subject to certif.
13	VLZEITTI	☐	VLZEITI	ALLGVLZEIT	DEC	2	0	Internal certification period (years)
14	VLZEITN	☐	VLZEITN	ALLGVLZEIT	DEC	2	0	Old cal. validity/int. cert. period (yrs) until prod. year
15	VLKZBAU	☐	BISBAUJR	JAHR	NUMC	4	0	Prod. yr until which old calib. valid./int.insp.per.is valid
16	ZWGRUPPE	☐	E_ZWGRUPPE	GEGST	CHAR	8	0	Register Group	EZWG
17	EAGRUPPE	☐	EAGRUPPE	GEGST	CHAR	8	0	Input/output group	EEAG
18	MESSART	☐	MESSART	MESSART	CHAR	1	0	Type of measurement
19	UEBERVER	☐	UEBERVER	UEBERV	DEC	10	3	Transformation ratio
20	BGLNETZ	☐	BGLNETZ	KENNZX	CHAR	1	0	Certify installed devices
21	WGRUPPE	☐	WGRUPPE	GEGST	CHAR	8	0	Winding group	EWIK
22	.INCLUDE	☐				0	0	Contains Fields for Entry of Default Winding Nos
23	PRIMWNR1	☐	PRIMWNR	LFDNR2	NUMC	2	0	Winding number of active primary winding
24	SEKWNR1	☐	SEKWNR	LFDNR2	NUMC	2	0	Winding number of active secondary winding
25	PRIMWNR2	☐	PRIMWNR	LFDNR2	NUMC	2	0	Winding number of active primary winding
26	SEKWNR2	☐	SEKWNR	LFDNR2	NUMC	2	0	Winding number of active secondary winding
27	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
28	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
29	.INCLUDE	☐				0	0	Factors in Register
30	ZSPANNS	☐	E_ZSPANNS	SPANNUNG	DEC	4	1	Register factor: secondary transformer voltage
31	ZSTROMS	☐	E_ZSTROMS	E_ZSTROMS	DEC	5	2	Register factor: secondary transformer current
32	ZSPANNP	☐	E_ZSPANNP	WSPANNP	DEC	6	0	Register factor: primary transformer voltage
33	ZSTROMP	☐	E_ZSTROMP	E_ZSTROMP	DEC	5	1	Register factor: primary transformer current
34	GRPMATNR	☐	GRPMATNR	MATNR	CHAR	18	0	Number for group material for IS-U serialization	MARA
35	ORDER_CODE	☐	ORDERCODE2	CHAR004	CHAR	4	0	Special Order Code for Dev./Dev. Category in Replacement	TEWOCODES
36	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
37	NENNBEL	☐	NENNBEL	NENNBEL	DEC	10	4	Nominal load
38	.INCLUDE	☐				0	0	IS-U WA: Vehicle and Container Categories
39	KENNZTYP	☐	KENNZ_TYP	KENNZ_TYP	CHAR	2	0	Vehicle category
40	KENNZTYP_TXT	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
41	STELLPLATZ	☐	ANZ_PLATZ	ANZ_PLATZ	NUMC	2	0	Number of container spaces
42	HOEHEBEH	☐	HOEHEBEH	DEC5_2	DEC	7	2	Height of container category
43	BREITEBEH	☐	BREITEBEH	DEC5_2	DEC	7	2	Width of container category
44	TIEFEBEH	☐	TIEFEBEH	DEC5_2	DEC	7	2	Depth of container category
45	ABMEIH	☐	ABMEIH	MEINS	UNIT	3	0	Unit for the dimensions of the container category	T006
46	LADEZEIT	☐	LADEZEIT	DEC5_2	DEC	7	2	Pull-up time of container category
47	LADZ_EIH	☐	LADZ_EIH	MEINS	UNIT	3	0	Unit of pull-up time	T006
48	LADEVOL	☐	LADEVOL	DEC5_2	DEC	7	2	Load volume
49	LADV_EIH	☐	LADV_EIH	MEINS	UNIT	3	0	Unit of load volume	T006
50	GEW_ZUL	☐	GEW_ZUL	DEC5_2	DEC	7	2	Maximum permissible load for container category
51	GEWEIH	☐	GEWEIH	MEINS	UNIT	3	0	Unit of weight	T006
52	EIGENTUM	☐	EIGENTUM	EIGENTUM	CHAR	2	0	Owner
53	EIGENTUM_TXT	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
54	LADV_TXT	☐	DIMTEXT	CHAR60	CHAR	60	0	Dimension Text
55	LADZ_TXT	☐	DIMTEXT	CHAR60	CHAR	60	0	Dimension Text
56	GEW_TXT	☐	DIMTEXT	CHAR60	CHAR	60	0	Dimension Text
57	ABM_TXT	☐	DIMTEXT	CHAR60	CHAR	60	0	Dimension Text
58	PRODUCT_AREA	☐	PRODUCT_AREA	PRODUCT_ID	CHAR	2	0	Service Area	TPRDCTAREA
59	NOTIF_CODE	☐	NOTIF_CODE	CHAR004	CHAR	4	0	Notification code	TENOCODES
60	G_INFOSATZ	☐	G_INFOSATZ	G_INFOSATZ	CHAR	1	0	Type of Device to be Created
61	PPM_METER	☐	PPM_METER	PPM_METER	NUMC	2	0	Prepayment Meter	TEPPM

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ETYP	ABMEIH	T006	MSEHI
2	ETYP	BAUKLAS	TE237	BAUKLAS	KEY	1	CN
3	ETYP	EAGRUPPE	EEAG	EAGRUPPE	KEY	1	CN
4	ETYP	FUNKLAS	TE055	FUNKLAS
5	ETYP	GEWEIH	T006	MSEHI
6	ETYP	GRPMATNR	MARA	MATNR	KEY	1	CN
7	ETYP	LADV_EIH	T006	MSEHI
8	ETYP	LADZ_EIH	T006	MSEHI
9	ETYP	MANDT	T000	MANDT
10	ETYP	MATNR	MARA	MATNR	KEY	1	1
11	ETYP	NOTIF_CODE	TENOCODES	NOTIF_CODE	KEY	C	CN
12	ETYP	ORDER_CODE	TEWOCODES	ORDER_CODE		1	CN
13	ETYP	PPM_METER	TEPPM	PPM_METER
14	ETYP	PREISKLA	TE431	PREISKLA	KEY	1	CN
15	ETYP	PRODUCT_AREA	TPRDCTAREA	PRODUCT_AREA
16	ETYP	SPARTE	TSPA	SPART	KEY	1	CN
17	ETYP	WGRUPPE	EWIK	WGRUPPE	KEY	1	CN
18	ETYP	ZWGRUPPE	EZWG	ZWGRUPPE	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in