06-29-2011 02:51 PM
We are currently looking into using LabView to communicate with the SAP ERP software database. This is still in the early stages, so I have been tasked with determining whether not there exists a clear solution for communication with the software. I have searched through the Developer Zone and have not been able to find anything. If anyone has any idea I would appreciate if you could let me know. We are using LV 10. Thanks.
06-29-2011 03:06 PM
I had to look it up: SAP ERP is software for efficient business management. It is extremely unlikely that any LabVIEW engineers have any way to interface to it. However, you never know, I've seen some pretty obscure things being interfaced together with LabVIEW. Keep searching at least for a while before you give up on it. Good luck!
06-29-2011 04:29 PM - edited 06-29-2011 04:31 PM
I don't know the specifics but our test group uses LabView "web services" to comunicate with SAP.
I believe the SAP group had to do something on their end also to make it all work together.
06-30-2011 07:43 AM
Thanks for the responses!
Even though SAP is extremely popular, it is true that it probably isn't something many people are looking to interface with.
As far as the "web services" go, I'm going to look into that as a solution. We have some in-house SAP people that might know how to do that.
If anyone has any more ideas please let me know!
06-30-2011 08:07 AM
My guess is that you can open ODBC connection and query it using SQL.
See here:
http://forums.ni.com/t5/LabVIEW/Can-anyone-tell-me-how-to-interact-with-SAP/td-p/284249
06-30-2011 09:07 AM
SQL is certainly a possibility but I'll bet it's a pretty big job to create a whole interface for SAP
Have you contacted NI Engineers directly? Maybe NI uses SAP and they have some of the groundwork done already. Can't hurt to call them...
06-30-2011 12:12 PM
Good Afternoon,
You can execute your SAP code with a macro in a Visual Basic Application Module. Visual Basic Application Modules can be called with the Word Import Module and Word Run Macro VI's or the Excel Import Module and Excel Run Macro VI's found in the Report Generation Toolkit.
To call SAP Transactions:
1. In LabVIEW go to Help»Find examples»Toolkits and Modules»Report Generation for Microsoft Office»Run Macro on Word Table.vi and open that example.
2. Change the Module Code parameter to the macro that you want to execute or provide the path of the module under the Module Path parameter of the Word Import Module.vi
3. Replace the Append Numeric Table to Report.vi with the table you want to operate on.
4. Save the VI with a new name to ensure you are not writing over the Run Macro on Word example.
I hope this helps!
-Cody C