Application Development and Automation 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: 
Read only

SELECT-OPTIONS

Former Member
0 Likes
758

SELECT-OPTIONS DATE FOR SY-DATUM DEFAULT SY-DATUM.

SELECT *

FROM BUT000

WHERE BUT000~CRDAT ????? Date.

If CRDAT is in the interval given as parameter/select-option it should be shown in the SELECT. What should I write?

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
720

Hi,

IN !!

SELECT-OPTIONS DATE FOR SY-DATUM DEFAULT SY-DATUM.

SELECT *

FROM BUT000

WHERE BUT000~CRDAT <b>IN</b> Date.

Sri

Message was edited by: Srikanth Pinnamaneni

SELECT-OPTIONS DATE FOR SY-DATUM DEFAULT SY-DATUM.

SELECT *

FROM BUT000

WHERE BUT000~CRDAT ????? Date.

If CRDAT is in the interval given as parameter/select-option it should be shown in the SELECT. What should I write?

3 REPLIES 3
Read only

Former Member
0 Likes
721

Hi,

IN !!

SELECT-OPTIONS DATE FOR SY-DATUM DEFAULT SY-DATUM.

SELECT *

FROM BUT000

WHERE BUT000~CRDAT <b>IN</b> Date.

Sri

Message was edited by: Srikanth Pinnamaneni

Read only

Former Member
0 Likes
720

SELECT-OPTIONS DATE FOR SY-DATUM DEFAULT SY-DATUM.

SELECT *

FROM BUT000

WHERE BUT000~CRDAT <b>IN</b> Date.

Sudha

Read only

Vinod_Chandran
Active Contributor
0 Likes
720

Hi Linn,

You have write as follows

SELECT *

FROM BUT000

WHERE BUT000~CRDAT IN DATE.

Cheers

Vinod