Hi All,
Happy new year..
There is one table in other database and with the same structure i have created one ore table in SAP system and a projection view for the same is also created.
Now with the following steps link has been established.
How to access an external database from ABAP via DBLINK (ORACLE)
Using transaction SE11, 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.
Using transaction SE11, create a view (ZTABLE_VIEW, projection view) using BASIS table ZTABLE
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
Enter value in key fields and hit execute. (displays rows from the remote table)
now the table will be dropped and if we go to view we can view the records from the remote table.
But now while i am trying to view the records in view it is going to dump. but it is showing the number of entries...
Can any body let me know why it is going to dump..
Regards,
Sunil Kumar Mutyala.
Bluesky
