Skip to Content
avatar image
Former Member

How to generate a summary table

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?

Add comment
10|10000 characters needed 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.

  • 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!

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

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

    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.

    Add comment
    10|10000 characters needed 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.