topic Select-Options not working in Application Development and Automation Discussions

Select-Options not working

Former Member — Tue, 14 Jun 2011 10:34:14 GMT

Hi,

I have a select options as below

SELECT-OPTIONS : s_date FOR ekbe-cpudt NO INTERVALS

OBLIGATORY DEFAULT sy-datum.

now when i enter three dates in the selection screen, the values are shown below for S_DATE.

SIGN OPTION LOW HIGH

I |EQ |20110606|00000000

I |EQ |20110607|00000000

I |EQ |20110608|00000000

Now in my Select Query I mention for eg ..

Select Ebeln

ebelp

from ekbe

into itab

where cpudt in s_date

But the select query fetches only the records for teh first date i.e. 20110606 and not for the other two dates..

Kindly advice...

Regards

Former Member — Tue, 14 Jun 2011 10:37:37 GMT

hi,

Select Ebeln

ebelp

from ekbe

into itab

where cpudt in s_date

you are passing data to itab? shouldnt it be "into table itab"

is it a typing error,or have you done same in codE?

former_member212713 — Tue, 14 Jun 2011 10:40:11 GMT

Hi Sam;

Please change as below code.

Best regards.


Select Ebeln
ebelp
into table itab
from ekbe 
"into itab
where cpudt in s_date

Former Member — Tue, 14 Jun 2011 10:43:47 GMT

hi,

i executed the same code.

Its working fine.Check the entries in table.

Former Member — Tue, 14 Jun 2011 13:18:03 GMT

Any objections if I re-assign the polnts here?

Done.

Rob

Edited by: Rob Burbank on Jun 15, 2011 2:50 PM