topic first row for each entry in Application Development and Automation Discussions

first row for each entry

Former Member — Mon, 26 Nov 2007 12:45:51 GMT

i have sorted the internal table by field f1 and i need to insert the first row for each f1 entry.

I tried AT NEW f1. But that doesnt seem to work.

Kindlly help.

Thanks.

Re: first row for each entry

rodrigo_paisante3 — Mon, 26 Nov 2007 12:49:07 GMT

Hi,

can you post your code? Thanks.

Rodrigo

Re: first row for each entry

Former Member — Mon, 26 Nov 2007 12:53:50 GMT

Hi here it is..

SORT it_gir BY age ASCENDING.

LOOP AT it_gir INTO wa_gir.

AT NEW age.

MOVE-CORRESPONDING wa_gir TO wa_final1.

APPEND wa_final1 TO it_final1.

ENDAT.

ENDLOOP.

Re: first row for each entry

Clemenss — Mon, 26 Nov 2007 13:13:55 GMT

Hi riya,

there is widely spear confusion on AT NEW and ON CHANGE OF. I'm sure you did not check or understand the relevant F1 help or WIKI or what ever.

Simply said:

1. AT NEW works for sorted tables only. Sorted by the whole line, that means SORT without any fields addidtion. SORT .

2. AT NEW is triggered only and alöways if the field content OR THE FIELD CONTENT OF ANY FIELD LEFT FROM IT changed.

Regards,

Clemens

Re: first row for each entry

Former Member — Mon, 26 Nov 2007 14:23:08 GMT

*--ENSURE THAT age IS FIRST FIELD IN INTERNAL TABLE it_gir while declaring it.....

SORT it_gir BY age ASCENDING.

LOOP AT it_gir INTO wa_gir.

AT NEW age.

<b>*--if there are fields which are getting populated with **** instead of original values....then use below statement...</b>

read table it_gir index sy-tabix.

MOVE-CORRESPONDING wa_gir TO wa_final1.

APPEND wa_final1 TO it_final1.

clear wa_final1.

ENDAT.

ENDLOOP.

now it should definitely work.....

if not check in debugging mode if data exists or not....!!!

Regards

Vasu

Re: first row for each entry

Former Member — Mon, 26 Nov 2007 14:27:00 GMT

Hi,

why cant u do like this

SORT it_gir BY age ASCENDING.

it_final[] = it_gir[].

delete adjacent duplicates from it_final[] comapring age.

now it_final contain only unique entries for age field

reward if answered