Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Feb 2 at 3:25 PM James - Sorry to misunderstand. So if I've got it correct now:
- You are in SAP
- The Z tables are in SAP
- You wish to make the Z table data available to another system, which happens to be an Oracle database.
If those statements are true then my friend Horacio is spot on, as usual. Create RFC's or even BAPI's in the SAP system, callable from the external system via .NET or any other product for that matter. You then could control the timing of the data retrieval from the external system.
If you need more immediate updating, and are using any kind of middleware (PI, WebMethods, etc.) consider putting workflow in place that would trigger every time data in one of the Z tables was changed (added, changed, deleted). That trigger would take the record(s) in question and send them through the middleware to the system(s) waiting on the other side.
If you don't have middleware, you could do the same workflow, but it would send the data to an external process/directory waiting for data from the SAP system. When the data hit the external process, it would open the data package, process it accordingly and could even send back a confirmation to the SAP system - sort of an "I got it" message that could be tracked on the SAP side. This last method is very time consuming to build, but it does work. My last company used that methodology for nearly 10 years before switching to a more modern "other side", capable of using middleware.
- Lou
| | | ---------------Original Message---------------
From: jth1015
Sent: Thursday, January 31, 2013 9:50 PM
Subject: How to Insert Data from SAP Ztables to Oracle Tables?
how to insert data from sap ztables to oracle tables?
client prefers data in oracle tables and will extract data from oracle tables using stored procedures ms sql and update their tables.
Using ABAP code how to insert data from ztables to oracle tables?
Thanks,
James |
| Reply to this email to post your response. __.____._ |   _.____.__ |
