To upload a data into SAP Table with the help of RFC function in BODS

[Former Member]

Hi,

Please provide me step-by-step solution to upload data into any SAP table with the help of RFC function in Data Services.

I have created RFC function that upload data into SAP table. RFC Function contains one table that has same structure as my database table.

In the data services how can i filled the table of RFC function, i am using this function in query transform of data services but it gives me error.

I am also follow link http://wiki.sdn.sap.com/wiki/display/BOBJ/BusinessObjectsDataServicesTipsand+Tricks

but it did not help me.

Thanks,

Abhishek

[Former Member]

Hi Jan,

I am unable to map my function module table (function module is in schema out) with schema in table.

Please let me know how can i map .

Thanks.

[Jan_van_Ansem]

Hi Abhishek,

Did you import the function module in the SAP datastore first? When you open the SAP datastore, the function should be listed in the 'functions' section. If not, import it. Make sure your function is remote executable.

Once the function is there, you can use it in a transformation. In 'Schema Out' right-click on 'Query' (top level) and choose 'New Function Call'. You can then select a datastore and a function in the datastore. The wizard will show you which output parameters are available. I believe you have to add at least one and can select as many as you like.

After confirming your selection the function and the output parameters appear in Schema Out. You can then right-click on the function and choose 'Modify function call'. A popup will appear where you can specify the input parameters.

I hope this helps.

Jan.

[Former Member]

Hello Abhi,

Did you tried the solution priovided by Jan, Let me know if it wokred.

I am also trying to achieve the same thing - Updating a SAP BW table from DS using RFC.

Any pointers till now from your side would be helpful.

You can email me mayank2k on gmail.

Regards,

Mayank

[Jan_van_Ansem]

Not sure what you mean by 'created an RFC function': Is that a ABAP FM which is remotely executable?

In that case, you're on the right track.

My suggestion is to first test the FM in SM37. If that works, then there shouldn't be a reason why it wouldn't work when called from DS (using the same data).

If it still doesn't work, perhaps you can share some information about the error message you get?

Jan.