Potency calculation issue

[Amit_SAP]

Hello Gurus,

Have this potency calculation issue,

Our final Product is : xxxxxxx 500 Capsules

As per BOM one of the require material has details as below. Consider below example

Material name        Batch number          quantity   (kg)       Assay

Xxxxx                                    xxxxxx1                  286.898                 99.15%

Xxxxx                                    xxxxxx2                  90.000                   99.37%

Actual required qty of xxxxx is 344.333 ( with potency 100% i.e. Assay)

Formula

Actual Require Qty  =  qty * 100 / Assay on Anhydrus basis

Now we have qty of xxxxx with Assay 99.15% and we want 100% potency Material to be used in final product….

So Formula will be

1. 286.898 * 99.15 / 100 = 284.459 kg (with 100% potency)

Now require qty is 344.333

Available qty 284.459

Shortage of QTY = 344.333 – 284.459 = 59.874

So this shortage of QTY will be calculated from batch number xxxxxx2

Now in Batch no. xxxxxx2 potency of Material is 99.37%

So it will be calculated …..

1. 59.874 * 100 / 99.37 = 60.254  (this will be our required qty after calculating 100% potency of Batch xxxxxx2 ).

So total qty will be used from both batches will be

1. 286.898 + 60.254 = 347.152 KG. this is our final output.

Need your help to Map this potency calculation  in SAP,Looking forward for your rply.

Thnx in advance.

Regards,

Amit Sharma

[Former Member · Accepted solution]

Amit,

You should explore 'batch specific unit of measure' and active ingredient management functionality available in standard SAP.

This functionality is based on idea of creating additional unit, lets call it 'Active unit'. This can be derived as 'qty in base unit of measure  * batch characteristic value = qty in active unit'.

In your case this will be Kg * potency = Active unit

                                    286.898 *  (99.15/100) = 284.459 ( I used 99.15/100 because you are representing this as %)

When you use this, you can indicate component requirement in BOM in active unit. Once you have this setup, batch determination will consider multiple batches and will give you exact physical quantity as per your requirement in active unit (according to actual potency of each batch). This is very common requirement in process industry

See this very useful post with step by step explanation for configuration requirement. .

Let me know if this works.

Regards,

Himanshu

[Amit_SAP · Accepted solution]

Thanx a lot Himanshu,

I will test the scenario and revert you back.

Regards,

Amit

[Amit_SAP]

Hii Himanshu,

I have tested the scenario but need more clarification regarding this issue,

1. when to use Assay percentage of 2nd batch??

2.What master data should be maintained for FG like in Proportion unit and in characteristics??

3.How to add this 60.254 kg of mat from 2nd batch to the first batch qty so that my qty will be 347.152 kg??

Looking forward for your rply.

Regards,

Amit

[Former Member]

Hey Amit,

Here is what I understand your scenario as.

I imagine a BOM as follows.

Mat desc	Mat No	Qty	UoM
Header (final capsule)	H1	500	EA
Component 1 (Assay)	C2	500	Kg
Component 2 (Outer Shell)	C2	500	EA
Component 3 (packaging material)	C3	50	EA

In this BOM, we consider that we need 500 Kg of C2, provided my potency is 100%.

Setup following master data and configuration.

1. Create new UoM, lets call it AA (Active Assay)

2. Create a characteristic with unit of measure %

3. Setup relationship for batch specific unit of measure (AA) and base unit of measure (KG).

4. Setup relationship in material master --> additional data --> proportional unit

Detailed steps for above is given in the document link I shared in my previous post.

Now setup your BOM as following

Mat desc	Mat No	Qty	UoM
Header (final capsule)	H1	500	EA
Component 1 (Assay)	C2	500	AA
Component 2 (Outer Shell)	C2	500	EA
Component 3 (packaging material)	C3	50	EA

Note that here instead of specifying 500 KG we are maintaining quantity in new unit AA.

make sure your condition record for batch determination has B - Display in unit of entry for document

I hope you have already setup the batch specific Unit of measure. This indicator for Display UoM is the key to achieve your requirement.

See two different screenshot below to understand this.

Batch determination with indicator - A.

Batch determination with indicator - B.

If you carefully, see above two screeshots with indicator A and B you can see that the available quantity and required quantity is changing from L (base unit of measure in above example) to GI (batch specific unit of measure in above example).

Hope this helps.

Regards,

Himanshu

[marianoc]

Hello,

What you need can be managed with Batch Determination.

When you setup the batch search strategy (MBC1), you can enter a no. of batch splits as much as you want or just keep 999.

This way the system will assigned the first batch and then in case there is a remaining inventory for the order, it will search for another batch still all the required quantity required has the corresponding batch assigned.

Kind Regards,

Mariano

[Amit_SAP]

Hello Mariano,

Thanx for your rply, but how potency can be calculated with this method??