Dynamic internal tables

Former Member — Wed, 09 May 2007 14:08:17 GMT

Dear All,

The problem I am stuck in is that -

> I have two internal tables

IT1 with two fields table1 (say, MARA) and field1 (say, MATNR)

and IT2 with two fields table2 (say, MARC) and field2 (say, MATNR)

Now, I want to match whether Field1 = Field2.

Now the Select query , probably using inner join needs to fetch data

but I am confused how shall I write the Select query.

Plz help.................

Re: Dynamic internal tables

Former Member — Wed, 09 May 2007 15:05:23 GMT

SELECT mara~matnr

FROM mara

INNER JOIN marc

ON marc_{matnr = mara}matnr

WHERE..

Sudha