06-14-2011 11:34 AM
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
06-14-2011 11:37 AM
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?
06-14-2011 11:37 AM
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?
06-14-2011 11:40 AM
Hi Sam;
Please change as below code.
Best regards.
Select Ebeln
ebelp
into table itab
from ekbe
"into itab
where cpudt in s_date
06-14-2011 11:43 AM
hi,
i executed the same code.
Its working fine.Check the entries in table.
06-14-2011 2:18 PM
Any objections if I re-assign the polnts here?
Done.
Rob
Edited by: Rob Burbank on Jun 15, 2011 2:50 PM