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