How to specify a decimal filter in 'select into table where' in ABAP?

Question

I need a query like this in ABAP, but this doesn't work.

SELECT * FROM table
INTO i_tab
WHERE amount = 100,15

I've tried: WHERE amount = '100,15' but that doesn't work either.

How to specify the decimal in my where syntax?

Answer 1

I outsmarted it by changing the logic into

WHERE amount > 100 AND amount < 101

Answer 2

The correct syntax is:

SELECT * 
FROM table
INTO i_tab
WHERE amount = '100.15'