Select options

[Former Member]

Hi there,

How to use select query with select option low and high,

Plz.

Thanx n advance,

Venu

[shishupalreddy]

Hi ,

Follow the sample code .

SELECT-OPTIONS : s_kunnr for kna1-kunnr.

data: itab type table of kna1 with header line.

select * from kna1 into table itab where kunnr IN s_kunnr.

or

select * from kna1 into table itab where kunnr between s_kunnr-low and s-kunnr-high.

Dont forget to give the reward points if helpful.

Regads,

[anversha_s]

hi,

check this sample code...

tables: mkpf.

select-options: s_date for mkpf-budat.

the first field will be

s_date-low

and the next fiedl will be s_date-high.

so query will be.

select * from table_naem where date = s_date-low.

or

select * from table_naem where date = s_date-high.

hope u undrstud.

rgds

anver

if hlped mark points

[Former Member]

SELECT-OPTIONS :S_MATNR FOR MARA-MATNR.

where select-options is table which contains fields like

low ,high,option,sign.

in order to write a query

we have to write like

select matnr from mara where matnr in s_matnr.

or

select matnr from mara where matnr between s_matnr-low and s_matnr-high.

thanks

srinivas