Active Ingredients Management And Material Quantity Calculation in Process Industry
Purpose of this document is to share how Active Ingredient Management is handled in SAP and more specifically in process industry scenario. Document will also illustrate how we can leverage Standard SAP functionalities of Bach specific unit of measure and Material quantity calculation to achieve one of the most complex business scenario of pharma industry.
Some of the key highlights of this two functionalities are,
Active ingredient management (Batch Specific UoM)
- Provides ability to maintain theoretical potency per material.
- Provides ability to maintain actual potency per material batch.
- Provides ability to automatically ‘exponentially’ convert material batch specific dimensional units of measure to doses based on ‘potency’ of the batch.
- Provides enterprise wide material batch inventory visibility in doses and in dimensional units
- Process order, provides ability to automatically determine active ingredient batches based on sort rule (e.g. FEFO, FIFO etc.), component requirement quantity needs to automatically adjust based on potency of the batch.
Material Quantity Calculation
- Provides ability to execute Quantity balancing to automatically adjust excipient (filler ) material quantity requirements, based on quantity picked of active ingredient material batch.
In this document i am not going into details like prerequisites and master data , as lot of information is available online, the main purpose of this document is to just give you a demo how this functionality works in a scenario where Process order quantity adjusted automatically based on quantity picked of a batch of Active pharma Ingredient.
- Batch size is not fix in dry powder injection products
- BOM components are mostly limited to one raw material only,
- There is no major processing involved. Raw Material is filled directly into Glass vial in specific quantity (e.g. 1 gram, 2 gram etc) under control environment,
Now lets quickly move forward and see how this two functionalities can help in this kind of product scenario.
Component details, required quantity of a Active ingredients is Maintained in unit KAI, which is a Batch specific unit of Measure.
Performing Manual Batch determination of a Active Ingredient.
Instead of required quantity of 92.5 (KAI), i have picked total available quantity, which is 119.9 KAI in KG this quantity will be different which we will see later in this document.
Now instead of 92.5 KAI, i have picked full batch quantity, which is 119.900 KAI, hence my order quantity should also change accordingly, here material quantity calculation will help to change this Process order quantity automatically.
Now go to Material quantity calculation tab, i have assign a formula to calculate the product quantity, based on the raw material quantity picked. for more information on how to define formula refer below links.
On pressing calculate product qty, process order quantity will change automatically.
Now Let us understand how Active ingredient management (Batch Specific unit of measure) has helped in this scenario
In above case raw material quantity picked was 119.900 KAI, which is in Batch specific unit of measure, however quantity in Base unit (KG ) is higher than 119.900, as its batch potency is 92.9585 % only, which means if you pick 1 KG from this batch then you will get only 0.9296 KG of pure active material.
Quantity conversion between KG and KAI
Here Potency of a batch is 92.9585%, hence instead of 1 GM i have to fill 1.0757 GM in a Vial so that at the time of usage, patient will get 1 GM 100% potent drug.
In Above scenario i have demonstrated a scenario where Product Quantity (process Order quantity ) is changed automatically with help of Material Quantity Calculation and Batch Specific Unit Of measure.You can use this functionality to,
- Auto adjust required quantity of other BOM component in a process order, based on the quantity picked of a Active Ingredient, in pharma this component is mostly referred as filler material.
- To auto calculate operation/phase quantity of a process order, depend upon quantity picked of a specific material.
For more information on how to define formula refer below links.
Kindly share your feedback/inputs to make this document for useful.
Nicely explained the functionality ..!!
Thank you for sharing ... !!
Thanks for sharing..
Good explanation (y) keep sharing
Dear Dhaval Choksi,
Please help me with the below scenario,
If I have an alternative item group for API as well as excipients, how do I handle MQC.
Hi, Thank you for sharing, very useful functionality especially in Pharma and food industry !
Very well articulated blog. Batch-specific UoM is always a complex subject. In the chemical and pharmaceutical industries in very much applicable. Consumption side it's okay, however, SAP has to enhance a bit on the inventory management side. 3-way invoice reconciliation and GR documents are still not well integrated with Batch-specific UoM and potency of chemical or API.