Hi SAP Gurus,
I would like to ask for some help with an issue that I am facing. Values for a specific key figure in found in the multiprovider is being multiplied by 100 compared to the values in the query/workbook. I tried creating a new query but the values are the same. The values are only changed for a specific plant within the report. Maybe, an illustration of the issue would be easier to understand.
When I display data through the multiprovider:
Sales Order
Line Item
Plant
Key Figure
Currency
0001
01
1234
28.80
JPY
0002
01
1234
12.13
JPY
0003
01
8910
14.50
USD
0004
01
8910
12.01
USD
When I display data through the query:
Sales Order
Line Item
Plant
Key Figure
Currency
0001
01
1234
2880.00
JPY
0002
01
1234
1213.00
JPY
0003
01
8910
14.50
USD
0004
01
8910
12.01
USD
The Key Figure in the Query has not been calculated in whatever way but was just taken from the KF list in the Query Designer. I can't find any thing that would multiply the values by 100 from the multiprovider to the query. The KF is also not a virtual one but a computed transactionally. Also, the KF is not converted to the currency in the report.
How can this be done? Is there any configuration that I am missing?
I hope you can help me with this, I have been looking for the solution for this for 2 weeks already and have asked other consultants. I hope someone can help me.
Thank you,
Chino Datu
Edited by: Chino Datu on Jan 16, 2009 1:48 PM