Skip to Content

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

Query Problem

Hi Guys,

I have a query problem

In my Cube i have the following char / k.f

Plant, Material, Std Price, Qty.

P1, M1, 10, 50

P2, M1, 11, 10

P3, M1 12, 25

P1, M2, 27,5

P2 M2, 22,10




I have standard price as both attribute of 0mat_plant as well as k.f in the Cube.

Std Price is only valid if the query output contains Material.

I need to calculate the value_CKF = Std Price * Qty at the query level and display the result at Plant level.

The problem is if i drag material from the query output, the calculated k.f value_CKF is calculated wrong. i:e the std Price field is aggregated to the plant level and then it is doing the calculation

I would like the output as

Plant, Qty, Value_CKF in the query output.

P1, 37, xxxx



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