By simplifying financial consolidation, reducing manual effort, and providing real-time insights into financial performance, businesses can make more informed decisions and achieve better results. In group reporting 2023 a Financial Statement Reporting Booklet will be introduced, (which is already available in the cloud version). It's licensed by Units. Good blog. Group Reporting is the newest tool embedded in SAP S/4HANA providing statutory as well as managerial financial consolidation capabilities for both On-Premise and Cloud customers. The system indicates any unmapped items as a means of pre validation. Suggest you to take a closer look of the note. This document touches on the pre-configured settings of the best practice content. What versions are available for free download? While at it, please also evaluate the other options on moving to S4. Record Ownership information using Journal entries on Statistical items. The Master Data for Group Reporting - Read API provides all master data entities in group reporting, such as financial statement item, consolidation unit, and cost center. So the periodic Operating CoA maintenance activity should include this important step. Are you talking with respective BPC on S4H1809 ? Data Collection options Release from Universal Journal, Flexible Upload of Reported Financial Data, or Published APIs from Other SAP or Customer applications. If you are using Rule based method - you can find the ownership percentage on FSI S00001 (standard content) in the backend table ACDOCU, under the field Quantity.. Thanks for the blog. 2. With SAP Group Reporting Data Collection, you can map data, create forms, design your own reports, and use . Group Reporting has more then 700 licensed customers now (more then half are still in implementation ) and several really large and challenging global corporations have been successfully using it. Group Reporting is SAP's way forward for Financial Consolidation. Thanks a lot for your replies. In a few months, SAP Universal ID will be the only option to login to SAP Community. Thanks for sharing. A mandatory prerequisite for running S4H Group Reporting is to install the best practices configuration content for the solution. Master Data for Group Reporting Integration (API_GRMASTERDATA_SRV)You can use this ODATA-based API to read master data business objects. Separate configuration setting is available to specify Automatic posting FS Items, like FS Item for P&L Net Income, FS Item for Rolling that up into a Balance Sheet, FS Items for posting Deferred Tax, etc. SAP S/4HANA - Group Reporting - YouTube as of 1809 OP there are 37 fields available in GR and you can adjust these fieldsas input fields, master data fields, or hierarchical master data in your consolidation process and related analysis reports. Release 2021 is a major version of our product, as we deliver one on premise release each year. SAPs Group Reporting tool facilitates not just in the preparation Financial Statements as per Statutory regulations, but also has added capabilities for facilitating managerial consolidation and analytics. SAP Best Practices provides the following two Sub item Categories . The new system empowered a more efficient and forward-looking finance team, one that can consolidate taxes and close its books faster. Reporting rules in Group Reporting also offer on the fly calculations of a combination of FS Item, Subitem (Transaction type or Functional Area), Consolation Unit, Document Type and reverse sign. FS Items replaces the old world Group CoA. I'm really looking forward to the delivery of greatly improved Monitors which the 1st is planned for August 2023 and the integration with Advanced Financial Close which is planned 2024/2025. The basic accounting system (ex: SAP FICO) remains untouched by the FS Item. So my depth of knowledge in BPC is not strong but my experience with Group Reporting is extensive. I'm located in California so Pacific Standard time. Please give me some suggestions, as I want to use this function in customer OP environments, thanks! Group Reporting | SAP Help Portal Am happy to know I have been of value.. Currently im checking the configuration in our sandbox which EC-CS and GRP co-exist. If so, you need SAP Universal ID. S4C1905 will have all latest and most advanced Consolidation features compare to S4H1809(OP). Version 2.0 of this tool is planned for this August and is planned to be part of Group Reporting OnPrem 2023. I will make a few edits to my article later on based on your feedback. This is irrespective of the deployment option (cloud or on-premise). Please refer to the Implementation Guide there. I have only worked with the GR 2021/22 on prem versions. You keep paying the Base Compute price for the underlying Azure infrastructure that your instance runs on, but the total cost for your instance can drop . The SAP Best Practices for SAP S/4HANA Cloud can enable you to improve: Finance Human Resources Sourcing and Procurement Manufacturing R&D/Engineering Supply Chain Asset Management Sales Service Professional Services Application Platform and Infrastructure Database and Data Management SAP S/4HANA Cloud Integration SAP S/4HANA Cloud Extensibility Global Settings for SAP S/4HANA Group Reporting - SAP PRESS Describes how to use SDA to read data for intercompany matching. Group psychological therapy: $50 Therapy: $166: Eye Examinations: Eye exam, routine visit, new patient* $141: Eye exam and treatment, new patient $256: Yes, as you say, all GRDC features are available both for Group Reporting on premise and cloud, unless stated differently in our limitation note https://launchpad.support.sap.com/#/notes/2646756 (the ad hoc items you mention is a good example). Types of the Item Classification on the basis of Nature of the Item, LEQ: Liabilities and equity items in balance sheets. SAP Group Reporting Data Collection (GRDC) is a set of side applications deployed on SAP Cloud Platform (SCP) and integrated with S/4HANA Group Reporting. SAP S/4 Hana Group Reporting 1909 license | SAP Community SAP Crystal Reports | Business Intelligence Reporting Tools Anything with IMG is mostly dealt with by the functional consultant, should be no different in here as well. The Corporate Group structure can be readily viewed in the Fiori app 'Manage Group Structure'. The figure below shows the group reporting Customizing menu in the overall IMG structure. Preparation of Consolidated Financial Statements is mandatory for Statutory compliance, example IFRS10. Does Group reporting use the traditional Group Chart of accounts from SAP FI or will the operating chart only be required? Your requirement is met with S4H 1809 version in S4 GROUP REPOTING Module which is on SAP Road map instead of BPC tool. "Enhanced reclassification for equity method, with a new option called Remove Predefined Filters to automate the consolidation adjustments for a unit consolidated with equity method". Thanks for the good question. Standard mapping tables are available in FIORI apps to map GL accounts to FS (Financial Statement) items. Also how does the licensing works when we extend Group Reports to Analysis for Office Reports. The direct integration offered between S/4HANA and Group Reporting is far beyond any previous consolidations solution offered by SAP that I'm aware of.. With regards to Data Collections the mapping capabilities are quite strong. https://www.sap.com/products/roadmaps/finder-all.html?sort=title_asc&search=Consolidation. At the same time AO supports Formula Based Reporting which means I can crate very specific formatted reports where cell by cell it extracts live data directly from Group Reporting. I have emailed the person, but unfortunately, no response. So the source data to be brought in directly to Group Reporting (no need to setup dummy S/4 companies) or to use Central Finance (if you only are considering Consolidations). I would take your last question first - you need a tool like Group Reporting or BPC for Consolidating Financial Statements. Details of these will be covered in a separate blog post. or i still need to go through the note. SAP Certification - SAP Training Shop Also the eliminations not just by Company but by Profit Center and Segment are supported with this same logic. Figure 1: Windows Defender Firewall. In a few months, SAP Universal ID will be the only option to login to SAP Community. You have been a guiding light to say the least, and this encouragement from you means a lot to me . As we continue to strengthen our development investment in SAPs next gen consolidation software, release 2021 delivers on major new features: SAP S/4HANA Finance for group reporting 2021 inherits from the innovations delivered in the 2011, 2102, 2105 and 2108 releases of our cloud version. And yes, the mapping with ACODCU as a source was the feature I refered. However, please be aware that this wont be aligned to SAP's vision/roadmap for Financial Consolidation. Earlier you mention the huge list of dimensions but you didn't delve into the Flexible Reporting around Eliminations made possible by the Effective Dating Reporting logic.. This data is not directly linked into P&L statements or balance sheets, such as headcount information. Could any one of you let me know if my understanding is correct?. where I posted few questions on how to do develop reports on consolidation of financial statements in the absence of BPC. Drive continuous improvement across your operations. If these are not the right ones can you please let me know the correct ones? In a few months, SAP Universal ID will be the only option to login to SAP Community. Thank you for going through the post.Your feedback and comments will help me make it more relevant to the community. SAP S/4HANA for Group reporting is SAPs strategic consolidation solution moving forward, in particular for customers implementing SAP S/4HANA irrespective of deployment option (cloud or on premise) as well as for customers looking for a public cloud stand-alone offering. Below interesting features part of the product vision will simplify complex and advanced processes in Consolidation : Integration into Financial Closing Cockpit, Automated InterUnit Profit Elimination from Inventory, Integration Scenarios with planning applications, Intelligent Data Validation leveraging Machine Learning. Its just a drag and drop of dimensions with no ability to (conditional) format, suppress, local calculations, Layout, Retrieve Cells etc like what is possible in the EPM add-in in BPC. Based on your GR implementation experience, will business focal configure the Special Version assignment, or still the consultant will perform this activity? The app is hosted on the SAP Cloud Platform and relies on data such as master data and allowed breakdowns from group reporting within SAP S/4HANA. SAP has provided the SAP S/4HANA Finance for group reporting in S/4 HANA Finance 1909. . EXAMPLE - you have 135 companies to consolidate. Check this out sometime. https://blogs.sap.com/2021/04/07/using-remote-data-source-in-icmr/. Integration of ECC data into On Prem GR seems available through GRDC as part of Q1-2021. October 18-19, 2022. If Yes, are there any limitations. Default logic gets executed every time data is loaded or entered into the system. Both have functionality to break down the validations further by movement type and or functional area. Consolidate planned and actual data in real time, both before and after closing. So Reporting Rules, Global Hierarchies, Validations, FS Items etc all need to be manually replicated in all systems. The note 2833748 given shown the process steps to solve the issue, but if i install SAP best practice content or or initialize the global settings for consolidation, will it help resolve this issue? This functionality is quite strong except for when it needs to be interfaced to BW / SAC. You can refer to the following sections of the 2208 feature deck https://www.sap.com/docs/download/2022/07/02c165c5-387e-0010-bca6-c68f7e60039b.pdf: Also, the the following (in the same feature deck) may be interesting for you: Thank you very much for your reply with detailed information! are available for cloud version only ( confirmed in Fiori library). But, I am not finding any setup document to connect ECC to S/4 HANA on-premise via these APIs . Equity pickup is again a manual process in Group Reporting. SAP Group Reporting Follow these setup instructions so you can start running your SAP software quickly and confidently. I think it is a bug. . Controls provided in the Document Type definition. If its Activity based - you find it on the Investment FSI (172000 - standard content) in the backend table ACDOCU, under the field Quantity. For more information on installing the best practices content, see the administration guide on SAP Help Portal. In this scenario, should we suggest them to implement Central Finance ? The latest version of our on-premise software includes new and enhanced capabilities to help you run your financial consolidation and close activities. For % holding being a 'varying' info, see below: Very nice blog Gayathri, Learned a lot on functional. What is SAP S/4HANA Group Reporting? | GAMBIT Consulting Thank you for being the guiding light on Blogging, Ajeet . I thought your blog post was well written and you laid out your assumptions/arguments quite logically. Yes I do except for Consolidation ledger which I could transport if it is other than Y1and other CL in SAP namespace. You can request for access by emailing the owner of the FAQ note 2659672. SAP Licensing explained! - LinkedIn I know you have mentioned that you will cover consolidation process in subsequent blog but I have few questions for which Ive been looking for answers for a while now. This is really a limitation once you are in a more complex environment. SAP Business One Pricing | SEIDOR I always though BPC was a great Consolidations tool for it's time. Watch on. S/4 HANA), as currently works SAP Analytics Cloud? The rule based consolidation of investments does not differ that much from BPC Reporting. As the two systems are interlinked, changes in S4 Operational Accounting could also affect Group Reporting which will result in additional effort. Roadmap for integration to Disclosure Management. Embedded SAC Analytics is included in the license, but SAP Disclosure Managment is also licensed separately. Can EC-CS and GRP co-exist in same system ? SAP Business One covers 80-90% of what all businesses need in software, including accounting, sales, CRM, purchasing, item management, production, projects, fixed . App Assign FS Item Mapping can be used. Master data either you can MAP or create their own FS Items etc in Consolidation > Customer own MD will be time consuming ( Create from scratch), 4. We understand that with S4HANA license, we will also get Group Reporting license and there will be no additional costs. Consolidation Ledger: A ledger to store documents generated by the consolidation tool. There are some exceptions (like ad-hoc items). In a few months, SAP Universal ID will be the only option to login to SAP Community. I should have probably mentioned that I'm comparing to Group Reporting 2022 on prem. At SAP, we want to provide businesses with a comprehensive and streamlined financial reporting process that can help drive success, and for this we have created the Group Reporting solution. Not sure if you are the right person to answer this. Tagging FS Item to Operational Chart of Accounts is a prerequisite to read data directly from the Universal Journal. so all it needs from the operating system is the Operating CoA and certain other master data like Cons ttype. SAP does not support GRP module without TRANSACTION TYPES and FUNCTIONAL AREA is it true statement pls? Controls input of further parameters such as consolidation transaction types, Functional Areas, Partner Unit etc called Breakdown Category, Balance Sheet and P&L structure in hierarchical fashion. Lets hope that SAP keeps investing in Group Reporting to make it the complete product that BPC already is and to have to great data integration that Group Reporting already has. then yes, Even in S4H1809 GR also can be done , but you have to create and enable. The Data Collection App on cloud should work in this case. I understand that we can use GR alone with online S/4 HANA too. are now populated in the local Universal Journal (ACDOCA) so releasing data to Group Reporting is now faster, more flexible and with an even stronger audit trail then the previous strong direct integration. Do you know where in group reporting I can find the control percentages for the group shares, like the ownership manager? SAP Group Reporting Data Collection helps you gather financial data for your business units. Pls advice if there are details to this. Data Source manual or automatic posting, file upload, or API. Yes, Group Reporting requires additional license in addition to S4H OP license. In a few months, SAP Universal ID will be the only option to login to SAP Community. If you have specific ones, let us know it. Combine financial, managerial, and operational data into a single repository and accelerate performance with real-time processes and analytics. I am about to start a new implementation of Group Reporting and a question came out: We may need to bring fields from acdoca to support some transactions that need to be eliminated at the consolidation level in acdocu. Well, first of all; SAP is not giving you much choice as the support (depending on your version) will stop within the next 4 years. SAP Group Reporting is the new consolidation solution for SAP on the S/4HANA platform delivered on the 1809 release. 6. The app is hosted on the SAP Cloud Platform and relies on data such as master data and allowed breakdowns from group reporting within SAP S/4HANA. Thank you for the blog! You can also explore Published APIs to load data from other SAP systems into Group Reporting. Seehow MBCC Group transformed group reporting in just six months. Thanks for sharing great deal of information, One Q - Can you help me join the JAM group please for Group Reporting. We are in process of checking the license requirements of the below: 1. - Customer-coded functions to use in substitution/ validation rules Just one question for better understanding. Optimize the configuration of SAP products with our comprehensive configuration guide. Instead, you have to make a download of your equity and investment accounts, and reverse out the amounts, then bring in the amounts again but with a percentage ownership against the share accounts. Introducing FS Items, replacing the Group CoA. Simpler data model: S/4 HANA is intended for the simpler data model. But what you probably haven't seen is a new Fiorir Reporting app called the Financial Statement Reporting Booklet which came out over a year ago in Public Cloud Group Reporting. I fully agree with you that the integration with operational accounting is one of the great assets of Group Reporting, there are no other tools that have comparable functionality! , Need to be manually replicated across the DTAP landscape. But in most cases if a customer is on premise and using GRDC (cloud), than most new functionalities of GRDC are available for on premise and the same timepoint, as they are for cloud customer. STAT: Statistical items that can be used to record financial and non-financial data. 1.Customer can utilize Cloud based application for Data Collection(FI-GL) - "SAP GROUP REPORTING DATA COLLECTION " Application to load data, https://help.sap.com/viewer/4ebf1502064b406c964b0911adfb3f01/1809.000/en-US/c27c73226dac4e07ac8aa59a45f92fd8.html, 2. Thanks for your prompt reply. Selection ID with more than one field parameter, namely FS Items and Transaction type is shown below, Selection ID with single field parameter Transaction Type is shown below, Where-used list helps in tracing down the usage of a particular Selection ID. You may also create a new version for performing Restatement of Actual Data. Thanks for your reply, is it not possible to have both Legal valuations ( Say Currency 1) and Profit Center Valuation( Currency 3) at the same time. BPC outperforms Group Reporting by far on this topic. Could the same process be used together with API_GRTRANSACTIONDATA_SRV to get real-time access to transactions in SAP ECC? Having this far more granular data is a big benefit of Group Reporting. Security in Group Reporting is done the same way as it is done in S4 Accounting, whereas in BPC a separate security administration is needed. I enjoy these type of conversations and I hope you take all my feedback as constructive dialog and definitely would be open to having a conversation with you in the future! I have following queries about GR. Both of them are having exactly same setting under FINSC_LEDGER, with respect to local and global currency types. Creation of New FS Items should carefully consider all parameters starting from transaction recording up until reporting. Example : For FS Item denoting Provisions, transaction types (Sub item category 1) are mandatory. What is SAP Crystal Reports? So the Breakdown Category tagged to the FS Item should have Transaction type as mandatory and could additionally specify a set of permissible transaction types as well. I have done 1 implementation so we probably compliment each other well. The latest version of our on-premise software includes new and enhanced capabilities to help you run your financial consolidation and close activities. If you have answered yes to any of the above questions, I invite you to join the sessions organized bySAP Intelligent Adoption and Consumption Teamin collaboration with Product Management, on Group Reporting with SAP S/4HANA Cloud, public edition. If so, you need SAP Universal ID. There are separate settings to specify how the FS Items should be Carried forward to the next year. SAP Group Reporting - Overview & Benefits - Finext . International Conference on Financial Close and Reporting. . The downsides are that BPC, being the mature product that it is, has better functionality in other areas. If you have multiple accounts, use the Consolidation Tool to merge your content. S/4HANA for Group Reporting is licensed separately to the underlying S/4HANA Enterprise Managment license in 1909 on-premise. They resemble the set in the SAP FICO system, just that Selection IDs can contain more than one field parameter. 2. There are other recent innovations in 2022 with the greatly enhanced Extension Versions that makes what if reporting far more easier with little to no additional overhead. With our latest release, you benefit from improved mapping transparency using the GRDC Data Mapping app through more efficient traceability, and explanation of target values linking back to source data records. Looking to streamline and transform your financial processes and data without disrupting existing ERP, finance, and legacy ecosystems? In a few months, SAP Universal ID will be the only option to login to SAP Community. Thanks for the video. Hopefully this will satisfy their needs! Save on licensing cost with Failover Rights for Azure SQL Managed Hi Gayathri, Very Informative and useful Blog !!! Posting level enables a selection of data by content. 1 Unit 1: Business Consolidation with SAP Group Reporting Overview 1 Lesson: Describing the Key Terms, Features, and Architecture 1 Lesson: Running Consolidation Tasks 1 Lesson: Implementing SAP S/4HANA Finance for group reporting 3 Unit 2: Master Data and Structures 3 Lesson: Describing the Structures Due to lack of time I'll limit my feedback to just two areas I also want to fully disclose that my focus in SAP field sales for the past 4+ years has been 100% on Group Reporting. If you have multiple accounts, use the Consolidation Tool to merge your content. It has come a long way in the past year and has a strong roadmap as it's upgraded independently from S/4HANA as it's a BTP application. With your experience in GR and with this limited information. Now this Selection ID could be called inside the Currency Translation Method and tagged to the Average Rate. License Requirements for S/4 HANA for Group Reporting | SAP Community How the Failover Rights benefit works. All Consolidation Groups should carry the same Ledger in one Version, to ensure consistency in Global parameters. This has been a huge benefit to customers who do reorganizations and need eliminations to not be hard coded to one hierarchy. Creation of new attributes is not supported. CU X - Company X - 'Release Universal Journal' active on Data Monitor. So if I understand you correctly, the license for on-prem version of Group Reporting also covers the usage of . You can only make changes to consolidation-relevant settings in Customizing for SAP S/4HANA for Group Reporting afterwards. If so, you need SAP Universal ID. Very information blog, thanks. Most the Std Fiori reports would give basic KPI's like Monthly Amounts, But if you need QTR, YTD Previous months KPI's then you have to go for customization of CDS views. https://help.sap.com/viewer/44ec04bc8de24103b400d261fde99462/2020.000/en-US/569960bcd8da4191a0bef41dc9f2f49a.html. Do we need license for each user for Analysis for Office setup. Experienced Digital Marketing & Marketing Operations Manager with a demonstrated history of working in various B2B industries. However, there are some limitations like Unavailable Custom extensions in Universal journal entry and Multicurrency reporting. If so, you need SAP Universal ID. Find out how you can integrate SAP products with your existing IT landscape. Yes if you only look at the existing Data Analysis Fiori apps I would agree with you. SAP S/4HANA Finance for Group Reporting and Consolidation This can be realized by checking No Posting/Entry check box. All the transactions and reports are available on Fiori. SAP S/4HANA Finance for group reporting 2022 is generally available The picture below taken from SAPs presentation on product vision, explains how Group Reporting fits into the landscape. This document provides you detailed information on SAP S/4HANA Finance for group reporting 2021, the latest version of SAP's next-generation software for financial consolidation and group close. Thanks for excellent blog. Can fields in acdoca that are not in acdocu be added in acdocu ? So as of the current release, Consolidation process happens at Company level. You can also leverage three additional new feature: Check out the new/enhanced features inherited from 2108 cloud release: Check out the new/enhanced features inherited from 2105 cloud release: Check out the new/enhanced features inherited from 2102 cloud release: Check out the new/enhanced features inherited from 2011 cloud release: For more information on SAP S/4HANA Finance for group reporting release 2021, you can refer to the following: You can co-innovate online with ourselves in the SAP Product Engineering team by joining us on the SAP S/4HANA for group reporting Customer Influence platform. If you have multiple accounts, use the Consolidation Tool to merge your content. At the same time one of the things I really admire about the Team behind the product is they really listen to customer feedback through the portal and a large % of the enhancements they make are a direct result of those requests and feedback. I see the following CDS views in Fiori (Image attached) but I see that in the description of each Consolidated CDS view the word cloud appears within square brackets [Cloud].