cancel
Showing results for 
Search instead for 
Did you mean: 

Transfer data from External SQL database to SAP CRM Z Table

0 Kudos

Hello All,

We want to so a weekly transfer of data from SQL database to SAP CRM Z table. Could you please let me know how to achieve this? It would be great if any one has done this and share the details. We are in SAP 7.0.

Thanks,

Ravi

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

If that external SQL server in you system landscape then you can extract the data using Native SQL statements in your ABAP programs of ECC/CRM systems.

Regards,

Bhanu

ceedee666
Active Contributor
0 Kudos

Hi Ravi,

I think using an external database connection would be the best approach for your requirement. The following blog provides detailed steps for creating such a connection as well as some sample code:

Once you have a external database connection in place you can simply write a report the updates your Z-table and schedule this report to run weekly.

Best,

Christian