S/4HANA Group Reporting - Group View on Accounting (GVA)

[harivenkatesh_subramanian]

Introduction

In this blog, we will discuss about the new Review Booklet app Group View on Accounting (GVA). The app provides a group view access of high granular and anytime access to the most recent Accounting data. The look and feel of the report is very similar to our existing reports in Group Reporting but based out of accounting data. A new analytical stack brings the data from accounting table ACDOCA and combines the existing Group Reporting analytical stack to deliver the results for this report to provide a Group View to end users. 

GVA Columns

• Column 1: “Accounting”: The measures reflects the accounting data (ACDOCA). It includes both released and unreleased data.
• Column 2: “Accounting released”: The measures reflects the accounting release data that is as per the Entry timestamp of ACDOCA table <= release time stamp (table RTC_PULL_REQ)
• Column 3: “Accounting unreleased”: The measures reflects the unreleased data that is as per Entry timestamp of ACDOCA > release time  stamp  (table RTC_PULL_REQ) 
• Column 4.1: “GR released”: The measures reflects the released data of Group Reporting as per PL blank ACDOCU table and consider the record type = U (only) (ACDOCU)
• Column 4.2: “GR adjusted” (PL blank CT, ANI): The measure  reflects the CT and ANI of GR that is nothing but as as per PL blank of ACDOCU table 
• Column 4.3: “GR corrected”: The measures reflects that manual postings that is as per PL 00, 01, 0C of Group Reporting Journals (ACDOCU)
• Column 5: “Delta GR Acctg. Released”: Column 4.1 - Column 2 (should always display a zero ) 

Pre-Requisites

The following are the pre-requisites for the proper functioning of the app

• The GRPL fields should be enabled
• Map FS items with G/L accounts
• The consolidation unit should be enabled for "Transfer From Universal Journal"

How unreleased data is reflected in the Review Booklet?

Please refer to the below video on how the data is reflected on the accounting unreleased column.

How Released data is reflected in the Review Booklet? 

Please refer to the below video on How the data is reflected on the accounting released and GR released  column.

Also, releasing the ANI/CT task the data will be reflected in  GR Retranslated as shown below.

Navigation

For the accounting columns you will be able to navigate to the Trial Balance app, provided the end user posses the necessary role as shown below.

Similarly you can navigate to Group Financial Statement app as shown below for Group Reporting columns:

Extensibility - Custom Fields

The fields need to be mapped in the SSCUI app Data Release Task: Define Mapping for Jrnl. You can map an existing or static field of General Ledger(ACDOCA) to a custom field in Group Journal(ACDOCU). Similarly, you can also map a custom field of General Ledger to a custom field in Group Journal as shown below.

The custom fields appear in the review booklet as shown below:

 

Commenting

The commenting feature offers the following:

• You can create, edit and display data cell  or page comments
• Cell icon appears only when the navigation state matches at the time of creation of the comments
• You can classify the comments as Critical, Important, Medium, Low or None
• A status (Open, In Process, or Resolved) can be set to the comments
• You can tag a comment

Please refer to the screenshot below:

Summary

• New group financial review app on real-time accounting data​
• Expose universal ledger accounting data into an analytical group view through this new SAP Fiori app 
• Integrate with group reporting for tighter accounting​
• Leverage the app to review group financial statements​
• New features of the new SAP Fiori app for readily consumed reporting content in different pages based on master data from group reporting and reporting rule definitions:​
  • Balance sheet​
  • Profit and loss statement (cost of sales and nature of expense structure)​
  • Cash flow statement​

• Predefined column and row structures:​
  • Data release status to group reporting (Accounting data, released data in group reporting)​
  • Period comparison reporting (such as prior-year)​
  • Organizational hierarchies (consolidation unit, segment, and profit center)​
  • Various measures, including  quarter comparison, and year to date, as well as local currency, transaction currency, group currency, and quantity​
• Navigation and drill-through capabilities to  (depending on the source of data)​:​
  • Group Financial Review Booklet​ 
  • Trial Balance - accounting 
• Custom fields of ACODCU are displayed in the Review Booklet and it is possible to map ACDOCA fields as explained above
• Commenting feature for data cell and page comments

Conclusion

Please feel free to share your thoughts by commenting on this blog. Also, we can use this blog as a communication tool for any clarification that you require on this topic. You can also follow my profile for more content on analytical application for group reporting. I would recommend posting your questions by specifying the tag: “SAP S/4HANA Finance for group reporting”