Error in the module RSQL accessing the database interface

[Former Member]

I have written the following query.

SELECT a~no

a~hist_no

a~chk_stat

a~chk_date

a~user as chk_user

b~name as chk_by

into corresponding fields of table hist

from zhist as a INNER JOIN zuser as b on

a_{user = b}bname

where pspnr = v_pspnr

and chk_no = v_chk_no.

I am getting the dump "Error in the module RSQL accessing the database interface".

Please provide me the solution.

Thanx,

Selva.

[Former Member]

Hi,

As i have analysed your query in that you are putting the data in the internal table 'hist' which is also a standard structure and if you check in SE11 'hist' is the standard structure for 'Tablespace History' and might be because of that it is causing the problem.

Kindly check by changing the name of the internal table to tt_hist and then try.

I think that will solve the problem.

Regards,

Harsh Goel

[Former Member]

resolved