maintain uom conversion by customer and material

[Former Member]

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.

[former_member1115366]

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

[Former Member]

Ken,

What enhancement did you do, did you have to create a z-table to store customer-material uom conversion?

Problem is a customer material uom of PACK is intepreted as BOX and another customer of same material uom of CASE is intepreted as BOX.

We were planning to create a z-table with these fields and use the user-exits you mentioned.

customer

material

customer-uom

sap-uom

denominator

numerator

Thanks,

Jack

[former_member1115366]

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

[Former Member]

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

[jpfriends079]

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