MBEW Material valuation but in group currency

[Former Member]

Hi,

Is there any table showing the inventory values/prices in group currency rather company code currency?

I know CKMLCR but the thing is that if a material is not valuated (no costing run for that material) at the selected period then the inventory price does not show in the table for the period even there is stock for mentioned material.

But in MBEW and also S_P99_41000062 it retrieves the inventory value with the latest PUP (e.g. maybe last costing run in 3 months ago).

So I wonder if there is such a table to use?

Thanks in advance!

[Former Member]

Jonathan,

I am not aware of a table that holds converted currency information.  We had a custom report written with selections for report currency, "which" exchange rated an the "valid on" date.

It solved a lot of problems.

[Former Member]

Hello Althea,

Thanks for your answer.

Could you know how you built up that kind of report?

I mean from which tables should I see "valid on" and "exchange rate" fields?

And is it going to lead moving average price in different currency?

Regards,

Jonathan

[former_member201529]

Dear Jonathan,

Kindly check the same in CXV1 transaction.

Regards,

Karna J

[Former Member]

Hello Jayapal,

Thanks for the answer!

I could not manage to use this transaction but I do not want to change anything on the system either. So this looks to me a kind of consolidation thing which seems not available for our erp.

Anyway I'm searching a kind of display table that can be used in customizing reports such as mbew, ckmlcr.

BR

Jonathan

[former_member201529]

Dear Jonathan,

Kindly have a look for below note.

1394183 - RKE_EXIT for accessing data of the material ledger

Also check the same in SAPLCKMD.

Regards,

Karna J