Cumulative YTD COPA Report

[Former Member]

Hello,

We have requirement in copa report (ke30) wherein Year to date information should be available based on period range selected in input parameters.

Say for example if user gives period range of Apr to June 2014 in ke30, then report should display cumulative values based on period selected.

Report should be as per below format and value should be cumulative value as per period selected.

Lead column	1000	2000	3000	4000	Total
Value Field 1	1	4	7	1	13
Value Field 2	2	5	8	2	17
Value Field 3	3	6	9	3	21
Value Field 4	4	7	0	4	15

where 1000 -4000 are profit center. For month wise details, i have created a separate report

Regards

Karthik

[Former Member]

HI,

and whats your question, where do you struggle?

BR Christian

[Former Member]

Hi,

My question is based on period range given in ke30, only cumulative values alone should appear in ke30 report. As mentioned above, say if user key in period as April to July, then only cumulative values of such period alone should appear and not month wise breakup...

Hope requirement is clear now...

please revert if i didnt explain clearly...

Thanks

Karthik

[Former Member]

Hi,

create a form based report. In the column(s) where the YTD values should appear (or in the general data selection if valid for all values) define period from as "1" and period to as "local variable".

It should look like this (no matter how the variable is named)

The variable "PERIODBIS" is a selection variable in the report defined using KE31 and the form created is attached to this report.

BR Christian

[Former Member]

Hi Ortner,

Thanks for your advise. I created period/year as global variable and attached in ke31.Now it shows the cumulative values correctly in the report I was not able to do it by creating period as local variable..

Thanks

Karthikeyan

[sanjay_ram]

My 2 cents advice, if we make the from period a variable too then in the selection screen we can enter from and to period so that both MTD and YTD reports can be reported using a single report.