select statement

[Former Member]

Hi,

How can i get the maximum number of one field using select statement..

[Former Member]

Can u clarify ur doubt plz?

Regards,

Talwinder

[Former Member]

hi

use aggregate fn max

select max( field ) from.........

[Former Member]

HI,

do like this.

DATA: M_TABLE TYPE TABNAME,

COLUMN_FIELD(14) TYPE C,

VALUE2(10)." TYPE P DECIMALs 1.

M_TABLE = 'MARA'.

COLUMN_FIELD = 'MATNR'."example 2.1

SELECT MAX( MATNR ) FROM (M_TABLE) INTO VALUE2.

write:/ value2.

In general

SELECT MAX( COLUMN_FIELD ) FROM (M_TABLE) INTO VALUE2.

rgds,

[arpit_shah]

try like this,

MAX (field): The maximum value of the field

eg.

SELECT MAX (field)

INTO (W_MAX)

FROM table

ENDSELECT.

Regards,

Arpit.