SAP ABAP Table EBW_ISU_DEVICE_I (BW: Complete Extraction View for IS-U Device)

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	EBW_ISU_DEVICE_I	Table Relationship Diagram
Short Description	BW: Complete Extraction View for IS-U Device

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	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
4	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
5	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
6	LOGIKNR	☐	LOGIKNR	LOGIKNR	NUMC	18	0	Logical device number
7	GERAET	☐	GERNR	GERNR	CHAR	18	0	Serial Number
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	ZWGRUPPE	☐	E_ZWGRUPPE	GEGST	CHAR	8	0	Register Group
12	EINBDAT	☐	EINBDAT	DATUM	DATS	8	0	Installation date
13	AUSBDAT	☐	AUSBDAT	DATUM	DATS	8	0	Device removal date
14	GERWECHS	☐	GERWECHS	GERWECHS	CHAR	2	0	Activity reason	TE401
15	DEVLOC	☐	DEVLOC	TPLNR	CHAR	30	0	Device Location	*
16	WGRUPPE	☐	WGRUPPE	GEGST	CHAR	8	0	Winding group
17	PRIMWNR1	☐	PRIMWNR	LFDNR2	NUMC	2	0	Winding number of active primary winding
18	SEKWNR1	☐	SEKWNR	LFDNR2	NUMC	2	0	Winding number of active secondary winding
19	PRIMWNR2	☐	PRIMWNR	LFDNR2	NUMC	2	0	Winding number of active primary winding
20	SEKWNR2	☐	SEKWNR	LFDNR2	NUMC	2	0	Winding number of active secondary winding
21	EAGRUPPE	☐	EAGRUPPE	GEGST	CHAR	8	0	Input/output group
22	KOMGRP	☐	KOMGRP	GEGST	CHAR	8	0	ARCR Command Group
23	LOS	☐	LOS	GEGST	CHAR	8	0	Sample lot
24	MESSDRCK	☐	MESSDRCK	MESSDRCK	DEC	7	4	Measured Pressure (Outlet Pressure) in Bars	*
25	UEBERVER	☐	UEBERVER	UEBERV	DEC	10	3	Transformation ratio
26	BESITZ	☐	BESITZ	BESITZ	NUMC	2	0	Inspection relevance of device	*
27	BGLJAHR	☐	BGLJAHR	JAHR	NUMC	4	0	Certification Year
28	WECHSEL	☐	WECHSEL	JAHR	NUMC	4	0	Advance replacement year
29	BGLSTAT	☐	BGLSTAT	BGLSTAT	CHAR	1	0	Certification status
30	KZSTICH	☐	KZSTICH	KZSTICH	CHAR	1	0	Status of sample device
31	SCHWGRAD	☐	SCHWGRAD	DEC2_1	DEC	3	1	Difficulty level: Factor for meter reader payment
32	PLOMBDAT	☐	PLOMBDAT	DATUM	DATS	8	0	Date of last lead sealing
33	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
34	BGLART	☐	BGLART	BGLART	CHAR	2	0	Type of certification	TE359
35	BGLNUM	☐	BGLNUM	CHAR15	CHAR	15	0	Certification number
36	UMBAUDAT	☐	UMBAUDAT	DATUM	DATS	8	0	Modification date
37	UMBAUGR	☐	UMBAUGR	UMBAUGR	CHAR	2	0	Modification reason	TE791
38	EICHFAEL	☐	EICHFAEL	KENNZX	CHAR	1	0	Use calibration validity
39	PARAMETR	☐	PARAMETR	PARAMETR	CHAR	8	0	Parametrization	TE927
40	PLOMBE	☐	PLOMBE	PLOMBE	CHAR	2	0	Seal code	TE937
41	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
42	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
43	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
44	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
45	ZSPANNS	☐	E_ZSPANNS	SPANNUNG	DEC	4	1	Register factor: secondary transformer voltage
46	ZSPANNP	☐	E_ZSPANNP	WSPANNP	DEC	6	0	Register factor: primary transformer voltage
47	ZSTROMS	☐	E_ZSTROMS	E_ZSTROMS	DEC	5	2	Register factor: secondary transformer current
48	ZSTROMP	☐	E_ZSTROMP	E_ZSTROMP	DEC	5	1	Register factor: primary transformer current
49	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
50	DEVGRP	☐	DEVGRP	DEVGRP	CHAR	8	0	Device group	*
51	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
52	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
53	APPROVALNR	☐	APPROVALNR	CHAR15	CHAR	15	0	Device inspection number
54	VLZEIT_DEV	☐	VLZEIT_DEV	ALLGVLZEIT	DEC	2	0	Individual cal. validity (years) of dev. subject to certif.
55	KOMBINAT	☐	KOMBINAT	KOMBINAT	CHAR	8	0	Combination of a device category
56	BGLNETZ	☐	BGLNETZ	KENNZX	CHAR	1	0	Certify installed devices
57	ORDER_CODE	☐	ORDERCODE2	CHAR004	CHAR	4	0	Special Order Code for Dev./Dev. Category in Replacement	TEWOCODES
58	NOTIF_CODE	☐	NOTIF_CODE	CHAR004	CHAR	4	0	Notification code	TENOCODES
59	S_EQBS	☐	KZEQBS	KZEQBS	CHAR	1	0	EQSI Exists
60	PPM_METER	☐	PPM_METER	PPM_METER	NUMC	2	0	Prepayment Meter	*
61	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
62	BGLBIS	☐	BGLBIS	JAHR	NUMC	4	0	Next replacement year
63	BGLKENN	☐	BGLKENN	BGLKENN	CHAR	2	0	Determination of dev.req.planning/rep.yr from certification
64	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
65	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
66	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
67	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
68	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
69	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
70	STATANZ	☐	STATANZ	STATANZ	INT4	10	0	Number in statistics
71	REGPOLIT	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EBW_ISU_DEVICE_I	BGLART	TE359	BGLART	REF	C	CN
2	EBW_ISU_DEVICE_I	EQUNR	EQUI	EQUNR	KEY	1	CN
3	EBW_ISU_DEVICE_I	GERWECHS	TE401	GERWECHS		C	CN
4	EBW_ISU_DEVICE_I	LAGER	T001L	LGORT
5	EBW_ISU_DEVICE_I	MANDT	T000	MANDT	KEY	1	CN
6	EBW_ISU_DEVICE_I	MATNR	MARA	MATNR
7	EBW_ISU_DEVICE_I	NOTIF_CODE	TENOCODES	NOTIF_CODE	KEY	C	CN
8	EBW_ISU_DEVICE_I	ORDER_CODE	TEWOCODES	ORDER_CODE	KEY	C	CN
9	EBW_ISU_DEVICE_I	PARAMETR	TE927	PARAMETR	REF	C	CN
10	EBW_ISU_DEVICE_I	PLOMBE	TE937	PLOMBE	REF	C	CN
11	EBW_ISU_DEVICE_I	SPARTE	TSPA	SPART	KEY	1	CN
12	EBW_ISU_DEVICE_I	UMBAUGR	TE791	UMBAUGR	REF	C	CN
13	EBW_ISU_DEVICE_I	WERK	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in	462