Report painter

[Former Member]

Hi,

I have a report for which we need to get Current year data in a column. If the users enter 5 in Period and 2006 in the year, the data should get values of year 2006 and past 12 month value from the period 5 of 2006, that is 5 months of 2006 data and 7 months of 2005 backwards from Dec,Nov,Oct etc.

Can any body help with what is the variable or From to To value I have choose for both 'Period' and 'Year'

Thank you ,

Nivi

[former_member188826 · Accepted solution]

<b>Here is the Recipe</b> (with PCA reports in mind, However you can extend the same logic for others as well)

2 Variables to be created for fiscal year.

3 Variables for posting period. Formulas given at end.

Report creation manual:

Include in the <b>first column</b>, Fiscal year and Period (besides other characteristics you may choose, like value type, version etc). Select the variable checkbox in both characteristics.

'Fiscal year' with the variable 'ZLYEAR' under the From column.

'Period' with the variable 'ZLPRPD' to 'ZL12'

You may name the first column in the medium text as from&ZLPRPRD &ZLYEAR Under Formatting-->Row/Column texts select Medium for column texts.

Include in the <b>second column</b>, Fiscal year and Period (besides other characteristics you may choose, like value type, version etc). Select the variable checkbox in Fiscal year and only the 'To' column in Period characteristic.

You may name the second column in the medium text as To &ZPOPER &8A-YEAR

'Fiscal year' with the variable '8A-YEAR' under the From column.

'Period' with the '1' under 'from' column and 'ZPOPER' under 'to' column.

Create the Third column, naming it 'Rolling Year' as a formula and adding the first two columns.

Run the reports, convince that you are getting correct values. Finally, hide the workshop columns 1 and 2.

<b>Variable Definitions</b>

<b>Fiscal Year</b>

<b>Fiscal Year Variable 1</b>

Make use of the standard variable for fiscal year 8A-YEAR.

<b>Fiscal Year Variable 2 </b>

Create the second variable for fiscal year as ZLYEAR (description "Last Year") of type formula for the field GLPCT-RYEAR and give the formula proposal '8A-YEAR' - 1.

<b>Posting Period</b>

<b>Posting Period Variable 1</b>

Create the first variable for posting period, of type value, for posting period field GLPCT-POPER with variable name ZPOPER and name it 'Posting period upto'.

<b>Posting Period Variable 2</b>

Create the second variable for posting period of type formula with variable name ZLPRPRD with description and formula

"Period entered + 1 (for PY) "

IF '&ZPOPER' < 12 THEN '&ZPOPER' + 1

ELSE 999

<b>Posting Period Variable 3</b>

Creat the third variable for posting period of type formula with variable name ZL12 and description "Previous year - last period". and the formula

IF '&ZPOPER' < 12 THEN 12

ELSE 999

<b>End of Recipe</b>

[Former Member · Accepted solution]

Thank you for the detailed description. The requirement is there are 5 columns with previous year data, plan data, CY data. I don't have any issues except one column which is the CY data. These are already defined by the client we cannot add any columns. I have to enter the char. and variables of period and year for the column named 'CY 12 month', which is if the uesr enters 6 in the period parameter for the report it should get values of Jan-June for this year and from July-Dec of last year.

Thanks,

Nivi

[Former Member · Accepted solution]

Sridhar,

Special Thanks to you.

Nivi

[Former Member]

Link: http://www.sap-img.com/sap-fi.htm

Topic:

Report Painter

Report Painter, How to reverse +/- signs

Library for Report Painter/Writer

Rept Painter, changing the tables assigned to libraries

Report Painter, Relationship with Rept Grps & Repts

Regards,

Rajesh Banka

Reward suitable points.

• How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).

[Former Member]

HI NIvi,

I dont think you have a SAP standar variable for your requirement.

But, you can define your own variables for FY and for PERIOD.

Inthis variables you can write formulas with conditions as per your requirement.

Example: Assume that you have FY and PR as the Fyscal Year and Period from the selection screen. Then you can define the variables like

<b>Fiscal Year:</b>

From: if PR < 12 THEN FY - 1 else FY

To: FY

<b>Perido:</b>

From: 12 - PR

To: PR

[Former Member]

There are already variables defined for 11 periods like F0-RP00 - Period; F0-RP01-Period-1;

Similarly for year also they have for current year 12 variables.

But I couldn't understand which variable i have give them for the requirement.

Thanks,

Nivi