Skip to Content
Product Information
Author's profile photo Stephane NEUFCOURT

SAP Group Reporting Data Collection in brief

Hi everyone!

Many of you asked us in Product Engineering to share a recap blog on the features and tech of SAP Group Reporting Data Collection (GRDC), the SAP S/4HANA for group reporting’s  companion app. Here it is, we hope you’ll find it useful. Please refer to the GRDC documentation for a complete description of all features and tech aspects.

In this blog you’ll find the following information:

  • What is GRDC
  • When to use GRDC
  • GRDC technical architecture
  • When to use GRDC data mapping
  • When to use GRDC forms
  • GRDC product roadmap

What is GRDC

GRDC is an app to help you collect financial data, non-financials and comments into SAP S/4HANA for group reporting – in the ACDOCU consolidation table. It provides two main features. With GRDC Data Mapping, you can automate the mapping, transformation and data load from SAP and non-SAP systems into ACDOCU. With GRDC Forms, you can enter data and comments manually in ACDOCU using pre-delivered forms, or by creating your own.

GRDC is part of SAP’s product strategy for consolidation, which aims at delivering building blocks for an integrated group reporting.


When to use GRDC

If you run SAP S/4HANA for group reporting in a standalone mode, you can collect all financial data, non-financials and comments from your subsidiaries with GRDC.

If you run SAP S/4HANA for group reporting in combination with SAP S/4HANA, GRDC helps you complement released data from ACDOCA, for example by collecting statistical information or splitting subitems. Also, GRDC helps you quickly collect data from companies you recently acquired and that are not yet integrated in your SAP S/4HANA system.


GRDC technical architecture

GRDC consists of a set of Fiori apps. These apps and the required services are hosted on SAP Business Cloud Platform (BTP). GRDC integrates with S/4HANA for group reporting – cloud or OP – via APIs. The usage of S/4HANA for group reporting is mandatory for GRDC, as all master data and financials figures are stored in S/4HANA. GRDC is a native cloud app, with a new release delivered every 2 weeks.

GRDC follows the “provider/subscriber” concept. The app is deployed and maintained by SAP in a “provider” subaccount. Through your subaccount, you “subscribe” to the app deployed on SAP’s provider account. The app is then customer managed. Check out for more: GRDC for SAP S/4HANA cloud and GRDC for SAP S/4HANA on premise.


When to use GRDC Data Mapping

GRDC Data Mapping is a flexible ETL app including the ability to define mappings (source to target), run / schedule mapping jobs, and check results in traceability logs. Use it to:


— CSV to ACDOCU —

This is the most general use case. Extract data from your source system in a CSV file. Data Mapping will map, transform, load data in ACDOCU. Check out for more: Run a Mapping Job with a File as Source and Extract and import data from ECC.


— Import API to ACDOCU —

This use case is more automated as you don’t need the intermediary CSV step. Implement Data Mapping’s Import API in your remote system. Your remote system will push data to Data Mapping to map, transform, load data in ACDOCU. Check out for more: Import API.

Important note
In this use case, you need to implement / develop an application in your remote system. This application reads data from the data base, format it in CSV and push it through the Push API. Your remote system should allow the development of applications or extensions, as well as connectivity to GRDC data mapping (store login, password and connect to GRDC).


— Remote ACDOCA to ACDOCU —

If you’re running multiple SAP S/4HANA instances, use Data Mapping to import ACDOCA data from a remote SAP S/4HANA system into your leading ACDOCU. Check out for more: Create a Data Mapping Definition with an ACDOCA Table as Source.


— ACDOCA to ACDOCU in the same SAP S/4HANA system —

Use Data Mapping to transform and load ACDOCA into ACDOCU within the SAP S/4HANA system. For example, if you need to retrieve additional ACDOCA data for statistical information (e.g. aging information of AR/AP). Check out for more: Run a Mapping Job with an ACDOCA Table as Source.


— ACDOCU to ACDOCU in the same SAP S/4HANA system —

Use Data Mapping to transform ACDOCU data within the SAP S/4HANA system. For example to copy missing consolidation units’ reported data for non-material consolidation units, help run your step consolidations or supplement C/I control data. Check out for more: Run a Mapping Job with an ACDOCU Table as Source.


— Check results in traceability logs —


When to use GRDC Forms

GRDC Forms is the app where your consolidation units can manually enter financial data, non-financials and comments in SAP S/4HANA for group reporting. The app contains pre-delivered forms, and you can create your own. Use Forms to manually enter package / reported data, and complement ACDOCA released data (e.g. sustainability information, statistical information like aging information of AR/AP).


— Pre-delivered business content —

You can use pre-delivered input schedules, such as Balance Sheet Accounts Detailed by Transaction Types (for example financial assets, fixed assets, current assets, non-current assets, financial liabilities, provisions or equity), Profit and Loss or inventory Profit (internal margin rate at seller, internal inventory detailed by partners at buyer).


— Define your own forms —

Create and organize forms and folders in the “Manage Forms” tile. You can create new forms or copy predefined forms to the custom folder and use them as templates to create enhanced forms. You can choose the dimensions you want to display. Drag and drop dimensions to the filters, rows, and columns and choose the order in which the dimensions appear.

You can enter formulas in cells, and use these formulas to run calculations, calculate amounts instead of entering them manually, and customize titles.

You can also provide guidelines that explain how to use the form, including, for example, links and screenshots. These guidelines are displayed in the Enter Package Data app to provide guidance when entering data in the form.


— Formulas and Conditional formatting —

Use functions when creating formulas in your forms. You can create formulas using functions in the formula section of the cell view. You can use these formulas to run calculations, calculate amounts instead of entering them manually, and customize titles. Leverage a large variety of formula syntaxes, such as Date and Time, Engineering, Information, Financial, Logical, Lookup and Reference, Math and Trigonometry, Matrix Functions, Operator, Statistical or Text. Formula results can be saved to the Consolidation Journal Entries (ACDOCU) table. Check out for more: Formula Syntaxes.

Use the Conditional formatting to change automatically the background or font color depending on the value in the cell. If you select Apply Background Color, the background is green if the value in the cell is zero, OK, true, or valid. The background color is orange if the value is a warning, otherwise it’s red. Similarly, if you select Apply Font Color, the font color changes to green, orange, or red. Check out for more: Automatic Conditional Formatting.


— Collect comments —

Collect text information using comments. Comments are directly associated to the data. They can be short, which is what the dialog’s size encourages – or up to 10.000 characters long, if required in certain cases. Check out for more: Enter Comments.


— Create form-specific master data (ad hoc items) —

By using ad hoc items, you can use SAP Group Reporting Data Collection (GRDC) to create form-specific master data during the design of a form, and split existing numbers into additional categories, collect new numbers that exceed the scope of the regular consolidation data model, create forms where non-financial and qualitative data need to be collected. Check out for more: Ad hoc items.


GRDC roadmap and more information

Assigned Tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Satyanarayana Rao Karri
      Satyanarayana Rao Karri

      Great overview of GRDC and its capabilities. Very helpful.

      Author's profile photo Stephane NEUFCOURT
      Stephane NEUFCOURT
      Blog Post Author

      Thank you Satya!! There's also a lots of additional info on GRDC in our new Group Reporting community on sap.com https://community.sap.com/topics/s4hana-group-reporting as part of our "Featured Content" of the month 😉

      Author's profile photo Nikhil Anand
      Nikhil Anand

      Stephane, Thanks for the detailed blog. Can we use GRDC to do Master data Load also? For e.g Flat file from external non sap system to S4 GR for Operational CoA to FS Item mapping load.

       

      Regards

      Nikhil

      Author's profile photo Stephane NEUFCOURT
      Stephane NEUFCOURT
      Blog Post Author

      Hi Nikhil,

      GRDC is for data load.

      For master data load, you can use S/4HANA for group reporting's "Import Master Data" app.

      More info
      👇 https://help.sap.com/products/SAP_S4HANA_CLOUD/90c07e91c7a64f328be3fd6b48955b13/6fcb7e5bf1334c0097d03c9b3d50badb.html?version=2108.501&q=import%20master%20data

      Kind regards,
      Stéphane

      Author's profile photo Swamy Madduluri
      Swamy Madduluri

      Hi Stephane,

      Excellent Summary and overview of GRDC, just in time to help for year end consolidation and group reporting

      Author's profile photo Stephane NEUFCOURT
      Stephane NEUFCOURT
      Blog Post Author

      Thank you Swamy. Glad to hear this is useful!

      Author's profile photo Rushabh Mehta
      Rushabh Mehta

      Hi Stephene,

      Thanks a lot for the overview of GRDC it's very helpful.
      If possible can you please elaborate more on the GRDC Data mapping use case around Run step consolidation

      Author's profile photo Stephane NEUFCOURT
      Stephane NEUFCOURT
      Blog Post Author

      Hi Rushabh, thanks for the kind feedback and suggestion. We plan to write a series of Blogs/How-to-Guides on different GRDC data mapping use cases. "How to leverage GRDC data mapping to run a step consolidation" is part of the list 😉 Would you like to get an update when the blog is published, you can follow our Group Reporting community https://community.sap.com/topics/s4hana-group-reporting
      Kind regards,
      Stephane

      Author's profile photo Rushabh Mehta
      Rushabh Mehta

      Hi Stephen,

      Thanks for the update, eagerly waiting for the Blogs / How-to-Guides on different use cases 🙂

      Author's profile photo Stephane NEUFCOURT
      Stephane NEUFCOURT
      Blog Post Author

      Hi Rusabh,
      In case you missed it, just to tell you the step consolidation blog has been published:
      How to run a step consolidation in SAP S/4HANA for group reporting using SAP Group Reporting Data Collection
      Kind regards,
      Stéphane

      Author's profile photo Kalyan Dey
      Kalyan Dey

      Hi Stephen,

      Great overview. Can we use GRDC for row level comments entry i.e., separate column for comment entry in the form or we can just do cell level comment entry?

      Regards,

      Kalyan.

      Author's profile photo Marcel Heckermann
      Marcel Heckermann

      Hi Kalyan,

       

      Thank you for your question. The roadmap holds items for

      1. general questions and answers that relate to a whole form
        and
      2. questions and answers relating to specific numbers

      It is planned that questions and answers always have dedicated in-line answer cells, so e. g. a separate row or - like you proposed - a separate column.

      From step 2, they can refer to selected row and column values, pointing to one cell like the comments do.

       

      If you are not focused on the visual representation (extra answer columns) only, but also on the data reference, then your idea goes one step further, either

      • making an answer relate to a whole row
        or
      • doing the same with a comment

      In this case, it would be great to have it in our Customer Influence platform for voting and assessment. May I suggest you enter it there? -> https://influence.sap.com/sap/ino/#/campaign/2283

       

      Kind regards,
      Marcel Heckermann

      Author's profile photo Former Member
      Former Member

      Hi Stephane, Thanks for detailed explanation. We are currently working on GRDC data load and completed CSV to ACDOCU approach but we stuck with Import API to ACDOCU approach.  Can you please help us with the below questions that we have? 1. Our source system is on-premise and standard Import API is not available, so can we use Import API approach?

      2. If yes, can we configure/enable Import API in source(remote) system as Push API to push data to GRDC data mapping?  or is Push API, a new one that we have to create?

      Kind Regards,

      Hima

      Author's profile photo Peter Muschick
      Peter Muschick

      Hi,

      When is GRDC planned to available? This product is not listed in PAM, and we can not find further information about it.

      Thanks a lot and kind regards

      Peter

      Author's profile photo Marcel Heckermann
      Marcel Heckermann

      Hi Peter,

      GRDC has been out there for some time already. 🙂

      We would be happy to provide more details, so:
      What would you like to know more about?

      Note: PAM is currently not maintained for this product.

      Thank you and kind regards,
      Marcel

      Author's profile photo Steven Foo
      Steven Foo

      We have setup GRDC 3 subaccount under 1 global account in eu10.

      1 - DEV, 1- QAS and 1 - PRD.

      We want to have all changes made in DEV and have CTMS transport into QAS.

      In QAS we only want to have test in place and not changes to config.

      Same as PRD.

      How to achieve ? We could not find the solution.

      Any idea?

      At the subaccount properties, if we set it user for production = yes, will it help?