Want select query to use Key Field in where clause with ranges

Hi,

Hi,

I need to use the ranges in the where clause.

I have performance issue in the select query so I want to use the key field of the table AFRu-RUECK

In where clause using Ranges..so that it will select all the ranges...

Select Single rueck

rmzhl

iedd

aufnr

stokz

stzhl

from afru into table et_afru

where

aufnr = i_aufnr and

stokz = space and

stzhl = 0.

Can anybody help me with the syntax...

Regards,

Kittu