Retrieve Installations with Multiple devices

[ricky_shaw]

Hi,

I need to find out list of Installations with multiple devices. How can i find them.

I tried joining V_EGERH & EASTS but could not get.

Thanks

[RonnyF · Accepted solution]

Hello Ricky,
if you want to select only real devices which are installed to an installation at the moment I recommend to first select all devices from EGERH (or V_EGER) with LOGIKNR ≠ 0 . Then use the result list to select in table EASTL via LOGIKNR and SORT the result list by installation.

Best regards,
Ronny

[ricky_shaw]

Thanks Ronny. Doing the same.