Skip to Content
0
Former Member
Jan 16, 2009 at 12:47 PM

Value in MultiProvider Different from Value in Query/Workbook

52 Views

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