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
