07-24-2009 6:29 AM
Hi ,
IS there any table name or reports to get the street route of the MRU with the Connection Object.
Please Let me know.
Thanks in advance,
Regards,
Santhosh.
07-26-2009 6:24 PM
Hi Santosh,
The street route does display a link between the MRU and the Device
The solution for your report Involves 3 tables
ELWEG = MRU - Logical Device Number
EGERH = Logical Dev Number - Device Location
IFLOT = Device Location - Connection Object (Superior Func Location)
Hope this helps.
07-24-2009 7:36 AM
Street Routes are stored in the ELWEG table for given MRU
ADRSTRTMRU in this table you can get the street codes associated with MRU
Regards,
Prajakta
Edited by: Prajakta Shringarpure on Jul 24, 2009 12:17 PM
07-24-2009 8:02 AM
Hi ,
Thanks for the reply.
My requirement is,i want the table name to get the street route of MRU with the connection object.
Suggestion Please....
Regards,
Santhosh
07-24-2009 8:18 AM
07-26-2009 3:32 PM
hi Santosh,
The connection object (HAus) u'l get from ILOA i suppose, then u'll find the adress number there from which u can find street from ADRC table.
The general flow is get premise -> Connection object -> Address number -> Street
wht is route, are you talking about route sequence number?
Hope it helps U,
Anni
07-26-2009 6:24 PM
Hi Santosh,
The street route does display a link between the MRU and the Device
The solution for your report Involves 3 tables
ELWEG = MRU - Logical Device Number
EGERH = Logical Dev Number - Device Location
IFLOT = Device Location - Connection Object (Superior Func Location)
Hope this helps.
07-27-2009 2:03 AM