Delete same records.

[Former Member]

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

[kesavadas_thekkillath]

do enddo.

while endwhile....???

[Former Member]

Hi!

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

Cheers!

[Former Member]

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.

[Former Member]

Hi,

Use like this..

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

[Former Member]

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

[kesavadas_thekkillath]

Done !!!!!

[Former Member]

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

[Former Member]

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

[Former Member]

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