Report Writer GRR1/GS11. CCA report

[Ishika]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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

[timbl]

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]

have you added the variable for Period in your column?

[timbl]

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

[Ishika]

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

which characteristics do you have maintained under JAN & FEB?

[timbl]

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.