rfc error

[Former Member]

can anybody explian me, what does the floowing error mean?

SELECT name1 ort01 FROM kna1 INTO TABLE itext WHERE name1 = name1.

[Former Member]

sorry, that was a statement in the source code,

but the error says:

"Error in module RSQL accessing the database interface"

[Former Member]

Hi ajay,

1. NAME1 must be a variable

containing some value.

(name1 on right of 😃

regards,

amit m.

[Former Member]

Check whether you have created the variable 'name1'.

If the error still persists try renaming the variable.

[athavanraja]

can you tell us the definition of the itab itext

i guess thats what is causing the problem.

Regards

Raja

[Former Member]

i created a RFC and

import = kunnr like knkk-kunnr

export = return like bapireturn

tables = itab like zacc_balance( which has fields like kunnr,skfor, ssobl ,total like skfor)

ssource code is:

DATA: l_skfor LIKE knkk-skfor,

l_ssobl LIKE knkk-ssobl.

SELECT skfor ssobl INTO TABLE itab

FROM knkk

WHERE kunnr EQ kunnr.

LOOP AT itab..

itab-total = l_skfor + l_ssobl.

MODIFY itab.

ENDLOOP.

ENDFUNCTION.

i want to store the difference of skfor and ssobl in my table itab.

[Former Member]

hi again,

1 where is the problem exactly u are facing ?

2. use CORRESPONDING-FIELDS OF

SELECT skfor ssobl INTO

CORRESPONDING-FIELDS OF

TABLE itab

regards,

amit m.

[Former Member]

The structure of itab must be similar to the structure of the select query..

Else change your select query as:

SELECT skfor ssobl

INTO <b>CORRESPONDING FIELDS OF</b> TABLE itab

FROM knkk

WHERE kunnr EQ kunnr.

[Former Member]

Hi,

Check that in the internal table declaration you have entered all required field which you are extracting from knkk. If you accidentally leave out one object the RSQL error is dumped.

[Former Member]

thankyou all,

i solved the problem. it was in the select statements. i changed the source code to the following and it worked. thankyou for your help

DATA: l_skfor LIKE knkk-skfor,

l_ssobl LIKE knkk-ssobl.

SELECT skfor ssobl INTO (l_skfor, l_ssobl)

FROM knkk

WHERE kunnr EQ l_kunnr.

ENDSELECT.

itab-total = l_skfor + l_ssobl.

y_kunnr = l_kunnr.

i_balance = itab-total.

APPEND itab.

CLEAR itab.

ENDFUNCTION.