SAP data to SQL

[Former Member]

Hi All,

Can anyone share their expertise/knowledge/idea on how to
get the data from SAP server to SQL?

Thanks in advance.

Have Great day!!!

[Former Member]

This message was moderated.

[Former Member]

Hi James,

As i understand you want to get data from SAP server to non sap then you can use RFC and BAPI.

But this will help you to get some Specific data related to your requirment but not all the data.

So if you req some specific data for further use in different application u can use RFC and BAPI.

else

kindly give some more information on your requirment.

Regards

Rohit

[satyabrata_sahoo3]

You can use BAPIs or FMs like RFC_READ_TABLE to get data of SAP tables from SQL. You have to use SQL queries using the BAPI or FM to get the data from SAP.

-SS-

[Former Member]

I need to move various data from SAP to SQL server and which is the best method to perform the transmission, SAP -to-> Excel -to-> SQL or Direct from SAP -to-> SQL?

[Former Member]

HI james,

It depends on you requirment... but normally if we send data to Non SAP System... it good  we directly send the data to other system i.e. SAP - to - SQL , but u have to ensure that the data u are sending , same get by non sap system, a data consistency check must be done at other system.

Hope it will helps you

Regards

Rohit

[Former Member]

Thanks all it helps me a lot.

I appreciate.