topic Re: Error in query in Application Development and Automation Discussions

Error in query

Former Member — Tue, 18 Jul 2006 23:53:42 GMT

Hi,

I am using following code.

event handler for data retrieval

select VENUM VBELN POSNR FROM VEPO into corresponding fields of table T_VEPO

WHERE VBELN = delnumber

AND POSNR = delitemnumber

order by VENUM.

endselect.

I get following error message:

Incorrect nesting: For the statement "ENDSEELCT", there is no open structure introduced by "SELECT".

Please guide me

Re: Error in query

former_member186741 — Wed, 19 Jul 2006 00:10:20 GMT

ENDSELECT IS NOT REQUIRED FOR INTO TABLE SELECTS.

Please mark the topic as closed and award the points.

Re: Error in query

Former Member — Wed, 19 Jul 2006 03:46:57 GMT

As Neil has mentioned, the endselect statement is used only when selecting data from the database into a structure or work area.

In the case you have shown, you are selecting the data into an internal table and hence Endselect is not required.

Re: Error in query

Former Member — Wed, 19 Jul 2006 04:11:58 GMT

select VENUM VBELN POSNR FROM VEPO into corresponding fields of table T_VEPO

WHERE VBELN = delnumber

AND POSNR = delitemnumber

order by VENUM.

<b>endselect.</b>-----> not required.

if u used FOR INTO TABLE SELECTS than end select is not required.

Re: Error in query

Former Member — Wed, 19 Jul 2006 04:12:40 GMT

good

write like this

wrong->

select VENUM VBELN POSNR FROM VEPO into corresponding fields of table T_VEPO

WHERE VBELN = delnumber

AND POSNR = delitemnumber

order by VENUM.

endselect.

right->

select VENUM VBELN POSNR FROM VEPO into corresponding fields of table T_VEPO

WHERE VBELN = delnumber

AND POSNR = delitemnumber

order by VENUM.

thanks

mrutyun

Re: Error in query

Former Member — Wed, 19 Jul 2006 04:38:35 GMT

in this case endselect is not required.

if u use 'INTO table' then Endselect is required.

Naveen