Skip to Content
avatar image
Former Member

maintain uom conversion by customer and material

Folks,

Is it possible to maintain uom conversion by customer AND material.

Here's a scenario -

For material-A,

Cust-A uses uom BOX and is defined in SAP as PACK;

Cust-B uses uom BOX and is defined in SAP as CASE;

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 21, 2010 at 04:26 AM

    Maintain all the Alternative UoM in Additional Data in Material master (MM02).

    And use Customer Material Information Record (VD51) for customer material combination

    OR

    For alternative method, check following link:

    Thanks & Regards

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2010 at 11:25 AM

    Dear j wong,

    Please note the following :

    1. Go to MM02 --> and in Additional Data tab , here you maintain all the required Unit of Measure .

    2. In Material Master --> Sales Org 1 tab , we have 2 Unit of measure A. Base unit of measure B. Sales Unit . In sales Unit you maintain the required unit for example Cases(CS) the while creating the order the system will automatically pick up Cases . In case you want to change to Pack we can do the same .

    Please try the above and let me know .It should come through.

    Thanks and regards

    Veera

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2010 at 03:17 PM

    J wong,

    You have to do what has been suggested already u2013 maintain the appropriate alternate units of measure and the customer-material info records (CMIR), plus a little bit of enhancement to the standard system to really make it work automatically.

    If you have confidence that a customer will consistently order a material in a known unit of measure, then you can maintain a conversion factor in the CMIR to convert it to the sales unit and EDI1 price that you want on the sales order item.

    Our enhancement is limited to EDI orders, and invokes a user exit called by the ORDE inbound IDOC process code. The user exit is Function Module EXIT_SAPLVEDA_001, which is contained in CMOD enhancement package is VEDA0001.

    We use the Search Term field in the CMIR for the conversion factor. The user exit looks up the saved value in the search term. When found, the value gives a factor and a resulting UOM for the sales order item. Our factors work something like this: u201C/006CASu201D will divide the provided quantity by six and set CAS as the UOM. It is useful for customers that want to order in u201Ceachesu201D when we want to process orders in cases.

    There is another user exit on the outbound IDoc side for ship notifications and invoices that reverses the conversion.

    The enhancement works well provided the customer orders consistently in a single unit of measure per item.

    Regards,

    Ken

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      J,

      u201CEnhancementu201D may have been a poor choice of words. This was just customer-exit VEDA0001 under CMOD, not an enhancement package.

      Instead of a z-table our concept uses the factor that we maintain in the Search Term field (KNMT-SORTL) on the CMIR to convert quantity and customer-expected (EDI1) unit price. The actual unit of measure sent by the customer is not relevant u2013 we assume that we know what unit the customer orders so we just apply the conversion math and load the item in the sales order with our UOM of choice.

      A z-table like you describe would provide for a more robust conversion system. It would allow customers to order in more than one unit of measure for a material.

      Regards,

      Ken