Skip to Content

Report writer

Oct 25, 2017 at 02:43 AM


avatar image


I have an existing report writer which pulls data from GLPCT. Let's say my columns are monthly actuals and year-to-date actuals. I have 3 sections: SKFs, Sales and Expenses. Each section has multi-sets on it that groups cost elements and profit centres. The profit centre/profit centre group is a selection parameter aside from the year and period. I now have to add another section that will pull into 1 group all cost elements and cost centres related to that profit centre/group. I created this section but SAP raises an error saying that "Only use multi-sets and key figure sets for table GLPCT" GR 804. I'm not sure if this means that I cannot have sets that use cost centres as characteristic or because GLPCT being a totals table does not have cost centre as a characteristic. Can anyone recommend or says if this is possible and how to go around this?

I also thought of using variables to filter the cost centres from the profit centre/group. Just to check if this would work, I wanted to filter profit centres based on departments. So I created a value variable where the value is “O” for Office in the profit centre master data. But when I insert this variable to a multi-set of cost elements and profit centres, SAP is saying "An appropriate object was not found" GU 003.

Would very much appreciate any help. Thank you

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

2 Answers

Eli Klovski
Oct 25, 2017 at 07:04 AM


I'm not sure what you are trying to achieve. As you correctly mentioned, cost centres are not a part of GLPCT table. Any attempt to incorporate this dimension in a report working on reporting table GLPCT will be resulted in error. The same goes for 'cost elements', which equally don't play any role in GLPCT. Profit centre totals are based on 'accounts' (RACCT) and not on cost elements.



10 |10000 characters needed characters left characters exceeded
Tess Sapico Oct 26, 2017 at 03:04 AM
Thanks Eli for the feedback. You're right, GLPCT uses RACCT. I just used the term cost elements loosely. The existing report shows sales, expenses and operating income for a plant(s) which is a profit centre in SAP. The business now wants to incorporate the different operational activities in the report. Examples of production activities are sandblasting, quarrying, etc.. Same with the distribution phase of the business e.g. shipping, warehousing costs. Each of these activities correspond to a cost centre. The reqt then is to somehow bring across these cost centre activities into the report. Hence, the use of report writer because it was thought that its possible to combine information from other tables. I guess I will now concentrate on using formula variables and exits instead. With regards to variables, I am testing the value variable to filter profit centres based on departments. I am using a multi-set which is composed of RACCT and RPRCTR. The set RPRCTR has a subordinate basic set which points to the profit centres and uses table CEPC and field name PRCTR. When I tried to insert a value variable into this set, I get the error "An appropriate object was not found". Would appreciate any comments. Thank you!
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Well, sorry to say, but you won't be able to base your report on GLPCT. From the fact that you are using this table, I reckon that you work with classical G/L, right? Because, in new GL you wouldn't have this problem.

For classical G/L, if you want incorporate data from different domains, namely from CO and EC-PCA, you would need to develop your own report (ABAP).