How to access an external database from ABAP via DBLINK (ORACLE)

1.Using transactionSE11 , create a table (ZTABLE) with the same fields as the table in the external database, make sure that the type and lengths of the fields are identical. 2. Using transaction SE11, create a view (ZTABLE_VIEW, projection view) using BASIS table ZTABLE 3. Using SVRMGRL> create dblink REMOTE_DB as connect to remote_user
identified by password; (database link created)
drop table ZTABLE; (table dropped)
create synonym ZTABLE for ZTABLE@REMOTE_DB; (synonym
created)
Using transaction SE16 , type in ZTABLE_VIEW and hit RETURN Entervalue in key fields and hit execute. (displays rows from the remote table) Tips and Tricks 1.To see the complete text of an error/warning message on the SAPGUI status bar, right click on the message and drag left.

2.To preventyour spool requests getting deleted from the BASIS cleanup jobs, you need to uncheck the Delete after print
checkbox in the print control screen, execute transaction SP01,
find your spool#, click onAttributes and change the Delete After
date 3.Short cuts using the OK-code box. %sc Search in page %pc Download do local file p+ Page up p- Page down p++Top of page p--End of page Use transaction AL11 to browse the application servers directory structure

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk