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

SAP Group Reporting Data Collection: create form-specific master data (ad hoc items)

SAP Group Reporting Data Collection: create form-specific master data (ad hoc items)

We’re glad to announce the general availability in Q1-2022 of the SAP Group Reporting Data Collection (GRDC) ad hoc items feature that enables you, as form designers, to create forms-specific master data during form design. If you’re using the cloud version of SAP S/4HANA for group reporting, you can leverage this new feature now; if you’re on premise you’ll be able to use it in Q4-2022.

In this blog, you’ll find insight on:

  • Ad hoc items benefits and use cases
  • How to create ad hoc items
  • How to design a form using ad hoc items
  • Simplified architecture diagram


Ad hoc items benefits and use cases

By using ad hoc items, you can now 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

The form-specific ad hoc item master data creates dimensions that are:

  • Controlled by SAP Group Reporting Data Collection (GRDC) users
  • Created during form design – with no group reporting governance involved
  • Combined with any other SAP S/4HANA for group reporting dimension, including financial statement items and custom dimensions

Our new ad hoc items help you create data collection forms for business scenarios such as:

You can use SAP Group Reporting Data Collection (GRDC) ad hoc items as additional dimensions for a financial statement item where you need to collect data values for a consolidation unit or consolidation group in group reporting. The ad hoc items facilitate the naming, collection, and reporting of a set of values that are supplemental to the modeled financial data.

With ad doc items, you can:

  • Empower business users to design a data-collection process including additional required master data
  • Increase flexibility for users to create master data ad-hoc with no need for group reporting related master data governance
  • Enable your business users who design a data collection process to use the extra master data where they are needed (such as for a specific report) and avoid adding them to everyday business

In the illustration below, ad hoc items are used in a form to collect data related to budget portions spent with local suppliers, as per Global Reporting Initiative (GRI) standards.

The illustrative form above is designed as follows:

  • Columns A and C – the Financial Statement item “Trade Payables” is broken down by Functional Areas
  • Columns E and G – two ad hoc items are used to provide a detail by local supplier, in amount and in percentage (calculated with a formula)
  • Columns I and J – check whether the % of local supplier is compliant from a sustainability perspective (in this example, 90% or more spent on local suppliers is compliant with the corporate sustainability goals)


Create your ad hoc items

Ad hoc items behave much like other dimensions of SAP S/4HANA for group reporting:

  • Ad hoc items’ master data is stored in SAP S/4HANA for group reporting master data table
  • Ad hoc items’ data is stored in SAP S/4HANA for group reporting data table (ACDOCU)
  • They can be considered in currency translation, intercompany eliminations, breakdown with other dimensions and validation rules

You can create your ad hoc items in the “Define Ad Hoc Items” app of SAP Group Reporting Data Collection (GRDC), as depicted below.


Design forms using ad hoc items

Once your ad hoc items are created, you can use them in a form definition in the “Manage Forms” app. Ad hoc items work like any other dimension – including their combination. The selected financial statement item (FS item) defines attributes like currency translation. In cases where there is no FS item available because you want to collect completely new numbers, a dummy FS item can be used.

When creating the form, the ad hoc item appears in the list of available dimensions, just drag and drop the ad hoc item in the Dimension Selection tab. See the example below, where ad hoc items go in columns.

Then, in the Form Designer tab, select the ad-hoc items you want to be collected.

You’re all set, and supplemental data is ready to be collected on ad hoc items.


Simplified architecture diagram

Below is a simplified architecture diagram depicting the supplemental numbers / ad hoc items master and transactional data flow.


More information

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mike Duboise
      Mike Duboise

      Thank you Stephane, this looks very useful.

      Is this designed to work with all S4 releases, or is there a required version level?

       

      Kind regards

      Michael

      Author's profile photo Marcel Heckermann
      Marcel Heckermann

      Hi Mike,

      For customers using SAP S/4HANA Cloud for group reporting, this innovation is available since release 2102.

      In combination with S/4HANA Finance for group reporting or SAP S/4HANA Cloud, private edition: availability is planned for Q4/2022.

      Kind regards,
      Marcel
      Product Owner
      Unstructured data in SAP S/4HANA for group reporting / SAP Group Reporting Data Collection