topic Re: sel opts in Application Development and Automation Discussions

sel opts

Former Member — Mon, 28 Jul 2008 07:10:29 GMT

hi !

how can i use up to rows in select-options Select stmt.

can any one give me wit an example code.

thanks and regards.

rajesh.

Re: sel opts

Former Member — Mon, 28 Jul 2008 07:12:04 GMT

This message was moderated.

Re: sel opts

bpawanchand — Mon, 28 Jul 2008 07:14:50 GMT

Well when you declare a SELECT-OPTIONS in your programs you have the ICON at the extreme right with an ARROW symbol known INTERVALS select it and enter the range manually or

if you want to go through programtically

use

SELECT-OPTIONS :

S_carrid for spfli-carrid.

s_carrid-LOW = 'AA'.

S-CARRID-HIGH = 'UA'.

S-carrid-sign = 'E'.

s-carrid-option = 'BT'.

APPEND s_carrrd.

select *

from <table name>

where <feild> in <select-options>

into table <itab>

up to <n> rows.

Regards

Pavan

Re: sel opts

Former Member — Mon, 28 Jul 2008 07:15:16 GMT

Hi Rajesh,

When you want to validate the given input in your select options you can use this statement

select * from <tablename> up to 1 rows into <target> where <fld> in <sel-opt>.

select * from mara up to 1 rows into table it_mara where matnr in s_matnr.

here s_matnr is select option in the program.

regards

padma

Re: sel opts

Former Member — Mon, 28 Jul 2008 07:15:36 GMT

Rajesh,

your code looks like this:

SELECT-OPTIONS: S_MATNR FOR MARA-MATNR.

SELECT * FROM MARA WHERE MATNR IN S_MATNR upto 25 rows.

Amit.

Re: sel opts

Former Member — Mon, 28 Jul 2008 07:18:49 GMT

Hi,



tables : bsis.

data : begin of gt_bsis occurs 0,
            bukrs like bsis-bukrs,
            hkont like bsis-hkont,
            belnr like bsis-belnr,
        end of gt_bsis.

select-options : so_bukrs for bsis-bukrs,
                        so_hkont for bsis-hkont.


start-of-selection.

select bukrs hkont belnr up to 10 rows from bsis into table 
                        gt_bsis where bukrs in so_bukrs and
                                             hkont in so_hkont.

"Write the output to the list.

Thanks,

Sriram Ponna.

Re: sel opts

Former Member — Mon, 28 Jul 2008 07:19:38 GMT

Try this code:

select-options: s_vbeln for ygtsheader-vbeln.

SELECT vbeln

INTO (st_header-vbeln)

UP TO 1 ROWS

FROM ygtsheader

WHERE vbeln IN s_vbeln.

ENDSELECT.

Regards,

Joy.

Re: sel opts

Former Member — Mon, 28 Jul 2008 07:20:56 GMT

Hi,

since select-options are internal tables so you can initialiZe them by using SELECT OPTION.... UPTO N ROWS.

select CARRID

INTO STMT

from SCARR up to 5 rows

Regards,

anirban

Re: sel opts

Former Member — Mon, 28 Jul 2008 07:23:47 GMT

Hi Rajesh,

Refer the following codes, that will help to you.

tables: mara.

data : begin of it_mara occurs 0,

matnr like mara-matnr,

end of it_mara.

SELECT-OPTIONS: S_MATNR FOR MARA-MATNR.

SELECT matnr FROM MARA into corresponding fields of table it_mara up to 5 rows where matnr in s_matnr.

loop at it_mara.

write : / it_mara-matnr.

endloop.

Hope it is helps.

Regards,

T.D.M.

Re: sel opts

Former Member — Mon, 28 Jul 2008 07:24:10 GMT

hiiii

use like below code

SELECT-OPTIONS  S_MATNR FOR MARA-MATNR.

SELECT  MATNR FROM MARA WHERE MATNR IN S_MATNR UPTO 10 ROWS.

regards

twinkal

Re: sel opts

Clemenss — Mon, 28 Jul 2008 07:29:11 GMT

Hi Rajesh,

I made a small addition to "use up to rows in select-options Select stmt":


> Hi,
> 
> 
> 
> tables : bsis.
> 
> data : begin of gt_bsis occurs 0,
>             bukrs like bsis-bukrs,
>             hkont like bsis-hkont,
>             belnr like bsis-belnr,
>         end of gt_bsis.
> 
> select-options : so_bukrs for bsis-bukrs,
>                         so_hkont for bsis-hkont.
> 
> parameters:
>   p_maxsel type TBMAXSEL. "parameter to determine maximum numer of records to be selected
> start-of-selection.
> 
> select bukrs hkont belnr up to  p_maxsel  rows from bsis into table " added  p_maxsel 
>                         gt_bsis where bukrs in so_bukrs and
>                                              hkont in so_hkont.
> 
> "Write the output to the list.
> 
> 
> 
> Thanks,
> Sriram Ponna.

Regards,

Clemens