Query

[Former Member]

Hi,

I need help in writing up a query.

Installation number higher than XXXXXXX and Installation Type YYYY.

Device is installed, no one is currently moved in but there is a move in pending that is more than 60 days out into the future.

I got step 1 .....now i have all the installation number. Which table to use to get all the equipment numbers and serial numbers for these installation.

Thanks.

[Former Member · Accepted solution]

With the istallation number, go to EASTL and get the logical device number LOGIKNR. Using that go to EGERH to get the equipment number EQUNR. Use equipment number and go to EQUI table and get the serial number GERNR.

[Former Member]

Thats perfect !! Thanks.

Now i need to figure out how to reduce the number of steps invloved.

Any advice.

[Former Member]

Just found it, use V_EGER.

[Former Member]

Got it.

I did a table join.

Thanks.

[Former Member]

Be sure to use the correct dates as all these tables are time dependant.

[Former Member]

I need the actual move in date which i am taking from EVER.

So i joint:

EVER for Installation No, M/In & M/Out dates

V_EANL for Installation type

EASTL for Logical device no.

V_EGER for Equipment No. & Serial No.