topic Re: Syntax error regarding table in Application Development and Automation Discussions

Syntax error regarding table

Former Member — Thu, 15 May 2008 13:43:24 GMT

Hi Gurus,

I am working on a select statement, initially I have wriiten a select statement using the inner joins but then we had some performance issues and I have advised not to use joins...and after that I have written the following statement:

select:

mara~matnr

mara~means

mara~mtart

marc~werks

mard~lgort

from

mara as mara,

mard as mard,

marc as marc

where

(mara_{matnr = mard}matnr) and (marc_{matnr = mard}matnr) and (marc_{werks = mard}werks).

but when I am executing this stattement it's iving me an error :

Wrong table name or table alias name table alias name "VBSEGS". table

can you please tell me how make it right

Re: Syntax error regarding table

Former Member — Thu, 15 May 2008 13:50:51 GMT

the syntax you are using is still assuming you want a join because you are trying to get from multiple tables.

If you want to do this without joins, you will need to do your first select into an Internal Table, then do the second select

using values from the 1st table, and repeat for 3rd.

See syntax for SELECT ... FOR ALL ENTRIES IN

Re: Syntax error regarding table

Former Member — Thu, 15 May 2008 13:55:46 GMT

Hi,

Instead of giving the join conditions in the WHERE addition give it in the ON addition.

for example:

select mara_{matnr makt}maktx

from mara inner join makt

on mara_{matnr = makt}matnr.

endselect.

Regards

Naren

Re: Syntax error regarding table

Adi_Bathineni — Thu, 15 May 2008 14:00:52 GMT

Instead of using select statment in your way, use for all entries to get the data from differnet tables.

Ex: MARA, MARC and MARD are Table

Select Matnr Maktx from mara into table itab1 where matnr = '1234'.

select x y from mard into table itab2 for all entries in itab1 where matnr = itab1-matnr.

same thing follows for the 3rd tale also.

Regards,

Adi

Re: Syntax error regarding table

Former Member — Thu, 15 May 2008 14:02:32 GMT

The above selection logic is also an inner join...break them into three SELECT statements using FOR ALL ENTRIES statement. Also there is some error as you have not provided the join condition using ON statement.