topic Re: Regarding max select statement. in Application Development and Automation Discussions

Regarding max select statement.

Former Member — Tue, 02 Jan 2007 07:46:55 GMT

hi ,

i m using max in select statement but its nt showing the o/p,cud u plz help me..thnx in advce.here i m giving the code....

tables:s032.

select-options:s_matnr for s032-matnr.

data:begin of itab occurs 0,

matnr like s032-matnr,

letztzug like s032-letztzug,

end of itab.

select matnr

MAX( letztzug )

into corresponding

fields of

table itab from s032 where matnr in s_matnr

group by matnr

order by

matnr

.

loop at itab.

write:/ itab-matnr,itab-letztzug.

endloop.

Re: Regarding max select statement.

Former Member — Tue, 02 Jan 2007 08:01:39 GMT

select matnr

MAX( letztzug )

into

table itab from s032 where matnr in s_matnr

group by matnr

order by

matnr

.

dont use corresponding fields of clause it is not matching the field name with max function.

regards

shiba dutta