Pharma -Different SKUs for same commercial product - MRP

[former_member1198835]

Hello Team,

I hope you are well.

I would like to understand how SAP Hana could handle the situation below :

• Product SKU : Aspirin 3mg
• The product can be produced using raw material from Supplier A or B
• The goods can be sold to :
• Customer 1 who will accept Aspirin produced with Raw Material from Supplier A or B.
• Customer 2 who will accept Aspirin produced with Raw Material from Supplier A only. In the future, this customer may accept the Raw material from Supplier B.

In our current ERP System (which is not SAP), we have created 2 SKUs to handle those cases:

- SKU 1 : Aspirin [Supplier A]

- SKU 2 : Aspirin [Supplier B]

With this method we are sure that Aspirin [Supplier B] won't be sold to customer 2.

Nevertheless this creates some issues to run MRP properly at the plant of Customer 1.

Indeed, each SKU is treated separately.

In a simplified example, we have the situation below :

=> Customer 1 can accept both SKU but MRP will perform the calculations for each SKU instead of aggregating the data (Stock & Demand) of both. Therefore irrelevant suggestion will be given by MRP. Eg : Aspirin [Supplier A], there no stock and a demand, therefore MRP will suggest Purchase Requisition whereas it is not needed as we have enough stock of Aspirin [Supplier B].

How do you get MRP running properly in this situation ?

Also, is it possible to maintain a link between those 2 SKUs in the Master Data ? If yes, how ? In our Current ERP, we can link SKUs under the same Master SKU.

Thank you very much for your feedback,

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

[Sycntegral]

in this case I would create alternative Bill Of Materials. Also should be make to order sales orders to each customer separately with a specific alternative BOM with specific raw material exploded. I would see more raw material MRP run issue more severe than the sales SKU. Interested to check if the alternative BOM could handle two different procurements for the same raw material from two different suppliers

[p391977]

If you use the material listing & material determination functionality you could solve the above issue.

Material listing is a functionality where in you are listing all the allowed materials for a particular customer.

Material determination is an option from which you can swap the materials if stock of one of the material is not existing.

Regards,

Radheshyam P.