Integrating Data from SAP S/4HANA Finance

Objective

After completing this lesson, you will be able to integrate data from SAP S/4HANA Finance

Integrating Accounting and Group Reporting

The image illustrate a person working at a desk. To represent the person from the text bellow.

At ABC Corporation, one of your responsibilities is to acquire data. Since you are using SAP S/4HANA Accounting, you need to understand the integration with group reporting.

Let’s learn more about this below.

Learn how group reporting and accounting are integrated in the following video.

Group Reporting Integration

As postings occur in the general ledger for integrated companies, they're captured in the ACDOCA (Accounting Document for Actual) table. Before the data is released into group reporting, the general ledger trial balance report can be used to view the group reporting related data in ACDOCA.

You can also view group reporting data in the accounting journal entry. This feature is related to the preparation ledger, which became available in the 2022 edition. The benefit is that reporting and reconciliation can occur before the Data Release task (the sooner discrepancies are discovered, the better).

The image illustrates a financial reporting process. It includes steps from general ledger posting to reporting in group reporting.

In the following image, there are four steps in the data release process:

  1. Postings in the general ledger: as postings occur in ACDOCA, group reporting data is derived based on mappings in group reporting. For example, G/L account 10010000 is mapped to FS item 111000 and company code 1010 is mapped to consolidation unit DE.
  2. Report on the group reporting data in the general ledger: group reporting fields can be added to the trial balance report. Also, the group reporting data can be displayed in the general ledger document.
  3. Release the data into group reporting.
  4. Report on the released data in group reporting.
The image illustrates the process of general ledger posting and group reporting in a financial system. It shows the flow of data between ACDOCA and ACDOCU tables, highlighting the entries for both general ledger and group reporting.

Note

Company codes are typically assigned on a one-to-one basis to companies. In this scenario, company code 1010 is assigned to company 1010.

As postings occur in the general ledger, group reporting fields are recorded along with the rest of the accounting data. You can view the group reporting fields in the Manage Journal Entries app with these steps:

  1. Switch from entry view to ledger view.
  2. Add the group reporting fields to the line item display.
This image shows a journal entry screen in SAP for the leading ledger 0L. It includes details such as journal entry date, posting date, and line items with debit and credit amounts. It also shows group reporting fields recorded in the ACDOCA table.

There are several group reporting fields that are recorded in the general ledger (ACDOCA table):

  • Consolidation unit
  • Partner consolidation unit
  • Consolidation chart of accounts
  • Consolidation FS item
  • Consolidation subitem category
  • Consolidation subitem.

Note

In this scenario, company code 1010 in combination with profit center P9091 are included in a substitution rule to derive consolidation unit DE91.
View Group Reporting Data in General Ledger Documents

Group reporting data can also be displayed when accessing the line items of general ledger documents.

The image shows the Line Item in Ledger View web page, detailing a journal entry item. It includes general data, payment transaction details, the account assignment and group reporting information.

Create a G/L Entry and View Group Reporting Fields

Business Scenario

As postings occur in the general ledger, group reporting information is recorded in the ACDOCA table. The data is later released into group reporting. You need to learn how to view the group reporting data in the general ledger.

The main steps in this exercise are:

  • Create a journal entry in the general ledger.
  • View group reporting data in the journal entry.

Task 1: Create a G/L Entry

Task 2: View Group Reporting Fields

Create a G/L Entry and View Group Reporting Fields

Business scenario

As postings occur in the general ledger, group reporting information is recorded in the ACDOCA table. The data is later released into group reporting. You need to learn how to view the group reporting data in the general ledger.

The main steps in this exercise are:

  • Create a journal entry in the general ledger.
  • View group reporting data in the journal entry.

Task 1: Post a General Ledger Journal in SAP S/4HANA Finance

In order to test the release process, post an adjusting entry into the general ledger.

Note

In this exercise, when you see ##, replace the characters with your group number.

Steps

  1. In the Journal Entries group, go to the Post General Journal Entries tile.

    1. Open the Journal Entries group.

    2. Open the Post General Journal Entries tile.

  2. Input the header data as follows:

    Journal Header

    FieldValue
    Journal Entry DateDecember 31, 2025
    Posting DateDecember 31, 2025
    Period12
    Journal Entry TypeSA
    ... 
    Company Code1010
    Transaction CurrencyEUR

    Note

    Ignore any Warning message about the posting date.
    1. Enter the data provided in the Journal Header table.

  3. Enter the line item data as follows:

    Journal Line Item Data

    Line ItemC.CodeG/L AccountDebitCreditProfit Ctr
    0011010100100005500P90##
    0021010310000000550P90##
    1. Enter the data (except for the Profit Center. field) as provided above.

    2. Use the ellipse (…) to access the credit field if needed.

    3. Expand line item 001.

    4. Scroll down and input P90## under Profit Center.

    5. Expand line item 002.

    6. Scroll down and input P90## under Profit Center.

    Result

    A profit center is needed in each line item because consolidation unit is derived from company and profit center combinations as part of the course scenario.
  4. Post the document.

    1. On the lower right, choose Post.

      Result

      A dialog opens with a Success message along with the document number 100000xxx, year 2025 and company code 1010.
    2. Choose Display.

    Result

    A document was posted to the ACDOCA table. The Manage Journal Entry page opens.
  5. In the Line Items section of the Journal Entry screen, keep the Ledger View tab selected and choose 0L (Ledger 0L) . Check for both Journal Entry Items the following Group Reporting field values in the ACDOCA table:

    Group Reporting Field Values in the ACDOCA Table

    FieldValue
    Consolidation UnitDE##
    Company1010 (DE Company)
    Consolidation Chart of AccountsY1
    Consolidation Financial Statement Item111100 (for Journal Entry Item 000001)
     311000 (for Journal Entry Item 000002)
    Consolidation Subitem Category1 (Transaction Types)
    Consolidation Subitem915
    Finally, return to the SAP Fiori Launchpad Home Page.

    1. On the Journal Entry page open the Line Items tab.

    2. Keep Ledger View selected.

    3. In necessary, use the drop-down right to the Ledger field and select 0L (Ledger 0L).

    4. Choose >(Details) for the first line item and confirm the Group Reporting field values as described in the table above.

    5. Choose <(Back) on the upper left.

    6. Choose >(Details) for the second line item and confirm the Group Reporting field values as described in the table above.

    7. Choose the icon to return to the SAP Fiori Launchpad Home Page.

    Result

    The group reporting field values allow reporting on group reporting data in ACDOCA before the data is released to ACDOCU.

    Note

    If you don't have the group reporting fields values as shown above, the next exercise to release the data won't work.

Data Release - Key Points

One of the main sources of reported data is SAP S/4HANA Finance. You release accounting data (from the SAP General Ledger) into group reporting using the data monitor. The data release process controls the flow of data into group reporting.

Data Release - Key Points

  • Data release is an important control mechanism that prevents unwanted data from becoming available to group reporting.

  • Prerequisites:

    • The period is open.

    • The company is a consolidation unit.

    • G/L accounts are mapped to FS items.

  • As adjustments are made in the SAP General Ledger, you can run the data release again and again as needed.
  • The data release has a delta mechanism so that it only picks up changes in the central journal vs. the prior release for the period.
  • You validate accounting data with the built-in Line Item Validation task.

The data release task can be run from the Data Monitor using the Update function. As a result, the task logs screen is shown.

The image shows the execution of the data monitor task Release Universal Journal using the update function. As a result, the task log screen is immediately shown.

If you use the Start w. Selection option instead of Update, and then select the Classic Result Screen option, the system opens the classic result screen after execution of the data release task.

Note

Before release 2402 the classic result screen was automatically shown when the Update function was executed.
The image shows the execution of the data monitor task Release Universal Journal using the Start w. Selection function. As a result, the classic result screen option is offered.
The image shows that when using the Start w. Selection function, the classic result screen is shown instead of the task log screen.

In theRelease of Universal Documents - Result screen, you can see the following:

  • Consolidation units with data to release.
  • Versions with data to release.
  • Document links: access the data release documents and preview the incoming data.
  • Data release status.
  • Possibility to jump to the Task Log.

Release Reported Financial Data Options

After you closed the period in accounting, data release should be run for the last time (for that period). After you run Release of Universal Journals, you can then block the task.

When transferring accounting financial data, the system derives the posting period based on the accounting posting date and the period definition of the assigned fiscal year variant (FYV).

Example: You assign the K4 (Calendar Year, 4 Special Periods) FSV to a consolidation unit and make an accounting posting using December 31 as the posting date and any of the four special periods (13, 14, 15, or 16) as the posting period. In group reporting, the system releases data using the same special period as in accounting.

When you had used the Start w. Selection option, you are in the Release of Universal Documents - Result screen. From there you can access the Documents view to display the data by FS Item (Summary Result based of (Financial Statement Item) .

The image displays a financial summary report based on Financial Statement Items. The report includes entries for the Financial Statement Items 111100 and 311000, each with corresponding amounts in transaction, local, and group currencies.

You can then toggle to the G/L account (Summary Result based of (Account Number)) view as well.

The image shows a summary result table based on account numbers. It includes columns for account, documents, updated documents, amounts in various currencies, quantity, and currency type.

How to Solve Data Release Issues

Sub-assignment issues

After data is released into group reporting, the Line Item Validation is run. This detects incorrect sub assignments such as a missing trading partner for an intercompany account. Sub-assignment issues would most likely need to be fixed in accounting and then data release would need to be run again.

G/L account-mapping issues

If there’s a G/L account that isn’t mapped to an FS item, the data validation log displays an error. To resolve this G/L account-mapping issues, complete the following steps:

  1. Map the G/L account to an FS item.
  2. Run the data release task again.

As a result, the value for the previously unmapped G/L account will be in group reporting and the log won't display any errors.

Schedule Data Release

You can use the Schedule Jobs for Consolidation Tasks app to schedule and monitor jobs for consolidation tasks using the provided templates. If you have manual activities that you often need to do at a specific time (such as data release), this app can reduce your workload by automatically running these tasks smoothly in the background.

How to schedule data release

To schedule data release, complete the following steps:

  1. Choose Create.
  2. Select the Release Universal Journal template.
  3. Select a recurrence pattern such as single run, minute, day, week, or month.
  4. Specify the job-specific parameters such as consolidation chart of accounts, consolidation version, fiscal year/period, and consolidation group/unit.
The image shows the process of creating a new job in SAP for releasing universal journals, including steps for template selection, scheduling options, and parameter settings. The parameters include organizational units, version/time period, and technical settings.

Note

The Schedule Jobs for Consolidation Tasks app can also be used to schedule the following tasks:
  • Balance carryforward
  • Balance validation
  • Release universal journals
  • Calculation of net income
  • Currency translation
  • Preparation for consolidation group changes
  • Reclassification
  • Interunit Elimination with ICMR Posting Rules
  • Realign group reporting preparation ledger.

The preparation for consolidation group changes and reclassification job templates bundle multiple tasks.

Scheduling the Data Release Task

In this video, you'll see how to schedule the data release task. Scheduling the data release is similar to scheduling other tasks.

Release Data from Accounting into Group Reporting

Business Scenario

At ABC Corporation, new postings in the general ledger need to be released into group reporting. You need to learn how the data release process works.

What skills will you develop in this practice exercise?

  • Set your global parameters.
  • Open the period for group reporting in the data monitor.
  • Release the data.
  • Display the data release document.

Task 1: Release Data From Accounting into Group Reporting

Task 2: Display the Data Release Document

Release Data from Accounting into Group Reporting

Business scenario

The new postings in the general ledger need to be released into group reporting. You need to learn how the data release process works.

Note

In this exercise, when you see ##, replace the characters with your group number.

The main steps in this exercise are:

  • Set your global parameters.
  • Open the period for group reporting in the data monitor.
  • Release the data.

Task 1: Set your Global Parameters

Steps

  1. Set your global parameters in the SAP Fiori Launchpad. Use the following data:

    FieldValue
    Cons. GroupWorld
    Cons. Unit 
    VersionU##
    Fiscal Year2025
    Period12
    Cons. COAY1
    1. Go to the Consolidation Data Preparation group.

    2. Open the Set Global Parameters tile.

    3. In the Global parameters dialog, set your parameters as shown in the table above.

    4. Choose Continue.

    Result

    Global parameters are user-specific defaults that are used when running tasks and reports in group reporting.

Task 2: Open the Period for Group Reporting in the Data Monitor

Steps

  1. From the Consolidation Data Preparation group open the Data Monitor tile.

    1. Go to the Consolidation Data Preparation group.

    2. Select the Data Monitor tile.

    Result

    The hierarchy on the left has World as the top node with the following children:
    • BE##
    • CA##
    • DE##
    • FR##
    • US##
    The consolidation groups and consolidation units are green because the period is closed.
  2. Right-click on World and choose Open Period.

    Result

    The consolidation group World and consolidation units are no longer green.
  3. In the ribbon, click on Global Parameters, remove World, and choose Continue.

    Result

    Now, you can see all three consolidation groups (and their consolidation units):
    • AMER - America
    • EUR - Europe
    • WORLD - World
    See the following example for group 90.Two screenshots of the SAP Data Monitor interface display hierarchical data for various consolidation units. The interface includes options for test runs, updates, global parameters, and other functionalities.
  4. Click on Global Parameters, enter Cons. Group World and choose Continue.

Task 3: Release the Data

Steps

  1. Run the Release Universal Journal task for DE## using the Start w. Selection update possibility.

    1. Right-mouse click the "x" icon in the cell at the intersection of DE## and Rel Uni.J.

    2. Choose Start w. Selection.

      Result

      The Release of Universal Documents for Consolidation page opens.
  2. Release the data with the following settings:

    FieldSelection
    Current Period - Deltaselect
    Classic Result Screenselect
    Test Runde-select
    1. On the Release of Universal Documents for Consolidation page enter the information provided in the table.

    2. Choose Execute.

    3. In the Release of Universal Documents for Consolidation dialog choose Continue.

      Result

      The Data Monitor page opens.
  3. View the document for the U## line item. Toggle to the view accounts. Return to the Data Monitor. Finally, return to the SAP Fiori Launchpad Home Page.

    1. Select the line with version U##.

    2. Choose Documents.

      Result

      In the Summary Result based of (Financial Statement Item) dialog, two line items with entries in FS items appear. The debit line item and credit line item both have amounts of EUR 550 each.
    3. Choose Toggle View in the lower right of your screen.

      Result

      In the Summary Result based of (Account Number) dialog, two line items with entries in Account appear. The debit line item and credit line item both have amounts of EUR 550 each.
    4. Choose Continue.

    5. Choose <(Back) until you are in the Data Monitor.

      Result

      The Overall Status for consolidation group World is yellow (Open) because for DE## no data release has taken place yet.
    6. Choose the icon to return to the SAP Fiori Launchpad Home Page.

Line Item Validation

When a Line item Validation task is executed in the data monitor, all the validation rules of following two validation rule types are always run:

  • Standard Validation: contains delivered validation rules. For example, released data, uploaded data and group journals are automatically checked against the breakdown category, i. e. are there missing or incorrect sub-assignments for FS items? Is there a subitem for the cash FS item? Is a partner unit missing for an intercompany FS item?
  • Custom Validation: contains validation rules created by the customer. Released data, uploaded data and group journals are checked against custom validation rules. For example: is there a trading partner in an intercompany posting.

So all Line Item Validation tasks check the same validation rules!

Custom validation rules are maintained with the Manage Substitution/Validations Rules - Group Journal Entries app.

The following figure gives an overview of line item validations during the consolidation preparation process.

The image shows the use of the Line Item Validation task along the consolidation process.

For the Line Item Validation of the Reported Financial Data and the Manual Postings according to the figure above, no task has to be defined, assigned and executed in the data monitor since the validation is automatically done in the background when data is provisioned.

For the Line Item Validation of the Data to Release, Released and corrected data and Rep. Data for staggered close according to the figure above, different Line Item Validation tasks have to be created and executed from the data monitor.

Especially for the Released and corrected data it is strictly recommended to run a subsequent line item validation task to check the data consistency since these data records are not checked during the entry on these posting levels.

To detect missing mappings between G/L accounts and FS items, assign content task S015 - Line item Val. on Acct. LIs to the data monitor and execute this Line Item Validation task before the data release task in the data monitor. You can then correct the missing mappings between G/L accounts and FS items and finally execute the data release task.

For example, you have the following entry in ACDOCA:

  • Debit to account 10010000 that is mapped to FS item 111100.
  • Credit to account 41000000 that isn’t mapped to an FS item.
  • The data release task execution would bring in the 10010000/111100 line item but not 44000000 ... causing an out-of-balance.
  • Correct the mapping: account 41000000 is mapped to FS item 411100.
  • Execute the data release task.
The image shows the SAP Data Monitor interface with the focus on the Line Item Validation Task. In this figure this task was executed successfully.

The Line Item Validation task can be run in the data monitor or using the Schedule Jobs for Consolidation Tasks app.

Note

If there’s an error result when executing the Line Item Validation, subsequent tasks can't be blocked in the data monitor.

Run Line Item Validation

Business Scenario

At ABC Corporation, you've released data from accounting into group reporting. Now, you want to run the built-in line item validation task.

What skills will you develop in this practice exercise?

Run line item validation.

Run Line Item Validation

Task 1: Run Line Item Validation

Business scenario

At ABC Corporation, you've released data from accounting into group reporting. Now you want to run the built-in line item validation task.

The main steps in this exercise are:

  • Go to the data monitor
  • Run line item validation

Note

In this exercise, when you see ##, replace the characters with your group number.

Steps

  1. From the Consolidation Data Preparation group open the Data Monitor tile.

    1. Go to the Consolidation Data Preparation group.

    2. Select the Data Monitor tile.

  2. Run the line item validation for DE## and view the log for the U## version. Finally, return to the SAP Fiori Launchpad Home Page.

    1. Right-click on the intersection of DE## and LIV GR

    2. Choose Update.

      Result

      The built-in validation task is run and the Line Validation - Task Log screen opens.

      See the following example for group 90:

      The screenshot shows the Line Item Validation result for the example of version U90.

      Note

      It's possible that instead of the detailed protocol shown in the figure above the Task Log is empty. This is ok, too.

      Note

      The data was checked against the breakdown categories and no discrepancies were found.

      Note

      When the accounting data is validated, checks are made for not only for consolidation version U## but also for other versions that are referenced to it.
    3. Choose the icon to return to the SAP Fiori Launchpad Home Page.

  3. Use the Display Group Journal Entries tile to display the release document for version U##.

    1. Go to the Consolidation Data Preparation group.

    2. Open the Display Group Journal Entries tile.

    3. In field Version enter U## and choose Go.

    Result

    Document number 4000000xxx is displayed along with document type 0F.
  4. In the details of the first line item, confirm that the posting level is Realtime Update. Finally, return to the SAP Fiori Launchpad Home Page.

    1. Right to the first Document Number row choose >(Details) .

      Result

      On the General Data tab of the Group Journal Entry page you will find Posting Level (Realtime update) in the Posting Information section.
    2. Choose the icon to return to the SAP Fiori Launchpad Home Page.