Function documentationFlexible Upload

 

You use this function 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 the method does not directly support - such as mapping source fields to target fields with a 1:n relationship). For more 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, you specify how the system is 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 system executes the method, it writes the values to the target area of the data basis in accordance with the settings you have made in Customizing. In doing so, the system derives the values for consolidation-specific characteristics (for example, the posting level and the default values for subassignments when loading 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

    Note Note

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

    End of the note.

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, and then assign this data collection method 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 the positions at which the system is to create a new document. 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.

Integrated Upload of Superordinate Fields

If you choose data type Assets/Liabilities - Master Data, you can specify that, in the case of a compound of characteristics, the system is also to upload independent (that is, superordinate) fields. Using this function you can, for example, upload the asset main number together with the asset subnumber.

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.