topic Re: date selection in background in Application Development and Automation Discussions

date selection in background

Former Member — Mon, 19 Nov 2007 10:23:51 GMT

Hi,

i have to run a repot on 15th of every month in a part in the report i want to select the data from table bkdf with the foolwinf condition

The field is BKDF-DBEDT All items with a date in the next 4 month should be

included on the report.

for eg : On September report (run 09/15) all entries with an end date in the range

of 10/01 through 01/31.

October report (run 10/15) would include the date range of 11/01 through

02/28.

Please suggest for what condition should i run select query on table bkdf.

Re: date selection in background

Former Member — Mon, 19 Nov 2007 10:27:10 GMT

add 15 days .

current date add 15 days.

Re: date selection in background

Former Member — Mon, 19 Nov 2007 10:47:45 GMT

Hi Richs

I wrote a small program...check this code..


REPORT test.

DATA : date1 LIKE sy-datum,
       date2 LIKE sy-datum.
RANGES : s_date FOR sy-datum.


CALL FUNCTION 'MONTH_PLUS_DETERMINE'
  EXPORTING
    months  = '1'
    olddate = sy-datum
  IMPORTING
    newdate = date1.
date1+6(2) = '01'.
WRITE :/ date1.

CALL FUNCTION 'MONTH_PLUS_DETERMINE'
  EXPORTING
    months  = '5'
    olddate = sy-datum
  IMPORTING
    newdate = date2.
date2+6(2) = '01'.
date2  = date2 - 1.
WRITE :/ date2.

s_date-low = date1. "append date1 and date2 to ranges s_date
s_date-option ='BT'.
s_date-sign = 'I'.
APPEND s_date.

s_date-high = date2.
s_date-option ='BT'.
s_date-sign = 'I'.
APPEND s_date.

SELECT .......FROM BKDF  WHERE "Use s_date in select statement.
DBEDT IN s_date.

Re: date selection in background

Former Member — Mon, 19 Nov 2007 11:06:41 GMT

Perez C ,

Thanks a lot for your reply

Regards,

Richs

Message was edited by:

richs