Missing Measurement in BEX: Weighted Average Unit Price (Variance)

[Former Member]

Hi All,

I found issue in Savings Analysis Report that the value of Weighted Average Unit Price (Global Curr/Global Unit) (Variance) is 0.

When I investigate this in BEX Query Designer, I couldn't find this measurement in Query: Spend Analysis Final (0ASA_MP01_Q1002) even though it's displayed in SPM GUI (Java).

I couldn't find the definition of this measure in Note: 1915678 - SPM Key Measure Definition

Anyone of you know the definition of this measurement? What's the formula? Is it using standard aggregation/exception aggregation?

If it's exception aggregation, could you provide the detail?

Thank you

Satria

[former_member257798]

Hi Satria,

I did find it in BEx.

Weighted Average PO Unit Price (Global Curr/Global Unit)

0ASA_MP01_CK106A

Aggregation-Use Standard Aggregation

[0XSAPOA]/[0XSAPOQ]

Kind Regards,

John

[Former Member]

Hi John,

Thank you for your prompt reply.

The one that you mention in here is different with what I need.

Weighted Average PO Unit Price (Global Curr/Global Unit) - [0ASA_MP01_CK106A] --> I know this one exist on BEX, I can see it

Weighted Average PO Unit Price (Global Curr/Global Unit) (Variance) ---> this one not exist on BEX but exist on SPM UI. I think the formula contain [0XSAPRVAR] Purchase Price Variance Amount.

Do you know the formula?

Thank you

Satria