Collect Activity Data Automatically

Overview

The following table shows which automatic data collection procedures are suitable for transferring data for data streams that use activity numbers for consolidating investments.

Automatic Data Collection for Data Streams with Activity Numbers

Data Stream	Flexible Upload	Load from Data Stream	Copy
Documents (posting level 30, Consolidation of Investments application)	(X)	X	X
Investments	(X)	X	X
Equity	(X)	X	X
Result	(X)	X	X
Goodwill	(X)	X	X
Sequence of Activities	–	X	X
Activity sorting	–	(together with sequence of activities)
Activity numbers	–	X	implicit

Note on (x): The system cannot collect activity numbers from the source data.

If you would only like to load the equity , investments , and/or results data streams, then the source activity number does not necessarily have to be available. When loading, the system creates new activity numbers which you can match afterwards by running an activity numbers match .

Note Note

If the source data contains automatic goodwill entries, then the system flags these entries in the target data as manual goodwill entries.

End of the note.

Please note the following prerequisites and restrictions for the various data collection procedures.

Flexible Upload

With the flexible upload , you can upload data for data streams that use activity numbers (provided the data streams are defined in the database), however, you cannot do this for the activity sequence, activity sorting, and activity numbers data streams.

When uploading data for the equity, investments, results, goodwill, and documents (posting level 30, Investment Consolidation application) data streams, you cannot collect the activity numbers from the source data.

It is not possible to upload automatic goodwill entries.

For more information on migrating investment consolidation data from EC-CS, see Migrating Investment Consolidation Data from EC-CS to SEM-BCS

Load from Data Stream

Load from data stream loads all data streams that use activity numbers, including the data streams Sequence of Activities, Activity Sorting, and Activity Numbers (provided the data streams are defined in the data basis).

The data streams Sequence of Activities and Activity Sorting are interconnected. The system loads both data streams when you choose data type Sequence of Activities in the Customizing settings for the Load from Data Stream method.

General Approach

If you want to use Load from Data Stream to load data streams that use activity numbers, you must load the Activity Numbers data stream first. Subsequently, the system generates new activity numbers and saves the source activity number of each new activity number (along with the logical name of the source system).

The system adopts the logical name of the source system (in which the activity numbers were originally assigned) from the source data basis. If the logical system is not specified, the system checks whether the InfoProvider you specified in the Load from Data Stream method as the source is used as a regular DataStore object in a regular data basis of the local system. If this is true, the system uses the logical name of the local system. Otherwise, the system issues an error message.

Note Note

If the activity numbers were not generated in the local system, you specify the logical name of the source system that generated the activity numbers in the Customizing settings of the source data basis on the Field Catalog tab page. This may be necessary, for example, when collecting consolidation of investments data from EC-CS or from a separate SEM-BCS system.

End of the note.

The system requires references to the source activity numbers to be able to match the source activity numbers of the other data streams to the target activity numbers already assigned.

Note Note

Mapping of the Load from Data Stream method for all subsequent loads must be consistent with the mapping for loading the activity numbers. This particularly applies to the mapping of the activity number.

End of the note.

To ensure that the relationship between the data types involved in a given activity is preserved, the source activity numbers need to be available for the following data streams, and you need to match them with the target activity numbers in the mapping of the Load from Data Stream method:

Sequence of Activities and Activity Sorting
Documents (posting level 30, Consolidation of Investments application)
Goodwill

If the source data contains automatic goodwill entries (which are marked as manual goodwill entries), you also need to load the data streams of the additional financial data that triggered the generation of the automatic goodwill entries. The source activity numbers need to be available for these data streams as well, and you need to match them with the target activity numbers in the mapping of the Load from Data Stream method.

Copy

The copy function copies all data streams that use activity numbers, including the data streams Sequence of Activities and Activity Sorting (provided the data streams are defined in the data basis).

The data streams Sequence of Activities and Activity Sorting are interconnected. The function copies both data streams when you choose data type Sequence of Activities in the Customizing settings for the copy method or for nonperiodic copying . You also can choose All Data Types in the copy method.

Note Note

You have the option to map source fields to target fields in the copy method. (By default, the fields are adopted on a one-to-one (1:1) basis.) Mappings must be consistent for all data streams that you copy and that use activity numbers. This particularly applies to the mapping of the activity number.

End of the note.

When you copy data streams with activity numbers, the function first copies the Activity Numbers data stream to be able to portray the activities in the target data in a consistent manner (as in Load from Data Stream). Whether the function adopts the activity numbers or assigns new activity numbers depends on the given situation. The following table shows this relationship:

Treatment of Activity Numbers

Given Situation	Treatment of Activity Numbers
Copy between versions within the same consolidation area	The function adopts the activity numbers from the source version.
Copy between group currencies within the same consolidation area	The function generates new activity numbers and saves the source activity number of each new activity number (along with the logical name of the source system).
Copy from a different consolidation area	The function generates new activity numbers and saves the source activity number of each new activity number (along with the logical name of the source system).