I am trying to create an internal table with five fields,
viz. <b>SHKZG, POSNR, BDMNG, MATNR</b> from table RESB and <b>MAKTX</b> from table MAKT.
data: begin of iresb occurs 100,
SHKZG like resb-SHKZG,
posnr like resb-posnr,
BDMNG like resb-BDMNG,
GMATNR like RESB-MATNR,
MAKTX like MAKT-MAKTX,
end of iresb.
SELECT <b>SHKZG POSNR BDMNG MATNR</b> into corresponding fields of table iresb from resb where aufnr = X.
Now I have to also add field MAKTX from MAKT table in my internal table apart from <b>above four fields</b>
How do I do this ? (MATNR field is common in RESB and MAKT)
<b>I tried doing following:</b>
SELECT MAKTX into corresponding fields of TABLE IRESB from MAKT inner join RESB on MAKTMATNR = RESBMATNR
where aufnr = X.
<b>But then it does not correspond properly to other four fields.</b>