topic SELECT OPTIONS PROBLEM in Application Development and Automation Discussions

SELECT OPTIONS PROBLEM

Former Member — Tue, 16 Dec 2008 11:29:13 GMT

hello all,

i have two date fields BLDAT & BLDAT1 in selection-screen, and i hardcoded the second date in program. but problem is that when i m picking data by passing BLDAT1(that is hardcoded date) then its making no effect and picking all data from table. can anyone please help me?

code :

bldat1-low = '20080101'.

bldat1-high = '20080131'.

g = '2008'.

IF ITAB[] IS NOT INITIAL.

SELECT bldat awkey FROM bkpf INTO TABLE itab2 WHERE bldat IN bldat1

AND blart = 'RE'

AND bukrs = '1000'

AND gjahr = g.

endif.

regards saurabh.

Re: SELECT OPTIONS PROBLEM

Former Member — Tue, 16 Dec 2008 11:31:46 GMT

Hi saurabh,

You need to also provide values for SIGN (I) and OPTION (EQ).

You need to APPEND the bldat1 to the internal table bldat1.

So,


bldat1-sign = 'I'.
bldat1-option = 'BT'. " u can also use  'EQ'
bldat1-low = value.
bldat1-high - value.
append bldat1 to bldat1.

Best Regards,

Ram.

Re: SELECT OPTIONS PROBLEM

SuhaSaha — Tue, 16 Dec 2008 11:33:48 GMT

Hello Saurabh,

Try this:


bldat1-sign = 'I'
bldat1-option = 'BT'.
bldat1-low = '20080101'.
bldat1-high = '20080131'.
APPEND bldat1.

@ Ram: You cannot use EQ for HIGH & LOW values )

Hope this helps.

BR,

Suhas

Edited by: Suhas Saha on Dec 16, 2008 12:37 PM

Re: SELECT OPTIONS PROBLEM

Former Member — Tue, 16 Dec 2008 11:34:52 GMT

Hi,

You will have to append the values to the selection table before applying it in the select query.

e.g.

bldat1-low = '20081201'.

bldat1-high = '20081231'.

bldat1-sign = 'I'.

bldat1-option = 'BT'.

append bldat1.

now use it in the select statement.

select f1 f2 from table name where bldat in bldat1.

Regards,

Sachin Dargan

Re: SELECT OPTIONS PROBLEM

Subhankar — Tue, 16 Dec 2008 11:36:41 GMT

Hi....

Select option contain 4 field. SIGN, OPTION, LOW and HIGH.

use the your code as below...

bldat1-sign = 'I'.

bldat1-option = 'BT'. -

> It should be BT as you have passed value in HIGH

bldat1-low = '20080101'.

bldat1-high = '20080131'.

g = '2008'.

IF ITAB[] IS NOT INITIAL.

SELECT bldat awkey FROM bkpf INTO TABLE itab2 WHERE bldat IN bldat1

AND blart = 'RE'

AND bukrs = '1000'

AND gjahr = g.

endif.