topic Re: RFC INSERT in Application Development and Automation Discussions

RFC INSERT

Former Member — Fri, 04 Aug 2006 14:21:38 GMT

Hi,

How to create a Remote Enabled Function Module with Insert code. I have a database table call ZTakeData.

and i want to insert data into that using some RFC FUnc Module..

Any Sugg.

Seshu

Re: RFC INSERT

Former Member — Fri, 04 Aug 2006 14:23:58 GMT

Write a function module and make it Remote-Enabled. In the function module declare required variables & also table structure.

In the code access the table passed and update the respective table.

Re: RFC INSERT

Former Member — Fri, 04 Aug 2006 14:24:18 GMT

Hi,

Thanks for reply, i need steps please.

Seshu

Re: RFC INSERT

RichHeilman — Fri, 04 Aug 2006 14:25:51 GMT

You can create your function module via SE80 or SE37, in the attributes tab, mark as "Remote Enabled", you can then define your interface, you can use a TABLES paramter typed like the structure of your "Z" table. Then in the code of your function module, you only need one statement.

Here im_ZTakeData is the name of the TABLES parameter that you defined.



insert ZTakeData from table im_ZTakeData.

Now all you need to do is call the RFC and pass an internal table with the same structure of your "Z" table and all records will be inserted into the "Z" table.

Regards,

Rich Heilman

Re: RFC INSERT

Former Member — Fri, 04 Aug 2006 14:27:39 GMT

Hi,

anything to do in Import, Export, Tables tab while creating Func Module?

Seshu

Re: RFC INSERT

RichHeilman — Fri, 04 Aug 2006 14:30:15 GMT

Yes, As I said, I would suggest passing the data thru the TABLES parameter.

For the name of the parmater, use something meaningful and in the next column enter LIKE, in the next column use the name of your "Z" table, then add the line of code that I mentioned above in to the source code.

REgards,

Rich Heilman

Re: RFC INSERT

Former Member — Fri, 04 Aug 2006 14:35:21 GMT

Hi Rich,

i did like this,

in tables tab:

ITAB          LIKE         ZTakeData

and in Source code tab

insert ZTakeData from table itab.

and while checking Syntax its saying

"Reference parameters are not allowed with RFC"

Re: RFC INSERT

RichHeilman — Fri, 04 Aug 2006 14:39:34 GMT

Yes, are you passing any other parameters in the IMPORT or EXPORT tab?

You usually see this error when passing by reference in an RFC. If you have anything on the IMPORT or EXPORT paramters tabs, you need to check the checkbox for "passing by value".

Regards,

Rich Heilman

Re: RFC INSERT

Former Member — Fri, 04 Aug 2006 14:42:24 GMT

Hi,

i am sorry, i have something in export tab and now i removed it.. now its activated..

actually, whats the use of Import and Export Tab?

Seshu

Re: RFC INSERT

RichHeilman — Fri, 04 Aug 2006 14:47:43 GMT

IMPORT and EXPORT parameters are usually single fields or structures containing one line of data, and you use the TABLES parameter for passing multy line data like internal tables.

Actually the best practice has shifted to using only IMPORT and EXPORT parameters and not use the TABLES parameters at all. You are now supposed to pass your internal tables via IMPORT and EXPORT parameters using Table Types defined in the ABAP dictionary. To tell you the true, I have not yet adopted this practice, and I haven't see many that have. But there is nothing wrong with using the TABLES parameters

Regards

Rich Heilman