How to extract Std Price from MBEW monthly ?

[Former Member]

Hi

We have 5 cubes in our system

1.Material Stocks

2.Forecast

3.PSI planned order

4.CO-PA

5.Purchasing data

MBEW table in R/3 has the std price.We need

Total Price = Volume*Std price(or previous price) for one report

The problem is how do i extract the exact std price and that too month wise?

The catch here is that based on the last price changed date for MBEW table if Transaction date is less than the changed date(when the std price is changed) then we would use the previous price,If the transaction date is equal to or after the changed date then we use the standard price.E.g If changed date is 1st Oct(10/01) and if transaction date is before 10/01 then we use previous price say 2000, but if the transaction date is on 10/01 or after 10/01 then we want to use the std price which is in MBEW table

How do we do this?Please help

Message was edited by: Jackofalltrades

[p_geurts]

To extract volumes and prices from MBEW you can use the standard extractors 0CO_PC_ACT_02 and 0CO_PC_ACT_05.

Regards,

Peter

[Former Member]

I cannot use those 2 extractors because it has fiscal year and I need monthly wise price.Also i want to take into consideration future months.

Any idea how can i get monthly std price instead of fiscal year from MBEW?

Thanks

[Former Member]

Any idea how can i get monthly std price instead of fiscal year from MBEW?

[Former Member]

Hi dear,

sometimes ago we built a custom extractor...

[Former Member]

hi dear

Custom extractors will work fine but i need month wise price instead of fiscal price.MBEW has FISCAL YEAR price and i want MONTHLY price

How do i get it

[Former Member]

MBEWH (but you cannot manage all the previous periods).