UoM Conversion in HANA

[neelesh_jain3]

As per the current HANA offering, Unit of Measurement conversion is not supported, then what will be the best way to implement UoM conversion?

-Neelesh

[richard_bremer · Accepted solution]

Hi Neelesh,

Unit of Measure conversion can in many places be implemented rather easily by introducing a mapping table plus simple calculated key figures. The very generic way of UoM conversion offered in the SAP (ABAP) standard is highly compley because of all the fun things you can do there (convert from table spoons to six packs or pallettes).

In most cases, either conversions between the SI system (aka metric system) and the imperial system are needed (pints to liters, meters to feet), or sometimes conversions such as pieces to boxes. Here the math is trivial and it can be easily expressed as calculated key figures. It is a bit trickier to have the target UoM selectable at query run time. In simple scenarios this should be achievable using variables in calculation views as far as I can see.

Kind regards,

Richard

--

Dr. Richard Bremer

Customer Solution Adoption (CSA), SAP AG

[neelesh_jain3 · Accepted solution]

Thanks Richard.

I will try to setup and check with a simple scenario.

Do you have any idea whether it will be available in SPS04? (Kind of functionality available in BW)

- Neelesh

[former_member198127]

We foung some information about currency conversion and UoM conversion in the document http://help.sap.com/hana/hana_dev_sqlscript_en.pdf, ,Section-7.2.11.

Is it the same thing discussed here?

[Former Member]

Does not work.. get the error.. T006D not found.. we have only T006 and T006A

[Former Member]

Hi Anbu,

If you would like to use HANA offered UoM conversion then its mandatory to have T006D as well as shown in below screen shot from HANA developer guide.

If not its suggested to follow the approach suggested by Richard as given above , by using a table which has conversion rates in it or by using calculated columns with few functions.