Skip to Content
0
Former Member
Mar 17, 2009 at 07:18 PM

COPA - Addition of Custom Key Figures

344 Views

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