Skip to Content
avatar image
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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    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

    Add comment
    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