Skip to Content
Former Member
Oct 19, 2007 at 08:03 PM

Select statement


Hi gurus,

I have a condition where I have an internal table it_tab1 and it_tab1 has material number and price, now I passes this material no. into marc to get the plan information of the corresponding material and for this I have written this code:

select werks matnr from it_tab1 into table it_tab2

from marc

where matnr = it_tab1-matnr.

is this statment right?

and now I need to create one more internal table that will have three fields matnr, price and werks and now I need to join it_tab1 and it_tab2 to get price, matnr and werks in my third internal table.

can you please help me out to do this.



Message was edited by:

Rajeev Gupta