Skip to Content
0

How to generate a summary table

Jan 06, 2017 at 09:45 AM

43

avatar image
Former Member

I have created interfaces of revenues MPR and interfaces of expenses MPE using the excel client. I would like to have a summary table wich contains all the data entered of MPR and MPE. How will I do?

10 |10000 characters needed characters left characters exceeded

Have to repeat: you provide no information to answer your question!

Please provide all details about models used and sample reports of revenues and expenses.

1
Former Member

What do you mean by interfaces? What is MPR, MPE?? How should we understand your case???

Please re phrase the question properly or provide the necessary details!

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jan 09, 2017 at 10:24 AM
0

I mean an user interface , with an input field. I called the report of revenues MPR and the report of expenses MPR. After creating reporting, how to generate a summary table, a reporting I mean

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Without screenshots of your reports with full details about models and dimensions it's not possible to help you.

0
avatar image
Former Member Feb 08, 2017 at 09:48 PM
0

Like others, I have no idea what the OP was talking about, but purely for guessing, I assume OP wants to extract and aggregate data from SAP tables. If so, you have multiple options: 1) extract raw data to your local workbook and summarize / aggregate using pivot tables; 2) create custom ABAP RFC function to aggregate data in SAP first, and send the "table" object back via the RFC function to Excel. In either option, you either have to do it manually (to download to CSV and upload to Excel), or programatically based on dotnet framework.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but here we are talking about BW cubes as a models in BPC. EPM is the client software to work with BPC reports. No idea how RFC can be related to the subject.

0