topic Select Query in Application Development and Automation Discussions

Select Query

Former Member — Thu, 01 Feb 2007 11:25:19 GMT

Hi,

please tell me the error in select query below, it results in a DUMP

with message "Error in the module RSQL accessing the database interface"

SELECT IDOCNUM

ORDNUM

SENDER

ZDATE

TIME

ZUSER

STATUS

STATUSDATE

STATUSTIME

STATUSUSER

REJECTREASON

PONUMBER

FROM zv7_custord INTO TABLE G_T_ZV7_CUSTORD

WHERE ( SENDER in S_SENDER and

ORDNUM in S_ORDER and

ZDATE in S_DATE ) OR

( SENDER in S_SENDER AND

STATUS = SPACE ).

Note i cannot use ENDSELECT .

Thanks in Advance

Bijal

Re: Select Query

Former Member — Thu, 01 Feb 2007 11:26:49 GMT

SELECT IDOCNUM

ORDNUM

SENDER

ZDATE

TIME

ZUSER

STATUS

STATUSDATE

STATUSTIME

STATUSUSER

REJECTREASON

PONUMBER

FROM zv7_custord INTO corresponding fields of TABLE G_T_ZV7_CUSTORD

WHERE ( SENDER in S_SENDER and

ORDNUM in S_ORDER and

ZDATE in S_DATE ) OR

( SENDER in S_SENDER AND

STATUS = SPACE ).

trry corresponding fields

regards

shiba dutta

Re: Select Query

Former Member — Thu, 01 Feb 2007 11:27:35 GMT

This is a generic error which occurs due to non availability of database table.

This situation can arise due to high load on server or due to large number of application accessing the table.

Re: Select Query

Former Member — Thu, 01 Feb 2007 11:28:44 GMT

Hi,

in select align the fields as they are in the ITAB.

or use into corresponding fields

regards

Shiva

Re: Select Query

Former Member — Thu, 01 Feb 2007 11:29:31 GMT

can you show the structure of G_T_ZV7_CUSTORD , does it contain all the fields mentioned int the select statement, if not

use INTO CORRESPONDING FIELDS OF

SELECT IDOCNUM

ORDNUM

SENDER

ZDATE

TIME

ZUSER

STATUS

STATUSDATE

STATUSTIME

STATUSUSER

REJECTREASON

PONUMBER

FROM zv7_custord <b>INTO CORRESPONDING FIELDS OF</b> TABLE G_T_ZV7_CUSTORD

WHERE ( SENDER in S_SENDER and

ORDNUM in S_ORDER and

ZDATE in S_DATE ) OR

( SENDER in S_SENDER AND

STATUS = SPACE ).

Re: Select Query

Former Member — Thu, 01 Feb 2007 11:31:39 GMT

Bijal,

Check if you can see data using transaction SE16. It will make clear if your application server can communicate to the Database server.

Your code is perfectly fine.

Re: Select Query

Former Member — Thu, 01 Feb 2007 11:32:25 GMT

this is a generic error. try using <b>INTO corresponding fields of TABLE</b>...also, this error comes sometimes only due to high process and lack of system resources. try to execute a couple of times and this error goes off when the system resources are available.

Re: Select Query

Former Member — Thu, 01 Feb 2007 11:35:03 GMT

i am sorry i did not provide complete details,

my problem is i cannot use INTO CORRESPONDING , due to coding stds,

But i can veiw table data thru SE16,

so is this still Server problem

Thanks

Re: Select Query

Former Member — Thu, 01 Feb 2007 11:37:02 GMT

Hi,

have you compared the fileds of itab and in select

make both of them as same tyep

they must be same

Thanks

Shiva

Re: Select Query

Former Member — Thu, 01 Feb 2007 11:42:35 GMT

hi,

Note its a DB table that only i am using it,

and also its the first Query in the report,

structure of both are same.

Re: Select Query

Former Member — Thu, 01 Feb 2007 11:48:01 GMT

I tested the same

i also got the same error 'Error in RSQL module of database interface.'

data : begin of it_mara1 occurs 0,

matnr like mara-matnr,

meins like mara-meins,

BLANZ like mara-BLANZ,

end of it_mara1.

select

matnr

blanz

meins

from mara

into table it_mara1

up to 100 rows.

this report is generating the dump with above error.

Regards

Shiva

Re: Select Query

Former Member — Thu, 01 Feb 2007 12:05:14 GMT

Hi Shiva,

The order of the fields is the problem in you case.

Please check with this code.

REPORT yalv_demop2 .

DATA : BEGIN OF it_mara1 OCCURS 0,

matnr LIKE mara-matnr,

meins LIKE mara-meins,

blanz LIKE mara-blanz,

END OF it_mara1.

SELECT

matnr

meins

blanz

FROM mara

INTO TABLE it_mara1

UP TO 100 ROWS.

Bijal : Please try with a similar select statement as shown below.

select single zzrshc zzrsdc into (i_results-zzrshc,

i_results-zzrsdc)

from vbak

where vbeln eq vbfa-vbelv.

regards,

Priya.