Data from R3 to mysql DB

[Former Member]

Hello everyone,

How do I download content directly to custom tables on mysql DB?

thanks

Emiliano

[krishnendu_laha]

Hello Friend,

You can not download data directly from R/3 to sql DB...

you have to first download into excel, text format....excel is recommended

Thanks

Krish

[Former Member]

hi, thanks for the answer.

so i have to first create some files and after with another application from sql take the data?

emiliano di giuseppe

[Former Member]

Hi Emiliano,

For non-automated table dumps you might be able to use SE16 or SE16N depending on your table size. From there you can save the data as a local file on your PC and then import them via LOAD DATA into MySQL. When doing that you should be careful though how you display the data. Usually I use ISO date format (YYYY-MM-DD) and a point as decimal separator. Furthermore I switch off the conversion exits.

I suspect based on your question that you don't have direct access to the SAP database - now that would be too easy, wouldn't it...

If you want to automate it, you could utilize the SAP JCo and create a custom RFC function module for retrieving table data (there are some in SAP, like RFC_READ_TABLE, but they all don't really work well, which you'll soon discover when you utilize it) and then download it via JCo. From Java you could easily load the data into MySQL via JDBC.

Cheers, harald

[Former Member]

ei thanks ....

i think that i will use PI with abap proxy ... maybe with some rfc i could arrive with pi to mysql DB .

Emiliano Di Giuseppe