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: 

Tables to link technical installation and devices

kevin_dewilde
Active Participant
0 Kudos

Hi,

I'm trying to make a query (sql statement) to list all devices for a giving technical installation. So far I've linked the TI (table EQUI) with the premise and the device location through ETINS and V_EGPL.

The challenge is that in this scenario, there are no installations in ISU, so I can't use the regular way of EASTS and ETDZ to get to the device...

So, does anyone know how the technical installation of a device is stored in the tables? I can't seem to find any IS-U tables that link the device location with an equipment, so I'm guessing I need to find the link between the functional location of the device location and the equipment of the device...

Please help me out!

Kevin

1 ACCEPTED SOLUTION

former_member303766
Participant
0 Kudos

Hi,

Please try EGERH table for your requirement.

Thanks

View solution in original post

1 REPLY 1

former_member303766
Participant
0 Kudos

Hi,

Please try EGERH table for your requirement.

Thanks