topic Re: select-options in Application Development and Automation Discussions

select-options

Former Member — Wed, 24 Oct 2007 05:46:59 GMT

Hi all,

I want to read only those two records given in lower limit and upperlimit of select-options.

pls help me ....points will be rewarded..

ThankYou,

Prashanth.

Re: select-options

Former Member — Wed, 24 Oct 2007 05:48:38 GMT

Declare your select option with "NO-EXTENSION" clause. This will make sure that you will be able to enter only LOW and HIGH value in select option.

ashish

Re: select-options

Former Member — Wed, 24 Oct 2007 05:48:58 GMT

HI,

tables:mara.

select-options:mat for mara-matnr no-extension.

data:itab like mara occurs 0 with header line.

select * from mara into table itab where matnr = mat-low or matnr = mat-high.

loop at itab.

write:/ itab-matnr,itab-ernam,itab-ersda.

endloop.

rgds,

bharat.

Re: select-options

Former Member — Wed, 24 Oct 2007 05:50:29 GMT

hi,

write the query like this..

consider SELOPT is ur select options for MATNR

SELECT *

FROM MARA INTO TABLE ITAB

WHERE

MATNR EQ SELOPT-LOW OR

MATNR EQ SELOPT-HIGH.

With Rgds,

S.Barani

Re: select-options

Former Member — Wed, 24 Oct 2007 05:51:02 GMT

use NO-EXTENSION

Re: select-options

Former Member — Wed, 24 Oct 2007 06:10:56 GMT

hi prashanth,

use :

SELECT * FROM TABLENAME

INTO TABLE ITAB

WHERE FIELD EQ SEL_OPTLOW OR FIELD EQ SEL_OPTHIGH.

Hope this helps u.

regards,

sohi

Re: select-options

Former Member — Wed, 24 Oct 2007 06:41:04 GMT

can i get the solution using/Creating the "RANGES"tables....

Message was edited by:

Prashanth Polsani

Re: select-options

Former Member — Wed, 24 Oct 2007 06:42:54 GMT

The Low value and high Value itself gives u a range.

regards,

Vimal

Re: select-options

Former Member — Wed, 24 Oct 2007 06:45:03 GMT

Hi,

use IN operator in the select query.

Select * from MARA
      into table itab
      where matnr IN s_matnr.

This will include low & high values of S_MATNR.

Best regards,

Prashant

Re: select-options

Former Member — Wed, 24 Oct 2007 06:51:37 GMT

Hi Prashanth,

You can use either of these:

Eg :1

select-options:s_matnr for mara-matnr no-extension.

data:itab like mara occurs 0 with header line.

Select * from MARA

into table itab

where matnr IN s_matnr.

eg :2

select-options:s_matnr for mara-matnr no-extension.

data:itab like mara occurs 0 with header line.

select * from mara into table itab where matnr = mat-low or matnr = mat-high.

Reward if useful.

Regards,

Chitra Parameswaran

Re: select-options

Former Member — Wed, 24 Oct 2007 06:54:25 GMT

Hi Prasanth,

Use the below logic

data v_num type i.

select-options: s_num for v_num.

at selection-screen.

delete s_num where not option = 'BT'.

Re: select-options

Former Member — Wed, 24 Oct 2007 07:13:01 GMT

Hi Prashanth,

Suppose you have created the select option named s_matnr.

then you can write the query,

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

reward if useful,

regards,

Supriya

Re: select-options

Former Member — Wed, 24 Oct 2007 08:34:19 GMT

One more way of doing this if you dont want to use No Extension :

SELECT *

FROM MARA INTO TABLE ITAB

WHERE

MATNR IN s_matnr.

describe table itab lines lin .

After this

DELETE ITAB from 2 to (lin-1) .

Itab will always have 2 records with low and high value .

Praveen.

Message was edited by:

praveen parasiya

Re: select-options

Former Member — Wed, 24 Oct 2007 08:44:38 GMT

Hi,

You can use the ranges or select statement as below :

select-options : so_bukrs for bsis-bukrs. 

First Option

ranges : gr_bukrs for bsis-bukrs.

initialization.

gr_bukrs-option = 'BT'.
gr_bukrs-sign = 'I'.
gr_burks-low = so_bukrs-low.
gr_bukrs-high = so_bukrs-low.

append gr_bukrs.

gr_bukrs-option = 'BT'.
gr_bukrs-sign = 'I'.
gr_burks-low = so_bukrs-high.
gr_bukrs-high = so_bukrs-high.

append gr_bukrs.


start-of-selection.

select field1 field2 from <tablename> into table itab where bukrs in gr_bukrs.


or 

Second option.

select field1 field2 from <tablename> into table itab
                       where bukrs eq so_bukrs-low
                            or  bukrs eq so_bukrs-high.

Thanks,

Sriram Ponna.

Re: select-options

Former Member — Wed, 24 Oct 2007 08:52:07 GMT

Why don't you use select_option-low and select_option-high values for selection.