Skip to Content
0
Former Member
Feb 18, 2011 at 02:03 PM

Help with Joins in ABAP

22 Views

Hello Experts,

I am struggling with a problem.

In my development I have two db tables for eg. Table A and Table B.

Now table A has about 200,000 entries and table B has about 800,000 entries.

I want to delete all the extra entries (junk entries-not present in A but present in B) from table B on the basis of one field that is common between them

i.e. All the entries for whom 'A-field NE B-field'

Now i tried using internal tables but the loop execution is taking forever.

And I tried using a Select query for all entries:

SELECT *

FROM B

INTO TABLE itab_B

FOR ALL ENTRIES IN itab_A

WHERE field EQ itab_A-field.

This query gives me the records which are present in both tables.

But if I try to change the 'where' condition to 'NE' it does not work.

Is there any join statement to meet my requirement?

Thanks in Advance

Omkar