Home > Ask the Domino Experts > ARCHIVE: Enterprise Integration Questions & Answers > How can I use an RFC transaction call to move data from Domino to SAP?
Ask The Domino Expert: Questions & Answers
EMAIL THIS

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

Scott Lemieux EXPERT RESPONSE FROM: Scott Lemieux

Pose a Question
Other Domino Categories
Meet all Domino Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 27 January 2004
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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
ARCHIVE: Enterprise Integration
Restricted in connecting LEI to Notes databases?
Integrate Domino 7 beta with DB2
Can I use LSXDB2 in a scheduled agent on AIX, Domino version 5?
Tracking interdependent LEI activities
Oracle table updates not transmitting to Notes
Oracle through DECS via the Web connection returns 'Error creating product object'
Managing user rights for Domino docs transferred to SAP
Two stored procedure events not working with DECS and SQL Server backend
Can I code a Notes script to bundle LEI-polling sequence activity?
Creating a database that will support concurrent entries with automatic updates

Lotus Notes Domino Interoperability
Display SharePoint data in a Lotus Notes Web application with Ajax
Search Microsoft Active Directory with LotusScript
Open a Lotus Notes database from Microsoft SharePoint 2007
Top 10 Lotus Notes/Domino administration tips of 2008
Can Lotus Notes/Domino and Microsoft SharePoint play nice together?
IBM Lotus Notes versus Microsoft SharePoint: The rest of the story
Fix Lotus Notes 8.0 issues when launching Microsoft Office applications
A batch file for Lotus Notes Domino maintenance on Windows Server 2003
Lotus Notes and Microsoft SharePoint integration
Running Lotus Notes Domino on Linux

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Lotus Notes Domino on Blackberry and mobile devices
HomeTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts