topic Re: Sort before delete adjacent in Application Development and Automation Discussions

Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:22:18 GMT

Hi,

I have a requirement for delete adjacent records,

DELETE ADJACENT DUPLICATES FROM IT_OPSALES COMPARING BUKRS ENAME NAME1 BSTKD VBELN AUDAT POSNR MATNR .

Is it mandatory to sort internal table before delete adjacent ??

regards

Mark

Re: Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:23:06 GMT

Hi Mark,

It is very compulsory to sort the table when you use the statement DELETE ADJACENT DUPLICATES. Because it checks if the adjacent record is similar . If it is similar it will delete else it will not delete. So it is compulsory to sort in order to get the appropriate output.

Regards,

Swapna.

Re: Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:23:41 GMT

hi,

Yes sort it on BUKRS ENAME NAME1 BSTKD VBELN AUDAT POSNR MATNR fields ...

i.e,


sort IT_OPSALES  by BUKRS ENAME NAME1 BSTKD VBELN AUDAT POSNR MATNR.

Re: Sort before delete adjacent

bpawanchand — Wed, 30 Jul 2008 06:24:08 GMT

Yes it is Mandatory to sort the internal table because as soon as you sort the Table all the SAME entries come Adjacent to each other so there after your statement works properly

Regards

Pavan

Re: Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:24:13 GMT

Hi,

Yes , It is mandetory.

For detail please check

http://help.sap.com/saphelp_nw04/Helpdata/EN/06/aafd54fc4011d195280000e8353423/content.htm

Regards,

Anirban

Re: Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:25:15 GMT

Hi Mark,

Yes Mark, it always better to SORT the internal table before you use DELETE ADJECENT DUPLICATES..

Best regards,

raam

Re: Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:26:02 GMT

Hi,

yes sorting is mandatory.

after sorting only u can do the delete adjacent duplicates.

when we sort all the data which are same come one after one so u can delete the adjacent duplicate data.

Re: Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:27:36 GMT

Hi,

After selecting the data into internal table. first we have to sort that internal table and use delete adjacent.

example:

select * from zse_role into itab_role.

sort itab_role by i_rolecd.

delete adjacent duplicates from itab_role.

Cheers,

vasavi.v

Re: Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:28:16 GMT

Hi,

Yes Mark, It is mandatory to sort before deleting adjacent records, or else the system compares only with adjacent records. If the adjacent is not found as same ,it wont be deleted. At the end of all, the duplicate will still exists after deletion.

regards

Jijo

Re: Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:30:33 GMT

Hi Mark,

You need to definitely SORT before using DELETE ADJACENT DUPLICATES

As you are using COMPARING in delete with some fields you need to SORT the table with those fields.

Regards,

Chandra Sekhar

Re: Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:31:34 GMT

let us we have an table with following record in itab1

F1 F2 F3 F4

a b c d

c x y z

a b d e

c x y h

now here if i apply

DELETE ADJACENT DUPLICATES FROM ITAB1 COMPARING F1 F2 .

here no record wil be deleteted

but if u sort the itab1

and then apply

DELETE ADJACENT DUPLICATES FROM ITAB1 COMPARING F1 F2 .

u have only two record

spo it is always recomended to apply sort defore delete adjacent

Cheers

Snehi

Re: Sort before delete adjacent

Former Member — Wed, 30 Jul 2008 06:33:09 GMT

as all have said you should always sort the internal table before using DELETE ADJACENT DUPLICATES, as otherwise you may not get the appropriate result you want, if the table is not sorted then after using DELETE ADJACENT DUPLICATES also there might be duplicate records left, so to be sure that all the duplicate records have been deleted you should use sort.

With regards,

Pritam