Device Location mass query

[Former Member]

Hi,

Is there a function module which could give a list of all the DeviceLocations which have NO equipments installed at the current time ?

I tried to check for a indicator/flag in IFLO and found none. Querying through millions of Device locations and then checking corresponding install entry in EGERH for each is a huge performance issue.

Appreciate al the help!

Thanks.

[william_eastman]

No there is nothing standard for that purpose.  You would need to build a query or write a program for that purpose.

regards,

bill.

[Former Member]

Hi Ramachandran

I'm not aware of a standard function that would do it. Independently, such a function would have the same performance impact.

Here's a SQL statement I would use:

  select tplnr into table gt_tplnr
    from iflot as t1
   where t1~tplnr in p_tplnr
     and t1~fltyp = 'G'
     and not exists ( select devloc
                        from egerh as t2
                       where t2~devloc =  t1~tplnr
                         and t2~bis    >= sy-datum
                         and t2~ab     <= sy-datum ).

From a performance point of view, it took around 100 seconds to run through 1 million device locations.

Yep

Jürgen