Dynamic Modification Rule per batch and sampling calculation

[jorgeho]

Hi Experts,

I have the following business requirement in my client distribution center, we have basically the following inspection stages for inspection 01 (GR from PO):

10 - Analysis
20 - Skip

The analysis follows a table in sampling scheme, and the skip occurs when the batch completes 35 samples ok whatever number of receipts that batch was delivered from the same vendor. The level of DM is per characteristic.

For example:
GR 1 Batch 1: Inspection Lot 1 has 10 samples from sampling scheme: valuation of characteristic ok. Total samples: 10
GR 2 Batch 1: Inspection Lot 2 has 20 samples from sampling scheme: valuation of characteristic ok. Total samples: 30
GR 3 Batch 1: Inspection Lot 3 has 5 samples from sampling scheme: valuation of characteristic ok. Total samples: 35

At the moment of UD of each inspection lot, it must have a valution (considering the same batch) and number of samples must reach 35 of all inspection lots to determine if the stage must be changed to 20 (skip).

So, I have 2 concerns:

1) The dynamic modification rule must be per batch (ie if there is a batch 2, a new quality level must be created).
2) The insp stage change must consider 35 samples (always 35 and for all materials) in the moment of Usage Decision.

I have checked enhancement QDSE0001 and QDSE0002, but I'm not sure which user exits to use, I have tried to put breakpoints in all exits but some of them didn't stop (eg EXIT_SAPLQDQL_001 and EXIT_SAPMQDQL_001) in the run.

Could you please advise which user exit to use for each one of the cases above?

I have checked the following user exits:

QDSE0001: EXIT_SAPLQDQV_001. EXIT_SAPLQDQL_001, EXIT_SAPMQDQL_001
QDSE0002: EXIT_SAPLQDQV_002 (that one can change the inspection stage but it is called in the moment of inspection lot creation).

Thanks in advance!

[Craig]

I think you'll have a very hard time with that requirement. Can I ask what kind of business or material this process is for? It seems to me to be a very unusual protocol.

Have you considered using an inspection type 01 using inspection points for this? Don't make the UD on the lot until all stock is received. Stock is received, applied to lot. You can use one of the inspection point FM's to pre-create 35 inspection points.

Can use QE11 to record results in table format.

When all inspection points are complete, make UD. Any new receipts of same batch after UD should go directly to unrestricted once UD is made.

Any new batches will create a new inspection lot.

Craig

[jorgeho]

Hi Craig,

The business is consumer goods (dipers, pads).

It won´t work this way, because the vendor can send the same batch after a long time, they can´t wait and must release (DU) as being a distribution center, the rotation of products are high...

Thanks for the reply!

Regards,

Jorge.

[Craig]

The stock posting is separate from the UD. You can release the stock without making the UD. Once you get 35 sample results you make the UD and close it out. Otherwise you leave the lot out there. I'd put a process out there where a quality person reviews the worklist for older lots and sets up a procedure where the make a determination on when a lot gets closed out when it has less than the 35 sample results.

If you get another solution can you let us know what you decide? I'd be interested in how you resolved this as it's the first time I've heard of this type of request. DMR based on batch is not something I think I've sen requested.

Craig