topic Re: maximum value in Application Development and Automation Discussions

maximum value

Former Member — Wed, 28 Jan 2009 08:03:51 GMT

hii,

how to find the maximum value from the internal table field for each personel number?

for ex.

field

i want 3 as output.

thanks

Re: maximum value

Former Member — Wed, 28 Jan 2009 08:05:53 GMT

Try sorting(desc)your internal table and pick the first record..

hope it helps.

Re: maximum value

Former Member — Wed, 28 Jan 2009 08:31:13 GMT

data: begin of it occurs 3,

val type i,

end of it.

it-val = 100.

append it sorted by val.

it-val = 400.

append it sorted by val.

it-val = 200.

append it sorted by val.

read table it index 1.

write: / it-val.

Regards

Jayapriya

Re: maximum value

Former Member — Wed, 28 Jan 2009 08:33:52 GMT

hi,

do you want to identify which cloumn has maximum value

Edited by: guest on Jan 28, 2009 9:33 AM

Re: maximum value

Former Member — Wed, 28 Jan 2009 08:36:50 GMT

HI,

SORT ITAB BY <FIELD> DESCENDING.
READ ITAB INDEX 1.

Re: maximum value

Former Member — Wed, 28 Jan 2009 08:37:53 GMT

Hi,

Try using

select MAX(field) from table.

Hope this helps.

Regards,

Deepthi.

Re: maximum value

Former Member — Wed, 28 Jan 2009 08:38:16 GMT

Hi,

U can use SORT statement to achieve this.

SORT <internaltable> BY fieldname DESCENDING .

Then take the first value of this internaltable.

This will be the max value.

Hope this helps u,.

Thanks.

Re: maximum value

Former Member — Wed, 28 Jan 2009 08:45:20 GMT

data: itab type table of ystudent with header line.

select * from ystudent into table itab.

sort itab descending by id descending.

read table itab index 1.

write itab-id.

Hope this helps

Regards,

Jayanthi.K

Re: maximum value

Former Member — Wed, 28 Jan 2009 08:48:31 GMT

SORT TABLE ITAB BY PERNR DESCENDING.

READ TABLE ITAB INTO WA INDEX 1.

WA-PERNR is the max number

Re: maximum value

Former Member — Wed, 28 Jan 2009 09:28:20 GMT

my code:

read table itab into wa with key pernr = was-pernr.

now where to write index 1.

thanks.

Re: maximum value

Former Member — Wed, 28 Jan 2009 09:33:11 GMT

Please be clear in asking questions

Re: maximum value

Former Member — Wed, 28 Jan 2009 09:34:41 GMT

Hello

try this

Select Max from Per into Lt_pers

After that you have only the biggest values

regards

Chris

Re: maximum value

Former Member — Wed, 28 Jan 2009 09:37:06 GMT

but we can use (select max) with standard tables n not with internal table.

Re: maximum value

Former Member — Wed, 28 Jan 2009 09:41:35 GMT

ok i got it how to use index 1.

thanks

but output showing all 3 values in field , i want only one dats max

Re: maximum value

jayanthi_jayaraman — Wed, 28 Jan 2009 09:44:50 GMT

Hi,

Sort the table by pernr and the field.

sort itab descending by pernr field1.

read table itab into wa with key pernr = was-pernr.

Now after this read statement, you can read the maximum value record.

Re: maximum value

Former Member — Wed, 28 Jan 2009 09:53:14 GMT

Hi,

After reading ur internal table using index.

u can move the value to another internal table know.

For ex:


SORT it_sum BY amount1 DESCENDING.

READ TABLE it_sum INTO wa_sum INDEX 1.
if sy-subrc eq 0.
  move: wa_sum-date to wa_res-date,
        wa_sum-amount1 to wa_res-amount1,
        wa_sum-amount2 to wa_res-amount2.
  append wa_res to it_res.
 endif.

Here the it_res table has the maximum value only.

Hope this helps u.

Thanks.

Re: maximum value

Former Member — Wed, 28 Jan 2009 11:40:09 GMT

thanks all of u.

Re: maximum value

Former Member — Thu, 29 Jan 2009 13:20:45 GMT

Hi Aks,

If your field for which you want to get the maximun value is a integer field than just sort the internal table descending and read the first record as also told by others, like:

Sort itab by char descending.

Read table itab into wa index 1.

but is its not a integer field say its a character field with lenght more than 1, than its always better to change it to a interger field than get the maximun value otherwise it can give a incorrect value to you, as for character fields it will compare with the first character, like if the field value are '12' and '5', it will take '5' as greater as the first character in the second case is 5 and its greater than the first character of the first case which is 1.

With luck,

Pritam.

Re: maximum value

Former Member — Thu, 29 Jan 2009 15:51:27 GMT

Hi,

Just sort your internal table in descending order and read the first row.

SORT ITAB BY PERNR DESCENDING.

READ TABLE ITAB INDEX 1.

ITAB-PERNR will be the biggest in the internal table ITAB.

Mubeen

Edited by: Mubeen Ahmed on Jan 29, 2009 4:52 PM