Select Query

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi,

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

or use into corresponding fields

regards

Shiva

[Former Member]

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 ).

[Former Member]

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.

[Former Member]

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.

[Former Member]

hi

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

[Former Member]

Hi,

have you compared the fileds of itab and in select

make both of them as same tyep

they must be same

Thanks

Shiva

[Former Member]

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.

[Former Member]

Hi

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

[Former Member]

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.