Problem solve Get help with specific problems with your technologies, process and projects.

How can I use an RFC transaction call to move data from Domino to SAP?

We are trying to interface with SAP using RFC transaction call. This RFC transaction call will post info from Domino into SAP.

For this, there is a transaction program that is created at SAP. This transaction program requires a table as an input. We are able to pass one record in the table and successfully receive a return status. However, for the transaction to be successful, we will need to pass more than one record in the table to SAP in the RFC transaction call.

We are using LSXLC to perform the above. May we ask how this can be done?
You essentially have two options to get the data into SAP. The first is using a simple loop to rebuild the LCFieldList object for each record you wish to insert. If you use this option, be sure to reinitialize the LCFieldList object at the top of the loop using the "Set mylist = New LCFieldList(...)" method of instantiation; otherwise, you may have data from the previous record left in the list. The second option is to build an LCFieldList object that contains all the records. You can do this by determining the number of records to be passed to the transaction and then instantiate the LCFieldList object accordingly; for example, if there are five records to insert you would reinitialize with Set mylist = New LCFieldList(5, ...). You can then use the LCFieldList.Insert(n,...) method where n is the record number (using a simple counter loop works well). If the transaction's return value contains a return status for each record, it should come back as an LCFieldList and you can parse through it similarly to how you built the input list -- by specifying the index value of the list row you want to examine.

Do you have comments on this Ask the Expert Q&A? Let us know.

Dig Deeper on Lotus Notes Domino Interoperability

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...