Skip to Content
0
Former Member
Jul 18, 2007 at 11:03 AM

program ended in dump-DBIF_RSQL_INVALID_RSQL

26 Views

hi all,

I have a problem and I am nt able to solve it, I have defined a table type zitem1 with line type zitem_line1.

it has five elements matnr postp posnr bdmng and meins, now i have written a small piece of code,

data itab type zitem1.

data temp_rsnum like resb-rsnum.

select single rsnum from afko into temp_rsnum

where aufnr '380000000021'.

Select * from resb into corresponding fields of table itab

where aufnr = '380000000021' and rsnum = temp_rsnum

and baust = '00'.

it ends up in a dump which has the following analysis

An exception occurred. This exception will be dealt with in more detail

below. The exception, assigned to the class 'CX_SY_OPEN_SQL_DB', was not

caught, which

led to a runtime error. The reason for this exception is:

The data read during a SELECT access could not be inserted into the

target field.

Either conversion is not supported for the target field's type or the

target field is too short to accept the value or the data are not in a

form that the target field can accept

I did include the corresponding fields to rule out the last error,

i also tried to split my select using the below code

data itab type zitem1.

data temp_rsnum like resb-rsnum.

select single rsnum from afko into temp_rsnum

where aufnr = '380000000021'.

Select postp matnr from resb into corresponding fields of table itab

where aufnr = '380000000021'

and rsnum = temp_rsnum

and baust = '00'.

loop at itab into line.

Select posnr from resb into corresponding fields of line

where aufnr = '380000000021'

and rsnum = temp_rsnum

and baust = '00'.

append line to itab.

endselect.

endloop.

but the error is still there

cud u please advise,

name of the dump is DBIF_RSQL_INVALID_RSQL

thanks,

Gaurav