cancel
Showing results for 
Search instead for 
Did you mean: 

how to export data from sap to sql?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

yakcinar
Active Contributor
0 Kudos

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