topic Re: RFC Program, data not populating in the table in Application Development and Automation Discussions

RFC Program, data not populating in the table

Former Member — Wed, 14 Nov 2012 04:54:56 GMT

Hi experts,

I am new to SAP R/3. I know basics of abap reports. So i am trying to write a RFC program in se37 to insert the data from external application. I have written the code as below,

DATA: wa TYPE ytable2,

wa_str TYPE ystr_emp_details.

LOOP AT table INTO wa_str.

wa_str-emp_name = wa-ename.

wa_str-emp_mail = wa-emial.

wa_str-emp_addr = wa-eaddr.

INSERT ytable2 FROM wa_str.

CLEAR: wa, wa_str.

ENDLOOP.

There is no error. But the data was not populating in the table. Please help to resolve.

Thanks & Regards

Amarnath M

Re: RFC Program, data not populating in the table

anup_deshmukh4 — Wed, 14 Nov 2012 06:48:20 GMT

Hello

Amarnath M,

How about commiting the changes to the table by writing a 'Commit work.' Statement at the end of the Remote Function Module .

Hope this helps.

Anup Deshmukh

Re: RFC Program, data not populating in the table

Former Member — Wed, 14 Nov 2012 06:51:08 GMT

Hi,

Your structure 'wa' is always empty. You don't fill it anywhere.

Re: RFC Program, data not populating in the table

vinoth_aruldass — Wed, 14 Nov 2012 07:31:28 GMT

Hi,

LOOP AT table INTO wa_str.

wa-ename = wa_str-emp_name.

wa-emial.= wa_str-emp_mail .

wa-eaddr = wa_str-emp_addr .

INSERT ytable2 FROM wa.

CLEAR: wa, wa_str.

ENDLOOP.

try this code...

and explain which is your table and from which wa you are getting the external information.

Re: RFC Program, data not populating in the table

Former Member — Wed, 14 Nov 2012 08:33:02 GMT

Hi,

I have changed according to you. But still i am facing the issue. My table contains only 3 fields namely name, email, address. External application like SAP PI sending data and i wrote a rfc to update those datas in the table. My internal table was 'table' which i have defined in tables tab of rfc and corresponding wa in data. wa_str is a structure of same type as db.

Thanks & Regards

Amarnath M

Re: RFC Program, data not populating in the table

anup_deshmukh4 — Wed, 14 Nov 2012 08:39:44 GMT

Hello Amarnath,

Just to have a SY-SUBRC check after your insert statement .

Try setting up a external break point ( Check the user for the break point .) so that you can debug the RFC when ever it is called from the external system so you that you can check what is going wrong in the function .

Hope this helps

Re: RFC Program, data not populating in the table

Former Member — Wed, 14 Nov 2012 08:40:54 GMT

What the primary key of your table ytable2? You also need to check SY-SUBRC after "INSERT ...". You just need to write the program carefully. Nobody can write the report instead of you.

Re: RFC Program, data not populating in the table

Former Member — Wed, 14 Nov 2012 08:47:14 GMT

Hi,

I have set break point and debugged. It is not entering into to the loop. thats the problem. I had set the sy-subrc after loop statement also. But no use. Primary key was ename. I checked sy-subrc after insert statement also. but no use. please help me.

Thanks & Regards

Amarnath M

Re: RFC Program, data not populating in the table

Clemenss — Wed, 14 Nov 2012 08:48:39 GMT

Hi,

you may record what is really imported in 'table'. Use statement LOG-POINT and transaction SAAB.

Regards,

Clemens

Re: RFC Program, data not populating in the table

vinoth_aruldass — Wed, 14 Nov 2012 08:53:22 GMT

hi,

see accoring to you db table is ytable2 and the internal table is

ystr_emp_details.

if so try this in insert.

Hi,

LOOP AT table INTO wa_str.

wa-ename = wa_str-emp_name.

wa-emial.= wa_str-emp_mail .

wa-eaddr = wa_str-emp_addr .

INSERT into ytable2 values wa.

CLEAR: wa, wa_str.

ENDLOOP.

Re: RFC Program, data not populating in the table

Former Member — Wed, 14 Nov 2012 08:54:10 GMT

Amarnath M wrote:
 It is not entering into to the loop.

So you have empty 'table' .

Re: RFC Program, data not populating in the table

Former Member — Wed, 14 Nov 2012 09:03:44 GMT

My 'table' has 2 entries. I am trying to enter 3rd entry but i am failed.

Thanks & Regards

Amarnath M

Re: RFC Program, data not populating in the table

vinoth_aruldass — Wed, 14 Nov 2012 09:12:08 GMT

check your primary key and don repeat that

Re: RFC Program, data not populating in the table

Former Member — Thu, 15 Nov 2012 05:10:31 GMT

Hi,

I have checked all the feasibility. But i couldn't find the solution. Please help me.

Thanks & Regards

Amarnath M

Re: RFC Program, data not populating in the table

vinoth_aruldass — Thu, 15 Nov 2012 05:18:11 GMT

hi ,

let me know your import parameters and export and table parameters in your function module.

Regards,

Vinoth Aruldass.

Re: RFC Program, data not populating in the table

Former Member — Thu, 15 Nov 2012 05:25:37 GMT

Please find my import, table parameter.. I am not using any export parameter. Here ytable2 was my db table.

*"*"Local Interface:

*" IMPORTING

*" VALUE(EMP_NAME) TYPE YEMP_NAME

*" VALUE(EMP_MAIL) TYPE YEMP_MAIL

*" VALUE(EMP_ADDR) TYPE YEMP_ADDR

*" TABLES

*" TABLE STRUCTURE YTABLE2

Please help me if i am wrong.

Thanks & Regards

Amarnath M

Re: RFC Program, data not populating in the table

vinoth_aruldass — Thu, 15 Nov 2012 05:37:41 GMT

hi,

in tables

declare

Tables :

table like ytable2.

Then.

confirm me you are putting all your external values which are going to inserted into table right

Your code must me

Re: RFC Program, data not populating in the table

vinoth_aruldass — Thu, 15 Nov 2012 05:38:27 GMT

conform me the input you will give in table.

Re: RFC Program, data not populating in the table

vinoth_aruldass — Thu, 15 Nov 2012 05:41:01 GMT

if you are giving your input in the table

your code must be

data :wa type ytable2.

loop at table into wa.

INSERT into ytable2 values wa.

clear wa.

endloop.

hope my answer will be helpful.

Re: RFC Program, data not populating in the table

Former Member — Thu, 15 Nov 2012 05:54:09 GMT

Hi,

I have tried ur coding but still data doesn't get populated. When i debug the program, it is not going inside the loop. I think that may be the problem.

Regards

Amarnath