3

How can I select table names that do contain slashes in the inline SQL performance analysis (aka "Explain SQL") of transaction ST05?

I tried escaping them with '/table/name' or "/table/name" or "\/table\/name". None of them worked.

Works for tables without slashes:

SELECT * FROM table_name

but not for tables with slashes (e.g. from a namespace):

SELECT * FROM /table/name.
Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
koks der drache
  • 1,398
  • 1
  • 16
  • 33
  • Have you tried without escaping? It works for me. – András Apr 28 '19 at 05:09
  • @konstantin : in the "Explain SQL" screen, you must use the SQL syntax corresponding to your database, not [ABAP SQL](https://help.sap.com/doc/abapdocu_753_index_htm/7.53/en-US/index.htm?file=abenopensql.htm) (ABAP SQL is a SQL-like language which is the greatest common divisor of the SQL of all databases supported by ABAP-based systems). – Sandra Rossi Jun 15 '19 at 07:10

1 Answers1

4

You can use Double Quotes to get the plan. Using quotes it is important to write the table names in capital letters.

SELECT * FROM "/TABLE/NAME"

The actual error occurs in the report RSXPLORA in form db_explain_plan where the undebuggable function DB_EXPLAIN_PLAN is called. It varies depending on sy-dbsys(3) which is ORA in my case.

koks der drache
  • 1,398
  • 1
  • 16
  • 33
Matthias Dachner
  • 56
  • 3