Maximum amount to be selected

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Friends,

I coded in this way but cannot

SELECT MAX( trans ) status

INTO (v_trans v_status ) from lt_final.

Regards,

Line

[Former Member]

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

[Former Member]

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

[Former Member]

Hi there,

Can we move a record by using one statement.

Regards,

Line

[Former Member]

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