Skip to Content
0
Former Member
Dec 22, 2007 at 07:54 AM

joins

23 Views

Hi all,

In a report program i have used a inner join. I am getting error in the where condition. Here I have furnished part of my code for ur reference.

Tables : mara, makt, mard.

data : begin of itab occurs 0,

matnr like mara-matnr,

maktx like makt-maktx,

lgort like mard-lgort,

labst like mard-labst,

end of itab.

parameters : matnr like mara-matnr.

start-of-selection.

select maramatnr maktmaktx mardlgort mardlabst into corresponding fields of iab from mara inner join maktx on maramatnr = maktmatnr inner join mard on maktmatnr = mardmatnr where matnr eq matnr.

  • in the where condition I am getting the following error message.

matnr has two meanings in data dictionary.

Please help me in sort out this problem and also tell me more abt inner joins.