Skip to Content

UOM Conversion BEx Query not working for 1 is to 1 material

Apr 24, 2017 at 08:16 AM


avatar image

Hi guys,

Just want to ask if there is an SNOTE related to this issue or what configuration I have missed? I applied UOM conversion using this doc:

It is working fine but the only problem I encountered was the conversion is NOT working for materials with 1 is to 1 conversion in UOM0MATE DSO.

Here is the output in analyzer.

As you can see, they all have conversion units in UOM0MATE thus, they should all be converted. Original value is CAS and I wanted to convert them to SC. But the last two (2) values where the conversion is 1 CAS = 1 SC did not convert. The unit remained to CAS instead of changing to SC.

Any idea guys about this scenario?

Thank you.

Loed Despuig

delete.jpg (59.9 kB)
delete.jpg (30.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

John Hawk Apr 24, 2017 at 10:19 PM

Hi Loed,

Please provide a screen shot of Quantity Conversion Type you used.

Please show all tabs.

John Hawk

Show 2 Share
10 |10000 characters needed characters left characters exceeded


Please see screens below.

Then in query designer I used the ZTAR_UOM conversion.

Any problem with my design mate or did I miss something?

Thank you.



Sorry, the screen shots were not sucessfully attached.