on 01-21-2015 12:09 PM
Data of Report (any small report of sales/mm) which is generated on SAP System transfer to any other database(MS SQL 2008) which is on other machine.
*Two machines, one is of SAP and second is MS SQL Server 2008.
*Data generated from report in SAP should have to be transfer to MS SQL for other usage.
I am in need of an automated solution. I guess that could be in a way when user runs/execute a report than that report generate data and then trigger something (RFC/ IDOC/ ALE/ BAPI) through which that data can be export (transfer) to SQL database and that database is on machine other than this.
Detail answer will be appreciated. I am using SAP ECC 6.0
Hello Syed,
Can give just an idea.
1- You can create a DB connect using transaction DBACOCKPIT and Add System Entry.
2- Write an ABAP program to transfer data from SAP tables to SQL Server tables.
3- Schedule a job for regular transfer.
4- Check transferred data in SQL server.
Hope this helps.
Regards,
Yuksel AKCINAR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.