topic Re: help on selection table in Application Development and Automation Discussions

help on selection table

selvi1 — Fri, 18 May 2007 06:18:09 GMT

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.

Re: help on selection table

Former Member — Fri, 18 May 2007 06:21:00 GMT

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

Re: help on selection table

Former Member — Fri, 18 May 2007 06:23:28 GMT

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

Re: help on selection table

Former Member — Fri, 18 May 2007 06:32:28 GMT

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