07-08-2008 1:54 PM
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
07-09-2008 12:42 PM
07-09-2008 12:42 PM