Syntax Error!

[Former Member]

Hi,

i had written the code as follows:

loop at it_rkwa.

select ekorg ekgrp

from eine as a

inner join eine as b on a_{infnr = b}infnr

where

matnr = it_rkwa-matnr_rkwa

and lifnr = it_rkwa-lifnr_rkwa.

endif.

append it_rkwa.

clear it_rkwa.

endloop.

when i check it for syntax for consistency it throws me the following error:

"the column name 'EKORG ' has two meanings: ABAP/4 open SQL statement "

Can any body here tell me what could be the problem?

Thanks,

Ravi

[Former Member]

You are doing an INNER JOIN on the same table

from eine as a

inner join eine as b

INNER JOINs are for joining different tables not the same table.

[Former Member]

loop at it_rkwa.

select <b>a_{ekorg a}ekgrp</b>

from eine as a

inner join eine as b on a_{infnr = b}infnr

where

matnr = it_rkwa-matnr_rkwa

and lifnr = it_rkwa-lifnr_rkwa.

endif.

append it_rkwa.

clear it_rkwa.

endloop.

Please modify the code in the high lighted part.

Regards,

Pavan

[RichHeilman]

Make sure you use the labels for the fields in the field list.

select a~ekorg a~ekgrp     "<--  RIGHT HERE
from eine as a
inner join eine as b on a~infnr = b~infnr
where
matnr = it_rkwa-matnr_rkwa
and lifnr = it_rkwa-lifnr_rkwa.

Regards,

Rich Heilman

[Former Member]

Re-write your code as below.

if not it_rkwa[] is initial.
select ekorg ekgrp
from eine 
into corresponding fields of table it_rkwa2
for all entries in it_rkwa
where matnr = it_rkwa-matnr_rkwa
and lifnr = it_rkwa-lifnr_rkwa.
endif.

Please mark points if the solution was useful.

Regards,

Manoj

[Former Member]

Hi,

Check this link....

change u r select according to that..

reward if it helps..

regards,

Omakr.

[Former Member]

Hi,

y r u joining the same table...??

We will generally get that error because when we are joining two tables and writing a condition on particular field which is PRESENT in both the tables then it will be giving that error. To avoid that we can use the Aliases i.e

select a_{ekorg a}ekgrp ... .

if it helps dont forget the REWARD.

rgds

harris

[Former Member]

Hi,

eine inner join eine is meaning less.use like this.

select ekorg ekgrp into wa from eine where where

matnr = it_rkwa-matnr_rkwa

and lifnr = it_rkwa-lifnr_rkwa.

endselect.

rgds,

bharat.