Regarding MQC for pharma active ingredient.

[Former Member]

Hi PP Gurus,

Please have a look at the scenario that we have

For 80 kg of SFG

it requires 50 kg of RM1 when % Assay = 100 -

---

(A)

and RM2 qty. = 64.1 - A

= 64.1 - 50 = 14.9 kg -

---

if %Assay for RM1 batch is 100%

1. I have made % Assay as Batch and Quality Characteristic and then assigned it to RM1

2. In Master Recipe assigned the material list and

For RM1 put formula:

CQSM(002;002)

and for RM2

64.1 - CQSM(002;002)

But

In order to get RM1 I have forced to put % Assay = 100% in Batch classification for RM1 and due to that during batch determination, system is not allowing me to allocate the batch having less than 100% Assay.

Could anybody please tell me

1. How to get rid of the above problem?

2. Moreover when I take % Assay = 100% and do MQC system calculate the quantity perfectly but unable to copy the result of the same to Process Order RM1 and RM2. Could anybody please tell me how the calculated quantities can be copied to respective RM1 and RM2?

Thanks,

Shoyeb

Edited by: Shoyeb A on Jul 11, 2010 9:50 PM

[Former Member]

Hi,

Could you please explain why you have to force your assay to 100% in RM1. I believe that won't be the case always.

Also tell me is that 64.1 is consatnt always & what it's significance?

Give an example in detail to know what problem you are facing?

Primafacie your formula looks ok.

SmanS

[Former Member]

Hi PP Gurus,

Could anybody please reply as I have gone through all the related threads but did find the solution for my issue?

Regards,

Shoyeb

[Former Member]

Hi PP Gurus,

Could anybody please tell me how to get

Summation of batch quotient (<material qty> / <batch characteristic value>square )

Where batch characteristic should be multiplied and then should divide the material quantity.

I've tried using CQSM(<material qty>;<batch char value1>;<batch char value1>) but its giving unexpected results.

Please help.

Regards,

Shoyeb

[Dsk]

Hi,

1. Are u looking for some think like below

material BatchQty BatchChar1 Batchchar 2

MatA 100 10 5%

2. As per the Cqsm syntax of CQSM(<material qty>;<batch char value1>;<batch char value1>)

it will divide the 10/0.05 and will give the result.

3. Also i dont know why you need to do a sqauare in the cqsm formulae.

reg

dsk

Edited by: Dsk on Jul 16, 2010 10:37 AM

[Former Member]

Hi SAP PP Cosnultant and Dsk,

Apology for delay in reply. Thanks for the comments!

Yes, we have the case where in %Assay for RM1 could vary between 90-130%. The quantity for RM1 in BoM (of 80 kg SFG) is 50 kg. but depending upon the %Assay present in RM1 batch, the calculation will happen like 50/%Assay.

For RM2 always the 64.1 is fixed if %Assay of RM1 is 0% and 14.1 if %Assay of RM1 is 100%.

For example, If Batch1 of RM1 is having %Assay = 110%

Then quantity to be issued for

RM1 = 50/110% = 45.45 kg

And for RM2 = 64.1 u2013 45.45 = 18.65 kg

Please reply with your prompt suggestions.

Regards,

Shoyeb