DBlink access in ABAP code

[Former Member]

hello all,

need your help.

can someone give me a useful code to access DBlink in sap abap code..?
is there any BAPI that can we use to do this..?

your response is highly appreciated..

[Former Member]

hello,

Using transaction SE11, create a table (ZTEST) with the same fields as the table in the external database, make sure that the type and lengths of the fields are identical.

Using transaction SE11, create a view (ZTEST_VIEW, projection view) using BASIS table ZTABLE

Using SVRMGRL> (Oracle utility)

create dblink REMOTE_DB (your db link) as connect to remote_user identified by password; (database link created)

drop table ZTEST; (table dropped)

create synonym ZTEST for ZTEST@REMOTE_DB; (synonym created)

Using transaction SE16 , type in ZTEST_VIEW and hit RETURN

Enter  value in key fields and hit execute. (displays rows from the remote table)

also check links

http://scn.sap.com/thread/6887

http://scn.sap.com/thread/1773060

best regards,

swanand