Qty conversion

[Former Member]

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,

[Former Member]

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

[Former Member]

Anupa,

The reply is very helpful, but it doesn't answer the issue experienced. In the particular problem situation, the sales order is entered in KGS and the price unit is MTD. The base unit is TND and the Sales org 1 tab shows the Base Unit of Measure as TND.

The Additional data Unit of Measure tab does not have a conversion of MTD to TND or KGS to MTD. It does have a conversion of KGS to TND.

Regardless of the information above, for the report request, only the price condition is known which is something like $230.00 per MTD. The intent is to convert it to the price in base unit TND. No other information is available for report.

Any additional information is greatly appreciated.

Bela

[Former Member]

Hi,

If the the conversion from one UoM to UoM is a standard(of same dimensions) for example ton to kilogram. Then there is no need to maintain in the additional data in the material master. It looks like you have created new UoM.hence you need to maintain in additional data in material master for the unit of measure.

For e.g. In CUNI, click unit of measurement by selecting MASS, you will get the list of the UoM which are standard and Kg is SI unit of the dimension mass.apart from the list mentioned which the user can create based on the requirement and the conversion has to be maintained in the material master.

Hope this answers your query.

Regards,

Nithin

[Former Member]

To achieve the desired results, the function MATERIAL_UNIT_CONVERSION was used. The pricing UOM was converted to base UOM and then the appropriate price with base uom was determined.

I will also be looking into the MATERIAL_UNIT_CONVERSION to see exactly how it does the conversion and what tables and values are pulled.

Thanks to all for your assistance.

[Former Member]

Marking question answered

[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