SAP Connector - how to fetch column called "FROM"

[Jacek]

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).

[fosuzuki]

Hello Jacek,

Have you tried using [FROM]?

SELECT [FROM] FROM YMDCS_005;

BR

[Jacek]

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]

Not sure .. but also try 

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

[Jacek]

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

[msan]

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