Function documentationControl of Data Collection Using Update Mode

 

The update mode you select for data collection determines how the system treats existing data in the target system. Both the type of data and the data collection procedure also affect the behavior of data collection.

Integration

The update mode controls the function of the data collection procedures flexible upload, copy, delete, and load from data stream.

Features

Determination of Data to Be Changed

The update mode you choose only applies to the data records that match the selection. Data beyond the selection range is not changed by any data collection procedure. The type of data to be collected affects the scope of the selected data as well as the data's composition:

  • Reported financial data

    The data to be changed can be selected based on the characteristics with the roles version, group currency, fiscal year, period, and consolidation unit along with their independent compound characteristics, and the characteristics that are fixed in the consolidation area.

  • Documents

    The same characteristics as for reported financial data (listed above) are used for selecting the data to be changed. In addition, the system uses the characteristic with the role document type.

  • Changes in investment

    The data to be changed can be selected based on the characteristics with the roles version, group currency, fiscal year, period, and investee unit along with their independent compound characteristics, and the characteristics that are fixed in the consolidation area.

  • Other data: changes in investee equity, goodwill, equity holdings adjustments, inventory data, and supplier data

    The data to be changed can be selected based on the characteristics with the roles version, group currency, fiscal year, period, and consolidation unit along with their independent compound characteristics, and the characteristics that are fixed in the consolidation area.

  • Master data and Customizing settings

    When selecting this type of data, the system normally uses the independent characteristic of the characteristic for which data is being collected. For more details about these characteristics, see the properties of each characteristic in the Data Warehousing Workbench of NetWeaver Business Intelligence (BI).

    Here is the selection behavior for several Customizing settings and special types of master data:

    • Combinations of consolidation units: The selection uses the independent compound characteristic of the characteristic with the role consolidation unit.

    • Version combination: The selection uses the independent compound characteristic of the characteristic with the role version.

    • Breakdown category: The selection uses the characteristic consolidation area.

Treatment of Existing Data

The application of the update modes treats the various types of data in different ways. These different effects are described below.

Recommendation Recommendation

Some differences in system behavior are very subtle and only concern narrowly-defined focal areas of data collection. We therefore recommend that you closely examine the effects of the update mode on the type of data you want to collect to avoid drawing any false conclusions about one data type over another.

End of the recommendation.
Reported Financial Data

  • Delete All: All data within the selection is reset to zero.

    By default, the system also reads any data records from the source environment in which all key figures are zero. If you have activated the business function FIN_ACC_GC_ASTHFS, you can specify that the system is to ignore these data records by selecting data type Reported Financial Data or All Data Types in the Customizing settings for a collection method of type Load from Data Stream or Copy.

  • Delete Uploaded Data: The system resets to zero all data within the selection whose combination of characteristics also appears in the data to be collected. However, data that lies within the selection but has no corresponding data in the data to be collected is not changed.

  • Overwrite: Existing data is overwritten with the imported data that has the same combination of characteristics. Data for which there is no corresponding data to be collected remains unchanged.

  • No Modification: All data in the target system remains unchanged.

    Note Note

    The system creates new data records in the target system for collected data records whose keys do not match the keys of the data in the target system. Exception: If update mode No Modification is used, no new reported financial data is created.

    All four update modes are available for the flexible upload method. Only the modes Delete All and Overwrite are available for the other data collection methods.

    End of the note.
Documents

  • Delete All: System behavior depends on the input type.

    • Periodic: All documents of the period are reversed. The system also creates a new document that eliminates the effects of all existing inverting and inverted documents within the period.

    • Cumulative: All documents of the period are reversed. The system also creates a new document for the period. This document eliminates the effects of all documents that were posted in the prior periods of the fiscal year. This document also eliminates all inverting and inverted documents that were posted in the current period of the fiscal year.

  • Delete Uploaded Data: The same as for Delete All.

  • Overwrite: All existing documents in the target system remain unchanged. If the input type is cumulative, the system creates a new document that eliminates the effects of all documents that were posted in the prior periods of the fiscal year.

  • No Modification: The same as for Overwrite.

    Note Note

    The system always posts documents that are imported from a data file.

    Whether data collection deletes or reverses existing documents depends on the settings for version combinations.

    All four update modes are available for the flexible upload method. Only the modes Delete All and Overwrite are available for the other data collection methods.

    End of the note.
Master Data, Customizing Settings, and Additional Financial Data

  • Delete All: The system deletes all data records within the selection. Then, the system transfers the collected data records to the target system.

  • Delete Uploaded Data: The system deletes all data within the selection whose combination of characteristics also appears in the data to be collected. Then, the system transfers the collected data records to the target system. However, data that lies within the selection but has no corresponding data in the data to be collected is not changed.

  • Overwrite: All collected data records are written to the target system. Any existing records with matching keys are overwritten. New records are created for collected data records that have no matching keys in the target system. All other settings remain unchanged.

  • No Modification: The system does not write data records that belong to objects that already exist. New records are created for data records that belong to objects that do not exist yet.

    Note Note

    All four update modes are available for the flexible upload method. Only the modes Delete All and Overwrite are available for the other data collection methods.

    End of the note.
Hierarchies and Attributes of Hierarchy Relationships

  • Delete All: First, the system deletes all existing hierarchy relationships within the selection. Then, the system transfers the collected data records to the target system.

  • Delete Uploaded Data: The system deletes all existing hierarchy relationships in the target system whose higher-level object appears in the collected data, regardless of whether the object is a higher-level node or lower-level node in the collected data. Then, the system transfers the collected data records to the target system.

  • Overwrite: The system transfers the collected hierarchies to the target system. Hierarchies that already exist in the target system are overwritten. New hierarchies are created if they do not exist in the target system.

  • No Modification: The same as for Overwrite.

See also:

Flexible Upload

Data Collection: Examples