SNAP_BEG table does not exist

[Former Member]

Hello,

I am working on a script which basically does a select count(*) on the SNAP_BEG table to get the number of short dumps occurred in the last weeks.

When checking the table via SE16, I can clearly see the contents and all the data I need from the table.

The problem is that when I do the select via the sql console from HA studio (SELECT count(*) from SCHEMA.SNAP_BEG or even SELECT * FROM SCHEMA.SNAP_BEG) I get the following error:

SAP DBTech JDBC: [259]: invalid table name: Could not find table/view SNAP_BEG in schema

I tried executing the command with both the SCHEMA user or the SYSTEM user but I got the same results.

What am I missing here?

Thank you

[matt]

Seems to me that this is more a HANA issue than an ABAP issue.

[UweFetzer_se38]

SNAP_BEG is not a database table but a projection view. Try to select directly from the base table SNAP instead.