Knowledge Management

Question:
Hi
Is there a way in SAP, to have the same DB table visible(accessible) in two different systems (one is SAP ECC 6.0 and other SAP 4.6D)?
I am working on a project, where this solution would be greatly appreciated... so far i have not been thinking of any other solutions (maybe via RFC calls...), but if anyone has any suggestions, you're welcome
Answer:
Not sure exactly what you are doing. But, you could possibly setup a database for your project and create connections to the external database from both SAP systems. Putting the entries in table DBCON using transaction SM30.
Then use "EXEC SQL" in your abaps to work on the external database. Be mindful of closing the connection in your code though or the next time a standard sap program uses EXEC SQL you might find short dumps occuring because it is trying to connect to your external database. Also the EXEC SQL stuff may be case sensitive so don't use pretty printer, trust me it can be very annoying.
Gav