06-09-2011 2:37 PM
Hi,
We have a scenario wherein we require to get data from two tables in SQL and send the data to r/3 and do some some calculation. finally save the data in tables.
Can you please help me out the best way to do so. Is it Flat file transfer or RFC. Please do provide examples, if any.
Thanks.
06-09-2011 2:53 PM
Hi Sai;
1. You can connect to SQL DB from SAP with native SQL. You can call to view or stored procedure or select statement.
2. You can write Vs .net NCO 3.0. You should write RFC at SAP. And call from .net.
Your sql tables and sap tables should be same structure.
I Think If you have .net license and should get periodic run process ; You can use .net with NCO 3.0
But If You use only several times this process ; You can use native sql method.
Best regards.
06-09-2011 2:53 PM
Hi Sai;
1. You can connect to SQL DB from SAP with native SQL. You can call to view or stored procedure or select statement.
2. You can write Vs .net NCO 3.0. You should write RFC at SAP. And call from .net.
Your sql tables and sap tables should be same structure.
I Think If you have .net license and should get periodic run process ; You can use .net with NCO 3.0
But If You use only several times this process ; You can use native sql method.
Best regards.
06-09-2011 3:01 PM
Hi Melih,
Thanks for the response. sql tables and sap tables both the structures are different. Even we dont have .Net interface to use.
Can you suggest me with any other way?
06-09-2011 3:07 PM
Setup a DBCO connection and use Native SQL. Check with your Basis for the connection setup.
http://help.sap.com/saphelp_nw04/helpdata/en/df/455ec9747111d6b25100508b6b8a93/content.htm
06-09-2011 3:24 PM
Hi Sai;
I suggest you 2 way for your status.
Native sql very useful and healty method. You can try this method.
Please check below links.
Best regards.
http://help.sap.com/saphelp_smehp1/helpdata/en/a9/9cbe7ecd9b464b8f31449df34c8d8c/content.htm
http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/content.htm
06-09-2011 3:38 PM
Thank you Suman n Mehil.. Is it good optin to use Native sql? because the data will updated for every month in the sql tables.
06-09-2011 4:00 PM
Sai, Native SQL is specific to database and In your case, you have a specific external database to access and as far as I understand you would read the data from two tables of the external database once in a month which should be fine.
06-09-2011 4:23 PM
Hello Sai,
In order to connect to external DBs SAP has provided [ADBC|http://help.sap.com/abapdocu_702/en/abenadbc.htm] API classes.
If you don't want to manually implement the Native SQL code you can use these API classes. Interested? Refer to the demo program ADBC_DEMO for further know-how!
Cheers,
Suhas