Hi ,
I have a select with < for all entries in> clause and i need to get all the values
in the date range . so i declared r_date as range and added in the end of the select using IN Clause...Is that correct or Am I using the wrong declaration,
Is there any other way to define the date ranges in the select?
r_date declaration with RANGES
Date range for the Previous month
r_date-sign = 'I'.
r_date-option = 'BT'.
r_date-low = w_strt_date.
r_date-high = w_end_date.
append r_date.
Select statement:
select <Field names> from <Tabname> into table <Internal Table>
for all entries in t_Keys_POI
where DOC_NUM = t_Keys_POI-DOC_NUM
and DOC_ITEM = t_Keys_POI-DOC_ITEM
and LOGSYS = t_Keys_POI-LOGSYS
and REC_TYPE = 1
and DOC_DATE IN r_date..
Thanks,
Mike