topic Re: HELP REQ IN SIMPLE CODE TO RETRIEVE DATA in Application Development and Automation Discussions

HELP REQ IN SIMPLE CODE TO RETRIEVE DATA

Former Member — Mon, 14 Aug 2006 17:35:12 GMT

Hi all,

i need to retrieve data from an internal TABLE whose date field is multiple of 2 days behind from current date.

like todays date is 14/08/06

i need records of date 12/08/06,10/08/06,8/8/06,6/8/06,4/8/06 .....

any help would be appreciated

THANKS

Re: HELP REQ IN SIMPLE CODE TO RETRIEVE DATA

suresh_datti — Mon, 14 Aug 2006 17:41:51 GMT

Didn't sy-datum - 2 help?

~Suresh

Re: HELP REQ IN SIMPLE CODE TO RETRIEVE DATA

RichHeilman — Mon, 14 Aug 2006 17:48:29 GMT

You can use a range for this and build it on the fly. The only question is how far back do you want to go. I mean, how many dates to add to the range. Here I'm only adding 10.



report zrich_0001.

<b>ranges: r_datum for sy-datum.

r_datum-sign = 'I'.
r_datum-option = 'EQ'.
r_datum-low  = sy-datum.  append r_datum.
do 10 times.
  r_datum-low  = r_datum-low - 2.  append r_datum.
enddo.</b>


select .....
          <b>where datum in r_datum</b>.

Regards,

Rich Heilman