topic Re: Delete same records. in Application Development and Automation Discussions

Delete same records.

Former Member — Tue, 11 Nov 2008 09:11:33 GMT

hi expert,

i have a requirment that i need to delete same records from two internal table without using LOOP statement..

so plz help me in solving this query.

thanks

Re: Delete same records.

kesavadas_thekkillath — Tue, 11 Nov 2008 09:14:03 GMT

do enddo.

while endwhile....???

Re: Delete same records.

Former Member — Tue, 11 Nov 2008 09:14:31 GMT

Hi!

Use a DELETE statement with a WHERE clause for both the internal tables.

Cheers!

Re: Delete same records.

Former Member — Tue, 11 Nov 2008 09:14:51 GMT

You can use one loop statement.

loop at itab1.

read table itab2 with key [[ur condition]].

if sy-subrc = 0. "If condition satisfied

delete itab1 index sy-tabix.

endif.

clear: itab1,itab2.

endloop.

Regards,

Aparna.

Re: Delete same records.

Former Member — Tue, 11 Nov 2008 09:17:16 GMT

Hi,

Use like this..


SORT itab by fieldname.
DELETE ADJACENT DUPLICATES FROM itab COMPARING fieldname1 fieldname2

Re: Delete same records.

Former Member — Tue, 11 Nov 2008 09:17:44 GMT

If both the internal tables are of same structure you can try as;

APPEND LINES OF itab1 TO itab2.
SORT itab2 BY col1 col2.
DELETE ADJACENT DUPLICATES FROM itab2 COMPARING col1 col2.

Using the above logic will solve your problem.

Regards

Karthik D

Re: Delete same records.

kesavadas_thekkillath — Tue, 11 Nov 2008 09:23:26 GMT

Done !!!!!

Re: Delete same records.

Former Member — Tue, 11 Nov 2008 09:31:25 GMT

hi i dont need to move the records from one table to another table.

Re: Delete same records.

Former Member — Tue, 11 Nov 2008 09:46:47 GMT

Hi,

Try out this.

Declare the internal table of sorted type with unique key.

Doing this it will not fetch duplicate records hence no need to delete.

Hope this helps you out.

Thanks & Regards

Re: Delete same records.

Former Member — Tue, 11 Nov 2008 09:48:10 GMT

Anyhow you want to delete the duplicate records, then do you think its possible without using LOOP as well as moving records to one table.

May we ask the reason for not using the LOOP and moving of records to one itab.

Also list what are the Dont's that are too be considered while giving you a solution.

Regards

Karthik D