on 06-23-2010 7:53 PM
Hi All,
I want to connect SAP to another SQL server. Basically each day I need to take data from 2 tables in SAP tables to another sql server. I want this to be automated via a program in SAP.
Please suggest me some methods to achieve this.
I have searched the web and found that this is possiable, some transactions such as DBCO was mentioned, but it was not much helpful.
Thanks a lot.
Regards,
Pankaj
You will have to write an extract and load the data through sap tools, you cannot do this directly at the db level. Bapi, or Idocs some data load method SAP will not support direct table loads through native SQL , it may / will corrupt your system
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This blog shows how to do this. [Using ABAP to access non-SAP databases|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11543] [original link is broken] [original link is broken] [original link is broken];
Cheers
Graham Robbo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.