Data Collection: Examples (SAP Library - Business Consolidation (SEM-BCS))

Data Collection: Examples

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 collected

· Results of data collection for each update mode

Reported Financial Data

Existing Data in Target System

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

Data 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 Ones

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

Existing Data in Target System

Doc. No.	Item	Posting Period	Value in Local Currency	Reversing Document	Reversed Document	Inverting Document	Inverted Document
1001	1000	6	100			1003

Data 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 Ones

Doc. No.	Item	Posting Period	Value in Local Currency	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. No.	Item	Posting Period	Value in Local Currency	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

Existing Data in 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 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 Ones

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

Existing Data in Target System

This graphic is explained in the accompanying text

Data Collected

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

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 Ones

This graphic is explained in the accompanying text

Result After Data Collection with Update Modes Overwrite and No Modification

This graphic is explained in the accompanying text