Page 17 - SAP Universal Allocation

Example: Top-Down Distribute Cost by Referencing Revenue Data II
Costs on high level dimension: Product Group
Result: Costs after Top-Down Distribution
CO Area
CompCode
ProfitCenter
BusArea
Account
ProdGrp
Product
Amount
A000 1010
PC_0001 BA001
400000 01
3000
A000 1010
PC_0001 BA001
400001 01
1000
A000 1010
PC_0001 BA001
400001 02
2000
A000 1010
PC_0001 BA001
400002 02
3000
A000 1010
PC_0001 BA001
400003 03
5000
CO Area
CompCode
Profit Center
BusArea
Account
ProdGrp
Product
Amount
A000 1010
PC_0001 BA001 400000
01
PROD001
1050
A000 1010
PC_0001 BA001 400000
01
PROD002
450
A000 1010
PC_0001 BA001 400000
01
PROD003
600
A000 1010
PC_0001 BA001 400000
01
PROD004
900
A000 1010
PC_0001 BA001 400001
01
PROD001
350
A000 1010
PC_0001 BA001 400001
01
PROD002
150
A000 1010
PC_0001 BA001 400001
01
PROD003
200
A000 1010
PC_0001 BA001 400001
01
PROD004
300
A000 1010
PC_0001 BA001 400001
02
PROD005
1400
A000 1010
PC_0001 BA001 400001
02
PROD006
600
A000 1010
PC_0001 BA001 400002
02
PROD005
2100
A000 1010
PC_0001 BA001 400002
02
PROD006
900
A000 1010
PC_0001 BA001 800000
03
PROD007
750
A000 1010
PC_0001 BA001 800000
03
PROD008
3000
A000 1010
PC_0001 BA001 800000
03
PROD009
1250
Distribute
Revenues on detailed dimension: Product Group + Product
CO Area
CompCode
ProfitCenter
BusArea
Account
ProdGrp
Product
Amount
A000 1010 PC_0001 BA001 800000
01 01
PROD001 PROD002
7000
3000
4000
A000 1010 PC_0001 BA001 800000
A000 1010 PC_0001 BA001 800000
01
PROD003
A000 1010 PC_0001 BA001 800000
01
PROD004
6000
A000 1010 PC_0001 BA001 800000
02 02
PROD005 PROD006
7000 3000
A000 1010 PC_0001 BA001 800000
A000 1010 PC_0001 BA001 800000
03 03
PROD007 PROD008
1500
6000
2500
A000 1010 PC_0001 BA001 800000
A000 1010 PC_0001 BA001 800000
03
PROD009
Costs by Product
4000
3000 Additional reports 2000
Margin by Product
1 0.8 0.6 0.4 0.2
after Top-Down Distribution
1000 00
© 2018 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC
17
Reference