Examples: Update Mode for Automatic Data Collection

The following tables and figures illustrate how the update mode you choose affects the various types of data. The following types of data are illustrated:

Reported financial data

Documents

Consolidation unit

Item hierarchy

Each data type is broken down into:

Data that already exists in the target system

Data to be collected

Results of data collection for each update mode

Reported Financial Data

Data that already exists in the target system

Item	Partner	Value in Local Currency
1000	A	100
2000	B	200
3000	C	300

Data to be collected

Item	Partner	Value in Local Currency
1000	A	400
1000	B	500
2000	A	600
4000	A	800

Result after data collection with update mode Delete All

Item	Partner	Value in Local Currency
1000	A	400
1000	B	500
2000	A	600
2000	B	0
3000	C	0
4000	A	800

Result after data collection with update mode Delete Changed Data

Item	Partner	Value in Local Currency
1000	A	400
1000	B	500
2000	A	600
2000	B	0
3000	C	300
4000	A	800

Result after data collection with update mode Overwrite

Item	Partner	Value in Local Currency
1000	A	400
1000	B	500
2000	A	600
2000	B	200
3000	C	300
4000	A	800

Result after data collection with update mode No Modification

Item	Partner	Value in Local Currency
1000	A	100
2000	B	200
3000	C	300

Documents

Data that already exists in the target system

Doc. Number	Item	Posting Period	Value in LC	Reversing Document	Reversed Document	Inverting Document	Inverted Document
1001	1000	6	100			1003
1001	2000	6	-100			1003
1002	3000	6	200
1002	4000	6	-200
1003	1000	12	-100				1001
1003	2000	12	100				1001
1004	3000	12	400
1004	4000	12	-400

Data to be collected (input type Cumulative)

Item	Posting Period	Value in Local Currency
4000	12	500
5000	12	-500

Result after data collection with update modes Delete All and Delete Changed Data

Doc. Number	Item	Posting Period	Value in LC	Reversing Document	Reversed Document	Inverting Document	Inverted Document
1001	1000	6	100			1003
1001	2000	6	-100			1003
1002	3000	6	200
1002	4000	6	-200
1003	1000	12	-100				1001
1003	2000	12	100				1001
1004	3000	12	400	1005
1004	4000	12	-400	1005
1005	3000	12	-400		1004
1005	4000	12	400		1004
1006	3000	12	-200
1006	4000	12	200
1007	4000	12	500
1007	5000	12	-500

Result after data collection with update modes Overwrite and No Modification

Doc. Number	Item	Posting Period	Value in LC	Reversing Document	Reversed Document	Inverting Document	Inverted Document
1001	1000	6	100			1003
1001	2000	6	-100			1003
1002	3000	6	200
1002	4000	6	-200
1003	1000	12	-100				1001
1003	2000	12	100				1001
1004	3000	12	400
1004	4000	12	-400
1005	3000	12	-600
1005	4000	12	600
1006	4000	12	500
1006	5000	12	-500

Consolidation Unit

Data that already exists in the target system

Company	Description	Version	Year of First Consolidation	Period of First Consolidation	Tax Rate
C1000	Old 1	100	2003	12	8
C1000	Old 1	200	2004	12	5
C3000	Old 3	200	2005	12	10

Data to be collected

Company	Description	Version	Year of First Consolidation	Period of First Consolidation	Tax Rate
C1000	New 1	100	2004	12	9
C2000	New 2	100	2005	12	15

Result after data collection with update mode Delete All

Company	Description	Version	Year of First Consolidation	Period of First Consolidation	Tax Rate
C1000	New 1	100	2004	12	9
C2000	New 2	100	2005	12	15

Result after data collection with update mode Delete Changed Data

Company	Description	Version	Year of First Consolidation	Period of First Consolidation	Tax Rate
C1000	New 1	100	2004	12	9
C2000	New 2	100	2005	12	15
C3000	Old 3	200	2005	12	10

Result after data collection with update mode Overwrite

Company	Description	Version	Year of First Consolidation	Period of First Consolidation	Tax Rate
C1000	New 1	100	2003	12	9
C1000	New 1	200	2004	12	5
C2000	New 2	100	2005	12	15
C3000	Old 3	200	2005	12	10

Result after data collection with update mode No Modification

Company	Description	Version	Year of First Consolidation	Period of First Consolidation	Tax Rate
C1000	Old 1	100	2003	12	8
C1000	Old 1	200	2004	12	5
C3000	Old 3	200	2005	12	10
C2000	New 2	100	2005	12	15

Item hierarchy

This graphic is explained in the accompanying text.

Data that already exists in the target system

Data to be collected

Hierarchy	Text Node	Item	From	To
H1		1000
		1000	1100
		1000	1200
H1		2000
		2000	2100
		2000	2200

This graphic is explained in the accompanying text.

Result after data collection with update mode Delete All

This graphic is explained in the accompanying text.

Result after data collection with update mode Delete Changed Data

This graphic is explained in the accompanying text.

Result after data collection with update modes Overwrite and No Modification