topic Re: Syntax error for AMDP class in Application Development and Automation Discussions

Syntax error for AMDP class

former_member198680 — Thu, 25 Mar 2021 03:44:43 GMT

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

Re: Syntax error for AMDP class

former_member1716 — Thu, 25 Mar 2021 04:44:24 GMT

prasad.ganta2,

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

Re: Syntax error for AMDP class

susuang — Thu, 27 Oct 2022 07:45:28 GMT

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