sel opts

[Former Member]

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.

[Former Member]

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.

[Former Member]

This message was moderated.

[bpawanchand]

Hi

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

[Former Member]

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>.

eg

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

[Former Member]

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.

[Former Member]

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.

[Clemenss]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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