topic Re: rfc error in Application Development and Automation Discussions

rfc error

Former Member — Wed, 25 Jan 2006 08:25:21 GMT

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

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

Re: rfc error

Former Member — Wed, 25 Jan 2006 08:26:37 GMT

sorry, that was a statement in the source code,

but the error says:

"Error in module RSQL accessing the database interface"

Re: rfc error

Former Member — Wed, 25 Jan 2006 08:28:13 GMT

Hi ajay,

1. NAME1 must be a variable

containing some value.

(name1 on right of 😃

regards,

amit m.

Re: rfc error

Former Member — Wed, 25 Jan 2006 08:36:11 GMT

Check whether you have created the variable 'name1'.

If the error still persists try renaming the variable.

Re: rfc error

athavanraja — Wed, 25 Jan 2006 08:37:46 GMT

can you tell us the definition of the itab itext

i guess thats what is causing the problem.

Regards

Raja

Re: rfc error

Former Member — Wed, 25 Jan 2006 08:40:40 GMT

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.

Re: rfc error

Former Member — Wed, 25 Jan 2006 08:46:27 GMT

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.

Re: rfc error

Former Member — Wed, 25 Jan 2006 08:47:11 GMT

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.

Re: rfc error

Former Member — Wed, 25 Jan 2006 09:01:03 GMT

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.

Re: rfc error

Former Member — Fri, 27 Jan 2006 05:40:33 GMT

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.