itab

[Former Member]

what is the syntax for eliminating duplicate values in internal table.

[Former Member]

DELETE ADJACENT DUPLICATEs FROM ITAB COMPARING FIELD1 FIELD1...

Message was edited by:

Chandrasekhar Jagarlamudi

[Former Member]

Hi

Use

Delete Adjacent duplicates

[Former Member]

Hi,

SORT itab BY ... .

Regards,

Stéphane.

[Former Member]

hi,

Example..

For DELETE ADJACENT DUPLICATES you have to sort first..

SORT ITAB BY MATNR.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING MATNR.

Just use that statement, omitting the COMPARING extension will simply mean that it will look at the entire line.

sort it_bsid ascending.

DELETE ADJACENT DUPLICATES FROM it_bsid.

Regards

Reshma

[Former Member]

hi

first sort the internal table and then use delete adjacent duplicates from itab

[Former Member]

DELETE ADJACENT DUPLICATES FROM itab.

the additions that you can give for this statement is

1) comparing f1 f2 ..........

2) comparing all fields.

f1 f2 fields refering to internal table fields

[Former Member]

hi,

syntax:

sort itab by <field1>...<fieldn>.

delete duplicate adjacent duplicates from <internal table name> comparing <fiel1>...<fieldn>

regards,

Navneeth.K

[Former Member]

hi,

DELETE ADJACENT DUPLICATES FROM itab COMPARING <field1> <field2

Regards,

Prasad

[jayanthi_jayaraman]

Hi,

delete adjacent duplicates from itab comparing all fields.

[Former Member]

DELETE ADJACENT DUPLICATES FROM <INTERNAL TABLE> COMPARING <FIELD1> <FIELD2>