Skip to Content
0
Former Member
Nov 15, 2012 at 07:51 AM

Help with BEx query substituting CoCode with Cost Centre (FIGL)

17 Views

Hi

I have a Bex query running of FIGL_C10. My budgets are stored in 0CCA_C02.

When I build my query I need to have Company code as a selection parameter.

0CCA_C02 does not store company code - it only uses cost centre - which is in essence my company code. I am not able to filter though on cost centre - it has to be on Company code.

What I would like to do is to replace the value of company code with the value of my cost centre - without having to modify the 0CCA_C02 cube (mainly because I have not got the ability to do so).

I am so lost here, so any help would be hugely appreciated.

Thank you