Pls any one guide me to this problem

[Former Member]

Hi ABAP Consultants,

Pls guide me to this problem,

I developed one report for inqury and quattaion and sales order on the same list.

there dupulicate vales are coming, i need to remove to this problem.

for that i wrote a duplicate addjusent squary. after that in inquary duplicates are not coming but in quataion and so repeated records are printed.

Pls pls any one say some thing about the problem.

[Former Member]

hi

use for all entries..and compare with key properly in read statement

for ex..

loop at itab1

read table itab2 with key <fld> = itab1-<fld>.

endloop.

also check out the append statements....use modify instead of append.

hope it will solve ur problem.

Rgs

Rajat.

[Former Member]

THANKS FOR HELP ME.

I TRIED THAT IT SOLVED.

[Former Member]

HI,

How are you displaying the entries is this done via ALV and did you first create an internal table which you pass to the ALV. When having an internal table you can simply do:

DELETE ADJACENT DUPLICATES FROM itab

You can even give key fields.

If you are using an SELECT and ENDSELECT statement and then a write statement in between, I would suggest to drop the SELECT and ENDSELECT statement and do:

SELECT * FROM TABLE INTO itab WHERE ...

Then you can loop over the table and do your write statements.

Best regards,

Guido Koopmann

[Former Member]

HI,

THAKS FOR HELP TO ME.

I GOT THE SOLUTION FROM UR GUIDE.