Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Disable automatic currency aggregation of key figures in bex query?

Dear Gurus,

we are facing an issue, where we receive value in different transactional currencies for a single company code.

Those records are automatically aggregated by the key figure in our query.

is it possible to disable the Default currency aggregatiob in case that different currencies are used?

As an example this is our view in the Query:

Comp CodeAccount Value in Transactional Currency
12001122330000*
12002211220000-152.000 USD

we want to get rid of this "*"

This is the view within the InfoProvider in SAP BW

Comp CodeAccountValueTransactional Currency Key
12001122330000100.000CAD
1200112233000050.000USD
12002211220000-152.000USD

Our query should like this

Comp CodeAccountValue in Transactional Currency
12001122330000100.000 CAD
1200112233000050.000 USD
12002211220000-152.000 USD

In addition it would be nice if the same logic could be applied to "result rows", but that is only nice to have.

Hope you guys can help me - thanks in advance.

Kind regards

Eric

Tags:
Former Member
Former Member replied

Hi Greger,

if the 'transaction currency key' is unit, then add it to rows, this wont allow same account of difference currencies to get summarized .

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question