topic Re: Record with highest sy-tabix in Application Development and Automation Discussions

Record with highest sy-tabix

Former Member — Tue, 01 Jul 2008 15:03:49 GMT

Hi,

In an internal table I have 10 records for a field like

Is it possible to get the records D and E which has highest sy-index.

good solution will be rewarded.

Thanks and Regards,

Neerup.

JozsefSzikszai — Tue, 01 Jul 2008 15:07:43 GMT

hi,

for example:

DATA : lv_tabix TYPE sy-tabix.

LOOP AT itab WHERE field EQ 'D'.
lv_tabix = sy-tabix.
ENDLOOP.

Now lv_tabix contains then number of last line with D.

hope this helps

Former Member — Tue, 01 Jul 2008 15:07:54 GMT

sort itab by field.

loop at itab.

v_count = v_count + 1.

at end of field.

*populate an internal table with the values

itab1-field = itab-field.

itab1-count = v_count.

append itab1.

clear v_count.

endloop.

itab1 has fields and the no. of times they appear in ITAB.

sort itab1 count descending.

Former Member — Tue, 01 Jul 2008 15:09:25 GMT

Neerup,

Neerup wrote:

Is it possible to get the records D and E which has highest sy-index.

but in your question you mention as :

Record with highest sy-tabix

any ways:

just sort decending then fetch the first record then exit from loop.