Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Jacek
Creator
Creator

SAP Connector - how to fetch column called "FROM"

Hi! I cannot fetch column called "FROM" from SAP table using  Qlik SAP Connectors . I tried use also parsing function like: upper(FROM), text(FROM), "FROM", 'FROM' - the same error. When I open preview tables from Qlik Sense, system cannot prepare load script for this table - loading preview without end. Probably due to the same problem. Please help 🙂

Error:

Connector reply error: RfcAbapException:SQL_ERROR Message: This Open SQL statement uses additions that can only be used when the fixed point arithmetic flag is activated (such as CASE expressions or host variables in expressions).
 
SAP.png
5 Replies
fosuzuki
Partner
Partner

Hello Jacek,

Have you tried using [FROM]?

SELECT [FROM] FROM YMDCS_005;

 

BR

Jacek
Creator
Creator
Author

Fernando, just tested, the same error 😞

The following error occurred:
Connector reply error: RfcAbapException:SQL_ERROR Message: "[" is invalid here (due to grammar). contains an invalid character or it is a Line: 4 Word: [
 
The error occurred here:
SELECT [FROM] FROM YMDCS_005
PradeepK
Creator II
Creator II

Not sure .. but also try 

  1. `FROM`
  2. $('FROM')

 

Jacek
Creator
Creator
Author

Thanks, unfortunately no luck. I'm pretty sure that this is an exception, which can be solved only in SAP Connector code. @support

msan
Partner
Partner

Maybe use * if the table has a reasonable number of columns and then in the Qlik part of the script just selected column FROM