Show TOC

Function documentationOpen Items: Data Selection Locate this document in the navigation structure

 

You can select open items posted between business partners within the group, whether the items are from other SAP systems or non-SAP systems. Data selection is a preparatory process step in which the system selects the data to be reconciled from the accounts of the operational systems of the companies to be reconciled and then transfers that data to the reconciliation database.

Recommendation Recommendation

Make the data selection using background processing.

During the closing phase, we recommend scheduling background processing to be executed at least once a day.

You can schedule background processing by choosing   System   Services   Jobs   Job Definition  , or by using the Schedule Manager or the Closing Cockpit.

End of the recommendation.

Using data selection, you can estimate the data volume to be processed further for the reconciliation and resolve any errors that occurred.

Integration

The entire process for cross-system intercompany reconciliation comprises the following process steps (some of which are mandatory, others optional):

This graphic is explained in the accompanying text.

Overview of Process Steps

Prerequisites

You have made the necessary Customizing settings for the sender and reconciliation systems.

To make the Customizing settings for Accounts Receivable and Accounts Payable, use the following menu path:

  • If you use classic Financial Accounting:

      Financial Accounting   Accounts Receivable and Accounts Payable   Business Transactions   Closing   Count   Cross-System Intercompany Reconciliation  

  • If you use new Financial Accounting:

      Financial Accounting (New)   Accounts Receivable and Accounts Payable   Business Transactions   Closing   Count   Cross-System Intercompany Reconciliation  

Features

Using the fiscal year variant stored in Customizing for the reconciliation process and the details entered in the selection screen, the system automatically determines the relevant key date to be applied in selecting the open items. The system then applies this key date to select the open items for the specified companies and stores the open items in the reconciliation database. Within the reconciliation database, the system stores the dataset by period in separate data areas.

The system outputs a list containing the number of data records transferred for each trading partner. Using this list, you can estimate the volume of data to be processed further and view any errors in the data selection so that you can resolve them.

Activities

You can schedule execution in background processing (see above).

  1. On the SAP Easy Access screen, choose the following paths:

      Accounting   Financial Accounting   Accounts Receivable or Accounts Payable   Periodic Processing   Closing   Check/Count   Cross-System Intercompany Reconciliation   Select Documents  

  2. In all screen areas, you specify the criteria to be applied for selecting data for the reconciliation.

  3. Choose Execute (Execute).

    The system transfers the selected open items to the reconciliation database and outputs a log containing the number of data records transferred for each trading partner.