SNAP_BEG table does not exist

Former Member — Sun, 09 Jun 2019 19:35:39 GMT

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

Re: SNAP_BEG table does not exist

matt — Mon, 10 Jun 2019 06:09:09 GMT

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

Re: SNAP_BEG table does not exist

UweFetzer_se38 — Tue, 11 Jun 2019 09:34:03 GMT

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

topic Re: SNAP_BEG table does not exist in Application Development and Automation Discussions

SNAP_BEG table does not exist

Re: SNAP_BEG table does not exist

Re: SNAP_BEG table does not exist