topic Re: Select Query in Application Development and Automation Discussions

Select Query

Former Member — Fri, 03 Aug 2007 03:09:44 GMT

I have selection screen with select-options field Validity

If the user enters some date

I have to fetch the data from A017 table depends on Datab Datbi that record should display

How to write select query to check the entered date is in between database fields Datab and Datbi

Re: Select Query

Former Member — Fri, 03 Aug 2007 03:14:54 GMT

Hi Pradeep,

If the date entered is in the select-option then it is very hard to validate the same.

As it involve lots of things to be checked.

Better define date as parameter and use you can check very easily.

Regards,

Atish

Re: Select Query

Former Member — Fri, 03 Aug 2007 03:31:06 GMT

if i declare it as parameter how to use it in select query

How to write select query

Can u please tell me

Re: Select Query

Former Member — Fri, 03 Aug 2007 03:32:57 GMT

You can write like

if user enters only low value and high value..

declare two variables

data : v_date1 type sy-datum,

v_date2 type sy-datum.

start-of-selection.

loop at s_date. -> select option

v_date1 = s_date-low.

v_date2 = s_date-high.

endloop.

select * from A017 into table int_a017

where datab ge v_date1

and datbi le v_date2.

Thanks

Seshu

Re: Select Query

Former Member — Fri, 03 Aug 2007 03:54:41 GMT

good

with the select query stament add the A017-FIELD NAME EQ that field name where you r going to entered the date,

thanks

mrutyun^

Re: Select Query

dev_parbutteea — Fri, 03 Aug 2007 04:32:34 GMT

Hi,

why don't you use :

where s_validity is your select option

select * from A017

into table int_a017

where datab in s_validity

and datbi in s_validity.

Regards

Re: Select Query

Former Member — Fri, 03 Aug 2007 06:23:00 GMT

select-options: s-date for a017-datab.

SELECT *

FROM a017 into itab

WHERE datab LE s_date

AND datbi GE s-date.

reward if useful

anju

Re: Select Query

Former Member — Fri, 03 Aug 2007 07:27:15 GMT

Thank you for all answers

Re: Select Query

Former Member — Fri, 03 Aug 2007 07:28:10 GMT

Thank you