Control of Data Collection Using Update
Mode 
Use
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 collected affects the scope of the selected data as well as the data's composition:
· Reported financial data
The system
uses all of the following characteristics for selecting the data to be
changed:
(a) The characteristics with the roles version, group
currency, fiscal year, period, and consolidation unit
(b) The independent compound characteristics that belong to
each of the above
characteristics
(c) 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 system
uses all of the following characteristics for selecting the data to be
changed:
(a) The characteristics with the roles version, group
currency, fiscal year, period, and investee
unit
(b) The independent compound characteristics that belong to
each of the above
characteristics
(c) 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 system
uses all of the following characteristics for selecting the data to be
changed:
(a) The characteristics with the roles version, group
currency, fiscal year, period, and consolidation
unit
(b) The independent compound characteristics that belong to
each of the above
characteristics
(c) 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 being collected. For more details about
these characteristics, see the properties of each characteristic in the 
Administrator
Workbench of SAP Business Information Warehouse (SAP BW).
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.
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.
Reported Financial Data
· Delete All: All data within the selection is reset to zero.
· Delete Changed Ones: The system resets to zero all data within the selection whose combination of characteristics also appears in the collected data. However, data that lies within the selection but has no corresponding data in the collected data is not changed.
· Overwrite: Existing data is overwritten with the imported data that has the same combination of characteristics. Data without any corresponding collected data remains unchanged.
· No Modification: All data in the target system remains unchanged.
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.
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.
· Delete Changed Ones: The same as 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 Overwrite.
The system always posts documents that are imported from a data file.
Whether data collection deletes or reverses matching 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.
Master Data, Customizing Settings, Additional Financial Data
· Delete All: The system deletes all data records within the selection. Then, the system transfers the collected data records into the target system.
·
Delete Changed Ones: The system deletes all data within the selection
whose combination of characteristics also appears in the collected data. Then,
the system transfers the collected data records into the target system.
However, data that lies within the selection but has no corresponding data in
the collected data 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.
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.
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 into the target system.
· Delete Changed Ones: 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- or lower-level node in the collected data. Then, the system transfers the collected data records into the target system.
· Overwrite: The system transfers the collected hierarchies into 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 Overwrite.
See also: