Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Creation of Synonyms

Former Member

‎06-13-2005 6:53 AM

0 Kudos

Hello,

Can anybody help me on how to create Synonyms in ABAP?

The exact syntax of CREATE OR REPLACE SYNONYM would be helpful.

Thanks in Advance,

Sudeep Achalia

2 REPLIES 2

Former Member

‎06-13-2005 7:00 AM

0 Kudos

Hi,

Can you be little more specific about the query? it would help the forum members to give the appropriate response.

Thanks,

Former Member
In response to Former Member

‎06-13-2005 7:49 AM

0 Kudos

I am creating synonyms using Native SQL -

EXEC.

CREATE SYNONYM <SYN> FOR <REMOTE_TABLE>@<DATABASE_LINK>

ENDEXEC.

This statement works fine when the synonym <SYN> is not already present but gives a short dump otherwise.

How do I catch such exceptions? Also, where can I see the synonyms in ABAP repository? I mean in which table (like DDO2L)?

Regards,

Sudeep Achalia