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: 

Device Location mass query

Former Member
0 Kudos
189

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.

2 REPLIES 2

william_eastman
Product and Topic Expert
Product and Topic Expert
0 Kudos
117

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
0 Kudos
117

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