Report Writer GRR1/GS11. CCA report
Moderators: Snowy, thx4allthefish, Baz, darkduck
Report Writer GRR1/GS11. CCA report
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.
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.
Re: Report Writer GRR1/GS11. CCA report
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):
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
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.
Mitch
Re: Report Writer GRR1/GS11. CCA report
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!
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!
Re: Report Writer GRR1/GS11. CCA report
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
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
Re: Report Writer GRR1/GS11. CCA report
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!
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!
Re: Report Writer GRR1/GS11. CCA report
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
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
Re: Report Writer GRR1/GS11. CCA report
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
Thanks
Re: Report Writer GRR1/GS11. CCA report
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?
Re: Report Writer GRR1/GS11. CCA report
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
thanks
Re: Report Writer GRR1/GS11. CCA report
are you only getting the error for Period 2? maybe compare your settings from Period 1 & 3 to Period 2?
Re: Report Writer GRR1/GS11. CCA report
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.
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.
Re: Report Writer GRR1/GS11. CCA report
have you added the variable for Period in your column?
Re: Report Writer GRR1/GS11. CCA report
Yes. The variable "period" is in every column.
Re: Report Writer GRR1/GS11. CCA report
which characteristics do you have maintained in your General data selection?
which characteristics do you have maintained under JAN & FEB?
which characteristics do you have maintained under JAN & FEB?
Re: Report Writer GRR1/GS11. CCA report
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.
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.