Former Member

### Qty conversion

In a sales order, the qty conversion that appears in the condition record is not found in material master Units of measure tab (stored in table MARM). How does the system make the calculation if the conversion factor is not available in table MARM?

I need to pull in the conversion factor in a report to then convert the price to the base unit of measure.

Regards,

10|10000 characters needed characters exceeded

• Former Member
Oct 27, 2009 at 04:32 AM

Hi,

Unit of measure works like this.

If you Sales UOM is different to Base UOM, you have to specify that in the Material Master under "Sales: sales org. 1" tab.

Base Unit of Measure and Sales unit can be entered there. You have to enter Sales unit only if Sales unit is differ from Base Unit.

If you enter that, system will pop up and ask you to enter the UOM conversion.

That conversion can be seen in the material master under Addition Data button option under Unit of Measure tab.

That Sales UOM will be the Condition UOM in the VK11 record. Then once you enter the material same will come as read only in to you sales order line item. (Pres F1 in UOM field in the SO /LI, you can see there is a field called Condition Unit)

Table

MEINH - Alternative Unit of Measure for Stockkeeping Unit

UMREZ - Numerator for Conversion to Base Units of Measure

UMREN - Denominator for conversion to base units of measure

LAENG - Length

BREIT - Width

HOEHE - Height

MEABM - Unit of Dimension for Length/Width/Height

VOLUM - Volume

VOLEH - Volume unit

BRGEW - Gross weight

GEWEI - Weight Unit

Best regards,

Anupa

10|10000 characters needed characters exceeded
• Former Member Former Member

Update on response

There are three options

1) MD_CONVERT_MATERIAL_UNIT converts the quantity and provides a ratio which can then be multiplied to the starting dollar.

w_bprice = ( w_umren / w_umrez ) * w_kbetr5.

Problem is that it truncates the ratio to 3 decimals.

2) MATERIAL_UNIT_CONVERSION converts the starting quantity to the target quantity. Take the starting quantity, divide by target quantity to get a ratio and then multiply against the price

w_bprice = ( w_kbetr5 * w_output1 ).

Problem is this only works for materials within the same dimension

3) Get the MARM table and do compute your own ratios and compute the end price.

w_bprice = ( i_marm-umren / i_marm-umrez ) * w_kbetr5.

Bela