Report Writer GRR1/GS11. CCA report

Financials (FI, CO, TR, EC)

Moderators: Snowy, thx4allthefish, Baz, darkduck

Ishika
Posts: 21
Joined: Tue May 25, 2010 9:39 am

Report Writer GRR1/GS11. CCA report

Post by Ishika » Wed May 26, 2010 12:53 am

Hello,

I need to create a report/formula variable in order for my report to work.
The requirement is to show Actuals and Budget values in a report.
For example if the user enters a 3 in the period field/selection screen, then the output must show JAN, FEB, MAR in Actuals and the remainder of the year in Budget. This must be done by period. If the user enters an 11 then the output must show JAN - NOV in Actuals and DEC in Budget. This is for the CCA report where they want to compare actuals CCA to budget.

Can you please assist me on how to handle this? Or how to create a formula variable that can handle this?

Many thanks for your assistance.

MitchK
Posts: 310
Joined: Wed Jan 04, 2006 4:41 pm

Re: Report Writer GRR1/GS11. CCA report

Post by MitchK » Wed May 26, 2010 6:13 am

There are two ways to tackle this...

If you are creating forecasts on a regular basis (i.e. every quarter the reporting requirement is that periods upto that date are actual and the rest of the year is budget) then I would look into versions. Each quarter you could use KP97 and KP98 to create a new version and then your reporting would be against that version rather than trying to manipulate the record type for each period.

The other way is that you create 12 (assuming you have a 12 period year) value formalae via GS11 that would be against field RRCTY (record type) with something like (in this example for period 3):

Code: Select all

IF 'ZRTPER' >= 3 then 0 else 1.
Where ZRTPER would be the value variable to determine where you want to flip from actuals to plan values (i.e. you create a value variable called ZRTPER against the period field).

Mitch

Ishika
Posts: 21
Joined: Tue May 25, 2010 9:39 am

Re: Report Writer GRR1/GS11. CCA report

Post by Ishika » Wed May 26, 2010 7:01 am

Hi Mitch

Thank you for the feedback.

Unfortunately we use one version 0 for both Actuals and Budget. The users would find copying the values from Budget into a new version to be a tedious process.

What I have done is created 12 new Variables for each period so that the user can indicate on the entry screen Budget or Actuals for each period. I thought there might be a better way using a formula.

Many thanks for your thoughts!

MitchK
Posts: 310
Joined: Wed Jan 04, 2006 4:41 pm

Re: Report Writer GRR1/GS11. CCA report

Post by MitchK » Wed May 26, 2010 9:31 am

Hi,
just to be clear, on the selection screen, there would only be one selection variant required, ZRTPER, not 12, and that would be used to determine the period to split which actuals/plan values appearing.

In GS11, create a new value variable called ZRTPER that is associated with Period.

In GS11, create 12 value formula (one for each column):

ZPER1 = IF 'ZRTPER' > 1 then 0 else 1.
ZPER2 = if 'ZRTPER' >= 2 then 0 else 1. etc

In each column, for "record type" tick the variable box and enter the corresponding value variable ZPER1, ZPER2 etc.

The user should only have to enter one value on selection - the cutoff period (that will automatically appear as its required by ZPER1 etc).

It sounds like you have them checking 12 values.

Hope this helps.
Mitch

Ishika
Posts: 21
Joined: Tue May 25, 2010 9:39 am

Re: Report Writer GRR1/GS11. CCA report

Post by Ishika » Wed May 26, 2010 10:52 pm

Hi there,

I tried your suggestion now. I created the ZRTPER using Table CCSS and Field name PERBL.
I then tried creating ZPER1 (Formula variable) with table CCSS and Field name WRTTP for Value type.
The formula i used is 'ZPER1' = IF 'ZRTPER' > 1 THEN 4 ELSE 1 - this the gave me an error "Variable ZPER1->ZPER1 cannot be calculated from itself".

Am I not understanding the logic?

Thank you!

Ishika
Posts: 21
Joined: Tue May 25, 2010 9:39 am

Re: Report Writer GRR1/GS11. CCA report

Post by Ishika » Wed May 26, 2010 11:27 pm

Hi Mitch,

I used the formula IF 'ZRTPER' > 1 THEN 4 ELSE 1 and it worked.

Thank you very much for the assistance - I really appreciate it!
Have a great day

timbl
Posts: 28
Joined: Thu Jul 10, 2008 3:08 pm

Re: Report Writer GRR1/GS11. CCA report

Post by timbl » Wed Jun 23, 2010 10:24 am

I am not sure if the above applies to my problem but I am trying to creat a report with a separate column for each month. Column 1, period 1; column 2 period 2, etc....However I am getting an error message "Characteristic 002 (Period) is missing from a column in section PERBL". I have tripled check and I do have (period in each column). How do I correct this error? Any help would be greatly appreciated.

Thanks

Ishika
Posts: 21
Joined: Tue May 25, 2010 9:39 am

Re: Report Writer GRR1/GS11. CCA report

Post by Ishika » Wed Jun 23, 2010 10:34 pm

my report was the same where each Period/Month had its own column. When do you get the error, when maintaining the variables in the Period 2 column?

timbl
Posts: 28
Joined: Thu Jul 10, 2008 3:08 pm

Re: Report Writer GRR1/GS11. CCA report

Post by timbl » Thu Jun 24, 2010 5:12 am

I am getting the error when it is processing the report. It doesn't get to the data selection screen. I do not have the characteristic "period" in the general data selection. I have it in each column in my report.

thanks

Ishika
Posts: 21
Joined: Tue May 25, 2010 9:39 am

Re: Report Writer GRR1/GS11. CCA report

Post by Ishika » Thu Jun 24, 2010 6:43 am

are you only getting the error for Period 2? maybe compare your settings from Period 1 & 3 to Period 2?

timbl
Posts: 28
Joined: Thu Jul 10, 2008 3:08 pm

Re: Report Writer GRR1/GS11. CCA report

Post by timbl » Thu Jun 24, 2010 8:01 am

I am also getting it for period three. All three periods have the same settings. It makes no sense why I am getting these error messages.

Any ideas?

I tried another report where I only have one column. I put period as 1 in the column. The error message states that 'Characteristic 001 (period) is missing from a column in section PERBL."

This is very frustrating.

Ishika
Posts: 21
Joined: Tue May 25, 2010 9:39 am

Re: Report Writer GRR1/GS11. CCA report

Post by Ishika » Fri Jun 25, 2010 5:38 am

have you added the variable for Period in your column?

timbl
Posts: 28
Joined: Thu Jul 10, 2008 3:08 pm

Re: Report Writer GRR1/GS11. CCA report

Post by timbl » Fri Jun 25, 2010 9:46 am

Yes. The variable "period" is in every column.

Ishika
Posts: 21
Joined: Tue May 25, 2010 9:39 am

Re: Report Writer GRR1/GS11. CCA report

Post by Ishika » Sun Jun 27, 2010 10:27 pm

which characteristics do you have maintained in your General data selection?

which characteristics do you have maintained under JAN & FEB?

timbl
Posts: 28
Joined: Thu Jul 10, 2008 3:08 pm

Re: Report Writer GRR1/GS11. CCA report

Post by timbl » Thu Jul 01, 2010 5:14 am

I have the same characteristics as the SAP standard report 6pp4-001.

Column - Jan, Period _1; Feb, Period _2

General Data Selection -

Object 6-OBJNR
CO Area 6-KOKRS
Fiscal Year 6-GJAHR
Version 0
Value Type 4
Value Type 11
Valuation 6-VALU

I appreciate your help.

Post Reply