Flexible Upload 

Purpose

You use this component to import transaction data or master data and hierarchies from a data file into the consolidation system (SEM-BCS).

Integration

You can use the Flexible Upload component as an alternative, or in addition, to the other data collection procedures.

Within the Flexible Upload method you can use the Business Add-in (BAdI) for data collection (UC_DATATRANSFER) to perform mapping activities that are not directly supported - such as mapping source fields to target fields with a 1 : n relationship. For detailed information, see the system documentation of the BAdI UC_DATATRANSFER and the documentation of its methods.

Features

In the Customizing settings for the Flexible Upload method, you specify the format of the data in an upload file. Furthermore, under Mapping you determine how to map the characteristics and key figures of the source data to the consolidation system. You also have the option to define target selections. For more information, see Customizing for Flexible Upload.

When the method is executed, the system writes the values to the target area of the data basis as defined in your Customizing settings. The system derives the values for consolidation-specific characteristics (for example, the posting level and the default values for subassignments when loading the transaction data).

Loading of Transaction Data

You can upload the following transaction data from a text file into the consolidation system:

●      Reported financial data (posting level 00)

●      Documents (posting levels 01, 02, 10, 12, 20, 22, and 30)

●      Additional financial data

The data streams Sequence of Activities, Activity Sorting, and Activity Numbers are not available for flexible uploads. When uploading the data streams Investments, Equity, Equity Holdings Adjustments, and Goodwill, you cannot adopt the activity numbers from the source data. However, you can do this in the data collection procedure Load from Data Stream.

To be able to periodically execute flexible uploads of transaction data in the Consolidation Monitor, you define an upload method, assign this method to a data collection method, which you then assign to a data collection task (see Defining a Flexible Upload).

Loading of Documents

The system uses the standard rules for writing uploaded documents to the target data. For more information, see Automatic Data Collection of Documents.

You can improve the differentiation of the documents by inserting header rows (in the upload file) that indicate when a new document should be created. To do this, you use row type indicators (see Customizing for Flexible Upload).

Loading of Master Data and Hierarchies

You can upload the following master data and hierarchies from a text file into the consolidation system:

●      Consolidation groups and their hierarchies

●      Consolidation units and their hierarchies

●      Combinations of consolidation units

●      Items and their hierarchies

●      Transaction types

●      Breakdown categories

●      Other master data (such as functional areas)

To upload master data and hierarchies, you only need to define an upload method, execute the method in the Consolidation Workbench, and save your changes.

Integration with SAP Applications

Processes are available for integrating SAP applications with the consolidation system (SEM‑BCS). These are primarily intended for customers who have previously used the consolidation component EC‑CS, and who now want to migrate to SEM‑BCS. For more information, see Integration with SAP Systems.