topic select statment error in Application Development and Automation Discussions

select statment error

Former Member — Wed, 07 Oct 2009 08:12:53 GMT

All experts,

i got a problem in select statment about this,

select count( * ) into var-verno from nast

where objky = nast-objky

and kschl = nast-kschl

and aende = 'X'.

in Dev system, it works well, but in QAS, it get long time to run this, and then got errors, can ervery one tell thow deal with this, thanks.

Re: select statment error

Former Member — Wed, 07 Oct 2009 08:20:40 GMT

Hi,

What value does nast-objky and nast-kschl hold in the where conditions of the select? Are you populating any value in those before the select? Else it would just take them as blank values and try to get the count of the table records whose aende = 'X' which is not a primary key. That must be the reason why its taking long time in QAS

Vikranth

Re: select statment error

Former Member — Wed, 07 Oct 2009 08:28:16 GMT

hi,

both the conditions get values, and i also tested them in database nast by SE11, it can select value from database.

i don not know why it can not select value in this select.

is it the database config error, or others?

Re: select statment error

Former Member — Wed, 07 Oct 2009 08:30:33 GMT

This message was moderated.

Re: select statment error

Former Member — Wed, 07 Oct 2009 08:40:30 GMT

venkat,

please test ONCE at least if your code is giving syntax error or not. ( count can be added with fieldnames only with come only with DISTINCT.

kevin,

dev server has very less data. so you can get it in small time... but in QR or PRD you have too much data.. so that takes time.. and might giving you dump for this

'time out error' - is it so??

do one thing..

select * from nast into table gt_nast "gt_nast is a standard table of type nast
where objky = nast-objky
and kschl = nast-kschl. " i have removed aende.
if sy-subrc = 0.
   delete gt_nast where aende NE 'X'. " deleted  not required entries
   describle table gt_nast lines var-verno.
endif.

Re: select statment error

Former Member — Wed, 07 Oct 2009 08:47:34 GMT

yes, it got time out errors,

i will try this, tks.