topic Re: Delete duplicate database entries in Application Development and Automation Discussions

Delete duplicate database entries

Former Member — Wed, 19 Oct 2011 10:44:38 GMT

Hi,

I would like to know if there is any special command to delete entries from one database that already exist in another. I've already implemented it selecting the table keys from one database into an internal table and deleting this entries in the other database using the internal table referred. Eventhough, I would like to know if there's a better solution to do that that can prevent me from having a huge internal table.

Best regards,

Nuno Barros

Re: Delete duplicate database entries

Former Member — Wed, 19 Oct 2011 10:53:10 GMT

No I don't think so ..Any special command through which you can compare two tables data in open sql statements.

Thanx.

Regards

Bibek

Re: Delete duplicate database entries

former_member332275 — Wed, 19 Oct 2011 12:38:22 GMT

I don't think that there's another way than going the way via internal tables. But function module RS_VERS_COMPARE_TAB will help to compare both tables, so that you don't have to read every single key.

Regards

Nicola

Re: Delete duplicate database entries

Former Member — Wed, 19 Oct 2011 13:51:54 GMT

Hi,

You could already use an inner join select on both table. This will result in all entries in table 2 that are present in table 1.

Then you would just have to use a delete table2 from table itab...No loop needed here.

Kr,

Manu