I have SAP Web AS on one server together with BW, and on other servers SAP R/3 4.6C.
On documentation (WAS help, forums, SAP PRESS books, etc.) I can not find some usefull information/code example how to do data retrieval from R/3 in BSP, when this is on different servers and databases. Both databases (R/3 and WAS) are on MS SQL SERVER.
In BSP documentation and tutorials are very simple data retrievals of type:
select * from bsbook into table books.
How can I connect to different databases? Without this possibility is BSP/WAS useless.
I want to use BSP/WAS as platform for overall company reporting - so I will need to access to other MS SQL SERVER databases.
Thanks a lot,