topic Re: where condition range in Application Development and Automation Discussions

where condition range

Former Member — Tue, 19 Dec 2006 01:55:07 GMT

Hi,

I am using the below code but the data is not selecting as per the where condition date range.it shows sy-subrc =4.

s_datum-option = 'EQ'.

s_datum-sign = 'I'.

s_datum-low = v_date.

s_datum-high = w_lastday.

append s_datum.

read table s_datum index 1.

SELECT * FROM VBRK INTO CORRESPONDING FIELDS OF TABLE I_VBRK

WHERE VKORG IN S_WERKS

AND FKDAT EQ S_DATUM.

In the above code the data is not selecting for s_datum.how to solve the issue.

Thanks,

Rajendra.

Re: where condition range

Former Member — Tue, 19 Dec 2006 01:56:15 GMT

Hi,

Use IN instead of EQ

SELECT * FROM VBRK INTO CORRESPONDING FIELDS OF TABLE I_VBRK

WHERE VKORG IN S_WERKS

AND FKDAT <b>IN</b> S_DATUM.

Thanks,

Naren

Re: where condition range

RichHeilman — Tue, 19 Dec 2006 01:56:17 GMT

You need to use the IN operator.



SELECT * FROM VBRK INTO CORRESPONDING FIELDS OF TABLE I_VBRK
WHERE VKORG IN S_WERKS
AND FKDAT IN S_DATUM.

Regards,

Rich Heilman

Re: where condition range

RichHeilman — Tue, 19 Dec 2006 01:56:56 GMT

Also, no need for this statement.

read table s_datum index 1.

REgards,

Rich Heilman

Re: where condition range

Former Member — Tue, 19 Dec 2006 01:59:08 GMT

Hi,

I tryed using in also still the sy-subrc is 4 only but i have the data in the vbrk table.

Thanks,

Rajendra.

Re: where condition range

Former Member — Tue, 19 Dec 2006 02:01:07 GMT

Hi,

use BT instead of EQ while building the range

s_datum-option = '<b>BT</b>'.

s_datum-sign = 'I'.

s_datum-low = v_date.

s_datum-high = w_lastday.

append s_datum.

Thanks,

Naren

Re: where condition range

RichHeilman — Tue, 19 Dec 2006 02:01:46 GMT

Oops, I overlooked another thing, you need to use BT as the option.

s_datum-option = 'BT'.

Regards,

Rich Heilman