Select Query

[Former Member]

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

[Former Member]

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

[Former Member]

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

How to write select query

Can u please tell me

[Former Member]

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

[Former Member]

hi

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^

[dev_parbutteea]

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

[Former Member]

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

[Former Member]

Thank you for all answers

[Former Member]

Thank you