topic Re: Select options in Application Development and Automation Discussions

Select options

Former Member — Sat, 07 Oct 2006 09:20:31 GMT

Hi there,

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

Plz.

Thanx n advance,

Venu

shishupalreddy — Sat, 07 Oct 2006 09:24:28 GMT

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.

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 — Sat, 07 Oct 2006 09:25:18 GMT

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.

select * from table_naem where date = s_date-high.

hope u undrstud.

rgds

anver

if hlped mark points

Former Member — Sat, 07 Oct 2006 09:29:39 GMT

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.

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

thanks

srinivas