topic Re: itab in Application Development and Automation Discussions

itab

Former Member — Fri, 27 Apr 2007 09:28:41 GMT

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

Re: itab

Former Member — Fri, 27 Apr 2007 09:29:16 GMT

DELETE ADJACENT DUPLICATEs FROM ITAB COMPARING FIELD1 FIELD1...

Message was edited by:

Chandrasekhar Jagarlamudi

Re: itab

Former Member — Fri, 27 Apr 2007 09:29:27 GMT

Use

Delete Adjacent duplicates

Re: itab

Former Member — Fri, 27 Apr 2007 09:29:50 GMT

Hi,

SORT itab BY ... .

Regards,

Stéphane.

Re: itab

Former Member — Fri, 27 Apr 2007 09:30:03 GMT

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

Re: itab

Former Member — Fri, 27 Apr 2007 09:30:16 GMT

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

Re: itab

Former Member — Fri, 27 Apr 2007 09:30:38 GMT

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

Re: itab

Former Member — Fri, 27 Apr 2007 09:30:58 GMT

hi,

syntax:

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

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

regards,

Navneeth.K

Re: itab

Former Member — Fri, 27 Apr 2007 09:34:00 GMT

hi,

DELETE ADJACENT DUPLICATES FROM itab COMPARING <field1> <field2

Regards,

Prasad

Re: itab

jayanthi_jayaraman — Fri, 27 Apr 2007 09:38:57 GMT

Hi,

delete adjacent duplicates from itab comparing all fields.

Re: itab

Former Member — Fri, 27 Apr 2007 15:57:49 GMT

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