topic Re: internal table in Application Development and Automation Discussions

internal table

Former Member — Mon, 25 Feb 2008 11:51:45 GMT

how to write a logic least marks and higest marks from internal table.

Re: internal table

matt — Mon, 25 Feb 2008 11:56:43 GMT

Sort the internal table by the marks. Read the first and last record of the table.

matt

Re: internal table

Former Member — Mon, 25 Feb 2008 11:57:29 GMT

Hope it will help you.

<REMOVED BY MODERATOR>

Highest Marks:-

sort internal table by field ascending.

read internal table index 1.

Lowest Marks:-

sort internal table by field descending

read internal table index 1.

Edited by: Alvaro Tejada Galindo on Feb 25, 2008 5:03 PM

Re: internal table

Former Member — Mon, 25 Feb 2008 12:00:26 GMT

sort itab by field descending.

read table i_sort index 1.

move i_sort-field to gv_field.

gv_field is the max value.

sort itab by field ascending.

read table i_sort index 1.

move i_sort-field to lv_field.

lv_field is the leas value.

Regards,

Ajay

Re: internal table

Former Member — Mon, 25 Feb 2008 12:01:28 GMT

Hi Krishna,

Say your internal table has MARKS field which holds marks.

data: low_marks type i,

high_marks type i,

v_lines type sy-tabix.

sort itab by marks.

*-- First record holds least marks

read table itab index 1.

if sy-subrc = 0.

low_marks = itab-marks.

endif.

*-- your last record holds highest marks

describe table itab lines v_lines.

read table itab index v_lines.

if sy-subrc = 0.

high_marks = itab-marks.

endif.

At this point low_marks holds least marks and high_marks holds highest marks

Re: internal table

Former Member — Mon, 25 Feb 2008 12:02:16 GMT

sort itab by field descending.

read table itab index 1.

move i_sort-field to gv_field.

**************************gv_field is the max value.

sort itab by field ascending.

read table itab index 1.

move i_sort-field to lv_field.

****************************lv_field is the leas value.

Regards,

Ajay

Re: internal table

Former Member — Mon, 25 Feb 2008 12:04:36 GMT

hi ,

if you sort the tabel by the marks field then first and last fields will be the lowest and highest values .

regards,

venkat.

Re: internal table

Former Member — Mon, 25 Feb 2008 12:46:21 GMT

By using min and max functions we can get the values.

By using sorting the internal table by using ascending or descending

If you want to write some logic then by using sorting techniques you can find

Re: internal table

Former Member — Mon, 25 Feb 2008 12:51:20 GMT

Hi,

You can do as below :


Sort itab by marks acsending.

read the table using index." First row will contain the lower value.

Again sort the itab by descending.

Sort itab by marks descending.
read the table using index." First row will contain the higher value.

Thanks,

Sriram Ponna.