Skip to Content

Hi Guys,

It has been some time since my first blog ( SAP Simple Finance blog series-1-Parallel Accou… | SCN ) , I take this second blog to talk about how reporting has changed  / enhanced in S4 HANA. We will take COPA / Profitability analysis as our use case for this example.

With S/4 HANA and OLAP and OLTP in single system, SAP has enabled a lot of simplification in reporting. There are many tools and modes of usage available. Fiori app and HANA live are also a great way to analyze data realtime. With all these options, a Finance functional consultant should be aware of these options and know when to use which option to cater to his clients need. We hope to take the first step in this regard.

We will take the case of Account based COPA for this example as that is the recommended approach by SAP for COPA.

COPA reporting previously šŸ˜

COPA reports were mainly driven from KE30 report painter reports or from BW – BO based reports. These reports were mainly fixed in format and would expect user to be using SAP gui in some form or other. The ability to analyze based on multiple dimensions was not available off the shelf for KE30 reports.

There was also a delay in data replication in case the reports are being accessed from BW system. SAP HANA’s first use case to have COPA reporting enabled in HANA system and would allow faster and more detailed analysis of the data.

So whats new in S/4 HANA

S/4 HANA combines OLAP and OLTP system and enables a single source of truth. It has an inbuilt BI and BW content which can be used for reporting purpose.

So we will list out the various options that are available to report out of S/4 HANA, Some of these may require additional licenses , which you need to check.

  1. SAP Fiori Apps

If you are using S/4 HANA it makes a lot of sense to use various Fiori apps provided by SAP. There are 3 main apps in the area of Profitability reporting:-

  • Net Margin Analysis
  • Margin Analysis
  • Profit Margin

Lets take example of Margin Analysis

/wp-content/uploads/2015/09/2_781774.jpg

When you run this app, you will have option to analyze margin based on customer, segment, product and for various period per Controlling Area

/wp-content/uploads/2015/09/4_781776.jpg

With this you can create analysis path and it is almost like drilldown facility šŸ™‚ šŸ™‚

/wp-content/uploads/2015/09/6_781777.jpg

So with this app an user can view the profit margin based on product, customer and market segment.

This app requires a fixed cost element groups created for Revenue , Direct Cost, Indirect cost as shown in the figure below This

/wp-content/uploads/2015/09/9_781778.jpg

This has an implication and will fix the Cost element group which can be used and hence reduce user’s ability to analyze the based on different GL accounts.

There are other apps offered in the GL catalog or as part of Integrated Business Planning ( we will have couple of blog on IBP later  šŸ™‚ )

Example- P&L plan actual shown below:-

/wp-content/uploads/2015/09/7_781779.jpg

As seen in the left hand side you can choose the various dimensions like Customer Group , Customer, etc to get the P&L and Margin for the required dimension.

Other such apps are- Profit Center Plan actual,Profit Center actual, Trial balance analysis etc.

These are also handy to analyze profit margin but they will not have the COPA dimension and will have standard dimension only ( unless enhanced )

2. Using Analysis for Office tool

AO is a great tool to analyze data and offers a lot of flexibility in report. There are 3 standard query available to analyze COPA data on it as shown below

/wp-content/uploads/2015/09/3_781780.jpg

With these query you can create any layout and analyze the details per all your COPA dimensions

/wp-content/uploads/2015/09/8_781781.jpg

We can select any field in the excel layout and analyze the figures according to it.

This offers a lot of flexibility and should be used by someone who needs to do a lot of slicing and dicing of COPA data.

3. HANA Live content

SAP HANA live can be used to get a browser based access to data and standard query. These query can provide a set of information in standard format

/wp-content/uploads/2015/09/1_781782.jpg

4. And other options šŸ˜†

There are other options which can be used like SAP Lumira ( which also has a Fiori app ) or custom report by Design studio.

Adding one of the screenshot from demo content, But I haven’t got a chance to use it so far.

/wp-content/uploads/2015/09/10_781783.jpg

To use Lumira you need to setup the Lumira tool and then enable the Fiori app for Lumira.

All these options so far are in addition to our good old KE30 report and reports out of BW-BO. šŸ˜Ž šŸ˜Ž

So what does all these mean

With greater options comes greater responsibility  ( twisted the dialog a bit šŸ˜› )  so the SFIN consultant working in space of Finance should work on gathering enough requirement from Client on the type of tool and use case for the tool

Putting a short table with modes of usage and flexibility of reporting as criteria. This is just a personal View

Type of Usage -X / Mode of usage-Y Mobile devices Desktop users SAP GUI user
Lot of Analysis and Slicing / Dicing features needed-Adhoc reporting Analysis for Office BO tools consuming HANA view
Low level of analysis needed-few additional dimension needed

Fiori Apps for Profit Analysis

And apps of Profit center , P&L etc

HANA live views
Standard Report to be generated per period HANA live views KE30 reports

Hope this blog is useful and will help you guys plan the reporting better and with more depth for your client.

Do let me know your feedback, In the next blog we will talk about IBP and its usage.

PS-Simple Finance is changed to S/4 Finance and hence the change in the blog name šŸ˜‰

Next blog on IBP setup

SAP S/4 Finance blog series-3-SAP Integrated Business planning-Overview & Setup

Regards

Rishab

Other blogs in the series:-


SAP Appendix ledger

SAP Simple Finance blog series-1-Parallel Accounting with multiple Ledger & Extension (Appendix )Ledger Usage

CO-FI initial setup

SAP S/4 Finance blog series-4-Changes in Controlling & how to use them

SAP S/4 1511 changes in details

S/4 Finance- Blog series-6- 1511 changes in details

S/4 Finance- Blog series-5- 1511 and its details

SAP IBP Solution

SAP S/4 Finance blog series-3-SAP Integrated Business planning-Overview & Setup

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. kuatroka kuatroka

    Thanks for the blog Rashib. It’s quite informative. Two questions:

    1. Are all these Fiori apps come standard with S4/HANA install and only need config work or they are separate apps that need one by one install. I only refer to COPA analysis related apps.

    2. the P&L Plan/Act what is the full name of this app or within what role which role can I find it? I know that the three COPA analysis apps are within “Accounting Information for Manager”, but where can I find the P&L Plan/Act app?

    Thanks,

    (0) 
    1. Rishab Bucha Post author

      Hi Kuatroka,

      Thanks for your comment šŸ™‚ .

      About your questions:-

      1) All/ Most the apps need configuration. the KPI related to these apps needs to be checked and set, user parameter needs to be set. As a thumb rule please read the installation guide for all the app

      2) All the P&L and Profit center apps are part of IBP / Integrated business planning solution and will be available / working once you have it.

      There are some other apps like Trial Balance analysis which is in GL accountant catalog

      Hope this helps

      Regards

      Rishab

      (0) 
  2. Prasad Garud

    Hi Rishab,

    Again very nice blog and throughy informative for people like me who don’t have access to S4 system but are curious to gather details for upcoming upgrade at current client site.

    Thanks again and keep posting (following you very closely šŸ™‚ )

    Thanks!

    Prasad Garud

    (0) 
      1. Ganesh Sadula

        Rishab Bucha,,

        I had made FICO & MM Configuration for Procure to Pay process in S4 HANA system,But in house bank configuration would be different from ERP system,

        Following queries related to S4 HANA and Sfin

        1. What is process of assign main bank GL a/c with respective house bank, showing message you require assign role to Cash_management and need run NWBC tcode.

        2. we had tested one scenario of PO- MIGO- MIRO , data is flowing in all the table in S4 HANA,  BSIS, BSIK, FAGLFLEXA ,FAGLFLEXT, BSEG, MSEG , AND ACDOCA.


        In S4 HANA it won’t be show in BSEG , MSEG , BSIK, BSIS.


        Kindly let me know any procedure we are missing due to these data is showing.


        with regards,

        Ganesh


        (0) 
  3. Emilio Cano

    Thanks for your input Rashib šŸ™‚ . We have finished parameterize IBP with s/4 HANA to the planning of cost centres and profit with the standard templates provided by SAP. Now we have the parameterization to COPA in s/4 HANA, we have set up the PA society with the transaction KE3E, KEA0. So initially we have active part of COPA, the problem is that we don’t see the standard reports available for COPA from Analysis for Office (Profitability Analysis Document, Profitability Analysis Data,…), we do not know if it is necessary to activate some extra parameter in s/4 in order to have access to standard reports, or any previous step activation?

    Thank you

    (0) 
  4. Luca Rapisarda

    Hi,

    Fiori applications listed above (Net Margin Analysis, Margin Analysis, Profit Margin) are restricted for SAP Business Suite on Hana with Simple Finance. Are they available also for S/4 HANA?

    Where can I find a list of COPA Fiori applications available in S/4 HANA?

    Thanks!

    (0) 

Leave a Reply