SQL syntax issue when selecting from edid4

[walkerist79]

Hi, I was encountering issues with this query. Not sure how to solve it.

 SELECT *
 FROM edid4
 WHERE segnam = 'E1EDK03'
 AND docnum = '0000123'
 AND segnum = '000009'
 INTO @DATA(lt_edid4).

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

[Ryan-Crosby]

Hi Wane,

You are missing the INTO TABLE since you have not indicated that you want to select a single record.

Regards,

Ryan Crosby

[walkerist79]

ryan.crosby2 same issue with the "INTO TABLE @DATA(lt_edid4)."

[RaymondGiuseppi]

Any reason not to activate the 'fixed point arithmetic flag' in program attributes.

[Sandra_Rossi]

You can search the forum about what the "fixed point arithmetic flag" is. It's probably said at lots of places that it's highly recommended that the programs use it.

NB: it's fun that SAP forced the use of that flag when the program uses the Strict SQL Syntax, although it doesn't seem related at all.

[Dominik_Tylczynski]

Switch on "fixed point arithmetic" and it'll work fine. As per SAP Help https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abenfixed_point_arithmetic_glosry.htm

The disabling of this program attribute is obsolete.