answer to the locked thread: use maximum aggregate function

[Former Member]

the locked thread below is actually as different as any other unlocked thread

UP TO 1 ROWS
where
doc_number = wa_pdate_temp-salesdoc and
s_ord_item = wa_pdate_temp-salesitem and
sched_line = wa_pdate_temp-sline
order by /bic/zpviewdt descending .

The order by and up to n rows can be very expensive, better use the max(bic/zpviewdt),

for details read documentation.

[Former Member]

What thread is that Siegfried?

Rob

[Former Member]

I guess this is the one

[Former Member]

Well, that one was locked because it didn't look as if the OP had done any work to see if there was in fact a problem or done a run time analysis.

Rob