Material price and material ledger

[Former Member]

Hi all

We have activated Material Ledger. I like to dowload all the three currency prices for the materials. How is it possible?

In MBEW only the company code currency is available.

Also u cannot use the exchange rate as it gives wrong data.

Regards

JOE

[Former Member · Accepted solution]

This is a 2-step process.

For the material / plant combination, read table CKMLHD and get the Cost Estimate Number.

Now read table CKMLCR using this Cost Estimate Number and you should see the all three prices with a different currency key.

Hope this helps.

Cheers.

[Former Member]

Hi Ram

Thanks for your reply.

We have a better solution for this.

We can use function module CKMS_MATERIAL_PRICES_GET to get the price.

Welcome your comments.

Cheers

JOE