SAP ABAP Table EDEVICED (Scrn Fields Devices Subscrn)

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	EDEVICED	Table Relationship Diagram
Short Description	Scrn Fields Devices Subscrn

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GERAET	☐	GERNR	GERNR	CHAR	18	0	Serial Number
3	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
4	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
5	INFOFIELD	☐	INFOFIELD	TEXT50	CHAR	50	0	Information field for device
6	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
7	SPARTEXT	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
8	KURZKOMBI	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
9	MATNR	☐	GERTYP	MATNR	CHAR	18	0	Device category	ETYP
10	BAUFORM	☐	BAUFORM	TEXT30	CHAR	30	0	Device category description
11	GERTYPTXTL	☐	GERTYPTXTL	TEXT100	CHAR	100	0	Basic device categories allocated to the device category
12	BGLJAHR	☐	BGLJAHR	JAHR	NUMC	4	0	Certification Year
13	BGLNUM	☐	BGLNUM	CHAR15	CHAR	15	0	Certification number
14	BGLSTAT	☐	BGLSTAT	BGLSTAT	CHAR	1	0	Certification status
15	BGLART	☐	BGLART	BGLART	CHAR	2	0	Type of certification	TE359
16	WECHSEL	☐	WECHSEL	JAHR	NUMC	4	0	Advance replacement year
17	BGLBIS	☐	BGLBIS	JAHR	NUMC	4	0	Next replacement year
18	BGLTXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
19	BGLNETZ	☐	BGLNETZ	KENNZX	CHAR	1	0	Certify installed devices
20	LOS	☐	LOS	GEGST	CHAR	8	0	Sample lot	TE271
21	LOSTXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
22	KZSTICH	☐	KZSTICH	KZSTICH	CHAR	1	0	Status of sample device
23	KZSTICHTXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
24	EINBDAT	☐	EINBDAT	DATUM	DATS	8	0	Installation date
25	AUSBDAT	☐	AUSBDAT	DATUM	DATS	8	0	Device removal date
26	UMBAUDAT	☐	UMBAUDAT	DATUM	DATS	8	0	Modification date
27	SPERRDAT	☐	SPERRDAT	DATUM	DATS	8	0	Disconnection date
28	GERWECHS1	☐	E_EINBGRD	GERWECHS	CHAR	2	0	Installation reason	*
29	GERWECHS2	☐	E_AUSBGRD	GERWECHS	CHAR	2	0	Reason for removal	*
30	UMBAUGR	☐	UMBAUGR	UMBAUGR	CHAR	2	0	Modification reason	TE791
31	SPGRUND	☐	SPGRUND	SPGRUND	CHAR	2	0	Disconnection reason
32	GWECHSTXT1	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
33	GWECHSTXT2	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
34	UMBAUGRTXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
35	ZWGRUPPE	☐	E_ZWGRUPPE	GEGST	CHAR	8	0	Register Group	EZWG
36	WGRUPPE	☐	WGRUPPE	GEGST	CHAR	8	0	Winding group	EWIK
37	EAGRUPPE	☐	EAGRUPPE	GEGST	CHAR	8	0	Input/output group	EEAG
38	KOMGRP	☐	KOMGRP	GEGST	CHAR	8	0	ARCR Command Group	EKOG
39	BESITZ	☐	BESITZ	BESITZ	NUMC	2	0	Inspection relevance of device	TEPRREL
40	BESITZTXT	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
41	PREL_KZ	☐	PREL_KZ	KENNZX	CHAR	1	0	Select as relevant to inspection
42	PARAMETR	☐	PARAMETR	PARAMETR	CHAR	8	0	Parametrization	TE927
43	PARAMETRTXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
44	PLOMBDAT	☐	PLOMBDAT	DATUM	DATS	8	0	Date of last lead sealing
45	PLOMBE	☐	PLOMBE	PLOMBE	CHAR	2	0	Seal code	TE937
46	PLOMBETXT	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
47	MESSDRCK	☐	MESSDRCK	MESSDRCK	DEC	7	4	Measured Pressure (Outlet Pressure) in Bars	*
48	SCHWGRAD	☐	SCHWGRAD	DEC2_1	DEC	3	1	Difficulty level: Factor for meter reader payment
49	UEBERVER	☐	UEBERVER	UEBERV	DEC	10	3	Transformation ratio
50	ZSPANNP	☐	E_ZSPANNP	WSPANNP	DEC	6	0	Register factor: primary transformer voltage
51	ZSPANNS	☐	E_ZSPANNS	SPANNUNG	DEC	4	1	Register factor: secondary transformer voltage
52	ZSTROMP	☐	E_ZSTROMP	E_ZSTROMP	DEC	5	1	Register factor: primary transformer current
53	ZSTROMS	☐	E_ZSTROMS	E_ZSTROMS	DEC	5	2	Register factor: secondary transformer current
54	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
55	DEVGRP	☐	DEVGRP	DEVGRP	CHAR	8	0	Device group	*
56	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset	TE063
57	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
58	APPROVALNR	☐	APPROVALNR	CHAR15	CHAR	15	0	Device inspection number
59	WANDART	☐	WANDART	WANDART	CHAR	1	0	Transformer type
60	WANDARTTXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
61	VLZEIT_DEV	☐	VLZEIT_DEV	ALLGVLZEIT	DEC	2	0	Individual cal. validity (years) of dev. subject to certif.
62	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
63	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
64	LOCK_INFO	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
65	EZWG_INFO	☐	EZWG_INFO	TEXT30	CHAR	30	0	Register information field
66	EEAG_INFO	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
67	EKOG_INFO	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
68	ORDER_CODE	☐	ORDERCODE2	CHAR004	CHAR	4	0	Special Order Code for Dev./Dev. Category in Replacement	TEWOCODES
69	ORDER_TEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
70	NOTIF_CODE	☐	NOTIF_CODE	CHAR004	CHAR	4	0	Notification code	TENOCODES
71	NOTIF_TEXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
72	ZWSTAND	☐	E_ZWSTAND	E_ZWSTAND	CHAR	36	0	Meter reading recorded
73	ADAT	☐	ADAT	DATUM	DATS	8	0	Meter reading date relevant to billing
74	MR_STATUS	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
75	TURNUSW	☐	TURNUSW	TEXT75	CHAR	75	0	Information on whether device is in periodic repl. list
76	TURNUSJ	☐	TURNUSJ	JAHR	NUMC	4	0	Periodic replacement year
77	AUFTRAG	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
78	MELDUNG	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
79	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	EDEVICED	BESITZ	TEPRREL	PRUEFRELEVANZ	KEY	1	CN
2	EDEVICED	BGLART	TE359	BGLART	KEY	C	CN
3	EDEVICED	EAGRUPPE	EEAG	EAGRUPPE	KEY	C	CN
4	EDEVICED	HERST	TE063	HERST	KEY	1	CN
5	EDEVICED	KOMGRP	EKOG	KOMGRP	KEY	C	CN
6	EDEVICED	LOS	TE271	LOS	KEY	C	CN
7	EDEVICED	MATNR	ETYP	MATNR	KEY	1	CN
8	EDEVICED	NOTIF_CODE	TENOCODES	NOTIF_CODE	KEY	C	CN
9	EDEVICED	ORDER_CODE	TEWOCODES	ORDER_CODE	KEY
10	EDEVICED	PARAMETR	TE927	PARAMETR	KEY	C	CN
11	EDEVICED	PLOMBE	TE937	PLOMBE	KEY	C	CN
12	EDEVICED	PPM_METER	TEPPM	PPM_METER
13	EDEVICED	SPARTE	TSPA	SPART		1	CN
14	EDEVICED	UMBAUGR	TE791	UMBAUGR	KEY	C	CN
15	EDEVICED	WGRUPPE	EWIK	WGRUPPE	KEY	C	CN
16	EDEVICED	ZWGRUPPE	EZWG	ZWGRUPPE		C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in