Skip to Content
0
Former Member
Jan 13, 2008 at 06:46 PM

Inner join

29 Views

Hi Guys I am trying to learn Inner join and I have written the following code...can you please tell me what I am doing wrong:

REPORT ZMM_DETAIL.

data: begin of it_mara occurs 0,

matnr like mara-matnr,

matkl like mara-matkl,

mtart like mara-mtart,

end of it_mara.

data: begin of it_marc occurs 0,

matnr like marc-matnr,

werks like marc-werks,

ekgrp like marc-ekgrp,

end of it_marc.

select mara-matnr mara-matkl mara-mtart marc-werks marc-ekgrp

into table it_mara

from mara

inner join marc on marc-matnr eq mara-matnr and mara-mtart eq 'HALB'.

what I am trying to achieve is list the plant number, plannng grup foe all those materials where mtart =

HALB

Thanks,

Rajeev