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

Lotus and SAP CRM

Do you know about specific Lotus script that may be used to "push" an email on user demand from Lotus client (R5.0.12) toward SAP CRM (v4.0), instead of a "pull" from CRM standard solution provided by SAP Groupware?

Do you know about specific Lotus script that may be used to "push" an email on user demand from Lotus client (R5.0.12) toward SAP CRM (v4.0), instead of a "pull" from CRM standard solution provided by SAP Groupware?
If I understand what you are asking, you want to create an SAP mail item from LotusScript. There are a couple of functions that can be called like standard SAP Remote Function Calles to do this.

SO_NEW_DOCUMENT_ATT_SEND_API1 (Used when there are binary attachments)


SO_NEW_DOCUMENT_SEND_API1 (Used when no attachments)

Of course you need to know who the SAP user is -- either the user ID or the email address associated to the user record.

To call these RFCs, you will need to install the Lotus Connector for SAP, which you can get from IBM. I have never used the connector, because we implemented a solution using the older LSX4SAP which is no longer supported, but which we still run on a backlevel server. But the idea is the same. After referencing the LC in your code, you log into SAP, set up an object to hole the RFC parameters and make the call.

We did something similar using a remote function call that one of our SAP developers created. The RFC exposed objects and types needed to log into SAP, access a table, and call RFCs to read and delete mail.

I can show you the general idea from the LotusScript side, and someone on your SAP support team should be able to fill in the rest.

  1. First, we copied the DLL to our server and referenced it in LotusScript with a USELSX "*RFC". You will use USELSX "*lsxlc".
  2. Next, we declared LotusScript variables corresponding to the types exposed by the DLL (you will declare variables called LCsession, LCfunction, etc.):
    • Public objServer As rfcServer
    • Public RFCReadESS As RFCfunction
    • Public ESSLog_t As RFCtable
    • Public RFCDelUpdESS As RFCfunction

  3. We then created a reference to SAP and logged in (the connection information has previously been loaded into variables):
    • Set objServer = New rfcServer
    • objServer.Destination = strSAPSystem
    • objServer.HostName= strSAPServer
    • objServer.System = Val (strSAPSysno)
    • objServer.Client = strSAPClient
    • objServer.User = strSAPUser
    • objServer.Language = strSAPLanguage
    • objServer.Password = strSAPPassword
    • SAPLogon = objServer.Logon()

  4. Next, we processed the contents of the table and posted deletions back to the table. I won't include the code for this, because it will look quite different in your application. The documentation that comes with the connector will have examples of calling RFCs and retrieving result sets.
  5. And finally, we log out of SAP.

Check out this site for more information on the lxlsx, which is now being refered to as the "IBM Lotus Connector for SAP Solutions".

Go here and search for "lclsx" for a couple of good articles with source code.

This was last published in September 2006

Dig Deeper on SAP CRM software

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.