Skip to Content
0
Former Member
Aug 11, 2005 at 08:51 PM

Problem in fetching values from different tables in internal table

66 Views

Hi,

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.

tables: RESB.

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>

Tushar