Skip to Content
0
Former Member
Dec 15, 2008 at 03:14 AM

Inner Join with Internal Table

9884 Views

Hi Abapers,

can we have the Join (Inner Join) between database table and internal table? this the scenario:

Internal table A (ITA)

rsnum material

1111 xxxx

2222 yyyy

3333 zzzz

Database Table B (DB)

rsnum qty

1111 3

2222 4

4444 7

6666 3

Expected Final Answer - internal table B (ITB)

rsnum material qty

1111 xxxx 3

2222 yyyy 4

can we something like this:

select *

from DB

into coressponding table of ITB

Inner join ITA on DBrsnum = ITArsnum

where DB~qty > 0.