- SAP Managed Tags
Hi SAP Folks,
Back in 2012 I had published Financial Statement Analysis by using Report Paint... - SAP Community that revealed the excellent feature of financial statement generation by using report painter. Back then, there was no SAP S/4HANA and we were using SAP ECC, in SAP S/4HANA, SAP has released an app Named Manage Global Hierarchies App ID: F2918 to create/generate/maintain FSVs in various dynamic ways.
In this Blog post, I am going to share my experience on using this app to generate financial statement versions.
In one of my SAP implementations, I had a chance to use this wonderful FIORI Application to generate desired financial statement version for Balance Sheet (hereinafter referred to BS) and Profit and Loss (hereinafter referred to P&L). I have found it to be very useful tool to generate Financial Statement Versions (FSV) as compared to the traditional GUI based T code OB58. There is SAP note 3528582 - Two ways of maintaining FSVs for Fiori Applications - SAP for Me that beautifully describes difference between FSVs maintenance in SAP GUI Versus SAP FIORI.
All the FSVs that are created via SAP GUI are saved in T011 table while app FSVs which are generated by FIORI App are stored in HRRP (Hierarchy Runtime Representation Persistence) table.
OB58/FSE2 were used in SAP ECC and are still in use in SAP S/4HANA to generate FSVs. To promote FIORI, SAP introduced FIROI App. F2918 which provided more dynamic and flexible way to generate FSV. In the steps below, we will see how to do we generate FSV for Balance Sheet reporting.
I am using S/4HANA 2023, if you logon to FIORI then you can search for Manage Global Hierarchies App and depending on the authorization if you have, you see below FIORI tile.
Standard Business Roles:
As per SAP help, following are the standard business roles that you may ask your authorization consultant to assign you to get the access of this app however there may be differences between the assigned authorization to select further hierarchy types like Financial Statement Version, Cost Centre Hierarchy, Profit Centre hierarchy etc.
- General Ledger Accountant (SAP_BR_GL_ACCOUNTANT)
- Overhead Cost Accountant (SAP_BR_OVERHEAD_ACCOUNTANT)
- General Ledger Accountant - Intercompany (SAP_BR_RECON_ACCOUNTANT)
- Group Accountant (SAP_BR_GRP_ACCOUNTANT)
- Cash Management Specialist (SAP_BR_CASH_SPECIALIST)
- Divisional Accountant (SAP_BR_DIVISION_ACCOUNTANT)
To be able to create/edit FSV using Manage Global Hierarchy App, you must access to BR SAP_BR_GL_ACCOUNTANT.
Create Financial Statement Version:
We will now see how to create financial statement version using this app, once you enter inside the app, you will see below screen, you see here two main options, create and Import, we will explore both options one by one in detail.
Create:
We will first explore the create option to create a sample FSV in FIORI bases financial statements. Once we click on create button, we must provide ID for FSV, name it needs, Chart of Accounts based on which its GL will be picked and Validity as shown below
Click on Create, it might ask you to provide the transport request number to capture the changes depending on your client settings. Once transport has been provided, a new FSV Y002 will be created in draft status.
In the hierarchy tab, select Allow Contra Node and Bank Account Grouping to allow adding a pair of contra nodes to the FSV so that, depending on the node-level balance is in credit or in debit, one of the nodes is displayed in the financial statements. This is useful for Bank Accounts Node where Debit balances are needed to be shown on the asset side and Bank balance if in credit then to be shown on the liabilities side.
You will now have to work on this FSV to create Hierarchy Nodes, assign GL Accounts etc.
To exemplify mapping, we need to work on Assets for instances, we will choose Edit button from top right corner or simply can press Ctrl+E on keyboard to start editing process.
I will select Asset Node as shown below and press on + button to add Sub-Nodes under it. I will add two Sub-Nodes under it and then assign GL to them.
+/- sign here implies that if it is selected that for the expenses GL which normally are shown with Positive sign, they will be presented in this FSV with - figure hence depending upon the selection of this +/- on a node , it will convert the underlying GL balances in that node from + to - or vice versa, it will not have any impact on the original GL balances in financial reports 🙂
We will now add few more sub-nodes under Current Assets and assign GLs.
Under cash & bank grouping, we usually have the requirement that if the balance of the these GLs are positive then it should appear under current assets however if it goes negative then it should automatically shift to another node under liability side let us assume Payable to Bank, this can be achieved easily by selecting on + for the Cash & Bank GL assignment and providing a contra node as shown below.
Exporting to Excel and Working On it:
We can also export this FSV hierarchy to excel and work on the same FSV and then retrieve the mapping we did in excel back to this FSV version 🙂. To me this is the most exciting part of this App.
Let us explore it,
This is most stunning feature of creating FSVs using Manage Global Hierarchies App :).
Simulation:
We have now seen how to create FSV using Manage Global Hierarchy App, let us now simulate the FSV we have just created.
I have now turned on the simulate button and saved it, turning it on will allow me to use this FSV in the Balance Sheet/Income Statement Application in draft status.
We have used above draft version of Y002 in Balance Sheet/Income Statement FIORI App as shown below and it is working fine.
Unassigned tab will show GL accounts which still are unassigned.
If you are okay with your mapping then you can activate the FSV and prepare to move this FSV to Production by transport .
Note: FSVs cannot be directly changes in production using Manage Global Hierarchy App, you must do the mapping in Golden client first, test them and then move to Production system.
Limitations:
The financial statement version Y002 which we have created using Manage Global Hierarchy App cannot be used in SAP GUI however FSVs which are created in GUI can be used in FIORI App for Financial statement, we can even import them in Manager Global Hierarchy app to redesign them :). There is one SAP Note that states the limitation 3064994 - Hierarchy IDs from "Manage Global Hierarchies" (F2918) are not saved into "Financial State...
2. Import Hierarchy:
In your legacy system, you have created financial statement versions using OB58 , you might want to re-use them in FIORI Based Balance Sheet/Income Statement App by doing some changes to the GL mapping or node changes, to be able to do so, you can use this option to import existing FSVs. I had created one test template FSV 1300 in GUI OB58 T Code, i want to re-use this FSV in FIORI Manage Global Hierarchies-Financial Statement Versions, we will need to follow the steps shown below.
In above, we have selected Maintain Financial Statement Versions a Source and selected 1300 FSV ID to import in this app to do the changes. Once we click Ok, we must next provide the FSV name with which it will be used in FIORI as shown below.
Once we clicked on create, FSV Y001 will be generated in Draft state, draft state allows you to make changes to FSV as many time as you want and you can simulate those changes as well. Alternatively you can use HRRP_REP T code to replicate FSVs from SAP GUI to FIORI platform. There is a wonderful SAP Note 3064950 - Financial Statement Version versus Hierarchy ID at Fiori reporting apps for Balance Sheet ... that explains this functionality.
I hope above knowledge article was useful to all the SAP geeks who are always looking forward to learn new things in SAP 🙂. At then end , I would say Learn and Spread the knowledge 🙂.
Bluesky| User | Count |
|---|---|
| 13 | |
| 9 | |
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 3 | |
| 3 | |
| 3 |
