topic Re: How to Send SAP SALES DATA into SQL2005 data base table in Application Development and Automation Discussions

How to Send SAP SALES DATA into SQL2005 data base table

Former Member — Thu, 07 Aug 2008 18:13:04 GMT

Hi Guys,

I have requirement is that to send SAP Monthly Sales data into SQL2005 data base. We have SAP 4.6c and SAP ECC6.0 version. I do have idea about BAPI, Webservice etc..

I am not sure how to proceed this requiremnt.

Can you anybody help me regarding this....

Thanks & Regards,

Sivakumar S

Re: How to Send SAP SALES DATA into SQL2005 data base table

Former Member — Thu, 07 Aug 2008 18:28:35 GMT


> Hi Guys,
> 
> I have requirement is that to send SAP Monthly  Sales  data into SQL2005 data base. We have SAP 4.6c and SAP ECC6.0 version. I do have idea about BAPI, Webservice etc..
> I am not sure how to proceed this requiremnt.
> 
> Can you anybody help me regarding this....
> 
> 
> Thanks & Regards,
> Sivakumar S

So you are sending data from SAP to an external database right? How much data? I am assuming on a monthly basis? Do you expect this data to grow (and by how much) in the future?

Answer these questions first, then I'll make some recommendations.

Re: How to Send SAP SALES DATA into SQL2005 data base table

Former Member — Thu, 07 Aug 2008 18:50:26 GMT

HI Kevin,

The maximum amount of data would be 500 records in a month...

Regards,

Sivakumar S

Re: How to Send SAP SALES DATA into SQL2005 data base table

Former Member — Thu, 07 Aug 2008 20:20:59 GMT

1. in your abap program, retrieve all the sales data in a internal table.

2. use EXEC.. ENDEXEC native sql statement to insert the data into the sql database.

LOOP AT itab.

EXEC SQL.

INSERT INTO tablename@connector_name

VALUES (:itab-field1)

ENDEXEC.

ENDLOOP.

Note, you should have the connection established to your database from sap.

check transaction DBCO.

Hope this answers your question.

Re: How to Send SAP SALES DATA into SQL2005 data base table

Former Member — Thu, 07 Aug 2008 20:29:25 GMT

Hi Arun,

This is working fine for SQL2000 but it is not working for SQL2005 from SAP4.6c version.

Re: How to Send SAP SALES DATA into SQL2005 data base table

Former Member — Thu, 07 Aug 2008 20:33:44 GMT

For 500 records a month, what Arun said above will work fine.

As for the connection problem, what version of SQL are you running on the SAP system?

Re: How to Send SAP SALES DATA into SQL2005 data base table

Former Member — Thu, 07 Aug 2008 20:36:40 GMT

what error message are you getting?

talk to your database/basis guys and check whether they could access and insert data into the tables you are trying to update.