topic Re: Maximum amount to be selected in Application Development and Automation Discussions

Maximum amount to be selected

Former Member — Tue, 22 May 2007 00:22:32 GMT

Hi Friends,

I want to select maximum amount record from the internal table, can any one tell me how to extract that maximum record.

Regards,

Line

Re: Maximum amount to be selected

Former Member — Tue, 22 May 2007 00:23:32 GMT

Hi Friends,

I coded in this way but cannot

SELECT MAX( trans ) status

INTO (v_trans v_status ) from lt_final.

Regards,

Line

Re: Maximum amount to be selected

Former Member — Tue, 22 May 2007 00:28:10 GMT

Hi Line,

Try this.

SELECT MAX( trans ) status

INTO (v_trans v_status ) from lt_final.

GROUP BY trans

Reward points if useful.

Regards,

Atish

Re: Maximum amount to be selected

Former Member — Tue, 22 May 2007 00:29:27 GMT

Hi Line Turbin,

Let me tell you one simple way..

sort the internal table descending by the amount.

then loop at the internable table and if sy-tabix = 1. then exit

example:

sort i_tab by wmbtr descending.

loop at i_tab.

if sy-tabix = 1.

move the hight value into variable or the row into something

exit.

endloop.

award points if useful

Re: Maximum amount to be selected

Former Member — Tue, 22 May 2007 00:36:00 GMT

Hi there,

Can we move a record by using one statement.

Regards,

Line

Re: Maximum amount to be selected

Former Member — Tue, 22 May 2007 00:38:04 GMT

Hi Line,

The best way is to select the maximum value using select query itself so that there will be less amount of data selected in the internal table and no need to do further processing on it.

Regards,

Atish