Use decimal in where clause in SAP ABAP

You are trying to use the user-specific setting in your queries, but ABAP does not support it. You need to use ‘.’ as the decimal separator instead of ‘,’.

So the query would look something like −

SELECT * FROM <table> INTO <index_tab>
WHERE amount = 10.15

Karthikeya Boyini

Published on 19-Dec-2017 09:00:37

• Related Questions & Answers
• Error while using LOOP…..WHERE in SAP ABAP
• “Where” clause not working while updating database record in ABAP
• How to use MySQL VIEW with WHERE clause?
• How Can we use MySQL DISTINCT clause with WHERE and LIMIT clause?
• How to use MySQL Date functions with WHERE clause?
• Can we use WHERE clause inside MySQL CASE statement?
• Multiple Where clause in C# Linq
• How can we use MySQL INSTR() function with WHERE clause?
• How can we use FIND_IN_SET() function with MySQL WHERE clause?
• How can we use ASCII() function with MySQL WHERE clause?
• How can we use CHAR_LENGTH() function with MySQL WHERE clause?
• How can we use BIN() function with MySQL WHERE clause?
• How can I use SPACE() function with MySQL WHERE clause?
• How can we use two columns with MySQL WHERE clause?
• Negation logic in SAP ABAP