help on selection table

[selvi1]

hai all,

my requirement is to get the dates given between the low and high values in to an internal table.

how can i do this.

thanks in advance.

[Former Member]

Hi,

you can code like this way

Select date from table into table itab where ( date >= s_date-low and date <=s_date-high ).

Reward points if it is helpful

Regards,

Sangeetha.A

[Former Member]

Hi,

you can do the same using infotypes. There are the two fields , ENDDA and

Begda in infotype pa0001.

also you can use the rp_provide_from_last in your report programme.

****do rewards if usefull

regards,

vijay

[Former Member]

If u r trying to fetch data from a Infotypte, u can use the function module

<b>HR_READ_INFOTYPE</b>, or if u've two different dates for start date and enddate in ur d/b table, u can use the following form of the select statement to fetch data

select <field list>

from <table>

where begda < enddate

and endda > start date