topic Re: Restricting internal table data for date wise calculation in Application Development and Automation Discussions

Restricting internal table data for date wise calculation

Former Member — Tue, 16 Jul 2013 05:14:11 GMT

Dear Experts,
I have a data table with records of power readings stored Date wise. Now I have to create a report that does the calculations from the data as below.

1. Average of readings of last week's data.(last 1-7 days)

2. Average of readings of previous week's data.(last 8 - 14 days)

3. Average of reading of prev. month's data. (last 15 - 45 days).

Now my question is how to extract the data from table date wise as required.

Also if there is any way I can store only 45 data records starting from yesterday till last 45th day then pls help me how to achieve this ??

Thanks,

Regards.

Re: Restricting internal table data for date wise calculation

Former Member — Tue, 16 Jul 2013 09:55:46 GMT

Hi,

The table's short description comes in as the title of the maintenance view.

Re: Restricting internal table data for date wise calculation

FredericGirod — Tue, 16 Jul 2013 09:57:16 GMT

Hi,

you could create ranges for the 3 type of period. You set date with a simple calculation:

Yesterday = sy-datum - 1.

45_days = Yesterday - 45 ...

What's the problem with your dates ??

I don't understand

regards

Fre