COPA and calculated key figures in R/3 (KER1) (Assign KF)

[Former Member]

Hello Everyone,

We are extracting COPA data. I see in transaction KER1 you have the elements that make up a key figure scheme. Then you can view what makes up the element (Net Sales for example) by clicking on Basic Formula.

Now, in SBIW (R/3 side), there is transaction 'Assign Key Figure'. Here you can assign 3 types:

1. Assignment - formula (from above in KER1)

2. Assignment - actual value field name

3. Assignment - function module.

I have read to be careful defining these and then selecting in the COPA datasource to bring over to BW. It states there could be problems.

My questions are:

1. What is the difference between Assignment formula and assigning the actual value field? Which one is better to use? What is the upside/downside of each one?

2. Why do I read to be careful with these calculated key figures and not being correct in BW? What does this mean? What problems?

I would like to define here and then select in my datasource because I wouldn't have to create a calculated key figure in BW query, meaning performance would be better because the value is already brought over from R/3 (calculated) and won't have to be each time the query is ran (calculated key figure).

Isn't it just easier to define in R/3 and replicate over than to have calculation in query?

Can anyone please help me?

Thanks so much, Colleen

[Former Member · Accepted solution]

Hi Colleen,

1. Assignment formula means that the value is calculated based on the key figure scheme when you extract the data, actual value field means that a value field from CO-PA is taken.

2. Especially with multiplications and divisions it might be that the results from formulas or function modules are incorrect because the calculation isn't based on the whole data. Note 457834 suggests using BW formulas instead.

3. I have very good results with uploading only the basic data and doing all the calculation in BI. Especially changes in the key figure scheme are much easier because you can simulate old and new scheme values without reloading the data.

Best regards

Dirk

[Former Member · Accepted solution]

Thanks Dirk.

Very clear explanation.