Select options

[Former Member]

Hi Experts,

Following is my selection screen which is very common. Date field is mandatory. When I enter the following dates (there are 25 records for it), in debugger it shows 0.

select ebeln

          bedat

        bsart

        ekgrp

        lifnr

from ekko

into table gt_ekko

where ebeln = s_ebeln and bedat = s_date and ekgrp = s_ekgrp and lifnr = s_lifnr and bsart = s_bsart.

The only mandatory field should be date. Why it is not picking any record when the user only enters the date?

Regards

Mani

[Former Member]

Hai,

first check,all the fields that you menctioned in the select query are declared in your internal table.

Try this:

select ebeln

          bedat

        bsart

        ekgrp

        lifnr

from ekko

into table gt_ekko

where ebeln in s_ebeln and bedat in s_date and ekgrp in s_ekgrp and lifnr in s_lifnr and bsart in s_bsart.

[Former Member]

hi mani,

                use the following

1. for select-option use "IN" in where condition.

2. for parameters use "eq" in where condition.

hope it helps

vikas