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

Select-options

Former Member — Tue, 20 Nov 2007 17:45:50 GMT

Hi All,

I have specified two values in a select-option.

for eg dat1 to dat7

if i want all the values that fall in dat1 to dat7 in an internal table, hw can i do it?

thanks,

Former Member — Tue, 20 Nov 2007 17:55:51 GMT

Hi Hitesh,

You can do like this

REPORT ZTEST .

tables: kna1.

Select-options: s_kunnr for kna1-kunnr.

Data: begin of itab occurs 0,

kunnr type kna1-kunnr,

end of itab.

Select Kunnr from kna1 into table itab where kunnr in s_kunnr.

Loop at itab.

write: / itab.

endloop.

Reward Points if this helps,

Satish

Former Member — Tue, 20 Nov 2007 18:41:59 GMT

Hi,

You shud use IN operator in your select stmt as below

Select Kunnr from kna1 into table itab where kunnr IN s_kunnr.

naimesh_patel — Tue, 20 Nov 2007 18:56:46 GMT

Can you paste your code for the select options here? This will help us to get more idea about the master you are using.

Regards,

Naimesh Patel

Former Member — Tue, 20 Nov 2007 19:05:15 GMT

By defualt it creates an Internal table(selection table) with fields SIGN,OPTION,HIGH and LOW fields when you declare any field as select-options

in this case if you declare date as

Select-options: s_date for sy-datum.

Now whatever values you enter in this low and high fields of select-options they will be stored in the internal table S_DATE.

and accordingly we use this internal table in the select query where condition as:

select* from <table> into table <itab> where date IN s_date.

Regards

anji