SAP ABAP View V_ETYP (View Material Master Rec and Device Cat.)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_ETYP
Short Description	View Material Master Rec and Device Cat.
Root table	ETYP	Dev. Cat.: IS-U Additional Material Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ETYP	ETYP
2	MARA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ				0	0
2	ETYP	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	ETYP	MATNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	ETYP	*		☐		☐
2	MANDT	ETYP	MANDT		☐	MANDT	☐	Client
3	MATNR	ETYP	MATNR		☐	MATNR	☐	Material Number
4	KOMBINAT	ETYP	KOMBINAT		☐	KOMBINAT	☐	Combination of a device category
5	FUNKLAS	ETYP	FUNKLAS		☐	FUNKLAS	☐	Function class
6	BAUKLAS	ETYP	BAUKLAS		☐	BAUKLAS	☐	Construction class
7	BAUFORM	ETYP	BAUFORM		☐	BAUFORM	☐	Device category description
8	BAUTXT	ETYP	BAUTXT		☐	BAUTXT	☐	Text for description
9	PREISKLA	ETYP	PREISKLA		☐	PREISKLA	☐	Price Class
10	PTBNUM	ETYP	PTBNUM		☐	PTBNUM	☐	PTI number
11	DVGWNUM	ETYP	DVGWNUM		☐	DVGWNUM	☐	GGWA number
12	BGLKZ	ETYP	BGLKZ		☐	BGLKZ	☐	Type of certification requirement
13	VLZEITT	ETYP	VLZEITT		☐	VLZEIT	☐	Calibration validity (yrs) for ext. devs subject to certif.
14	VLZEITTI	ETYP	VLZEITTI		☐	VLZEITI	☐	Internal certification period (years)
15	VLZEITN	ETYP	VLZEITN		☐	VLZEITN	☐	Old cal. validity/int. cert. period (yrs) until prod. year
16	VLKZBAU	ETYP	VLKZBAU		☐	BISBAUJR	☐	Prod. yr until which old calib. valid./int.insp.per.is valid
17	ZWGRUPPE	ETYP	ZWGRUPPE		☐	E_ZWGRUPPE	☐	Register Group
18	EAGRUPPE	ETYP	EAGRUPPE		☐	EAGRUPPE	☐	Input/output group
19	MESSART	ETYP	MESSART		☐	MESSART	☐	Type of measurement
20	UEBERVER	ETYP	UEBERVER		☐	UEBERVER	☐	Transformation ratio
21	BGLNETZ	ETYP	BGLNETZ		☐	BGLNETZ	☐	Certify installed devices
22	WGRUPPE	ETYP	WGRUPPE		☐	WGRUPPE	☐	Winding group
23	PRIMWNR1	ETYP	PRIMWNR1		☐	PRIMWNR	☐	Winding number of active primary winding
24	SEKWNR1	ETYP	SEKWNR1		☐	SEKWNR	☐	Winding number of active secondary winding
25	PRIMWNR2	ETYP	PRIMWNR2		☐	PRIMWNR	☐	Winding number of active primary winding
26	SEKWNR2	ETYP	SEKWNR2		☐	SEKWNR	☐	Winding number of active secondary winding
27	AENAM	ETYP	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
28	AEDAT	ETYP	AEDAT		☐	AEDAT	☐	Last Changed On
29	ZSPANNS	ETYP	ZSPANNS		☐	E_ZSPANNS	☐	Register factor: secondary transformer voltage
30	ZSTROMS	ETYP	ZSTROMS		☐	E_ZSTROMS	☐	Register factor: secondary transformer current
31	ZSPANNP	ETYP	ZSPANNP		☐	E_ZSPANNP	☐	Register factor: primary transformer voltage
32	ZSTROMP	ETYP	ZSTROMP		☐	E_ZSTROMP	☐	Register factor: primary transformer current
33	GRPMATNR	ETYP	GRPMATNR		☐	GRPMATNR	☐	Number for group material for IS-U serialization
34	ORDER_CODE	ETYP	ORDER_CODE		☐	ORDERCODE2	☐	Special Order Code for Dev./Dev. Category in Replacement
35	SPARTE	ETYP	SPARTE		☐	SPARTE	☐	Division
36	NENNBEL	ETYP	NENNBEL		☐	NENNBEL	☐	Nominal load
37	KENNZTYP	ETYP	KENNZTYP		☐	KENNZ_TYP	☐	Vehicle category
38	KENNZTYP_TXT	ETYP	KENNZTYP_TXT		☐	AS4TEXT	☐	Short Description of Repository Objects
39	STELLPLATZ	ETYP	STELLPLATZ		☐	ANZ_PLATZ	☐	Number of container spaces
40	HOEHEBEH	ETYP	HOEHEBEH		☐	HOEHEBEH	☐	Height of container category
41	BREITEBEH	ETYP	BREITEBEH		☐	BREITEBEH	☐	Width of container category
42	TIEFEBEH	ETYP	TIEFEBEH		☐	TIEFEBEH	☐	Depth of container category
43	ABMEIH	ETYP	ABMEIH		☐	ABMEIH	☐	Unit for the dimensions of the container category
44	LADEZEIT	ETYP	LADEZEIT		☐	LADEZEIT	☐	Pull-up time of container category
45	LADZ_EIH	ETYP	LADZ_EIH		☐	LADZ_EIH	☐	Unit of pull-up time
46	LADEVOL	ETYP	LADEVOL		☐	LADEVOL	☐	Load volume
47	LADV_EIH	ETYP	LADV_EIH		☐	LADV_EIH	☐	Unit of load volume
48	GEW_ZUL	ETYP	GEW_ZUL		☐	GEW_ZUL	☐	Maximum permissible load for container category
49	GEWEIH	ETYP	GEWEIH		☐	GEWEIH	☐	Unit of weight
50	EIGENTUM	ETYP	EIGENTUM		☐	EIGENTUM	☐	Owner
51	EIGENTUM_TXT	ETYP	EIGENTUM_TXT		☐	AS4TEXT	☐	Short Description of Repository Objects
52	LADV_TXT	ETYP	LADV_TXT		☐	DIMTEXT	☐	Dimension Text
53	LADZ_TXT	ETYP	LADZ_TXT		☐	DIMTEXT	☐	Dimension Text
54	GEW_TXT	ETYP	GEW_TXT		☐	DIMTEXT	☐	Dimension Text
55	ABM_TXT	ETYP	ABM_TXT		☐	DIMTEXT	☐	Dimension Text
56	PRODUCT_AREA	ETYP	PRODUCT_AREA		☐	PRODUCT_AREA	☐	Service Area
57	NOTIF_CODE	ETYP	NOTIF_CODE		☐	NOTIF_CODE	☐	Notification code
58	G_INFOSATZ	ETYP	G_INFOSATZ		☐	G_INFOSATZ	☐	Type of Device to be Created
59	PPM_METER	ETYP	PPM_METER		☐	PPM_METER	☐	Prepayment Meter

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in