Skip to Content

Transfer data from External SQL database to SAP CRM Z Table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 19, 2015 at 08:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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:

      Using ABAP to access non-SAP databases

      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