on 10-19-2015 9:17 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.