Skip to Content
0

Report painter problem with Business area

Jul 19, 2017 at 02:32 PM

86

avatar image
Former Member

Hello Community,

I have some problem with Report Painter. Task is to create Actual/Plan Comparision report. I tried to do this based on solution i found on link: https://help.sap.com/saphelp_globext607_10/helpdata/en/5b/d22da443c611d182b30000e829fbfe/frameset.htm

I'm using EC-PCA Totals table: GLPCT where I defined
CHARACTERISTICS:
Ledger, Record type, Version, Fiscal Year,
Profit Center, Account Number, Period,
Business Area and Controlling Area.

I included all basic key figures and key figures.

This four fields, below, should be on the selection screen:

Fiscal Year
Business Area
Period
Version

In Report, I defined:

GENERAL DATA SELECTION:
Ledger, Profit Center, CO Area, Business Area and Period

ROWS:

Account Number based on predefined Sets

COLUMNS:
1. col - Actual - HSL(Amount in company code curr.)
Record Type = 0
Record Type = 2
Version = 0
Fiscal Year = variable

2. col - Planned - HSL(Amount in company code curr.)
Record Type = 1
Record Type = 3
Version = variable
Fiscal Year = variable

3. col - Difference - formula = between col1 and col2
4. col - Difference% - formula

5. col - Accomplished last year - HSL(Amount in company code curr.)

Record Type = 0
Record Type = 2
Version = 0
Fiscal Year = variable

6. col - Difference - formula
7. col - Difference% - formula

But, when I try to execute report, getting error: "Characteristic GSBER cannot be used with key figures". Where is the problem, maybe in using wrong table, maybe solution in link I posted above is for other table? I found some hints and tried to combine all possibilities, but still no success, so if someone had same situation please help :D

Hints:
- GSBER can only be used with Posting Period(POPER) and (ACT.) key figures and not with RPMAX.
- Planned values can only be reached with RPMAX

Regards,

Stipan

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers