Error in query

[Former Member]

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

[former_member186741]

ENDSELECT IS NOT REQUIRED FOR INTO TABLE SELECTS.

Please mark the topic as closed and award the points.

[Former Member]

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.

[Former Member]

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.

[Former Member]

hi

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

[Former Member]

hi

in this case endselect is not required.

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

Naveen