Skip to Content
avatar image
Former Member

Report painter problem with Business area

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers