Get Standard price in Hard currency

[Former Member]

Hello All,

I have a custom report which fetches the standard price of the material in company code currency. I have to add a field with the value of standard price in hard currency. Where can I find this value ?

Currently, when I go to MM03 transaction, I can see both of them in accounting tab but I havent been able to find a table to get that value.

Any tips ?

Thanks

Shubhendu

[Anna_Strokova]

I know that this question is 9 years old, but in case somebody is looking as I was looking, I'm leaving this comment.

In MBEW I find ProdCostEst.No. MBEW-KALN1 + Year current period LFGJA + Current period LFMON

and find record in table CKMLCR where KALNR = MBEW-KALN1, BDATJ = MBEW-LFGJA, POPER = MBEW-LFMON and CURTP = "40".  

[Anna_Strokova]

Another good advice:
https://community.sap.com/t5/enterprise-resource-planning-q-a/material-price-and-material-ledger/qaq...

[Anna_Strokova]

Another good advice:https://community.sap.com/t5/enterprise-resource-planning-q-a/material-price-and-material-ledger/qaq...

[RaymondGiuseppi]

Check with CKMLPR price in material ledger and similar tables, AFAIK Amounts/Prices in MBEW refer to T001-WAERS company code currency code.

Did you try F1 on the field to identify its origin from database?

Regards,

Raymond

[sundaramoorthy_ramalingam]

You can check with MBEW table.

Thanks,

Sundar.