Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from john.louk on Feb 1 at 9:54 AM I would lean to what Horacio has given you on the RFC (Remote-enabled) approach. You could also publish a web method. Both allow the external application to access your custom tables.
This keeps you from having to look at whether your tables are in sync at the time the external system reads this other Oracle table.
Cheers
John
| | | ---------------Original Message---------------
From: Horacio Zapettini
Sent: Friday, February 01, 2013 9:34 AM
Subject: How to Insert Data from SAP Ztables to Oracle Tables?
James,
You have two (or even more) possible solutions: define one or more RFC fm's and call them from the .net platform or use exec sql (native sql) to update the tables (or... the list does not end here, i can imagine the Idocs as an alternative... ).
If you go for Lou's idea, then
you may want to visit service.sap.com -> search for oss notes with exec sql (You'll get a list of oss notes that tell your basis how to set up your system in order to send data from sap to the legacy system
you may also want to visit help.sap.com and search for exec sql.(you'll get a list with sintax allowed, statements allowed and forbiden).
You may also want to google a bit.
and at last: you may also want to search in the groups (sap-dev and sap-abap). I think this question has been answered some times in the past (you may also add my nicname as I posted some of them.
If you gor for the RFC's idea then it's quite simple: define the FM in your SAP system. then tell the .net programmer the user, the password, the client, ip and stuff he needs to connect the legacy system to your SAP system. You'll also have to tell him the FM and the structures. Once you've done that, the programmer would have to look in the net for an example (there are hundreds) of how to connect and execute the fm from his program. Once the data is on his side, then inserting/updating/deleting is his problem.
HTH
Horacio |
| Reply to this email to post your response. __.____._ |   _.____.__ |
