topic Re: Syntax error in select statement in Application Development and Automation Discussions

Syntax error in select statement

Former Member — Wed, 26 Aug 2009 11:46:04 GMT

This is the select statement it's giving syntax error,

Lesen Überschrifttabellen -------------------------------------------*

SELECT SINGLE * FROM T166U WHERE SPRAS EQ EKKO-SPRAS

AND DRUVO EQ XDRUVO

AND BSTYP EQ EKKO-BSTYP

AND BSART EQ EKKO-BSART.

How come it's not giving syntax error in production but it's giving in development server. Please help me with this.

Re: Syntax error in select statement

Former Member — Wed, 26 Aug 2009 12:03:39 GMT

Hi,

Is it giving error for destination field not given.

Is else, tell me the error.

Regards

Krunal Raichura

Re: Syntax error in select statement

Former Member — Wed, 26 Aug 2009 12:18:15 GMT

When I try to activate it gives Syntax error says ' The INTO clause is missing at SELECT, OR the From addition at either DELETE INSERT, UPDATE, MODIFY is missing.

Re: Syntax error in select statement

Former Member — Wed, 26 Aug 2009 12:22:41 GMT

Hi Thanvi

After fetching the data from database table,what do you want to do ?

do you want to do some operations ?

are you wnat the data to internal table?

SELECT SINGLE * FROM T166U into <workarea> WHERE SPRAS EQ EKKO-SPRAS

AND DRUVO EQ XDRUVO

AND BSTYP EQ EKKO-BSTYP

AND BSART EQ EKKO-BSART.

Edited by: Tulasi Palnati on Aug 26, 2009 2:51 PM

Re: Syntax error in select statement

Former Member — Wed, 26 Aug 2009 13:06:17 GMT

Hello

Declare table T166U and error will disappear.


tables: T166U.

Re: Syntax error in select statement

Former Member — Wed, 26 Aug 2009 18:17:04 GMT


>   SELECT SINGLE * FROM T166U WHERE SPRAS EQ EKKO-SPRAS
>                              AND   DRUVO EQ XDRUVO
>                              AND   BSTYP EQ EKKO-BSTYP
>                              AND   BSART EQ EKKO-BSART.
>

select single needs a into clause, as the table T166U would not have been declared as : TABLES : T166U.

but this is obsolete now. so..

data: gs_t166u type t116u.

SELECT SINGLE * FROM T166U
                              INTO  gs_t166u "add this
                          WHERE  SPRAS EQ EKKO-SPRAS
                              AND   DRUVO EQ XDRUVO
                              AND   BSTYP EQ EKKO-BSTYP
                              AND   BSART EQ EKKO-BSART.


> How come it's not giving syntax error in production but it's giving in development server. Please help me with this.

compare the code between(in version management) and check if those two are same or not.

Re: Syntax error in select statement

venkat_o — Thu, 27 Aug 2009 02:38:08 GMT

Hi Thanvi, Try this way.


TABLES:t166u. " If you declare like this, it is not needed to use INTO clause in select query
SELECT SINGLE *
  FROM t166u
 WHERE spras EQ ekko-spras
   AND druvo EQ xdruvo
   AND bstyp EQ ekko-bstyp
   AND bsart EQ ekko-bsart.

Thanks Venkat.O

Re: Syntax error in select statement

Former Member — Thu, 27 Aug 2009 05:24:33 GMT

Hi ,

U Declare the Table name:

Tables: T166U

Hope its useful.

Regards,

Shankar Gj

Re: Syntax error in select statement

Former Member — Thu, 27 Aug 2009 06:29:00 GMT

cross check the where condition.

there is no data element called XDRUVO.

it shopuld be DRUVO

Re: Syntax error in select statement

Former Member — Thu, 27 Aug 2009 12:05:04 GMT

HI,

The error might occur bcoz there is not "Into" clause na. You are selecting only one row na, So you can use Workarea in the palce of internal table andthat work area name can be specified in that "Into" clause. This will clear problem. Ans also check whether you have specfied the tables.

Regards,

Dhanalakshmi L

Re: Syntax error in select statement

Former Member — Thu, 27 Aug 2009 12:06:40 GMT

HI,

Regards,

Dhanalakshmi L

Re: Syntax error in select statement

sivakrishna_boddapati — Thu, 22 Oct 2009 10:28:35 GMT

hi,

if u select multiple rows then you put a internal table ,

if u select single row from data base u must put a work area , why should u get the data from the data base due to some modifications so it says errors like modify update ,change,insert

select * into table <itab> from <database table>condition.

select * into <WA_itab> from <database table > condition.