topic Re: syntax error in Application Development and Automation Discussions

syntax error

Former Member — Mon, 25 Feb 2008 15:35:17 GMT

Hi,

I am working on report.

while using innerjoin i am getting error like

"The column name "EBELN" has two meanings.ABAP/4 OPEN SQL statement.

my code is

SELECT a_{ebeln a}bsart a_{ekgrp a}bedat a~waers

a_{ekorg a}lifnr a_{reswk b}ebelp b~matnr

b_{txz01 b}matkl

b_{loekz b}pstyp b_{knttp b}werks

b_{lgort b}menge b_{meins b}netpr

b_{peinh b}bednr b_{banfn b}bnfpo

c_{menge c}wemng c~eindt

FROM ( ( ekko AS a

INNER JOIN ekpo AS b ON a_{ebeln = b}ebeln )

INNER JOIN eket AS c ON a_{ebeln = c}ebeln AND

b_{ebelp = c}ebelp )

INTO TABLE it_orders

WHERE ebeln IN s_ebeln AND

ekorg IN s_ekorg AND

bsart IN s_bsart AND

ekgrp IN s_ekgrp AND

bedat IN s_bedat AND

lifnr IN s_lifnr AND

ebeln IN s_ebeln AND

werks IN s_werks AND

pstyp IN s_pstyp AND

knttp IN s_knttp AND

matnr IN s_matnr AND

txz01 IN s_txz01 AND

matkl IN s_matkl AND

bednr IN s_bednr AND

elikz EQ space. "AND

loekz EQ space.

please solve my problem SSM.

Aruna

Re: syntax error

Former Member — Mon, 25 Feb 2008 15:38:16 GMT


SELECT a~ebeln a~bsart a~ekgrp a~bedat a~waers
a~ekorg a~lifnr a~reswk b~ebelp b~matnr
b~txz01 b~matkl
b~loekz b~pstyp b~knttp b~werks
b~lgort b~menge b~meins b~netpr
b~peinh b~bednr b~banfn b~bnfpo
c~menge c~wemng c~eindt
FROM ( ( ekko AS a
INNER JOIN ekpo AS b ON a~ebeln = b~ebeln )
INNER JOIN eket AS c ON a~ebeln = c~ebeln AND
b~ebelp = c~ebelp )
INTO TABLE it_orders
WHERE ebeln IN s_ebeln AND
ekorg IN s_ekorg AND
bsart IN s_bsart AND
ekgrp IN s_ekgrp AND
* bedat IN s_bedat AND
lifnr IN s_lifnr AND
a~ebeln IN s_ebeln AND
werks IN s_werks AND
pstyp IN s_pstyp AND
knttp IN s_knttp AND
matnr IN s_matnr AND
txz01 IN s_txz01 AND
matkl IN s_matkl AND
bednr IN s_bednr AND
elikz EQ space. "AND
* loekz EQ space.

It must be like a~ebeln

Greeting,

Blag.

Re: syntax error

Former Member — Mon, 25 Feb 2008 15:39:00 GMT

EBELN exists on more that one table so the error is stating that the sql does not know which table to you.

You need to do this.

Where a~ebeln eq .....

Re: syntax error

Former Member — Mon, 25 Feb 2008 15:39:18 GMT

Hello,

Make the change like this.


SELECT a~ebeln a~bsart a~ekgrp a~bedat a~waers
a~ekorg a~lifnr a~reswk b~ebelp b~matnr
b~txz01 b~matkl
b~loekz b~pstyp b~knttp b~werks
b~lgort b~menge b~meins b~netpr
b~peinh b~bednr b~banfn b~bnfpo
c~menge c~wemng c~eindt
FROM ( ( ekko AS a
INNER JOIN ekpo AS b ON a~ebeln = b~ebeln )
INNER JOIN eket AS c ON a~ebeln = c~ebeln AND
b~ebelp = c~ebelp )
INTO TABLE it_orders
WHERE a~ebeln IN s_ebeln AND
a~ekorg IN s_ekorg AND
a~bsart IN s_bsart AND
a~ekgrp IN s_ekgrp AND
* bedat IN s_bedat AND
lifnr IN s_lifnr AND
* ebeln IN s_ebeln AND
b~werks IN s_werks AND
b~pstyp IN s_pstyp AND
b~knttp IN s_knttp AND
b~matnr IN s_matnr AND
b~txz01 IN s_txz01 AND
b~matkl IN s_matkl AND
b~bednr IN s_bednr AND
b~elikz EQ space. "AND
* loekz EQ space.

Cheers,

Vasanth

Re: syntax error

Former Member — Mon, 25 Feb 2008 15:39:30 GMT


SELECT a~ebeln a~bsart a~ekgrp a~bedat a~waers
a~ekorg a~lifnr a~reswk b~ebelp b~matnr
b~txz01 b~matkl
b~loekz b~pstyp b~knttp b~werks
b~lgort b~menge b~meins b~netpr
b~peinh b~bednr b~banfn b~bnfpo
c~menge c~wemng c~eindt
FROM ( ( ekko AS a
INNER JOIN ekpo AS b ON a~ebeln = b~ebeln )
INNER JOIN eket AS c ON a~ebeln = c~ebeln AND
b~ebelp = c~ebelp )
INTO TABLE it_orders
WHERE a~ebeln IN s_ebeln AND
a~ekorg IN s_ekorg AND
a~bsart IN s_bsart AND
a~ekgrp IN s_ekgrp AND
* bedat IN s_bedat AND
a~lifnr IN s_lifnr AND
* ebeln IN s_ebeln AND
b~werks IN s_werks AND
b~pstyp IN s_pstyp AND
b~knttp IN s_knttp AND
b~matnr IN s_matnr AND
b~txz01 IN s_txz01 AND
b~matkl IN s_matkl AND
b~bednr IN s_bednr AND
elikz EQ space. "AND
* loekz EQ space.

You forgot to add wich table belongs each field in the where condition

Re: syntax error

Former Member — Mon, 25 Feb 2008 15:56:15 GMT

in the where condition specify as a~ebeln.

regards,

venkat.