View going to short dump

Former Member — Fri, 02 Jan 2009 09:05:32 GMT

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.

Re: View going to short dump

Former Member — Fri, 02 Jan 2009 09:26:20 GMT

Hi,

Below is few possibilities,

Check if change any key fields You should active and adject database.

goto - SE11 - Utilities -Data Base Object - Database Utility - Click on Active and adjust data base.

Check table maintance regenerated or not.

Regards

Md.MahaboobKhan

Re: View going to short dump

Former Member — Fri, 02 Jan 2009 10:34:08 GMT

Nope i tried in that manner also.

topic Re: View going to short dump in Application Development and Automation Discussions

View going to short dump

Re: View going to short dump

Re: View going to short dump