Hi All,
I am currently working on getting COPA working in BW. I have all the help documentation and I am pulling data but I have one issue...'
We have setup a few Key Figure Schemes but we have some key figures that do not map to the standard ones in ERP, when creating the datasource in ERP it gives me these fields for Key Figure Sceme
Sales unit COPASLQTU
Sales quantity COPASLQTY
Revenue COPAREVEN
Cust. discnt COPACDSCN
Prod. Discount COPAPDSCN
Qty discount COPAQDSCN
Promotion COPASPROM
Cash discount COPACASHD
Rebates COPAREBAT
Misc. Sales Ded. COPAODSCN
SalesDeductions COPADISCT
Net sales COPANETSL
Sales Commission COPASCOMM
SDC from Sales COPASDIRS
Ant. Ship. Costs COPAFRGTC
Dir.Sales Costs COPADIRSL
Net revenue COPANETRV
Direct mat. costs COPADMATC
Variable Prod Costs COPAPRDCV
Total var. COGM COPACOGSV
CM I COPAMRGN1
Material Overhd Cst COPAMATOH
Fixed prod. costs COPAPRDCF
Total fixed COGM COPACOGSF
CM II COPAMRGN2
Total Variances COPAVRNCS
CM III COPAMRGN3
Marketing Overhead COPAOHMRK
Sales Overhead COPAOHSLS
Admin. Overhead COPAOHADM
R & D Overhead COPAOHRND
Logistical Overhead COPAOHLOG
Other Overhead Costs COPAOHOTH
Total Overhead Cst COPAOVHDC
Operating profit COPAPROFT
Ratio 1 COPAUSR01
Ratio 2 COPAUSR02
Key Figure 3 COPAUSR03
Key Figure 4 COPAUSR04
Key Figure 5 COPAUSR05
Key Figure 6 COPAUSR06
Key Figure 7 COPAUSR07
Key Figure 8 COPAUSR08
Key Figure 9 COPAUSR09
Total COGM COPACOGS
Our Key Figure Scheme has the following:
10 Gross Sales
15 Discounts
20 Allowances
25 Freight Out
26 Net Sales
30 Cost of Sales
35 Production Variances
40 Inventory Adjustment
45 Intra-comp trans exp
50 Yrd Expense
55 Gain/Loss on RM Dlvr
60 Unplanned Freight
100 Warranties
110 Rebates
120 Stat Pallet (ZFRC)
125 Manual Royalties
130 Royalties
135 GMCB Man Variances
140 Net Income
Is there a way to add new key figures with the names that we have in our key figure scheme? Am I missing an important step that will give me my key figure scheme instead of the one that comes up when creating the extractor?
Thank you!
Caroline