Access in abap report to hana view in SYS schema

[Former Member]

I want to create a report in abap and execute this query:

     "Select PATH from M_DISK"

and I have this error:

"M_DISK" is not defined in the ABAP Dictionary as a table, projection view, or database view.

M_DISK is a view in SYS schemafrom hana.

Thanks

[former_member189905]

Hi,

if you release is earlier 7.4 you must use Native SQL.

For the 7.4 release, you must create a dictionary view in HANA and import it in ABAP Data dictionary.

After this operation, you can access to this view imported like a table of your SAP Database by Open SQL statements.

I hope that will help you.

[former_member189905]

Hi,

Add the name of your schema before the table.

Check your autorisation for this schema.

Check the use of this schema.

[pfefferf]

It is not possible to access the M_DISK view directly via Open SQL. You have to use for instance an AMDP, and ADBC statement or a dedicated secondary database connection for that specific schema. What is valid in Khalid's answer is that the user which is used for the DB connection needs the necessary SELECT privileges.

Regards,

Florian