SAP SQL Connector: error " ...... is not defined in the ABAP Dictionary as a table, projection view, or database view".

[Joseph_Musekura]

The following error could be thrown when extracting data using  Qlik SAP SQL Connector "ID:00 Type:E Number:001 'xxxxxx' is not defined in the ABAP Dictionary as a table, projection view, or database view" where ''xxxxxx' is the name of the table.  

Environment:

Qlik SAP Connectors 

Resolution:

The SQL connector can fetch data from Cluster tables, Views and  Transparent tables but NOT from an "internal/structure" table. 

Please check if the table ''xxxxxx' that is being accessed is not an "internal/structure" table.
"Structure table" holds no permanent data thus can’t be accessed using SELECT statement. 

This can be checked in transaction SE11: