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: