Mapping COPA fields

[Former Member]

Dear BW gurus,

I have a list of chars and KF's from R/3 that were configured for COPA. No i want to map these to InfoObjects in BW for the COPA InfoCube. Is there any documentation online where i could go and check the best Infoobjects to use for these chars and KF's for COPA? Thanks in advance for your time and help.

Raj

[Former Member · Accepted solution]

Raj

Please let us know the exactly what key figures you are looking for. For example you could use some of the following Key figures in BW side

InfoObject

Description

Data element

Field in transfer structure

Source

0COPASLQTY

Sales quantity

COPASLQTY

COPASLQTY

Key figure scheme

0COPAREVEN

Revenue

COPAREVEN

COPAREVEN

Key figure scheme

0CUST_DSCNT

Customer discount

COPACDSCN

COPACDSCN

Key figure scheme

0PROD_DSCNT

Material discount

COPAPDSCN

COPAPDSCN

Key figure scheme

0QTY_DSCNT

Quantity discount

COPAQDSCN

COPAQDSCN

Key figure scheme

0COPASPROM

Promotion

COPASPROM

COPASPROM

Key figure scheme

0CASH_DSCNT

Cash discount

COPACASHD

COPACASHD

Key figure scheme

0VOL_REBATE

Rebate

COPAREBAT

COPAREBAT

Key figure scheme

0COPAODSCNT

Miscellaneous sales deductions

COPAODSCN

COPAODSCN

Key figure scheme

0COPADISCT

Total sales deductions

COPADISCT

COPADISCT

Key figure scheme

0COPANETSL

Net sales

COPANETSL

COPANETSL

Key figure scheme

0SALES_CMSN

Sales commission

COPASCOMM

COPASCOMM

Key figure scheme

0SPCDSLS_CS

Special direct sales costs

COPASDIRS

COPASDIRS

Key figure scheme

0ACCRDFR_CS

Accrued freight costs

COPAFRGTC

COPAFRGTC

Key figure scheme

0COPADIRSL

Total direct sales costs

COPADIRSL

COPADIRSL

Key figure scheme

0COPANETRV

Net revenue

COPANETRV

COPANETRV

Key figure scheme

0DIRMAT_CS

Direct material costs

COPADMATC

COPADMATC

Key figure scheme

0VARPROD_CS

Variable production costs

COPAPRDCV

COPAPRDCV

Key figure scheme

0COPACOGSV

Total variable costs of goods manufactured

COPACOGSV

COPACOGSV

Key figure scheme

0COPAMRGN1

Contribution margin I

COPAMRGN1

COPAMRGN1

Key figure scheme

0MATOVHD

Material overhead

COPAMATOH

COPAMATOH

Key figure scheme

0FIXPROD_CS

Fixed production costs

COPAPRDCF

COPAPRDCF

Key figure scheme

0COPACOGSF

Total fixed costs of goods manufactured

COPACOGSF

COPACOGSF

Key figure scheme

0COPAMRGN2

Contribution margin II

COPAMRGN2

COPAMRGN2

Key figure scheme

0COPAVRNCS

Total variances

COPAVRNCS

COPAVRNCS

Key figure scheme

0COPAMRGN3

Contribution margin III

COPAMRGN3

COPAMRGN3

Key figure scheme

0SALES_CS

Sales costs

COPAOHSLS

COPAOHSLS

Key figure scheme

0ADMNSTRTN

Administration

COPAOHADM

COPAOHADM

Key figure scheme

0MARKETING

Marketing

COPAOHMRK

COPAOHMRK

Key figure scheme

0RSRCH_DEV

Research & Development

COPAOHRND

COPAOHRND

Key figure scheme

0LOGISTICS

Logistics

COPAOHLOG

COPAOHLOG

Key figure scheme

0OTHER_OVHD

Miscellaneous overhead

COPAOHOTH

COPAOHOTH

Key figure scheme

0COPAOVHDC

Total overhead

COPAOVHDC

COPAOVHDC

Key figure scheme

0COPAPROFT

Operating profit

COPAPROFT

COPAPROFT

Key figure scheme

Hope this helps

Thnaks

Sat

[Former Member]

Thanks for the prompt response guys. The problem is solved.

Raj

[former_member188975]

Hi Raj,

There is a document that explains very well how to set up the COPA extraction. When assigning the COPA datasource, the InfoSource in 'generated' in BW and all the Key Figures are also created by the system. Like for field G_AVVV0, the key figure 0G_AVVV0 will be created in the InfoSource. You can then use the InfoSource as the template when creating your ODS or cube. The system is able to propose majority of the chars that should map to the fields, so that should not be a problem either.

Hope this helps...

[former_member188975]

Here is a link to the doc:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/how to set up connection co-pa - extraction