topic weekly report! in Application Development and Automation Discussions

weekly report!

Former Member — Sat, 14 May 2011 08:49:13 GMT

Hi All,

I have developed a report( weekly report) to get total number of the contents inside an internal table in a particular Date range. suppose if the date range is 01/01/2010 to 29/01/2010 ,the user first enter the date from the select-option then a weekly report in ALV appears to him. the dates like for example :

01/01/2010

08/01/2010

15/01/2010

22/01/2010

29/01/2010.

After getting these dates I have to find the sum of the contents inside that range between:

01/01/2010 & 08/01/2010 >>> total number of (Bookings) = 432132 (e.g)

09/01/2010 & 15/01/2010 >>>.....

16/01/2010 & 22/01/2010>>>>....

23/01/2010 & 29/01/2010.>>>.....

and so on,

i have manage to get the total sum of all the field contents but the date is the problem. it's getting the sum daily not weekly.

in the report that will be displayed in the ALV, the date type is D. and in the internal table to manipulate the data, I declaired (auth_date(2) type n). then i have used (auth_date+6(2) ) to get the weekly days.

Experts please help me to find a solution for this report.

Re: weekly report!

Clemenss — Sat, 14 May 2011 12:19:19 GMT

Hi Eman,

you may add a WEEK field to your list, use

CALL FUNCTION 'DATE_GET_WEEK'
  EXPORTING
    DATE               = <date>
 IMPORTING
   WEEK               = <week>
 EXCEPTIONS
   DATE_INVALID       = 1
*   OTHERS             = 2
            .

set sort on that field in ALV, create subtotal and total for what you want to know weekly.

Regards,

Clemens

Re: weekly report!

Former Member — Sun, 15 May 2011 05:28:26 GMT

Thank you Sir,

although this way is good but it's not applicable to my code...

Can I do it manually instead of using a function?

Re: weekly report!

Clemenss — Sun, 15 May 2011 14:23:11 GMT

Hi Eman,

manually? Donwload to excel, use excel (week & sum) functions.

Regards,

Clemens

Re: weekly report!

Former Member — Sat, 04 Jun 2011 07:57:41 GMT

I've managed to solve this problem... Thanks!!