Skip to Content

Functionality of Report Painter in S4HC?

Hello S4HC-experts,

I´m wondering does S4HC provide a tool which is (fully) equivalent to the old Report Painter or not?

I want to set up a report (App AnalyticQuery) for e.g. cost center providing:

  • columns: plan, actual, diff(plan vs. actual)
  • row 1: account "revenue" 8xxxxxxxxx
  • row 2: account "personal costs" 41xxxxxxxx
  • row 3: calculation: (row 1 - row 2)
  • row 4: account "service costs" 44xxxxxxxx
  • row 5: calculation: (row 3 - row 4)
  • ...

and so on.

Needless to say:

- I want to be able to use one "account" or an "account group" per row and

- data is coming from a cds view which providing information in a consistent manner like e.g. (I_ACTUALPLANJRNLENTRYITEMCUBE).

So can someone from SAP or anyone else please provide a statement whether this is possible in S4HC or not and if it is possible which tool(s) needs to be used to achieve this.

Thanks

Dio.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jun 26 at 10:02 AM

    Hello Dio,

    I just stumbled across your question.

    In fact such reports are possible since quite a while in S/4HANA Cloud and OnPrem.

    With the app Custom Analytical Queries you can create CDS Queries. In such a query you can create restricted and calculated key figures with which you can build up such a report line by line!

    This query is then exposed as OData Service and InA service so that you can use it in Fiori Applications and also SAC or Analysis for Office, ...

    Best Regards,

    Jörg

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 01, 2019 at 04:45 PM

    Hi Dio

    The KBA https://launchpad.support.sap.com/#/notes/2579584 has useful information and links to blogs for reporting tools that can be used instead of the Report Painter.

    Thanks

    Enda

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Enda,

      Ok, I see I did not miss the key points in the topic at all. All the examples just refers to the fact to display figures in a multi dimensional reports fine, of course we can display amounts per account/profit center per line.

      But I could not find an answer to my question for this:

      • row 1: account "revenue" 8xxxxxxxxx
      • row 2: account "personal costs" 41xxxxxxxx
      • row 3: calculation: (row 1 - row 2)

      If I just would need row 1 and row 2 I would set up a hierarchy according to my needs. But unfortunately I want to calculate in row 3.

      So can you give me hope that this is possible to define calculations for rows, please please?

      Thanks.

      Regards & greets to Irland!

      Dio.

  • Posted on May 26, 2019 at 08:17 AM

    Hello World,

    in short. The answer to my question is: "It is not possible & no tool available" (05/2019).

    S/4HANA Cloud reporting capabilities do not provide functionalities SAP used to provide since 25 years in ERP with Report Painter nor Report Writer. Even SAC is not able close the gap.

    Regards

    Dio.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.