topic Re: AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/" in Application Development and Automation Discussions

AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/"

ajay_mukundan2 — Wed, 18 Sep 2019 08:54:23 GMT

Hi Gurus,

Consider the customer name space is '/XYZ/'. We have created custom table - /XYZ/DB_0019.

While using the table /XYZ/DB_0019 in AMDP method, we encounter the below error.

SQLSCRIPT: sql syntax error: incorrect syntax near "/"

Version of ADT on Eclipse:

Eclipse IDE for Java Developers Version: 2019-03 (4.11.0) Build id: 20190314-1200 OS: Windows 10, v.10.0, x86_64 / win32 Java version: 12.0.2

How to go about the above error?

Re: AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/"

Sijin_Chandran — Wed, 18 Sep 2019 09:23:58 GMT

Hello,

In line number 94 can you remove the space after '/'

I have a feel like you have mentioned the Table name as '/ sflight' instead of '/sflight'.

If the table name is correct then it should not throw an error, try with this and update here.

Thanks,

Sijin

Re: AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/"

ajay_mukundan2 — Wed, 18 Sep 2019 11:59:17 GMT

Hi Sijin,

The table name is /XYZ/DB0019. I have removed the space in the 'USING' clause.

Still the error is thrown on the 'Select' clause only.

Can you try table join with table under Customer Names Space /XYZ/ .

Re: AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/"

former_member1716 — Wed, 18 Sep 2019 15:31:19 GMT

Hello,

Instead of typing the table name, can you please try dragging the table from the left and drop in the select query and let us know the results.

Regards

Re: AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/"

ajay_mukundan2 — Wed, 18 Sep 2019 23:58:50 GMT

Hi Satish,

Thanks for responding!

Upon drag and dropping the table from the Project explorer to the AMDP method, the table is opened in SE11 in new window. The table is not filled in the AMDP table selection query.

Refer screenshot-

Re: AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/"

Sijin_Chandran — Thu, 19 Sep 2019 08:03:19 GMT

Hi Ajay,

Unfortunately now I don't have access to S4 system 😞

This error looks really strange. If you have given the correct table name in the USING part and later using it in the SQL query it should not throw an error. Might be as highlighted by you its because of the Custom Namespace starting with '/' and this '/' is getting interpreted as something else from the SQL end.

See something like this https://stackoverflow.com/questions/36795096/forward-slash-in-column-name-throwing-an-incorrect-syntax

And as suggested in the above link can you try with giving your table name inside [] , just a wild guess.

If [] doesn't works out you can also try using "" mask , say like FROM "/XYZ/SFLIGHT"

Please give this a try and let me know.

Lets wait for some expert comments here.

Thanks,

Sijin

Re: AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/"

Sijin_Chandran — Thu, 19 Sep 2019 09:36:05 GMT

Considering the below thread,

https://answers.sap.com/questions/9089838/invalid-table-name-in-sql-command-editor-for-table.html

I guess "" mask should work in your case and as mentioned by me over comments earlier try with [] and '' mask also in case "" doesn't work.

Eg. FROM "/XYZ/SFLIGHT" or FROM [/XYZ/SFLIGHT] or FROM '/XYZ/SFLIGHT'

Please give this a try and update here.

Thanks,

Sijin

Re: AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/"

DoanManhQuynh — Fri, 20 Sep 2019 08:32:24 GMT

table naming look like BW object, I think you should put it inside " " (double quote) mark.

Re: AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/"

mahesh_2093 — Sun, 28 Aug 2022 04:51:06 GMT

Quotations ( "/XYZ/SFLIGHT" ) worked.

Thank You !

Re: AMDP error -SQLSCRIPT: sql syntax error: incorrect syntax near "/"

Kirubakaran_72 — Sat, 09 Nov 2024 04:04:43 GMT

Make sure your using only UPPER CASE characters. Using lower case characters with "(Double Quotes) will show as error only.