Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Select-Options not working

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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?

4 REPLIES 4

Former Member
0 Kudos

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
Contributor
0 Kudos

Hi Sam;

Please change as below code.

Best regards.


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

0 Kudos

hi,

i executed the same code.

Its working fine.Check the entries in table.

Former Member
0 Kudos

Any objections if I re-assign the polnts here?

Done.

Rob

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