Query

[Former Member]

Dear gurus,

I have a table like this

id counter text

001 001 AAA

001 002 BBB

002 001 AAA

002 002 BBB

002 003 CCC

I want to have a o/p like this

001 002 BBB

002 003 CCC

it it should fetch the latest counter of the id text

please help me out regards this query

thank in advance

Senthil

[Former Member]

thanx for all u r replies

senthil

[Former Member]

hi

use <b>delete duplicate</b>.

regards,

pankaj singh

[Former Member]

Hi Senthil,

You can do two ways.

One is

AT END OF id
ENDAT.

Other is

Sort itab by text decending.
delete adjacent duplicates itab comparing id.

Regards

Bhupal Reddy

[Former Member]

hi..

u must use the following command in order to delete the repeated values:

<b> delete adjacent duplicates</b>.

try out this command in ur code..

all the best

[Former Member]

sort itab by id.

itab1[] = itab[].

delete adjacent duplicates from itab comparing id.

loop at itab.

loop at itab1 into itab3 whre id = itab-id.

append itab3.

endloop.

sort itab3 by id descending.

move itab3 to out.

append out.

refresh: itab3.

endloop.

[Former Member]

sort itab by id.

itab1[] = itab[].

delete adjacent duplicates from itab comparing id.

loop at itab.

loop at itab1 into itab3 whre id = itab-id.

append itab3.

endloop.

sort itab3 by id descending.

read table itab3 index 1.

move itab3 to out.

append out.

refresh: itab3.

endloop.

[Former Member]

Hi Senthil ,

The code woule be like this

Data : wa_1 like line of it_1.
sort it_1 by id counter descending .
Loop at it_1.
wa_1 = it_1.    " Please dont forget to do this
at new id
 write: / it_1-id  , wa_1-counter  , WA_1-TEXT.
endat.


ENDLOOP

Regards

Arun

Message was edited by:

Arun Ramachandran

[Former Member]

sort itab by id counter descending.

loop at itab.
 at new itab.
 read table itab index sy-tabix.
 move-corresponding itab to itab1.  " Declare itab1 same as itab
 append itab1.
endat.
endloop.

[Former Member]

thanx for all u r replies

senthil