topic Re: Select options in Application Development and Automation Discussions

Select options

Former Member — Sat, 15 Mar 2014 06:41:38 GMT

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

Re: Select options

Former Member — Sat, 15 Mar 2014 06:53:30 GMT

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.

Re: Select options

Former Member — Sat, 15 Mar 2014 07:00:10 GMT

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