Question:
Hello,
Does anybody have experience on the following issue:
Material is batch managed (number range is generated by an exit) and both inspection type 03 and 04 is activated. The batch is created when the production order is confirmed (e.g. transaction CO11N).
Inspection lot 03 is created nicely when the order is released but since the batch is not there yet, the inspection lot has no batch. However, if I want to make an UD for 03-lot, I need the batch and therefore the user assigns the batch manually in QA32.
I think it is due to fact that since the batch is assigned manually, the system cannot pick results to my CoA (production chain).
Anybody done any coding for this in the form???
Pia
Answer:
What results do show up in your COA? Do you get the 04 inspection lot values?
My understanding of production chain is that the process does not step back to the in-process lot for the batch being certified but steps back through the raw materials used and gets a test result from a raw or HALB used in production.
Also, I believe that when the COA process looks for inspection lots, it will use the most recent one found, it won't retrieve results from multiple lots. If you want it to use results specifically from the 03 lot, then in the COA header you can specify the type of inspection lot to search for. I would try putting in 03, (at least temporarily for testing), and see if you get the results.
I would also look at the timing of the UD on the 03. Many places don't make UD's on the 03 inspection lots and leave them hanging out there. You can have an auto UD program run on 03 inspection lots but this can be tricky to implement. If the UD has not been made before the COA attempts to issue, there is a good chance, (I've never actually tested this), that the COA process will ignore that 03 lot for COA purposes.
And lastly, if this is batch managed material, as you probably already know, you can set up a strategy for finding a missing result if no result is found. This is usually set up to be "batch value" if no inspection lot value is found. If you can get the value to the batch record you can use this.
You can also set up customized strategies as well if you want to. In that way, if no lot is found, you could use a custom strategy maybe to force the system to go find the value from the 03 lot, and get around whatever SAP code is not letting you find the 03 lot in the first place.
I'd be very interested in hearing what you find out as you work this issue out Pia.
Thanks,
Craig
_________________
Available for spot consulting, troubleshooting, remote configuration/consulting and teaching. 10+ yrs in QM. Primary focus on Pharma and Chemicals.
Answer:
Hi Graig,
Maybe I was a bit unclear. I have a production chain with raw materials, semi-finished material and the final product. The results in the CoA consist of measurement from the production chain. I have set in the certificate profile from which material and inspection type the system should get the result(s). I know that if the batch is created when the production order is released, I do get the result (or mean value of the last partial lot) for inspection lot type 03.
For the semi-finished material there is a big process tank and some measurements are carried out; those measurement results are recorded in the inspection lot (insp. type 03). However, then the big tank is divided to smaller storage tanks (i.e. several confirmations against one production order). For each storage tank there is an inspection lot (type 04) with its' unique results. These MIC's aren't the same as the MIC's for the inspection 03 and I need all the results.
I'm in 4.6C and cannot utilize copy results functionality.
Your idea of copying results from inspection lot batch is good and I have to test it. One problem is that customer is not very keen to show inspection results in batch level
egards,
Pia
Answer:
Ok.. sounds like your using it right.. I wasn't sure in the earlier posting. You didn't mention about the status of the 03 lot though. Was the lot UD'd and the order TECO when you tried to generate the COA? You might experiment with that.
Also, I assume the material number you specified in the COA to retrieve the production results from is a component of the BOM for the material your issuing the COA for.
The last thing I would check, is your batch where used list. Next time, try updating the batch where used list after your UD and before you attempt to generate the COA. I'm wondering if SAP is using those records in any way?
We had a similiar process on an earlier version of SAP. In that process we created a special UD code for tank splits like you are doing. It was used for UD's of tank splits like your doing. In the follow-up action we identified the largest component of the BOM (had to be at least 90% of components) and copied any missing characteristic values from the main tank batch, to the smaller split batch having the UD done. It was a batch to batch copied done following the UD. That way, the smaller batch would have a complete set of batch results and the COA was issued against the batch.
Craig
_________________
Available for spot consulting, troubleshooting, remote configuration/consulting and teaching. 10+ yrs in QM. Primary focus on Pharma and Chemicals.
Answer:
Hi,
So...you do not have batch associated with the 03 lot then? Entire "results from production chain" functionality works on batch where-used. And I am afraid in this scenario SAP will not be able to get the 03 results, since it cannot associate that lot with any batch of the material.
The solution probably is to get the value in 04's only since it has a batch associated with it, correct? Or maybe something like Craig suggested.
INteresting scenario, I'll keep watching how this one gets resolved.
Good luck
Anand
Answer:
Hello,
There is a peace on earth. We finally solved the issue, or actually my basis guys did it... roughly 800 lines of coding.
It was a true nightmare and now the programme is almost stabbed to death
We have to modify programs AAP001F04 and AAP00T01. The spec.limits are really hard since they picked from floating point -fields and the usual (E) fixing for printouts doesn't work. The other problem is that system picks the results up then empties the field ones and fills the tables once again. In addition you cannot use the FM shown in QM IMG (or at least we didn't) since you cannot detect the place where data is stored - it's structure after structure.
We simply force the results to be filled after the second standard fillling and hence the MIC is shown always last in the CoA.
I definitely do not recommend this to anybody...
Regards,
Pia
Answer:
OUCH!!
Beware the next hotpack or upgrade!!!
Craig
_________________
Available for spot consulting, troubleshooting, remote configuration/consulting and teaching. 10+ yrs in QM. Primary focus on Pharma and Chemicals.