topic Re: SELECT-OPTION in Application Development and Automation Discussions

SELECT-OPTION

Former Member — Tue, 11 Sep 2007 11:56:39 GMT

I want to filter the data according to the inputs given by user in SELECT-OPTION.

in an select quires.

please help to know how to get the values enter by user in screen of Select-option ...is it in LOW and HIGH of SELECT-OPTION. ??

Thanks in advance

Re: SELECT-OPTION

Former Member — Tue, 11 Sep 2007 11:58:28 GMT

Hi,

Refer to the following code:

SELECT vbeln

fkart

fkdat

FROM vbrk

INTO TABLE int_vbrk

WHERE vbeln IN s_vbeln.

Hope this helps.

Regards,

Sipra

Message was edited by:

Alvaro Tejada Galindo

Re: SELECT-OPTION

former_member404244 — Tue, 11 Sep 2007 11:58:46 GMT

Hi,

u ahve to write the query like this irrespective of low or high.

data : s_matnr for mara-matnr.

select * from mara into table itab where matnr in s_matnr.

Regards,

Nagaraj

Re: SELECT-OPTION

Former Member — Tue, 11 Sep 2007 11:59:52 GMT

if u have given SELECT-OPTIONS: A for MARA-MATNR..

then in select query u can write the code as following.

code no _ 1.

select * from mara

into table IT_MARA

where

matnr IN A.

Code No 2.

select * from mara

into table IT_MARA

where

matnr >= A-LOW or

matnr <= A-HIGH.

but i think the Code No 1 is the best option and used by the all ABAPers....

Message was edited by:

Alvaro Tejada Galindo

Re: SELECT-OPTION

Former Member — Tue, 11 Sep 2007 12:00:24 GMT

Hi,

Here i am sending sample code for selecting the data by enetring selection screen values

SELECT-OPTIONS : S_MATNR FOR MARA-MATNR.

select matnr from mara into table itab where matnr = s_matnr.

praveen

Message was edited by:

Alvaro Tejada Galindo

Re: SELECT-OPTION

Former Member — Tue, 11 Sep 2007 12:07:41 GMT

hi,

select options internally creates a internal table for u with four field

1. low

2. high

3. sign

4. option.

for ex:

select-options: s_vbeln like vbap-vbeln.

in select statement u can give as

select * from vbap into table itab where vbeln in s_vbeln.

means that all the values u gave in select options are considered here.

the screen which u get for select options will have again four options as

include -

single value or range of values

exclude -

single value or range of values.

with regards,

Suresh Aluri.

Message was edited by:

Alvaro Tejada Galindo

Re: SELECT-OPTION

Former Member — Tue, 11 Sep 2007 12:17:13 GMT

Hello Lokesh,

validate the field that u are selecting from the selection statements like this in where clause...

.....

WHERE MATNR IN S_MATNR.

Now select statement will fetch the records for only the values given in LOW and HIGH of S_MATNR.

Regards

Sasidhar Reddy Matli.

Message was edited by:

Alvaro Tejada Galindo

Re: SELECT-OPTION

varma_narayana — Tue, 11 Sep 2007 12:53:14 GMT

Hi Lokesh..

This is the Sample code.

TABLES : EKKO.

SELECT-OPTIONS: S_EBELN FOR EKKO-EBELN.

START-OF-SELECTION.

SELECT * FROM EKKO INTO TABLE IT_EKKO

WHERE EBELN IN S_EBELN.

there is no need to Fill the LOW and HIGH explicitly. The user input is automatically store in SELECT-OPTION field.

Message was edited by:

Alvaro Tejada Galindo

Re: SELECT-OPTION

Former Member — Wed, 12 Sep 2007 04:29:35 GMT

Hi Lokesh,

If you have s_matnr as your select options, all values entered on the selection screen will be considered.

Select * into itab from mara

where matnr in s_matnr.

As you may know, s_matnr is a table. As described by other replies, all your inputs will be in this table.

If you enter one value say '100' on your screen, your table has one entry

s_matnr-low = '100'

s_matnr-high= initial

s_matnr-sign= 'I'

s_matnr-option='EQ'

Best thing to do is run your program or any SAP program with input, and enter values in the From and To and also ranges if there is one. Enter a bunch of values and then debug and examine the s_matnr table and see how the program has populated the table. Note the -sign and -option values. Best way to learn this.

Hope this helps.

Filler