Community
Application Development and Automation 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: 
Read only

Syntax error for AMDP class

former_member198680
Participant

‎2021 Mar 25 3:44 AM

1,186

Hello,

I am getting syntax error for sap demo class for amdp CL_DEMO_AMDP.

It is giving error as 'The default schema "XXXXXX" cannot be specified explicitly for the object "SFLIGHT".

Please help me to fix the issue.

Thanks,

Prasad

2 REPLIES 2
Read only

former_member1716
Active Contributor

‎2021 Mar 25 4:44 AM

1,008

prasad.ganta2,

Information is very limited to help you, can you kindly paste the code snippet using CODE Button?

Read only

susuang
Explorer

‎2022 Oct 27 8:45 AM

1,008

The problem in this case is that someone has created Public Synonym on the HANA level, which is exactly the same as the table name. So the statement could be:

CREATE PUBLIC SYNONYM SFLIGHT FOR SCHEMA.SFLIGHT<br>

because of that AMDP Class is lost. If you do not need that public synonym just drop it with statement:

DROP PUBLIC SYNONYM SFLIGHT

More information you can find here: https://launchpad.support.sap.com/#/notes/2401716