Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Feb 1 at 9:33 AM 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
| | | ---------------Original Message---------------
From: jth1015
Sent: Friday, February 01, 2013 9:14 AM
Subject: How to Insert Data from SAP Ztables to Oracle Tables?
Lou,
Thanks for your help. We have data in ztables but also want to move same data to ORACLE tables. Our underlined database is ORACLE. The ZTABLES and ORACLE tables (created in ORACLE by DBA) will be in different table spaces. Is there a sample native sql code I can use to achieve this. Client doesn't use SAP they are on .NET platform.
Again thanks for your help.
James |
| Reply to this email to post your response. __.____._ |   _.____.__ |
