ABAP code for unit conversion

[Former Member]

Hi all

I have a scenario where I need to convert unit of measure into lowest unit of measure. In detail we have material coming into BW from ECC and oracle. The same material is stored in kg in ECC and grams in Oracle. So in report it is showing different values in dollars for the same material because of different units.

Can any one please let me know how to identify which system is sending least unit of measure and after identifying how to convert into least unit of measure using ABAP code in transformations in BW.

[Former Member]

Hi Saathiyaa,

In BI/BW you have a place where you do a mapp or conversion. In this place, for each field you can create a conversion rule or enter an ABAP code. There would be your place.

Also, BI/BW has something called "Start Routine" and "End Routine", you could add a code in the start routine to check which is the unit of measure and maybe use a map table (from/to) to convert the unit of measures you need.

If you decide to create a map table to hold and be used for unite of measure conversion, keep in mind that somebody will have maintain it and keep it up to dated.

As you are dealing with two different systems I don't a Function Module would help you in this case.

Regards,

Ricardo.