02-25-2015 9:10 AM
Hello Gurus,
I have requirement that convert the currency based on Unit of Measurement, is there any Function Module for this conversion. We have FM convert_local_currency but it is based on currency key, I need based on Unit of Measurement.
I have searched for this but i didnt find any.
Thanks and Regards,
Muralikrishna Peravali
02-25-2015 9:17 AM
Hello,
Question is not very clear for me, can you explain the context?
Because there shouldn't be any ling between currency and unit of measure.
From my point of view, currency is used for an amount and unit of measurement is used for quantity.
02-25-2015 9:24 AM
Hello Brice,
Actually the requirement is, we have PO and Outline Agreement(OA). I need to display PO netpr when PO order price UoM and OA order price UoM are different then I need to convert the NETPR value according to OA UoM and display in report.
Thanks and Regards,
Muralikrishna
02-25-2015 9:33 AM
Hi Murali,
You want to convert currency based on UOM. Please correct me if I am wrong.
For this requirement, I dont think any FM / Class available.
I would recommend you to write your own function module in which you can call FM convert_local_currency based on UOM.
I hope already there is some mapping for UOM and Currency, if that is the case use that mapping table to find out target currency.
Thanks and Regards,
Chandra
02-25-2015 9:35 AM
Ok, now I understand.
I don't know if there is such function (I don't think it will be easy to find), I think you will have to code it by yourself using cross multiplication.
You may be using conversion factors between units, following function may be helpful:
MM_ARRANG_QUANTITY_CONVERSION
02-25-2015 10:09 AM
Hi Murali,
FM CONVERSION_FACTOR_GET may help u to get conversion factor between two units.
Then multiply the amount with conversion factor.
Regards
Sreekanth
02-25-2015 10:27 AM
Hi Sreekanth,
What will be the factor field in the function module?
Regards,
Muralikrishna
02-25-2015 10:32 AM
02-25-2015 10:30 AM
Hi Muralikrishna ,
Try FM CF_UT_UNIT_CONVERSION this might help you.
Thanks & Regards.
Anand N Parulekar
02-25-2015 2:55 PM
03-13-2015 3:55 AM
Hi All,
Thank you for your valuable suggestion. As I was busy with work I didnt respond to your replies.
I have solved this by my self, by using the formula which given by Functional consultant.
Thank you for all your support. Am closing this thread.
Regards,
Muralikrishna Peravali