SAP ABAP Table BIW_ISU_DEVCAT (BW Extract View for IS-U Device Category)

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	INTTAB	Structure
Structure	BIW_ISU_DEVCAT	Table Relationship Diagram
Short Description	BW Extract View for IS-U Device Category

Delivery and Maintenance

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

History

Last changed by/on	SAP	20050224
SAP Release Created in