SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

Street route

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

View solution in original post

6 REPLIES 6

Former Member
0 Kudos

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

0 Kudos

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

Former Member
0 Kudos

EWMINSPDETAIL see if it is maintained

Regards,

Prajakta

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

0 Kudos

Thanks dominic...Appreciated.Problem Resolved.