I will like to hear if any have made a RFC call from a CRM system (placed on oracle server 1) to another SAP system (placed on oracle server 2) - In my case a IS-U.
Is it possible to do so? (I guess it is)
I want to access a Z-table defined in IS-U, which off course is not known in the CRM - I guess this is not a problem too.
Have any of you a example for doing this? (I hope so :-D)
Thanks in advance.
apart from Ajay's suggestion, you can also have a look at one of the articles where i have given a slightly modified version (for better handling of return data) of RFC_READ_TABLE.
<a href="https://www.sdn.sap.com/sdn/url.sdn?res=http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/f50dcd4e-0501-0010-3596-b686a7b51492">rfc_read_table for SAP Web AS</a>
This is a common thing to do, especially in fact sheets, etc.
You can determine the RFC destination either by using the OLTP site (call function SMOF_READ_SMOFERPSH with sitetypeid = 'SMOF_ERPSITE') or by using a parameter in SMOFPARSFA and calling SMOF0_READ_SMOFPARSFA.
RFC_READ_TABLE is perhaps not the best thing to use for a productive enterprise system. It's a very generic tool and you have a specific need. Maybe you could consider creating a Z RFC function on your IS-U system.
If the Z table is configuration data or master data, then buffering would be good (perhaps using a proxy on the CRM side, maybe with a shared object or context), or ideally use the middleware to replicate the data on the CRM DB. It's not that hard to do.
If lots of users on CRM are making lots of parallel RFC calls to IS-U, then there are performance issues to consider. There are solutions to these issues.