SAP ABAP View V_EGER (All Data for IS-U Dev. Master)

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_EGER
Short Description	All Data for IS-U Dev. Master
Root table	EGERS	IS-U Device Master Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EGERS	EGERS
2	EQUI
3	EGERH

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EQUI	MANDT	JL	EQ				0	0
2	EGERS	MANDT	JR	EQ			AND	0	0
3	EQUI	EQUNR	JL	EQ				0	0
4	EGERS	EQUNR	JR	EQ			AND	0	0
5	EQUI	MANDT	JL	EQ				0	0
6	EGERH	MANDT	JR	EQ			AND	0	0
7	EQUI	EQUNR	JL	EQ				0	0
8	EGERH	EQUNR	JR	EQ			AND	0	0
9	EGERS	MANDT	JL	EQ				0	0
10	EGERH	MANDT	JR	EQ			AND	0	0
11	EGERS	EQUNR	JL	EQ				0	0
12	EGERH	EQUNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EGERS	MANDT		☐	MANDT	☐	Client
2	EQUNR	EGERS	EQUNR		☐	EQUNR	☐	Equipment Number
3	BIS	EGERH	BIS		☐	BISZEITSCH	☐	Date at Which a Time Slice Expires
4	AB	EGERH	AB		☐	ABZEITSCH	☐	Date from which time slice is valid
5	LOGIKNR	EGERH	LOGIKNR		☐	LOGIKNR	☐	Logical device number
6	GERAET	EQUI	SERNR		☐	GERNR	☐	Serial Number
7	MATNR	EQUI	MATNR		☐	MATNR	☐	Material Number
8	WERK	EQUI	WERK		☐	WERKS_D	☐	Plant
9	LAGER	EQUI	LAGER		☐	LGORT_D	☐	Storage location
10	ZWGRUPPE	EGERH	ZWGRUPPE		☐	E_ZWGRUPPE	☐	Register Group
11	EINBDAT	EGERH	EINBDAT		☐	EINBDAT	☐	Installation date
12	AUSBDAT	EGERH	AUSBDAT		☐	AUSBDAT	☐	Device removal date
13	GERWECHS	EGERH	GERWECHS		☐	GERWECHS	☐	Activity reason
14	DEVLOC	EGERH	DEVLOC		☐	DEVLOC	☐	Device Location
15	WGRUPPE	EGERH	WGRUPPE		☐	WGRUPPE	☐	Winding group
16	PRIMWNR1	EGERH	PRIMWNR1		☐	PRIMWNR	☐	Winding number of active primary winding
17	SEKWNR1	EGERH	SEKWNR1		☐	SEKWNR	☐	Winding number of active secondary winding
18	PRIMWNR2	EGERH	PRIMWNR2		☐	PRIMWNR	☐	Winding number of active primary winding
19	SEKWNR2	EGERH	SEKWNR2		☐	SEKWNR	☐	Winding number of active secondary winding
20	EAGRUPPE	EGERS	EAGRUPPE		☐	EAGRUPPE	☐	Input/output group
21	KOMGRP	EGERS	KOMGRP		☐	KOMGRP	☐	ARCR Command Group
22	LOS	EGERS	LOS		☐	LOS	☐	Sample lot
23	MESSDRCK	EGERS	MESSDRCK		☐	MESSDRCK	☐	Measured Pressure (Outlet Pressure) in Bars
24	UEBERVER	EGERS	UEBERVER		☐	UEBERVER	☐	Transformation ratio
25	BESITZ	EGERS	BESITZ		☐	BESITZ	☐	Inspection relevance of device
26	BGLJAHR	EGERS	BGLJAHR		☐	BGLJAHR	☐	Certification Year
27	WECHSEL	EGERS	WECHSEL		☐	WECHSEL	☐	Advance replacement year
28	BGLSTAT	EGERS	BGLSTAT		☐	BGLSTAT	☐	Certification status
29	KZSTICH	EGERS	KZSTICH		☐	KZSTICH	☐	Status of sample device
30	SCHWGRAD	EGERS	SCHWGRAD		☐	SCHWGRAD	☐	Difficulty level: Factor for meter reader payment
31	PLOMBDAT	EGERS	PLOMBDAT		☐	PLOMBDAT	☐	Date of last lead sealing
32	HERST	EQUI	HERST		☐	HERST	☐	Manufacturer of asset
33	BGLART	EGERS	BGLART		☐	BGLART	☐	Type of certification
34	BGLNUM	EGERS	BGLNUM		☐	BGLNUM	☐	Certification number
35	UMBAUDAT	EGERS	UMBAUDAT		☐	UMBAUDAT	☐	Modification date
36	UMBAUGR	EGERS	UMBAUGR		☐	UMBAUGR	☐	Modification reason
37	EICHFAEL	EGERS	EICHFAEL		☐	EICHFAEL	☐	Use calibration validity
38	PARAMETR	EGERS	PARAMETR		☐	PARAMETR	☐	Parametrization
39	PLOMBE	EGERS	PLOMBE		☐	PLOMBE	☐	Seal code
40	ERDAT	EQUI	ERDAT		☐	ERDAT	☐	Date on which the record was created
41	ERNAM	EQUI	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
42	AEDAT	EGERS	AEDAT		☐	AEDAT	☐	Last Changed On
43	AENAM	EGERS	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
44	ZSPANNS	EGERS	ZSPANNS		☐	E_ZSPANNS	☐	Register factor: secondary transformer voltage
45	ZSPANNP	EGERS	ZSPANNP		☐	E_ZSPANNP	☐	Register factor: primary transformer voltage
46	ZSTROMS	EGERS	ZSTROMS		☐	E_ZSTROMS	☐	Register factor: secondary transformer current
47	ZSTROMP	EGERS	ZSTROMP		☐	E_ZSTROMP	☐	Register factor: primary transformer current
48	BAUJJ	EQUI	BAUJJ		☐	BAUJJ	☐	Year of construction
49	DEVGRP	EGERH	DEVGRP		☐	DEVGRP	☐	Device group
50	SPARTE	EQUI	SPARTE		☐	SPARTE	☐	Division
51	TYPBZ	EQUI	TYPBZ		☐	TYPBZ	☐	Manufacturer model number
52	APPROVALNR	EGERS	APPROVALNR		☐	APPROVALNR	☐	Device inspection number
53	VLZEIT_DEV	EGERS	VLZEIT_DEV		☐	VLZEIT_DEV	☐	Individual cal. validity (years) of dev. subject to certif.
54	KOMBINAT	EGERH	KOMBINAT		☐	KOMBINAT	☐	Combination of a device category
55	BGLNETZ	EGERS	BGLNETZ		☐	BGLNETZ	☐	Certify installed devices
56	ORDER_CODE	EGERS	ORDER_CODE		☐	ORDERCODE2	☐	Special Order Code for Dev./Dev. Category in Replacement
57	NOTIF_CODE	EGERS	NOTIF_CODE		☐	NOTIF_CODE	☐	Notification code
58	S_EQBS	EQUI	S_EQBS		☐	KZEQBS	☐	EQSI Exists
59	PPM_METER	EGERH	PPM_METER		☐	PPM_METER	☐	Prepayment Meter
60	OBJNR	EQUI	OBJNR		☐	J_OBJNR	☐	Object number

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	20110901
SAP Release Created in