topic Re: delete duplicate adjest in Application Development and Automation Discussions

delete duplicate adjest

Former Member — Tue, 18 Jul 2006 09:49:27 GMT

i have itab that have 6 record * 8 times so i get 48 rows

i make delete comma and it delete only 12 why??

i need it to delete 7 times

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 09:51:08 GMT

Message was edited by: Dinu M Babu

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 09:51:37 GMT

Hi ,

u have to sort before deleting .

sort itab by matnr.

delete adhjacent duplicates from itab comparing matnr.

sort itab by matnr.

regards

Prabhu

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 09:52:13 GMT

did you sort the records before you use the delete adjacent duplicates from itab comparing field1 field2..statement?

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 09:53:38 GMT

Hi,

do you use the right key column in:

DELETE ADJACENT DUPLICATES FROM itab

COMPARING keycolumn.

grtz

Koen

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 09:53:46 GMT

can u show ur code.

first sort the itab for the duplicate fields

sort itabby matnr lgort.

delete adjacent duplicates from itab comparing matnr lgort.

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 09:55:16 GMT

Hello Rani,

USe like this.

<b>Delete adjacent duplicates from itab comparing field.</b>

If useful reward pooints.

Vasanth

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 10:03:31 GMT

i get al lot of values not just matnr and they are all the same 8 time

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 10:06:24 GMT

then use

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 10:09:30 GMT

Hi.

I think the problem is because of your sorting criteria or not sorting at all.

Regards,

close the issue if solved

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 10:17:59 GMT

Hi Rani,

1)Sort you Internal Table(with key fields)

SORT itab BY <b>f1 f2</b>.

2)Delete the records then comparing that fields.

DELETE ADJACENT DUPLICATES FROM itab COMPARING <b>f1 f2</b>.

You will have only single unique records then.

Regards,

Arun Sambargi.

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 10:28:23 GMT

Hi Rani,

You can delete duplicate entries from internal table :

1st sort your table as:

sort itab key field.

delete adjacent entries.

append itab.

so it may be possible that your condition is satisfied all 12 entries.

Ankur Garg.

Re: delete duplicate adjest

Former Member — Tue, 18 Jul 2006 10:35:54 GMT

Hi Rani,

You can delete duplicate entries from internal table :

1st sort your table as:

sort itab key field.

delete adjacent duplicates entries.

append itab.

so it may be possible that your condition is satisfied all 12 entries.

Ankur Garg.