delete duplicate adjest

[Former Member]

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

[Former Member]

.

Message was edited by: Dinu M Babu

[Former Member]

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

[Former Member]

then use

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS

[Former Member]

Hi ,

u have to sort before deleting .

sort itab by matnr.

delete adhjacent duplicates from itab comparing matnr.

sort itab by matnr.

.

regards

Prabhu

[Former Member]

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

[Former Member]

Hi,

do you use the right key column in:

DELETE ADJACENT DUPLICATES FROM itab

COMPARING keycolumn.

grtz

Koen

[Former Member]

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.

[Former Member]

Hello Rani,

USe like this.

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

If useful reward pooints.

Vasanth

[Former Member]

Hi.

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

Regards,

• close the issue if solved

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.