Display of cost elements in BEx Queries

98 Views

Hello,

I have a built a BEX query, in which the standard InfoObject 0COSTELMNT (cost element) is displayed in the rows. 0COSTELMNT is obviously compounded with 0CO_AREA (Controlling Area).

Now when I execute the query, the cost element is displayed in the report showing the combination of 0CO_AREA & 0COSTELMNT. For e.g. the report displays the cost element 100000 as "1000/100000" where 1000 is the controlling area & 100000 is the cost element.

However I would like to display JUST "100000" & NOT "1000/100000".

Does anybody know how to achieve this???

Strangely, I have queries running out of another cube using the same InfoObject 0COSTELMNT and in these queries the cost elements are displayed just the way I would like to see it i.e. "100000".

So I am a little confused why BW displays the same InfoObject differently in different queries.

Thank you in advance for your answers.

Raja