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
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: