12-19-2006 1:55 AM
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.
12-19-2006 2:01 AM
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
12-19-2006 1:56 AM
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
12-19-2006 1:59 AM
Hi,
I tryed using in also still the sy-subrc is 4 only but i have the data in the vbrk table.
Thanks,
Rajendra.
12-19-2006 2:01 AM
12-19-2006 1:56 AM
12-19-2006 1:56 AM
12-19-2006 2:01 AM
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